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 BCD.admin
{
    public partial class Office : System.Web.UI.Page
    {
        Class1 obj = new Class1();
        SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
        SqlDataAdapter adp;
        SqlCommand cmd;
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                HealthNewsdata();
            }
        }
        public void HealthNewsdata()
        {
            string qrajneeti = "select * from Officelist  order by id desc";
            DataSet dsrajneeti = obj.ReturnDataSet(qrajneeti);
            if (dsrajneeti != null && dsrajneeti.Tables[0].Rows.Count > 0)
            {
                DataGrid2.DataSource = dsrajneeti;
                DataGrid2.DataBind();
                DataGrid2.Visible = true;
            }
            else
            {
                DataGrid2.Visible = false;
            }
        }


        protected void DataGrid2_ItemCommand1(object source, DataGridCommandEventArgs e)
        {


            if (e.CommandName == "delete")
            {
                HiddenField idn = (HiddenField)e.Item.FindControl("HiddenField5");
                // HiddenField idn = (HiddenField)e.Item.FindControl("HiddenFidfeld4");          
                string del = "delete from Officelist where id='" + idn.Value + "'";
                obj.DeleteRecord(del);
                HealthNewsdata();
                RegisterStartupScript("12", "<script>alert('Deleted.')</script>");

            }
            if (e.CommandName == "Edit")
            {
                HiddenField idn = (HiddenField)e.Item.FindControl("HiddenField5");
                string qrajneeti = "select * from Officelist where id='" + idn.Value + "' order by id desc";
                DataSet dsrajneeti = obj.ReturnDataSet(qrajneeti);
                if (dsrajneeti != null && dsrajneeti.Tables[0].Rows.Count > 0)
                {
                    TextBox1.Text = dsrajneeti.Tables[0].Rows[0]["Name"].ToString();

                    TextBox6.Text = dsrajneeti.Tables[0].Rows[0]["Mobile"].ToString();
                    TextBox8.Text = dsrajneeti.Tables[0].Rows[0]["Post"].ToString();


                    HiddenField2.Value = dsrajneeti.Tables[0].Rows[0]["Photo"].ToString();
                    HiddenField1.Value = idn.Value;
                }
            }


        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            string kl = "";
            if (FileUpload1.FileBytes.Length > 1024)
            {
                string nname = DateTime.Now.Ticks.ToString();
                FileUpload FileUpload7 = FileUpload1;
                string virtualFolder7 = "../dataimp1/" + nname;
                string physicalFolder7 = Server.MapPath(virtualFolder7);
                FileUpload7.SaveAs(physicalFolder7 + FileUpload7.FileName);
                kl = "../dataimp1/" + nname + FileUpload7.FileName;
                HiddenField2.Value = kl;
            }

            if (HiddenField1.Value == "")
            {
                connect.Open();
                cmd = new SqlCommand("insert into Officelist (Name,Post,Mobile,Photo) values (@Name,@Post,@Mobile,@Photo)", connect);
                cmd.Parameters.Add("@Name", System.Data.SqlDbType.VarChar);
                cmd.Parameters["@Name"].Value = TextBox1.Text;
                cmd.Parameters.Add("@Mobile", System.Data.SqlDbType.VarChar);
                cmd.Parameters["@Mobile"].Value = TextBox6.Text;
                cmd.Parameters.Add("@Post", System.Data.SqlDbType.VarChar);
                cmd.Parameters["@Post"].Value = TextBox8.Text;
                cmd.Parameters.Add("@Photo", System.Data.SqlDbType.VarChar);
                cmd.Parameters["@Photo"].Value = HiddenField2.Value;

                cmd.ExecuteNonQuery();
                connect.Close();
                HealthNewsdata();
                RegisterStartupScript("12", "<script>alert('Inserted Succssesfully.')</script>");
            }
            else
            {
                connect.Open();
                cmd = new SqlCommand("update Officelist set Name=@Name,Post=@Post,Mobile=@Mobile,Photo=@Photo where id='" + HiddenField1.Value + "'", connect);
                cmd.Parameters.Add("@Name", System.Data.SqlDbType.VarChar);
                cmd.Parameters["@Name"].Value = TextBox1.Text;
                cmd.Parameters.Add("@Mobile", System.Data.SqlDbType.VarChar);
                cmd.Parameters["@Mobile"].Value = TextBox6.Text;
                cmd.Parameters.Add("@Post", System.Data.SqlDbType.VarChar);
                cmd.Parameters["@Post"].Value = TextBox8.Text;
                cmd.Parameters.Add("@Photo", System.Data.SqlDbType.VarChar);
                cmd.Parameters["@Photo"].Value = HiddenField2.Value;
                cmd.ExecuteNonQuery();
                connect.Close();
                HealthNewsdata();
                RegisterStartupScript("12", "<script>alert('Updated Succssesfully.')</script>");
            }
        }

        protected void DataGrid2_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
        {
            if (DataGrid2.Items.Count >= 0)
            {
                DataGrid2.CurrentPageIndex = e.NewPageIndex;
                HealthNewsdata();
            }
        }
        protected void Button2_Click(object sender, EventArgs e)
        {
            string empty = "";

            if (TextBox7.Text != "")
            {
                empty = empty + " and Mobile = '" + TextBox7.Text + "'";
            }

            string qrajneeti = "select * from Officelist where id!='0' " + empty + "  order by id desc";
            DataSet dsrajneeti = obj.ReturnDataSet(qrajneeti);
            if (dsrajneeti != null && dsrajneeti.Tables[0].Rows.Count > 0)
            {
                DataGrid2.DataSource = dsrajneeti;
                DataGrid2.DataBind();
                DataGrid2.Visible = true;
            }
            else
            {
                DataGrid2.Visible = false;
            }
        }
    }
}