protected void btnresolutionsubmit_Click(object sender, EventArgs e) { ComplaintsLink.TbL_Complaints_Resolution obj = new ComplaintsLink.TbL_Complaints_Resolution(); try { obj.Resolution_ID = 0; obj.Cmp_ID = comid; obj.Person_ID = hfd_pid.Value; obj.Resoutions = Convert.ToInt16(ddlresoultion.SelectedValue); obj.DateofResolution = Convert.ToDateTime(txtdateresolution.Text); obj.BoardAction = Convert.ToInt16(ddlboardaction.SelectedValue); if (txtdateaction.Text != "") { obj.DateofAction = Convert.ToDateTime(txtdateaction.Text); } obj.ModifiedBy = Convert.ToInt32(Session["UID"].ToString()); obj.ModifiedDate = DateTime.Now;//.ToString("MM/dd/yyyy"); int k = ComplaintsLink.Complaints.Complaint_Resolution_InsertValues(obj, 101); string js = " altbox('Record added successfully.');"; ScriptManager.RegisterStartupScript(Page, GetType(), "scr", js, true); ddlresoultion.SelectedIndex = 0; txtdateresolution.Text = ""; ddlboardaction.SelectedIndex = 0; txtdateaction.Text = ""; } catch { } bind_resolution(); }
protected void btnresolutionupdate_Click(object sender, EventArgs e) { using (ComplaintsLink.ComplaintsDataContext cdc = new ComplaintsLink.ComplaintsDataContext()) { ComplaintsLink.TbL_Complaints_Resolution obj = new ComplaintsLink.TbL_Complaints_Resolution(); try { obj.Resolution_ID = Convert.ToInt16(hfd_resolution.Value.ToString()); obj.Cmp_ID = comid; obj.Person_ID = hfd_pid.Value; obj = cdc.TbL_Complaints_Resolutions.Where(c => c.Resolution_ID == Convert.ToInt32(hfd_resolution.Value)).SingleOrDefault(); if (obj.Resoutions != Convert.ToInt32(ddlresoultion.SelectedValue) || obj.DateofResolution != Convert.ToDateTime(txtdateresolution.Text)) { ComplaintsLink.tbl_Complaints_Resolution_History cmpreshistory = new ComplaintsLink.tbl_Complaints_Resolution_History(); cmpreshistory.Resolution_ID = Convert.ToInt32(hfd_resolution.Value); cmpreshistory.Cmp_ID = comid; cmpreshistory.Person_ID = hfd_pid.Value; cmpreshistory.Old_Resolutions = ddlresoultion.SelectedValue; if (txtdateresolution.Text == "") { cmpreshistory.Old_Date_Of_Resolution = null; } else { cmpreshistory.Old_Date_Of_Resolution = Convert.ToDateTime(txtdateresolution.Text); } cmpreshistory.Old_BoardAction = ddlboardaction.SelectedValue; if (txtdateaction.Text != "") { cmpreshistory.Old_BoardAction_Date = Convert.ToDateTime(txtdateaction.Text); } cmpreshistory.Created_By = Session["UID"].ToString(); cmpreshistory.Created_Date = Convert.ToDateTime(DateTime.Now.ToShortDateString()); cdc.tbl_Complaints_Resolution_Histories.InsertOnSubmit(cmpreshistory); cdc.SubmitChanges(); } obj.Resoutions = Convert.ToInt16(ddlresoultion.SelectedValue); if (txtdateresolution.Text == "") { obj.DateofResolution = Convert.ToDateTime("01/01/1900"); } else { obj.DateofResolution = Convert.ToDateTime(txtdateresolution.Text); } obj.BoardAction = Convert.ToInt16(ddlboardaction.SelectedValue); if (txtdateaction.Text != "") { obj.DateofAction = Convert.ToDateTime(txtdateaction.Text); } obj.ModifiedBy = Convert.ToInt32(Session["UID"].ToString()); obj.ModifiedDate = DateTime.Now;//.ToString("MM/dd/yyyy"); int k = ComplaintsLink.Complaints.Complaint_Resolution_InsertValues(obj, 102); string js = " altbox('Record updated successfully.');"; ScriptManager.RegisterStartupScript(Page, GetType(), "scr", js, true); ddlresoultion.SelectedIndex = 0; txtdateresolution.Text = ""; ddlboardaction.SelectedIndex = 0; txtdateaction.Text = ""; } catch { } } bind_resolution(); }