protected void btnhfd_delparid_click(object sender, EventArgs e)
 {
     using (ComplaintsLink.ComplaintsDataContext cdb = new ComplaintsLink.ComplaintsDataContext())
     {
         ComplaintsLink.TbL_Complaints_Participant obj = cdb.TbL_Complaints_Participants.Where(c => c.Cmp_Paticipant_ID == Convert.ToInt32(hfd_delparid.Value)).SingleOrDefault();
         cdb.TbL_Complaints_Participants.DeleteOnSubmit(obj);
         cdb.SubmitChanges();
     }
     Page.RegisterStartupScript("js", "<script>altbox('Record deleted successfully.');parent.sa5.process()</script>");
 }
Beispiel #2
0
        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();
        }