protected 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);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
hfdpid.Value = Request.QueryString[0].ToString();
Person_Details.tbl_PersonDetail objtype = Person_Details.Licensing_Details.get_PersonsData(Convert.ToInt32(hfdpid.Value));
hfdobjtype.Value = objtype.object_type.ToString();
if (hfdobjtype.Value == "1")
{
haspharmacy.Attributes.Add("style", "display:none");
}
else
{
employee.Attributes.Add("style", "display:none");
supervisor.Attributes.Add("style", "display:none");
//exam.Attributes.Add("style", "display:none");
outofstate.Attributes.Add("style", "display:none");
otherstate.Attributes.Add("style", "display:none");
}
Utilities_Licensing.BindDropdown(ddlstate, 9);
Utilities_Licensing.BindDropdown(ddlcounty, 10);
btnadd.Attributes.Add("onClick", "return open_edit(" + hfdpid.Value + ");");
btnaddemployer.Attributes.Add("onClick", "return Open_employer(" + hfdpid.Value + ");");
//Utilities_Licensing.BindGridEmployer(grdemployee, Convert.ToInt32(hfdpid.Value));
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
hfdperid.Value = Request.QueryString[0].ToString();
Utilities_Licensing.BindDropdown(ddl_status1, 53);
Utilities_Licensing.BindDropdown(ddlnewappstatus, 24);
Utilities_Licensing.BindDropdown(ddlappreason, 28);
Utilities_Licensing.BindDropdown(ddlmailorderstatus, 53);
Utilities_Licensing.BindCheckboxlist1(chkschedules, 68);
Utilities_Licensing.Bind_LicenseTypes_Business(ddl_buslictypes);
Utilities_Licensing.BindLicType(ddllictype, Convert.ToInt32(hfdperid.Value));
Utilities_Licensing.BindLicType(ddl_licensetype, Convert.ToInt32(hfdperid.Value));
Utilities_Licensing.BindLicType(ddl_schedulelicensetype, Convert.ToInt32(hfdperid.Value));
Person_Details.tbl_PersonDetail objtype = Person_Details.Licensing_Details.get_PersonsData(Convert.ToInt32(hfdperid.Value));
hfdobjtype.Value = objtype.object_type.ToString();
//if(hfdobjtype.Value=="1")
//mailorder.Attributes.Add("style","display:none");
Utilities_Licensing.BindDropdown(ddlnewstatus, 14);
txtDateOfChange.Text = DateTime.Now.ToShortDateString();
txtappdt.Text = DateTime.Now.ToShortDateString();
Utilities_Licensing.BindStatusChange(ddlReason);
ddlcmp.DataSource = ComplaintsTabLinq.ClsComplaints.GetComplaints("0", Convert.ToInt32(hfdperid.Value));
ddlcmp.DataTextField = "Complaint_Number";
ddlcmp.DataValueField = "Complaint_Number";
ddlcmp.DataBind();
ddlcmp.Items.Insert(0, new ListItem("", ""));
//BindLicenseData();
Utilities_Licensing.BindLicenseTypeByPersonID(chklictypes, Convert.ToInt32(hfdperid.Value));
foreach (ListItem li in chklictypes.Items)
{
li.Attributes.Add("App_ID", li.Value);
}
}
}
protected void btnsubmit_Click(object sender, EventArgs e)
{
try
{
hfdpid.Value = Request.QueryString[0].ToString();
int contacttype = Convert.ToInt32(ddlcontacttype.SelectedValue);
var query = Utilities_Licensing.GetPersonandBusiness(hfdrelid.Value, contacttype);
var queryforstatus = Utilities_Licensing.GetPersonandBusinessLicense(hfdrelid.Value);
string Name = "";
string address = "";
string email = "";
string licensestatus = "-1";
if (queryforstatus.Count > 0)
{
if (queryforstatus[0].licstatus != null)
{
licensestatus = queryforstatus[0].licstatus;
}
}
if (query.Count > 0 && (contacttype == 3 || contacttype == 5))
{
string business = query[0].busin;
string licno = query[0].licno;
string contact = ddlcontacttype.SelectedValue;
string comments = txtcomment.Text;
string js = "Confirmation('" + business.Replace("'", "`") + "','" + licno + "','" + contact + "','" + comments + "');";
ScriptManager.RegisterStartupScript(Page, GetType(), "scr", js, true);
}
else
{
if (contacttype == 3 && licensestatus == "808")
{
string contact = ddlcontacttype.SelectedValue;
string comments = txtcomment.Text;
string js = "Warning('" + contact + "','" + comments + "');";
ScriptManager.RegisterStartupScript(Page, GetType(), "scr", js, true);
}
else
{
Person_Details.Licensing_Details.Insert_ContactDetails(Convert.ToInt32(hfdcontactid.Value), hfdpid.Value, Convert.ToInt32(ddlcontacttype.SelectedValue), hfdrelid.Value, txtcomment.Text.ToString(), "Current", DateTime.Now.ToShortDateString(), "", Session["UID"].ToString(), Session["UID"].ToString(), txt_percentage.Text);
altbox("Record inserted successfully.");
Clear();
}
}
if (contacttype == 3)
{
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 == Convert.ToInt32(hfdrelid.Value)).SingleOrDefault();
//if (obj.object_type != 1)
// Name = obj.Business;
//else
// Name = obj.First_Name + ' ' + obj.Middle_Name + ' ' + obj.Last_Name;
//address = obj.Address1;
email = obj.Email;
Person_Details.tbl_PersonDetail objq = new Person_Details.tbl_PersonDetail();
objq = plc.tbl_PersonDetails.Where(c => c.Person_ID == Convert.ToInt32(hfdpid.Value)).SingleOrDefault();
if (objq.object_type != 1)
{
Name = objq.Business;
}
else
{
Name = objq.First_Name + ' ' + objq.Middle_Name + ' ' + objq.Last_Name;
}
address = objq.Address1;
}
DataTable dt = new DataTable();
dt = Utilities_Licensing.GetNameandLicNumber(Convert.ToInt32(hfdpid.Value));
string st = @"<table cellspacing='0' >
<tr>
<td style='text-align:left;' colspan='3'><b>This email is to alert you that you have been identified as the supervising pharmacist of this pharmacy:</b><br/><br/></td>
</tr>
<tr>
<td style='text-align: left;width:130px'><b>Pharmacy Name:</b></td><td style='text-align:middle;'>" + Name +
"</td></tr><tr><td style='text-align:left;width:130px'><b>Pharmacy Address:</b></td><td style='text-align:middle;'>" + address + "</td>";
//if (dt.Rows[0]["object_type"].ToString() == "1")
// st = st + @"</tr><tr><td style='text-align:left;width:130px'><b>Respondent :</b></td><td style='text-align:middle;'>" + Convert.ToInt32(hfdpid.Value) + "' target='_blank' >" + Name + "</a></td></tr>";
//else
// st = st + @"</tr><tr><td style='text-align:left;width:130px'><b>Respondent :</b></td><td style='text-align:middle;'>" + Convert.ToInt32(hfdpid.Value) + "' target='_blank' >" + Name + "</a></td></tr>";
foreach (DataRow dr in dt.Rows)
{
st = st + @"<tr>
<td style='text-align: left;width:130px'><b>License Type :</b></td>
<td style='text-align:middle;'>" + dr["License_Type"].ToString() + "</td></tr>";
st = st + @"<tr>
<td style='text-align:left;width:130px'><b>License Status :</b></td>
<td style='text-align:middle;'>" + dr["LicenseStatus"].ToString() + "</td></tr>";
st = st + @"<tr>
<td style='text-align:left;width:130px'><b>License # :</b></td>
<td style='text-align:middle;'>" + dr["Lic_no"].ToString() + "</td></tr>";
}
st = st + @"<tr style='margin-top:10px;'>
<td style='text-align:left;' colspan='3'></b><br/><br/><b>If you believe this is in error, please email [email protected] </td>
</tr>";
st = st + "</table>";
if (email != null && email != "")
{
Mail.SendMail("", email, "", "Supervising Pharmacist", st);
}
}
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}