//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);
}
