private void SendMailtoForwaredUser()
{
string strFromEmail = "";
string strToEmail = "";
string strCCEmail = "";
List <string> strToEmails = new List <string>();
List <string> strCCEmails = new List <string>();
DataTable dtInquriyDetails = new DatabaseService().executeSelectQuery("SELECT * FROM Inquiry WHERE InquiryNumber = '" + lblInqNo.Text.ToString() + "'");
DataTable dtCusDetais = new DatabaseService().executeSelectQuery("SELECT * FROM Customer WHERE Id = '" + GetCusId(lblInqCus.Text.Trim()) + "'");
strFromEmail = GetEmail(GetEmpId(Views.frmHome.EmpName));
strToEmail = GetEmail(GetEmpId(lblInqForTo.Text.Trim()));
strCCEmail = GetEmail(GetEmpId(lblInqForBy.Text.Trim()));
StringBuilder strBuliderEmailSubject = new StringBuilder();
strBuliderEmailSubject.Append("Inquiry Forward Approved – Customer :" + lblInqCus.Text.Trim() + " " + " -Inquiry No :" + lblInqNo.Text.Trim() + " ");
StringBuilder strBuliderEmailBody = new StringBuilder();
strBuliderEmailBody.Append("<head>");
strBuliderEmailBody.Append("<title>");
strBuliderEmailBody.Append(Guid.NewGuid().ToString());
strBuliderEmailBody.Append("</title>");
strBuliderEmailBody.Append("</head>");
strBuliderEmailBody.Append("<body>");
strBuliderEmailBody.Append("<br>");
strBuliderEmailBody.Append("<br>");
strBuliderEmailBody.Append("Dear " + lblInqForTo.Text.Trim() + ",");
strBuliderEmailBody.Append("<br>");
strBuliderEmailBody.Append("<br>");
strBuliderEmailBody.Append("Inquiry <b><u><FONT COLOR=DodgerBlue>Forwarded</FONT></u></b>, pending for your Acceptance,");
strBuliderEmailBody.Append("<br>");
strBuliderEmailBody.Append("<br>");
strBuliderEmailBody.Append(" <b>Inquiry No : </b>" + lblInqNo.Text.Trim() + "");
strBuliderEmailBody.Append("<br>");
strBuliderEmailBody.Append(" <b>Type : </b>" + lblInqType.Text.Trim() + "");
strBuliderEmailBody.Append("<br>");
strBuliderEmailBody.Append(" <b>Customer : </b>" + lblInqCus.Text.Trim() + "");
strBuliderEmailBody.Append("<br>");
strBuliderEmailBody.Append(" <b>Location : </b>" + GetSubLocationName(dtInquriyDetails.Rows[0]["Location"].ToString()) + "");
strBuliderEmailBody.Append("<br>");
strBuliderEmailBody.Append(" <b>Caller Name : </b>" + dtInquriyDetails.Rows[0]["CallerName"].ToString() + "");
strBuliderEmailBody.Append("<br>");
strBuliderEmailBody.Append(" <b>Caller Phone : </b>" + dtInquriyDetails.Rows[0]["CallerPhone"].ToString() + "");
strBuliderEmailBody.Append("<br>");
strBuliderEmailBody.Append(" <b>Inquiry Details : </b>" + dtInquriyDetails.Rows[0]["FollowupDetails"].ToString() + "");
strBuliderEmailBody.Append("<br>");
strBuliderEmailBody.Append(" <b>Priority : </b>" + dtInquriyDetails.Rows[0]["Priority"].ToString() + "");
strBuliderEmailBody.Append("<br>");
strBuliderEmailBody.Append(" <b>Job Entry Date & Time : </b>" + Convert.ToDateTime(dtInquriyDetails.Rows[0]["JobEntryDate"].ToString()).ToString("mm/dd/yyyy") + " " + dtInquriyDetails.Rows[0]["JobEntryTime"].ToString() + "");
strBuliderEmailBody.Append("<br>");
strBuliderEmailBody.Append(" <b>Forwarded By : </b>" + lblInqForBy.Text.Trim() + "");
strBuliderEmailBody.Append("<br>");
strBuliderEmailBody.Append(" <b>Remarks : </b>" + lblInqRemarks.Text.Trim() + "");
strBuliderEmailBody.Append("<br>");
strBuliderEmailBody.Append(" <b>Forward Approved By : </b>" + Views.frmHome.EmpName + "");
strBuliderEmailBody.Append("<br>");
strBuliderEmailBody.Append(" <b>Forward Approved Date & Time : </b>" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss") + "");
strBuliderEmailBody.Append("<br>");
strBuliderEmailBody.Append("<br>");
strBuliderEmailBody.Append("Regards,");
strBuliderEmailBody.Append("<br>");
strBuliderEmailBody.Append("<br>");
strBuliderEmailBody.Append("" + Views.frmHome.EmpName + "");
strBuliderEmailBody.Append("<br>");
strBuliderEmailBody.Append("<br>");
strBuliderEmailBody.Append("<FONT COLOR=darkred>Auto generated email from CRM system</FONT>");
strBuliderEmailBody.Append("<br>");
strBuliderEmailBody.Append("</body>");
strBuliderEmailBody.Append("</html>");
EmailServices Email = new EmailServices();
Email.SendEmailsCC(strFromEmail.Trim(), strToEmail.Trim(), strCCEmail.Trim(), strBuliderEmailSubject.ToString(), strBuliderEmailBody.ToString());
}
