Exemple #1
0
        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();

        }
Exemple #2
0
 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();
     }
 }