using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data.SqlClient;
using System.Data;
using System.IO;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace Newdelhibarassocia.dhadmin
{
    public partial class Teammaster : System.Web.UI.Page
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                GetData();
            }
        }

        // 🔹 LOAD DATA
        public void GetData()
        {
            SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM tb_members ORDER BY id DESC", con);
            DataTable dt = new DataTable();
            da.Fill(dt);

            RepeaterBanner.DataSource = dt;
            RepeaterBanner.DataBind();
        }

        // 🔹 INSERT / UPDATE
        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            string photo = "";
            string sign = "";

            // Upload Photo
            if (FileUpload1.HasFile)
            {
                string fileName = Guid.NewGuid() + Path.GetExtension(FileUpload1.FileName);
                photo = "Uploads/" + fileName;
                FileUpload1.SaveAs(Server.MapPath(photo));
            }

            // Upload Signature
            if (FileUpload2.HasFile)
            {
                string fileName = Guid.NewGuid() + Path.GetExtension(FileUpload2.FileName);
                sign = "Uploads/" + fileName;
                FileUpload2.SaveAs(Server.MapPath(sign));
            }

            con.Open();

            if (HiddenField1.Value == "")
            {
                // INSERT
                SqlCommand cmd = new SqlCommand(@"INSERT INTO tb_members
            (Name, Post, Number, Photo, Signature)
            VALUES (@Name,@Post,@Number,@Photo,@Signature)", con);

                cmd.Parameters.AddWithValue("@Name", inputName.Value);
                cmd.Parameters.AddWithValue("@Post", inputPost.Value);
                cmd.Parameters.AddWithValue("@Number", inputNumber.Value);
                cmd.Parameters.AddWithValue("@Photo", photo);
                cmd.Parameters.AddWithValue("@Signature", sign);

                cmd.ExecuteNonQuery();
                ClientScript.RegisterStartupScript(this.GetType(), "msg", "alert('Inserted Successfully');", true);
            }
            else
            {
                // UPDATE
                SqlCommand cmd = new SqlCommand(@"UPDATE tb_members SET
            Name=@Name,
            Post=@Post,
            Number=@Number,
            Photo=ISNULL(NULLIF(@Photo,''),Photo),
            Signature=ISNULL(NULLIF(@Signature,''),Signature)
            WHERE id=@id", con);

                cmd.Parameters.AddWithValue("@Name", inputName.Value);
                cmd.Parameters.AddWithValue("@Post", inputPost.Value);
                cmd.Parameters.AddWithValue("@Number", inputNumber.Value);
                cmd.Parameters.AddWithValue("@Photo", photo);
                cmd.Parameters.AddWithValue("@Signature", sign);
                cmd.Parameters.AddWithValue("@id", HiddenField1.Value);

                cmd.ExecuteNonQuery();
                HiddenField1.Value = "";

                ClientScript.RegisterStartupScript(this.GetType(), "msg", "alert('Updated Successfully');", true);
            }

            con.Close();

            Clear();
            GetData();
        }

        // 🔹 EDIT / DELETE
        protected void RepeaterBanner_ItemCommand(object source, System.Web.UI.WebControls.RepeaterCommandEventArgs e)
        {
            HiddenField hf = (HiddenField)e.Item.FindControl("hiddenID");

            if (e.CommandName == "Edit")
            {
                SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM tb_members WHERE id=" + hf.Value, con);
                DataTable dt = new DataTable();
                da.Fill(dt);

                if (dt.Rows.Count > 0)
                {
                    inputName.Value = dt.Rows[0]["Name"].ToString();
                    inputPost.Value = dt.Rows[0]["Post"].ToString();
                    inputNumber.Value = dt.Rows[0]["Number"].ToString();

                    HiddenField1.Value = hf.Value;
                }
            }

            if (e.CommandName == "Delete")
            {
                con.Open();
                SqlCommand cmd = new SqlCommand("DELETE FROM tb_members WHERE id=@id", con);
                cmd.Parameters.AddWithValue("@id", hf.Value);
                cmd.ExecuteNonQuery();
                con.Close();

                ClientScript.RegisterStartupScript(this.GetType(), "msg", "alert('Deleted');", true);
                GetData();
            }
        }

        // 🔹 CLEAR FORM
        public void Clear()
        {
            inputName.Value = "";
            inputPost.Value = "";
            inputNumber.Value = "";
            HiddenField1.Value = "";
        }
    }
}