public void LoadGrid()
        {
            DetailsBizDB insDetails = new DetailsBizDB(connectionString());

            //bind data to grid view
            this.Grid_GetDetails.DataSource = insDetails.Getallobjects();
            this.Grid_GetDetails.DataBind();
        }
        public void DropDownBind_Stat()
        {
            DetailsBizDB detailsBizDb = new DetailsBizDB(connectionString());

            this.ddlStatus.DataSource = detailsBizDb.GetAllStatusPropsProps();
            this.ddlStatus.DataBind();
            this.ddlStatus.Items.Insert(0, "Select..");
        }
        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            DetailsBizDB detailsBizDb = new DetailsBizDB(connectionString());
            DetailsProp  detailsProp  = new DetailsProp();

            TextBox6.Text = ddlCategory.SelectedItem.Text;


            try
            {
                // propDe.Id = Convert.ToInt32(TextBox9.Text);
                detailsProp.Name    = TextBox2.Text.ToString();
                detailsProp.Address = TextBox3.Text.ToString();
                detailsProp.Tele    = Convert.ToInt32(TextBox4.Text);

                detailsProp.Description = TextBox5.Text;
                detailsProp.Category    = Convert.ToString(ddlCategory.SelectedItem.Text);
                detailsProp.Timestamp   = TextBox7.Text;
                detailsProp.Status      = Convert.ToString(ddlStatus.SelectedItem.Text);
                //Console.WriteLine(detailsProp.Status);

                ddlCategory.Items.Clear();
                ddlStatus.Items.Clear();
                detailsBizDb.insertDataMeth(detailsProp);
            }
            catch (Exception exception)
            {
                MessageBox.Show("Enter correct details!");

                //Console.WriteLine(exception);
                //throw;
            }
            finally
            {
                LoadGrid();
                DropDownBind_Cat();
                DropDownBind_Stat();

                EmptyVals();
            }
        }
        public void EditRecord()
        {
            DetailsBizDB detailsBizDb = new DetailsBizDB(connectionString());
            DetailsProp  detailsProp  = new DetailsProp();

            try
            {
                detailsProp.Id          = Convert.ToInt32(this.hidId.Value);
                detailsProp.Name        = this.TextBox2.Text.ToString();
                detailsProp.Address     = this.TextBox3.Text.ToString();
                detailsProp.Tele        = Convert.ToInt32(TextBox4.Text.ToString());
                detailsProp.Description = TextBox5.Text.ToString();
                detailsProp.Category    = TextBox6.Text.ToString();
                detailsProp.Timestamp   = TextBox7.Text.ToString();
                detailsProp.Status      = TextBox8.Text.ToString();

                detailsBizDb.EditRecords(detailsProp);
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
                throw;
            }
            finally
            {
                LoadGrid();

                btnSubmit.Enabled = true;
                btnEdit.Enabled   = false;

                this.TextBox2.Text = "";
                this.TextBox3.Text = "";
                this.TextBox4.Text = "";
                this.TextBox5.Text = "";
                this.TextBox6.Text = "";
                this.TextBox7.Text = "";
                this.TextBox8.Text = "";
                this.TextBox9.Text = "";
            }
        }
        public void DeleteRecord()
        {
            DetailsBizDB detailsBizDb = new DetailsBizDB(connectionString());

            detailsBizDb.DeleteRecord(Convert.ToInt32(hidId.Value));
        }