private void InsertReocod()
{
if (InqSatatus.SelectedValue != null || InqSeverity.SelectedValue != null || txtRemarks.Text != null)
{
string SQL = string.Empty;
eq.EnqType = iqnRadioButtonList.SelectedValue.ToString();
eq.CustID = lblCustID.Text;
eq.EnqActionOn = Session["UserName"].ToString();
eq.EnqDate = Convert.ToDateTime(DateTime.Now.ToString());
eq.Severity = InqSeverity.SelectedValue.ToString().Trim();
eq.Status = InqSatatus.SelectedValue.ToString().Trim() + "!" + ddlExlation.SelectedValue.ToString();
eq.Remarks = txtRemarks.Text;
InBal.SaveRecord(eq);
GetRecord();
try
{
SendEmailCustomer();
SendActivationEmail();
//display = "Record Saved Successfully. Ticket Numener is:" + TktNumber;
}
catch (Exception ex)
{
display = ex.Message;
}
ScriptManager.RegisterStartupScript(UpdatePanel1385, UpdatePanel1385.GetType(), "popup", "alert('" + display + "');", true);
TktHistoryBind();
//TktHistoryBind();
BindSeverity();
BindStatus();
BindInqType();
txtRemarks.Text = "";
}
else
{
string message = "alert('Please Enter the values..')";
ScriptManager.RegisterClientScriptBlock((CmdGenerated as Control), this.GetType(), "alert", message, true);
}
}
protected void cmdUpdate_Click(object sender, EventArgs e)
{
if (Session["TKTID"] != string.Empty)
{
try
{
string GetTID = Session["TKTID"].ToString();
eq.TKTID = GetTID;
eq.EnqType = iqnRadioButtonList.SelectedValue.ToString();
eq.EnqActionOn = Session["UserName"].ToString();
eq.EnqDate = Convert.ToDateTime(DateTime.Now.ToString());
eq.Severity = InqSeverity.SelectedValue.ToString().Trim();
eq.Status = InqSatatus.SelectedValue.ToString().Trim() + "!" + ddlExlation.SelectedValue.ToString();
eq.Remarks = txtRemarks.Text;
//Update Method Other_Z
ObjDAL.InqueryUpdateDetails(GetTID, iqnRadioButtonList.SelectedValue.ToString(), InqSeverity.SelectedValue.ToString().Trim()
, InqSatatus.SelectedValue.ToString().Trim() + "!" + ddlExlation.SelectedValue.ToString(),
txtRemarks.Text, Session["UserName"].ToString());
UpdateTKTRecord();
TktHistoryBind();
//SendActivationEmail();
// SendActivationEmail();
RemarksHistoryBind();
string display = "Ticket No " + UpdTktID + " Updated Successfuly...";
ScriptManager.RegisterStartupScript(UpdatePanel1385, UpdatePanel1385.GetType(), "popup", "alert('" + display + "')", true);
BindReset();
}
catch (Exception ex)
{
}
}
}
protected void SendActivationEmail()
{
try
{
eq.CustID = Session["CustID"].ToString();
string Date = DateTime.Now.ToString("yyyy-MM-dd");
DateTime DE = DateTime.ParseExact(Date, "yyyy-MM-dd", CultureInfo.InvariantCulture);
String Datetime = DE.ToString("dd-MMM-yyyy");
string CustID = Session["CustID"].ToString();
DataTable DT = new DataTable();
DataSet StrEmailID = ObjDAL.InqTypeEmailID(CustID, "GetEmail", Convert.ToInt32(iqnRadioButtonList.SelectedValue.ToString()));
string TO = "";
if (StrEmailID.Tables[0].Rows.Count > 0)
{
// string TO = "*****@*****.**";
if (StrEmailID.Tables[0].Rows[0]["EmailFrom"].ToString() != "")
{
TO = StrEmailID.Tables[0].Rows[0]["EmailFrom"].ToString();
}
MailMessage mailMessage = new MailMessage();
mailMessage.To.Add(TO);
String MFromID = ConfigurationManager.AppSettings["FromMail"].ToString();
String MPwd = ConfigurationManager.AppSettings["Password"].ToString();
mailMessage.From = new MailAddress(ConfigurationManager.AppSettings["FromMail"].ToString());
mailMessage.Subject = StrEmailID.Tables[0].Rows[0]["EmailSub"].ToString() + ": " + Datetime;
string body = StrEmailID.Tables[0].Rows[0]["EmailBody"].ToString() + "," + "\n\n";
//body += "Your inquiry has been successfully received." + "\n\n";
body += "Inquiry ticket number: " + Session["TicketGet"].ToString() + "\n\n";
//body += "Please use the above ticket number for future reference." + "\n\n\n";
body += StrEmailID.Tables[0].Rows[0]["EmailSign"].ToString() + "," + "\n";
mailMessage.Body = body;
SmtpClient smtp = new SmtpClient();
smtp.Host = ConfigurationManager.AppSettings["SMTP"].ToString();
smtp.Port = Convert.ToInt32(ConfigurationManager.AppSettings["Port"].ToString());
smtp.UseDefaultCredentials = false;
smtp.Credentials = new System.Net.NetworkCredential(MFromID, MPwd);
smtp.EnableSsl = Convert.ToBoolean(ConfigurationManager.AppSettings["Enablessl"].ToString());
smtp.Send(mailMessage);
string Messgae = string.Empty;
Messgae = "Ticket: " + TktNumber + "raised successfully. Email sent to customer.";
ScriptManager.RegisterStartupScript(UpdatePanel1385, UpdatePanel1385.GetType(), "popup", "alert('" + Messgae + "');", true);
}
else
{
string Messgae = string.Empty;
Messgae = "Ticket: " + TktNumber + "raised successfully. Email not sent to customer.";
ScriptManager.RegisterStartupScript(UpdatePanel1385, UpdatePanel1385.GetType(), "popup", "alert('" + Messgae + "');", true);
}
}
catch (Exception ex)
{
Console.WriteLine("{0} Exception caught.", ex);
}
}
protected void SendEmailCustomer()
{
try
{
string CustID = Session["CustID"].ToString();
string Date = DateTime.Now.ToString("yyyy-MM-dd");
DateTime DE = DateTime.ParseExact(Date, "yyyy-MM-dd", CultureInfo.InvariantCulture);
String Datetime = DE.ToString("dd-MMM-yyyy");
DataSet StrEmailID = ObjDAL.InqTypeEmailID(CustID, "GetCustEmail", 0);
string TO = "";
string Messgae = string.Empty;
if (StrEmailID.Tables[0].Rows.Count > 0)
{
if (StrEmailID.Tables[0].Rows[0]["EmailID"].ToString() != "")
{
TO = StrEmailID.Tables[0].Rows[0]["EmailID"].ToString();
}
MailMessage mailMessage = new MailMessage();
mailMessage.To.Add(TO);
String MFromID = ConfigurationManager.AppSettings["FromMail"].ToString();
String MPwd = ConfigurationManager.AppSettings["Password"].ToString();
mailMessage.From = new MailAddress(ConfigurationManager.AppSettings["FromMail"].ToString());
mailMessage.Bcc.Add(new MailAddress("*****@*****.**"));
//mailMessage.From = new MailAddress("*****@*****.**");
mailMessage.Subject = "Inquiry Received: " + Datetime;
string body = "Dear " + Session["CustName"].ToString() + "," + "\n\n";
body += "Your inquiry has been successfully received." + "\n\n";
body += "Inquiry ticket number: " + TktNumber + "\n\n";
body += "Please use the above ticket number for future reference." + "\n\n\n";
body += "Regards" + "," + "\n";
body += "Chetana" + "\n";
mailMessage.Body = body;
SmtpClient smtp = new SmtpClient();
smtp.Host = ConfigurationManager.AppSettings["SMTP"].ToString();
smtp.Port = Convert.ToInt32(ConfigurationManager.AppSettings["Port"].ToString());
smtp.UseDefaultCredentials = false;
smtp.Credentials = new System.Net.NetworkCredential(MFromID, MPwd);
smtp.EnableSsl = Convert.ToBoolean(ConfigurationManager.AppSettings["Enablessl"].ToString());
try
{
smtp.Send(mailMessage);
display = "Mail Sent";
// Messgae = "Mail Sent";
}
catch (Exception ex)
{
display = ex.Message;
//Messgae = ex.Message;
// display = ex.Message;
}
Messgae = "Inquiry saved successfully with ticket number " + TktNumber + " " + display;
ScriptManager.RegisterStartupScript(UpdatePanel1385, UpdatePanel1385.GetType(), "popup", "alert('" + Messgae + "');", true);
}
else
{
// string Messgae = string.Empty;
Messgae = "Inquiry saved successfully with ticket number" + TktNumber + " " + display;
ScriptManager.RegisterStartupScript(UpdatePanel1385, UpdatePanel1385.GetType(), "popup", "alert('" + Messgae + "');", true);
}
}
catch (Exception ex)
{
Console.WriteLine("{0} Exception caught.", ex);
}
}
