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 addcommitteemembers : 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_committee_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 = "";

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

            con.Open();

            if (HiddenField1.Value == "")
            {
                // INSERT
                SqlCommand cmd = new SqlCommand(@"INSERT INTO tb_committee_members
            (Designation, MemberName, PhoneNumber, PhotoPath)
            VALUES (@Designation,@MemberName,@PhoneNumber,@PhotoPath)", con);

                cmd.Parameters.AddWithValue("@Designation", inputDesignation.Value);
                cmd.Parameters.AddWithValue("@MemberName", inputMemberName.Value);
                cmd.Parameters.AddWithValue("@PhoneNumber", inputPhoneNumber.Value);
                cmd.Parameters.AddWithValue("@PhotoPath", photo);

                cmd.ExecuteNonQuery();
                ClientScript.RegisterStartupScript(this.GetType(), "msg", "alert('Inserted Successfully');", true);
            }
            else
            {
                // UPDATE
                SqlCommand cmd = new SqlCommand(@"UPDATE tb_committee_members SET
            Designation=@Designation,
            MemberName=@MemberName,
            PhoneNumber=@PhoneNumber,
            PhotoPath=ISNULL(NULLIF(@PhotoPath,''),PhotoPath)
            WHERE Id=@id", con);

                cmd.Parameters.AddWithValue("@Designation", inputDesignation.Value);
                cmd.Parameters.AddWithValue("@MemberName", inputMemberName.Value);
                cmd.Parameters.AddWithValue("@PhoneNumber", inputPhoneNumber.Value);
                cmd.Parameters.AddWithValue("@PhotoPath", photo);
                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_committee_members WHERE Id=" + hf.Value, con);
                DataTable dt = new DataTable();
                da.Fill(dt);

                if (dt.Rows.Count > 0)
                {
                    inputDesignation.Value = dt.Rows[0]["Designation"].ToString();
                    inputMemberName.Value = dt.Rows[0]["MemberName"].ToString();
                    inputPhoneNumber.Value = dt.Rows[0]["PhoneNumber"].ToString();

                    HiddenField1.Value = hf.Value;
                }
            }

            if (e.CommandName == "Delete")
            {
                con.Open();
                SqlCommand cmd = new SqlCommand("DELETE FROM tb_committee_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()
        {
            inputDesignation.Value = "";
            inputMemberName.Value = "";
            inputPhoneNumber.Value = "";
            HiddenField1.Value = "";
        }
    }
}