//insert to table public void insertDataMeth(DetailsProp detailsProp) { using (SqlConnection con = new SqlConnection(ConnectionString)) { SqlCommand comm = new SqlCommand("cms_insertTotable", con); comm.CommandType = CommandType.StoredProcedure; /* * SqlParameter cid = new SqlParameter(); * cid.ParameterName = "@c_id"; * cid.Value = Convert.ToInt32(detailsProp.Id); * comm.Parameters.Add(cid); */ SqlParameter cname = new SqlParameter(); cname.ParameterName = "@c_name"; cname.Value = detailsProp.Name.ToString(); comm.Parameters.Add(cname); SqlParameter caddress = new SqlParameter(); caddress.ParameterName = "@c_Address"; caddress.Value = detailsProp.Address.ToString(); comm.Parameters.Add(caddress); SqlParameter ctele = new SqlParameter(); ctele.ParameterName = "@c_Tele"; ctele.Value = Convert.ToInt32(detailsProp.Tele); comm.Parameters.Add(ctele); SqlParameter cdescription = new SqlParameter(); cdescription.ParameterName = "@c_Description"; cdescription.Value = detailsProp.Description.ToString(); comm.Parameters.Add(cdescription); SqlParameter ccategory = new SqlParameter(); ccategory.ParameterName = "@c_Category"; ccategory.Value = detailsProp.Category.ToString(); comm.Parameters.Add(ccategory); SqlParameter ctime = new SqlParameter(); ctime.ParameterName = "@c_Time"; ctime.Value = DateTime.Now.ToShortTimeString(); comm.Parameters.Add(ctime); SqlParameter cstatus = new SqlParameter(); cstatus.ParameterName = "@c_Status"; cstatus.Value = detailsProp.Status.ToString(); comm.Parameters.Add(cstatus); con.Open(); comm.ExecuteNonQuery(); } }
public void EditRecords(DetailsProp detailsProp) { using (SqlConnection con = new SqlConnection((ConnectionString))) { SqlCommand cmd = new SqlCommand("cms_EditProcedure", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter did = new SqlParameter(); did.ParameterName = "@c_id"; did.Value = Convert.ToInt32(detailsProp.Id); cmd.Parameters.Add(did); SqlParameter dname = new SqlParameter(); dname.ParameterName = "@c_name"; dname.Value = detailsProp.Name.ToString(); cmd.Parameters.Add(dname); SqlParameter daddress = new SqlParameter(); daddress.ParameterName = "@c_Address"; daddress.Value = detailsProp.Address.ToString(); cmd.Parameters.Add(daddress); SqlParameter dtelephone = new SqlParameter(); dtelephone.ParameterName = "@c_Tele"; dtelephone.Value = detailsProp.Tele.ToString(); cmd.Parameters.Add(dtelephone); SqlParameter ddescription = new SqlParameter(); ddescription.ParameterName = "@c_Description"; ddescription.Value = (detailsProp.Description).ToString(); cmd.Parameters.Add(ddescription); SqlParameter dcategory = new SqlParameter(); dcategory.ParameterName = "@c_Category"; dcategory.Value = (detailsProp.Category).ToString(); cmd.Parameters.Add(dcategory); SqlParameter dtime = new SqlParameter(); dtime.ParameterName = "@c_Time"; dtime.Value = (detailsProp.Timestamp).ToString(); cmd.Parameters.Add(dtime); SqlParameter dstatus = new SqlParameter(); dstatus.ParameterName = "@c_Status"; dstatus.Value = (detailsProp.Status).ToString(); cmd.Parameters.Add(dstatus); con.Open(); cmd.ExecuteNonQuery(); } }
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 = ""; } }
//select records public List <DetailsProp> Getallobjects() { List <DetailsProp> insProp = new List <DetailsProp>(); using (SqlConnection con = new SqlConnection(this.ConnectionString)) { SqlCommand comm = new SqlCommand("cms_selectallrecords", con); comm.CommandType = CommandType.StoredProcedure; con.Open(); SqlDataReader rdr = comm.ExecuteReader(); //reading line by line while (rdr.Read()) { DetailsProp dr = new DetailsProp(); dr.Id = Convert.ToInt32(rdr["ComplaintID"]); dr.Name = rdr["C_Name"].ToString(); dr.Address = rdr["C_Address"].ToString(); dr.Tele = Convert.ToInt32(rdr["C_Tele"]); dr.Description = rdr["C_Description"].ToString(); dr.Category = rdr["C_Category"].ToString(); dr.Timestamp = rdr["C_Time"].ToString(); dr.Status = rdr["C_Status"].ToString(); insProp.Add(dr); } } return(insProp); }