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

namespace Newdelhibarassocia.dhadmin
{
    public partial class usermaster : System.Web.UI.Page
    {
        SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
        SqlDataAdapter adp;
        SqlCommand cmd;

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

        public void GetData()
        {
            string query = "SELECT * FROM tb_usermaster ORDER BY id DESC";
            adp = new SqlDataAdapter(query, connect);
            DataSet ds = new DataSet();
            adp.Fill(ds);
            if (ds != null && ds.Tables[0].Rows.Count > 0)
            {
                RepeaterBanner.DataSource = ds.Tables[0];
                RepeaterBanner.DataBind();
                RepeaterBanner.Visible = true;
            }
            else
            {
                RepeaterBanner.Visible = false;
            }
        }

        protected void RepeaterBanner_ItemCommand(object source, RepeaterCommandEventArgs e)
        {
            if (e.CommandName == "Edit")
            {
                HiddenField hf = (HiddenField)e.Item.FindControl("hiddenID");
                string query = "select * from tb_usermaster where id='" + hf.Value + "'";
                SqlCommand com = new SqlCommand(query, connect);
                SqlDataAdapter da = new SqlDataAdapter(com);
                DataTable dt = new DataTable();
                da.Fill(dt);
                if (dt.Rows.Count > 0)
                {
                    inputtype.Value = dt.Rows[0]["uid"].ToString();
                    inputfee.Value = dt.Rows[0]["password"].ToString();
                    DropDownList1.SelectedValue = dt.Rows[0]["stype"].ToString();
                    HiddenField1.Value = hf.Value;
                    string[] jkl= dt.Rows[0]["smenu"].ToString().Split(',');
                    int kjj =jkl.Length;
                    for (int i = 0; i < kjj; i++)
                    {
                        if (CheckBoxList1.Items[i].Text == jkl[i])
                        {
                            CheckBoxList1.Items[i].Selected=true;
                        }
                    }
                }
                connect.Open();
                com.ExecuteNonQuery();
                connect.Close();
            }
            if (e.CommandName == "Delete")
            {
                HiddenField hf = (HiddenField)e.Item.FindControl("hiddenID");
                string query = "Delete from tb_usermaster where id='" + hf.Value + "'";
                SqlCommand com = new SqlCommand(query, connect);
                connect.Open();
                com.ExecuteNonQuery();
                connect.Close();
                RegisterStartupScript("12", "<script>alert('Deleted')</script>");
                GetData();
            }
        }

        protected void Unnamed_Click(object sender, EventArgs e)
        {
            if (HiddenField1.Value == "")
            {
                string kjj = "";
                for(int i = 0;i<CheckBoxList1.Items.Count;i++)
                {
                    if (CheckBoxList1.Items[i].Selected == true)
                    {
                        kjj = kjj + CheckBoxList1.Items[i].ToString() + ",";
                    }
                }
                connect.Open();
                cmd = new SqlCommand("insert into tb_usermaster (uid,password,stype,smenu) values (@uid,@password,@stype,@smenu)", connect);     //insert query
                cmd.Parameters.Add("@uid", System.Data.SqlDbType.VarChar);
                cmd.Parameters["@uid"].Value = inputtype.Value;
                cmd.Parameters.Add("@password", System.Data.SqlDbType.VarChar);
                cmd.Parameters["@password"].Value = inputfee.Value;
                cmd.Parameters.Add("@stype", System.Data.SqlDbType.VarChar);
                cmd.Parameters["@stype"].Value = DropDownList1.SelectedValue;
                cmd.Parameters.Add("@smenu", System.Data.SqlDbType.VarChar);
                cmd.Parameters["@smenu"].Value = kjj;

                cmd.ExecuteNonQuery();
                connect.Close();
                GetData();
                RegisterStartupScript("12", "<script>alert('Add Succssesfully.')</script>");
            }
            else
            {
                string kjj = "";
                for (int i = 0; i < CheckBoxList1.Items.Count; i++)
                {
                    if (CheckBoxList1.Items[i].Selected == true)
                    {
                        kjj = kjj + CheckBoxList1.Items[i].ToString() + ",";
                    }
                }
                connect.Open();
                cmd = new SqlCommand("update tb_usermaster set stype=@stype,smenu=@smenu ,uid=@uid,password=@password where id='" + HiddenField1.Value + "'", connect);     //insert query
                cmd.Parameters.Add("@uid", System.Data.SqlDbType.VarChar);
                cmd.Parameters["@uid"].Value = inputtype.Value;
                cmd.Parameters.Add("@password", System.Data.SqlDbType.VarChar);
                cmd.Parameters["@password"].Value = inputfee.Value;
                cmd.Parameters.Add("@stype", System.Data.SqlDbType.VarChar);
                cmd.Parameters["@stype"].Value = DropDownList1.SelectedValue;
                cmd.Parameters.Add("@smenu", System.Data.SqlDbType.VarChar);
                cmd.Parameters["@smenu"].Value = kjj;
                cmd.ExecuteNonQuery();
                connect.Close();
                GetData();
                HiddenField1.Value = "";
                RegisterStartupScript("12", "<script>alert('Updated Succssesfully.')</script>");
            }
        }
    }
}