protected void btnINvestiativeVoilations_Click(object sender, EventArgs e) { TbL_Complaints_Conclusion obj = new TbL_Complaints_Conclusion(); obj.Cmpid = Convert.ToInt16(comid); obj.ConclusionArea = txtinvconclusion.Text.Trim(); obj.CreatedUser = 1; obj.ConclusionViolationID = ddlVoilations.SelectedValue; if (hfd_concl.Value == "") { obj.ConclusionID = 0; obj.CreateDate = DateTime.Now; ComplaintsTabLinq.ClsComplaints.InsertUpdateDeleteConclusion(obj); string js = " altbox('Investigative voilations added successfully.');"; ScriptManager.RegisterStartupScript(Page, GetType(), "scr", js, true); } else { obj.ConclusionID = Convert.ToInt16(hfd_concl.Value); obj.CreateDate = DateTime.Now; obj.modifiedBy = 1; ComplaintsTabLinq.ClsComplaints.InsertUpdateDeleteConclusion(obj); string js = " altbox('Investigative voilations updated successfully.');"; ScriptManager.RegisterStartupScript(Page, GetType(), "scr", js, true); } Bindinvestigations(); }
public static void InsertUpdateDeleteConclusion(TbL_Complaints_Conclusion objtblConclusion) { using (ComplaintsTabDataContext dbInsertConclus = new ComplaintsTabDataContext()) { if (objtblConclusion.ConclusionID == 0) { dbInsertConclus.USP_Complaints_ConclusionDetailsIUD(101, objtblConclusion.ConclusionID, objtblConclusion.Cmpid, objtblConclusion.ConclusionViolationID, objtblConclusion.ConclusionArea, objtblConclusion.CreatedUser, objtblConclusion.CreateDate); } else { dbInsertConclus.USP_Complaints_ConclusionDetailsIUD(102, objtblConclusion.ConclusionID, objtblConclusion.Cmpid, objtblConclusion.ConclusionViolationID, objtblConclusion.ConclusionArea, objtblConclusion.CreatedUser, objtblConclusion.CreateDate); } dbInsertConclus.SubmitChanges(); } }