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