public static void CompaintsUpdateValues(TbL_Complaint ObjCompUpdate) { using (ComplaintsTabDataContext dbUpdate = new ComplaintsTabDataContext()) { TbL_Complaint obj = ObjCompUpdate; dbUpdate.SubmitChanges(); } }
public static void ComplaintInsertValues(TbL_Complaint complaint) { using (ComplaintsDataContext dbInsert = new ComplaintsDataContext()) { string cmpnumber = ""; dbInsert.USP_Licensing_Complaints(101, complaint.Complaint_ID, complaint.Respondent_type, complaint.Respondent_ID, complaint.Complaint_Number, Convert.ToInt16(complaint.Source_Id), Convert.ToInt16(complaint.Category_Id), complaint.DateReceived.ToString(), complaint.DateDocketed.ToString(), complaint.Address1, complaint.Address2, complaint.City, complaint.State, complaint.Zip, Convert.ToInt16(complaint.PersonResponcible_ID), complaint.ComplaintType, Convert.ToInt16(complaint.InvestiGator_ID), complaint.SecondInvestigatiorID, complaint.DateInvestigatorAssigned, complaint.DateInvestigatorReceived, complaint.Consultant, complaint.CompanionCase_ID, complaint.Compainant, complaint.Complaint_Status, complaint.check_number, complaint.Create_User, complaint.Create_Date, ref cmpnumber); dbInsert.SubmitChanges(); } }
protected void btn_submit_click(object sender, EventArgs e) { string complaintnumber = ""; DateTime dt = System.DateTime.Now; string year = dt.Year.ToString(); if (ddl_source.SelectedValue == "1257" || ddl_source.SelectedValue == "1038" || ddl_source.SelectedValue == "1039" || ddl_source.SelectedValue == "1040" || ddl_source.SelectedValue == "1041" || ddl_source.SelectedValue == "1417" || ddl_source.SelectedValue == "1419") { complaintnumber = year.Substring(2) + "-L-"; } else if (ddl_source.SelectedValue == "1259") { complaintnumber = year.Substring(2) + "-F-"; } else { complaintnumber = year.Substring(2) + "-"; } string temp = ""; TbL_Complaint objtblComplaint = new TbL_Complaint(); objtblComplaint.Complaint_ID = 0; objtblComplaint.Respondent_type = "1"; objtblComplaint.Respondent_ID = Convert.ToInt32(hfdpid.Value); objtblComplaint.Complaint_Number = complaintnumber; objtblComplaint.Source_Id = ddl_source.SelectedValue.ToString(); objtblComplaint.Category_Id = ddl_category.SelectedValue.ToString(); if (txt_daterec.Text != "") { objtblComplaint.DateReceived = Convert.ToDateTime(txt_daterec.Text.ToString()); } else { objtblComplaint.DateReceived = null; } //if(txt_datedocketed.Text!="") //objtblComplaint.DateDocketed = txt_datedocketed.Text.ToString(); objtblComplaint.Address1 = ""; objtblComplaint.Address2 = ""; objtblComplaint.City = ""; objtblComplaint.State = ""; objtblComplaint.Zip = ""; objtblComplaint.PersonResponcible_ID = ddl_personresp.SelectedValue.ToString(); objtblComplaint.ComplaintType = "1"; objtblComplaint.InvestiGator_ID = ddl_investigater.SelectedValue.ToString(); objtblComplaint.SecondInvestigatiorID = ddl_investigater1.SelectedValue.ToString(); if (txt_dateassigned.Text.Length > 0) { objtblComplaint.DateInvestigatorAssigned = Convert.ToDateTime(txt_dateassigned.Text.ToString()); } if (txt_dateinRec.Text.Length > 0) { objtblComplaint.DateInvestigatorReceived = Convert.ToDateTime(txt_dateinRec.Text.ToString()); } objtblComplaint.Consultant = "0"; objtblComplaint.CompanionCase_ID = "0"; objtblComplaint.Compainant = txtcomplainant.Text; //Convert.ToInt16(ddl_complainant.SelectedValue.ToString()); objtblComplaint.Complaint_Status = "885"; objtblComplaint.check_number = temp; objtblComplaint.Create_User = Convert.ToInt32(Session["UID"].ToString()); objtblComplaint.Create_Date = Convert.ToDateTime(DateTime.Now.ToShortDateString()); ComplaintsLink.Complaints.ComplaintInsertValues(objtblComplaint); GetComplaintNumber(); Response.Redirect("../PersonLicensing/PersonDetails.aspx?pid=" + hfdpid.Value + "&iscmp=1"); }