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());
}
}
