コード例 #1
0
        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();
        }
コード例 #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();
        }