protected void btnupdateComplaint_Click(object sender, EventArgs e)
{
string person = "";
string caseno = "";
string prvres = "";
string curres = "";
string pstatus = "";
string cstatus = "";
using (ComplaintsTabLinq.ComplaintsTabDataContext cdb = new ComplaintsTabDataContext())
{
ComplaintsTabLinq.TbL_Complaint objcom = cdb.TbL_Complaints.Where(c => c.Complaint_ID == Convert.ToInt32(hfdautoid.Value)).SingleOrDefault();
pstatus = objcom.Complaint_Status;
cstatus = ddlcompstatus.SelectedValue;
prvres = objcom.PersonResponcible_ID;
curres = ddlcompresposible.SelectedValue;
objcom.Respondent_type = hfdRespondentType.Value.ToString() == "1" ? "1" : "2";
objcom.Respondent_ID = Convert.ToInt32(hfdRespondentId.Value);
objcom.Source_Id = ddlcompsource.SelectedValue.ToString();
objcom.Category_Id = ddlcompcategory.SelectedValue.ToString();
if (txtcompdaterecive.Text != "")
{
objcom.DateReceived = Convert.ToDateTime(txtcompdaterecive.Text);
}
else
{
objcom.DateReceived = Convert.ToDateTime("01/01/1900");
}
//if (txtcomodocketed.Text != "")
// objcom.DateDocketed = Convert.ToDateTime(txtcomodocketed.Text);
//else
// objcom.DateDocketed = Convert.ToDateTime("01/01/1900");
objcom.Address1 = txtcompadd1.Text;
objcom.Address2 = txtcompadd2.Text;
objcom.City = txtcompcity.Text;
//objcom.State = ddlcompstate.SelectedValue.ToString();
objcom.Zip = txtcompzip.Text;
objcom.PersonResponcible_ID = ddlcompresposible.SelectedValue.ToString();
caseno = objcom.Complaint_Number;
objcom.State = ddlcompstate.SelectedValue;
if (txtdateinvgcomplete.Text != "")
{
objcom.DateInvestigationComplete = Convert.ToDateTime(txtdateinvgcomplete.Text);
}
else
{
objcom.DateInvestigationComplete = Convert.ToDateTime("01/01/1900");
}
objcom.ComplaintType = "1";
objcom.InvestiGator_ID = ddlcompinvestigate.SelectedValue.ToString();
objcom.SecondInvestigatiorID = ddlcompinvestigate2.SelectedValue.ToString();
objcom.Compainant = txtcomplainant.Text;
if (txtInvestigateAssigned.Text != "")
{
objcom.DateInvestigatorAssigned = Convert.ToDateTime(txtInvestigateAssigned.Text);
}
else
{
objcom.DateInvestigatorAssigned = Convert.ToDateTime("01/01/1900");
}
if (txtInvestigatorReceived.Text != "")
{
objcom.DateInvestigatorReceived = Convert.ToDateTime(txtInvestigatorReceived.Text);
}
else
{
objcom.DateInvestigatorReceived = Convert.ToDateTime("01/01/1900");
}
// objcom.Consultant = ddlNurseConsultant.SelectedValue.ToString();
objcom.Complaint_Status = ddlcompstatus.SelectedValue.ToString();
objcom.modifiedby = Convert.ToInt32(Session["UID"].ToString());
objcom.modifieddate = Convert.ToDateTime(System.DateTime.Now.ToString("MM/dd/yyyy"));
if (prvres != curres)
{
ComplaintsTabLinq.tbl_Personresponsible_History his = new tbl_Personresponsible_History();
his.Complaint_id = objcom.Complaint_ID;
his.Old_person = Convert.ToInt32(prvres);
his.New_Person = Convert.ToInt32(curres);
his.Changedby = Convert.ToInt32(Session["UID"].ToString());
his.Changeddt = DateTime.Now;
cdb.tbl_Personresponsible_Histories.InsertOnSubmit(his);
}
if (pstatus != cstatus)
{
ComplaintsTabLinq.tbl_ComplaintStatusChanged_History cmpstatushis = new tbl_ComplaintStatusChanged_History();
cmpstatushis.Complaint_ID = objcom.Complaint_ID;
cmpstatushis.Complaint_Number = objcom.Complaint_Number;
cmpstatushis.Person_ID = objcom.Respondent_ID;
cmpstatushis.Old_Status = pstatus;
cmpstatushis.New_Status = cstatus;
cmpstatushis.Date_Status_Changed = Convert.ToDateTime(DateTime.Now.ToShortDateString());
cmpstatushis.Modify_By = Session["UID"].ToString();
cmpstatushis.Modify_Date = Convert.ToDateTime(DateTime.Now.ToShortDateString());
cdb.tbl_ComplaintStatusChanged_Histories.InsertOnSubmit(cmpstatushis);
}
cdb.SubmitChanges();
}
if (prvres != curres && ddlcompstatus.SelectedValue != "1049")
{
prvres = AdminLinq.Admin.Getemail(prvres);
//prvres = prvres + ";" + "*****@*****.**";
curres = AdminLinq.Admin.Getemail(curres);
DataTable dt = new DataTable();
dt = Utilities_Licensing.GetNameandLicno(Convert.ToInt32(hfdautoid.Value));
string st = @"<table cellspacing='0' width='100%' >
<tr>
<td style='text-align:left;' colspan='3'><b>This Email is to notify you that a case has been assigned to you.</b><br/><br/></td>
</tr>";
foreach (DataRow dr in dt.Rows)
{
st = st + @"<tr>
<td style='text-align: left;'><b>Respondent :</b></td>
<td style='text-align:left;'>" + dr["Name"].ToString() + "</td></tr>";
st = st + @"<tr>
<td style='text-align: left;'><b>License Type :</b></td>
<td style='text-align:left;'>" + dr["License_Type"].ToString() + "</td></tr>";
st = st + @"<tr>
<td style='text-align: left;'><b>License # :</b></td>
<td style='text-align:left;'>" + dr["Lic_no"].ToString() + "</td></tr>";
st = st + @"<tr>
<td style='text-align:left;'><b>License Status :</b></td>
<td style='text-align:left;'>" + dr["LicenseStatus"].ToString() + "</td></tr>";
}
if (chkattachdoc.Checked == true)
{
DataSet ds = Utilities_Licensing.GetDocumentPath(hfdautoid.Value);
string docpath = ds.Tables[0].Rows[0]["docpath"].ToString();
string comments = ds.Tables[0].Rows[0]["Comments"].ToString();
if (docpath.ToString() != "")
{
st = st + @"<tr><td colspan='2'> </td></tr><tr>
<td colspan='2' style='text-align:left;'><a href=" + docpath + " style='text-decoration:none;' target='blank'>Download Initial Complaint Document</a></td></tr>";
}
if (comments != "" && comments != null)
{
st = st + @"<tr><td colspan='2'> </td></tr><tr>
<td style='text-align:left;'>Comments :</td><td style='text-align:left'>" + comments + "</td></tr>";
}
}
st = st + "</table>";
if (ddlcompsource.SelectedValue == "1257" || ddlcompsource.SelectedValue == "1038" || ddlcompsource.SelectedValue == "1039" || ddlcompsource.SelectedValue == "1040" || ddlcompsource.SelectedValue == "1041" || ddlcompsource.SelectedValue == "1259")
{
Mail.SendMail(ddlcompresposible.SelectedItem.Text, curres, prvres, "Case Assigned : " + caseno, st);
}
else
{
prvres = prvres + ";" + "*****@*****.**" + ";" + "*****@*****.**" + ";" + "*****@*****.**";
Mail.SendMail(ddlcompresposible.SelectedItem.Text, curres, prvres, "Case Assigned : " + caseno, st);
}
}
if (pstatus != "1049" && cstatus == "1049")
{
if (ddlcompsource.SelectedValue == "1257" || ddlcompsource.SelectedValue == "1038" || ddlcompsource.SelectedValue == "1039" || ddlcompsource.SelectedValue == "1040" || ddlcompsource.SelectedValue == "1041" || ddlcompsource.SelectedValue == "1259")
{
DataTable dt = new DataTable();
dt = Utilities_Licensing.GetNameandLicno(Convert.ToInt32(hfdautoid.Value));
string st = @"<table cellspacing='0' width='100%' >
<tr>
<td style='text-align:left;' colspan='3'><b>This Email is to notify you that a case :" + caseno + " Has Been Closed. </b><br/><br/></td></tr>";
foreach (DataRow dr in dt.Rows)
{
st = st + @"<tr>
<td style='text-align: left;'><b>Respondent :</b></td>
<td style='text-align:left;'>" + dr["Name"].ToString() + "</td></tr>";
st = st + @"<tr>
<td style='text-align: left;'><b>License Type :</b></td>
<td style='text-align:left;'>" + dr["License_Type"].ToString() + "</td></tr>";
st = st + @"<tr>
<td style='text-align: left;'><b>License # :</b></td>
<td style='text-align:left;'>" + dr["Lic_no"].ToString() + "</td></tr>";
}
st = st + "</table>";
Mail.SendMail("", System.Configuration.ConfigurationManager.AppSettings["cmpclose"].ToString(), "", "Case Closed ", st);
}
else
{
DataTable dt = new DataTable();
dt = Utilities_Licensing.GetNameandLicno(Convert.ToInt32(hfdautoid.Value));
string st = @"<table cellspacing='0' width='100%' >
<tr>
<td style='text-align:left;' colspan='3'><b>This Email is to notify you that a case :" + caseno + " Has Been Closed. </b><br/><br/></td></tr>";
foreach (DataRow dr in dt.Rows)
{
st = st + @"<tr>
<td style='text-align: left;'><b>Respondent :</b></td>
<td style='text-align:left;'>" + dr["Name"].ToString() + "</td></tr>";
st = st + @"<tr>
<td style='text-align: left;'><b>License Type :</b></td>
<td style='text-align:left;'>" + dr["License_Type"].ToString() + "</td></tr>";
st = st + @"<tr>
<td style='text-align: left;'><b>License # :</b></td>
<td style='text-align:left;'>" + dr["Lic_no"].ToString() + "</td></tr>";
}
st = st + "</table>";
Mail.SendMail("", System.Configuration.ConfigurationManager.AppSettings["cmpclose1"].ToString(), "", "Case Closed ", st);
}
}
string js = " altbox('Complaints updated successfully.');";
ScriptManager.RegisterStartupScript(Page, GetType(), "scr", js, true);
}
protected void btnedit_click(object sender, EventArgs e)
{
clearcomp();
string Value = hfdselid.Value;
ComplaintsTabLinq.TbL_Complaint ObjComplaint = Utilities_ComplaintsTAB.GetComplaintsById(Convert.ToInt32(Value));
hfdautoid.Value = ObjComplaint.Complaint_ID.ToString();
hfdcompNum.Value = Convert.ToString(ObjComplaint.Complaint_Number);
hfdRespondentType.Value = ObjComplaint.Respondent_type;
hfdRespondentId.Value = Convert.ToString(ObjComplaint.Respondent_ID);
hfdcompanioncaseidoutparm.Value = ObjComplaint.CompanionCase_ID.ToString();
string source = ObjComplaint.Source_Id;
ddlcompsource.SelectedIndex = -1;
if (ddlcompsource.Items.FindByValue(source) != null)
{
ddlcompsource.Items.FindByValue(source).Selected = true;
}
string category = ObjComplaint.Category_Id;
ddlcompcategory.SelectedIndex = -1;
if (ddlcompcategory.Items.FindByValue(category) != null)
{
ddlcompcategory.Items.FindByValue(category).Selected = true;
}
string status = ObjComplaint.Complaint_Status;
ddlcompstatus.SelectedIndex = -1;
if (ddlcompstatus.Items.FindByValue(status) != null)
{
ddlcompstatus.Items.FindByValue(status).Selected = true;
}
string datereceived = Convert.ToDateTime(ObjComplaint.DateReceived).ToString("MM/dd/yyyy");
if (datereceived != null && datereceived != "01/01/0001" && datereceived != "01/01/1900" && datereceived != "")
{
txtcompdaterecive.Text = Convert.ToDateTime(ObjComplaint.DateReceived).ToString("MM/dd/yyyy");
}
else
{
txtcompdaterecive.Text = "";
}
//txtcompdaterecive.Text = ObjComplaint.DateReceived.ToString();
//txtcomodocketed.Text = ObjComplaint.DateDocketed.ToString();
//if (ObjComplaint.DateDocketed != null)
//txtcomodocketed.Text = Convert.ToDateTime(ObjComplaint.DateDocketed).ToString("MM/dd/yyyy");
txtcomplainant.Text = ObjComplaint.Compainant;
txtcompadd1.Text = ObjComplaint.Address1;
txtcompadd2.Text = ObjComplaint.Address2;
txtcompcity.Text = ObjComplaint.City;
txtcompzip.Text = ObjComplaint.Zip;
string personres = ObjComplaint.PersonResponcible_ID;
ddlcompresposible.SelectedIndex = -1;
if (ddlcompresposible.Items.FindByValue(personres) != null)
{
ddlcompresposible.Items.FindByValue(personres).Selected = true;
}
hfdpers.Value = ObjComplaint.PersonResponcible_ID;
ddlcompinvestigate2.SelectedIndex = -1;
if (ddlcompinvestigate2.Items.FindByValue(ObjComplaint.SecondInvestigatiorID) != null)
{
ddlcompinvestigate2.Items.FindByValue(ObjComplaint.SecondInvestigatiorID).Selected = true;
}
string investigator = ObjComplaint.InvestiGator_ID;
ddlcompinvestigate.SelectedIndex = -1;
if (ddlcompinvestigate.Items.FindByValue(investigator) != null)
{
ddlcompinvestigate.Items.FindByValue(investigator).Selected = true;
}
string cmptype = ObjComplaint.ComplaintType;
if (ddlcompstate.Items.FindByValue(ObjComplaint.State) != null)
{
ddlcompstate.SelectedIndex = -1;
ddlcompstate.Items.FindByValue(ObjComplaint.State).Selected = true;
}
string dateinvestigation = Convert.ToDateTime(ObjComplaint.DateInvestigatorAssigned).ToString("MM/dd/yyyy");
if (dateinvestigation != "01/01/1900" && dateinvestigation != "01/01/0001" && dateinvestigation != "" && dateinvestigation != null)
{
txtInvestigateAssigned.Text = Convert.ToDateTime(dateinvestigation).ToString("MM/dd/yyyy");
}
else
{
txtInvestigateAssigned.Text = "";
}
string dateinvsrec = Convert.ToDateTime(ObjComplaint.DateInvestigatorReceived).ToString("MM/dd/yyyy");
if (dateinvsrec != "01/01/1900" && dateinvsrec != "01/01/0001" && dateinvsrec != "" && dateinvsrec != null)
{
txtInvestigatorReceived.Text = Convert.ToDateTime(dateinvsrec).ToString("MM/dd/yyyy");
}
else
{
txtInvestigatorReceived.Text = "";
}
string dateinvscmp = Convert.ToDateTime(ObjComplaint.DateInvestigationComplete).ToString("MM/dd/yyyy");
if (dateinvscmp != "01/01/1900" && dateinvscmp != "01/01/0001" && dateinvscmp != "" && dateinvscmp != null)
{
txtdateinvgcomplete.Text = Convert.ToDateTime(dateinvscmp).ToString("MM/dd/yyyy");
}
else
{
txtdateinvgcomplete.Text = "";
}
//if (Convert.ToDateTime(ObjComplaint.DateInvestigatorAssigned).ToString("MM/dd/yyyy") != "01/01/1900")
//txtInvestigateAssigned.Text = Convert.ToDateTime(ObjComplaint.DateInvestigatorAssigned).ToString("MM/dd/yyyy");
//if (Convert.ToDateTime(ObjComplaint.DateInvestigatorReceived).ToString("MM/dd/yyyy") != "01/01/1900")
//txtInvestigatorReceived.Text = Convert.ToDateTime(ObjComplaint.DateInvestigatorReceived).ToString("MM/dd/yyyy");
// if (Convert.ToDateTime(ObjComplaint.DateInvestigationComplete).ToString("MM/dd/yyyy") != "01/01/1900")
// txtdateinvgcomplete.Text = Convert.ToDateTime(ObjComplaint.DateInvestigationComplete).ToString("MM/dd/yyyy");
try
{
}
catch (Exception)
{
}
string js = "Openapplication();";
ScriptManager.RegisterStartupScript(Page, GetType(), "scr", js, true);
}
