private void GetComplaintNumber() { using (ComplaintsTabLinq.ComplaintsTabDataContext cdc = new ComplaintsTabLinq.ComplaintsTabDataContext()) { string cmpnumber = ""; string respondent = ""; ComplaintsTabLinq.TbL_Complaint cmp = cdc.TbL_Complaints.OrderByDescending(c => c.Complaint_ID).First(); cmpnumber = cmp.Complaint_Number; using (Person_Details.Person_LicenseDataContext plc = new Person_Details.Person_LicenseDataContext()) { Person_Details.tbl_PersonDetail obj = new Person_Details.tbl_PersonDetail(); obj = plc.tbl_PersonDetails.Where(c => c.Person_ID == cmp.Respondent_ID).SingleOrDefault(); if (obj.object_type != 1) { respondent = obj.Business; } else { respondent = obj.First_Name + ' ' + obj.Middle_Name + ' ' + obj.Last_Name; } } if (ddl_source.SelectedValue == "1257" || ddl_source.SelectedValue == "1038" || ddl_source.SelectedValue == "1039" || ddl_source.SelectedValue == "1040" || ddl_source.SelectedValue == "1041" || ddl_source.SelectedValue == "1259" || ddl_source.SelectedValue == "1417" || ddl_source.SelectedValue == "1419") { Mail.SendMail("", System.Configuration.ConfigurationManager.AppSettings["cmpcreated"].ToString(), "", "Case Created ", "A case has been created with the number : " + cmpnumber + "<br/><br/>Respondent : " + respondent); } else { Mail.SendMail("", System.Configuration.ConfigurationManager.AppSettings["cmpcreated1"].ToString(), "", "Case Created ", "A case has been created with the number : " + cmpnumber + "<br/><br/>Respondent : " + respondent); } } }
public static List <Person_Details.USP_getRenewaldata2018Result> getrenewaldata2018(string sdt, string edt, string ltype, string isprocess, string licno) { using (Person_Details.Person_LicenseDataContext odb = new Person_Details.Person_LicenseDataContext()) { if (sdt == "") { sdt = DateTime.Now.ToShortDateString(); } if (edt == "") { edt = DateTime.Now.ToShortDateString(); } return(odb.USP_getRenewaldata2018(Convert.ToDateTime(sdt), Convert.ToDateTime(edt), Convert.ToInt32(ltype), Convert.ToInt32(isprocess), licno).ToList()); } }