public bool PAEmailRequestForApproval(int paid, string ToEmailId, string EmployeeNo)
{
EmailSend emails = new EmailSend();
var ipaddress = ConfigurationManager.AppSettings["UI_IpAddress"];
ipaddress = ipaddress + "SCM/mprpa/" + paid + "";
string reqemployeeno = obj.MPRPADetails.Where(x => x.PAId == paid).FirstOrDefault().RequestedBy;
var maildata = obj.Mailsendingviews.Where(x => x.Approver == EmployeeNo && x.PAId == paid).FirstOrDefault();
try
{
emails.ToEmailId = ToEmailId;
emails.FrmEmailId = obj.Employees.Where(x => x.EmployeeNo == reqemployeeno).FirstOrDefault <Employee>().EMail;
emails.Subject = "Reminder for Purchase Authorization to approve";
emails.Body = "<html><meta charset=\"ISO-8859-1\"><head><link rel = 'stylesheet' href = 'https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css' ></head>" +
"<body>" +
"<div class='container'>" +
"<table border='1' class='table table-bordered table-sm'>" +
"<tr>" +
"<td><b>MPR Number</b></td><td>" + maildata.DocumentNo + "</td>" +
"<td><b>Document Description</b></td><td>" + maildata.DocumentDescription + "</td>" +
"<td><b>Vendor</b></td><td>" + maildata.VendorName + "</td>" +
"</tr>" +
"<tr>" +
"<td><b>Department</b></td><td>" + maildata.Department + "</td>" +
"<td><b>Project Manager</td></td><td>" + maildata.projectmanagername + "</td>" +
"<td><b>Buyer Group</b></td><td>" + maildata.BuyerGroup + "</td></tr>" +
"</tr>" +
"<tr>" +
"<td><b>Paid</b></td><td>" + maildata.PAId + "</td>" +
"<td><b>PARequested</b></td><td>" + maildata.parequestedname + "</td>" +
"<td><b>RequestedOn</b></td><td>" + maildata.RequestedOn + "</td>" +
"</tr>" +
"<tr>" +
"<td><b>Approver Name</b></td><td>" + maildata.approvername + "</td>" +
"<td><b>Approver Status</b></td><td>" + maildata.ApprovalStatus + "</td>" +
"<td><b>Approver Remarks</b></td><td>" + maildata.ApproversRemarks + "</td>" +
"</tr>" +
"</table><br/><b>Request For Purchase Authorization To Approve:</b><br/> <a href='" + ipaddress + "'>" + ipaddress + " </a></div></body></html>";
if (emails.FrmEmailId != "NULL" && emails.ToEmailId != "NULL")
{
sendEmail(emails);
}
return(true);
}
catch (Exception ex)
{
throw;
}
}
public bool sendEmail(EmailSend emlSndngList)
{
bool validEmail = IsValidEmail(emlSndngList.ToEmailId);
if (!string.IsNullOrEmpty(emlSndngList.ToEmailId) && !string.IsNullOrEmpty(emlSndngList.FrmEmailId) && validEmail)
{
string noreply = "<font color='#808080'><i>Note : This is system generated notification email, do not reply to the sender.<br><br>Pls email your response to : " + emlSndngList.FrmEmailId + "</i></font>";
//Mail.Body = noreply + "<br><br>" + Body;
var BCC = ConfigurationManager.AppSettings["PABCC"];
var SMTPServer = ConfigurationManager.AppSettings["SMTPServer"];
var scmfrommail = ConfigurationManager.AppSettings["fromemail"];
MailMessage mailMessage = new MailMessage(scmfrommail, emlSndngList.ToEmailId);
SmtpClient client = new SmtpClient();
if (!string.IsNullOrEmpty(emlSndngList.Subject))
{
mailMessage.Subject = emlSndngList.Subject;
}
if (!string.IsNullOrEmpty(emlSndngList.CC))
{
mailMessage.CC.Add(emlSndngList.CC);
}
if (!string.IsNullOrEmpty(BCC))
{
mailMessage.Bcc.Add(BCC);
}
mailMessage.Body = noreply + "<br><br>" + emlSndngList.Body;
//Mail.From = ConfigurationSettings.AppSettings["AppFromEmailid"].ToString();
//mailMessage.Body = emlSndngList.Body;
mailMessage.IsBodyHtml = true;
mailMessage.BodyEncoding = Encoding.UTF8;
SmtpClient mailClient = new SmtpClient(SMTPServer, 25);
//SmtpClient mailClient = new SmtpClient("10.29.15.9", 25);
//mailClient.EnableSsl = true;
mailClient.DeliveryMethod = SmtpDeliveryMethod.Network;
mailClient.Send(mailMessage);
}
return(true);
bool IsValidEmail(string email)
{
try
{
var addr = new System.Net.Mail.MailAddress(email);
return(addr.Address == email);
}
catch
{
return(false);
}
}
}
public bool msaconfirmationmail(int paid)
{
var ipaddress = ConfigurationManager.AppSettings["UI_IpAddress"];
EmailSend send = new EmailSend();
send.FrmEmailId = obj.LoadMSALineItems.Where(x => x.paid == paid).FirstOrDefault().ConfirmedBy;
send.ToEmailId = "*****@*****.**";
send.Subject = "MSA Confirmation for YGS Upload";
if (!string.IsNullOrEmpty(send.FrmEmailId) && !string.IsNullOrEmpty(send.FrmEmailId))
{
sendEmail(send);
}
return(true);
}
public bool PAEmailRequest(int paid, string loginemployee)
{
var ipaddress = ConfigurationManager.AppSettings["UI_IpAddress"];
var data = obj.MPRPAApprovers.Where(x => x.PAId == paid).ToList();
ipaddress = ipaddress + "SCM/mprpa/" + paid + "";
EmailSend mails = new EmailSend();
mails.FrmEmailId = obj.Employees.Where(x => x.EmployeeNo == loginemployee).FirstOrDefault <Employee>().EMail;
//mails.CC = "*****@*****.**";
foreach (var item in data)
{
var maildata = obj.Mailsendingviews.Where(x => x.Approver == item.Approver && x.PAId == paid).FirstOrDefault();
mails.Body = "<html><meta charset=\"ISO-8859-1\"><head><link rel = 'stylesheet' href = 'https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css' ></head>" +
"<body>" +
"<div class='container'>" +
"<table border='1' class='table table-bordered table-sm'>" +
"<tr>" +
"<td><b>MPR Number</b></td><td>" + maildata.DocumentNo + "</td>" +
"<td><b>Document Description</b></td><td>" + maildata.DocumentDescription + "</td>" +
"<td><b>Vendor</b></td><td>" + maildata.VendorName + "</td>" +
"</tr>" +
"<tr>" +
"<td><b>Department</b></td><td>" + maildata.Department + "</td>" +
"<td><b>Project Manager</td></td><td>" + maildata.projectmanagername + "</td>" +
"<td><b>Buyer Group</b></td><td>" + maildata.BuyerGroup + "</td></tr>" +
"</tr>" +
"<tr>" +
"<td><b>Paid</b></td><td>" + maildata.PAId + "</td>" +
"<td><b>PARequested</b></td><td>" + maildata.parequestedname + "</td>" +
"<td><b>RequestedOn</b></td><td>" + maildata.RequestedOn + "</td>" +
"</tr>" +
"<tr>" +
"<td><b>Approver Name</b></td><td>" + maildata.approvername + "</td>" +
"<td><b>Approver Status</b></td><td>" + maildata.ApprovalStatus + "</td>" +
"<td><b>Approver Remarks</b></td><td>" + maildata.ApproversRemarks + "</td>" +
"</tr>" +
"</table><br/><b>Please Click The Below Link To Approve:</b><br/> <a href='" + ipaddress + "'>" + ipaddress + " </a></div></body></html>";
mails.ToEmailId = obj.Employees.Where(x => x.EmployeeNo == item.Approver).FirstOrDefault <Employee>().EMail;
mails.Subject = "Purchase Authorization Waiting For Your Approval";
if (mails.FrmEmailId != "NULL" && mails.ToEmailId != "NULL")
{
this.sendEmail(mails);
}
}
return(true);
}
public bool sendEmail(EmailSend emlSndngList)
{
bool validEmail = IsValidEmail(emlSndngList.ToEmailId);
if (!string.IsNullOrEmpty(emlSndngList.ToEmailId) && !string.IsNullOrEmpty(emlSndngList.FrmEmailId) && validEmail)
{
var BCC = ConfigurationManager.AppSettings["PABCC"];
var SMTPServer = ConfigurationManager.AppSettings["SMTPServer"];
MailMessage mailMessage = new MailMessage(emlSndngList.FrmEmailId, emlSndngList.ToEmailId);
SmtpClient client = new SmtpClient();
if (!string.IsNullOrEmpty(emlSndngList.Subject))
{
mailMessage.Subject = emlSndngList.Subject;
}
if (!string.IsNullOrEmpty(emlSndngList.CC))
{
mailMessage.CC.Add(emlSndngList.CC);
}
if (!string.IsNullOrEmpty(BCC))
{
mailMessage.Bcc.Add(BCC);
}
mailMessage.Body = emlSndngList.Body;
mailMessage.IsBodyHtml = true;
mailMessage.BodyEncoding = Encoding.UTF8;
SmtpClient mailClient = new SmtpClient(SMTPServer, 25);
//SmtpClient mailClient = new SmtpClient("10.29.15.9", 25);
//mailClient.EnableSsl = true;
mailClient.DeliveryMethod = SmtpDeliveryMethod.Network;
mailClient.Send(mailMessage);
}
return(true);
bool IsValidEmail(string email)
{
try
{
var addr = new System.Net.Mail.MailAddress(email);
return(addr.Address == email);
}
catch
{
return(false);
}
}
}
public bool paemailstatus(int statusid, int paid, int mprrevisionid, string ApprovalStatus, string employeeno)
{
var ipaddress = ConfigurationManager.AppSettings["UI_IpAddress"];
var ipaddress1 = ConfigurationManager.AppSettings["UI_IpAddress"];
string parequestby = obj.MPRPADetails.Where(x => x.PAId == paid).FirstOrDefault().RequestedBy;
ipaddress = ipaddress + "SCM/mprpa/" + paid + "";
ipaddress1 = ipaddress1 + "SCM/MPRForm/" + mprrevisionid + "";
EmailSend mails = new EmailSend();
mails.FrmEmailId = obj.Employees.Where(x => x.EmployeeNo == employeeno).FirstOrDefault <Employee>().EMail;
string mprpreparedby = obj.MPRRevisions.Where(x => x.RevisionId == mprrevisionid).FirstOrDefault().PreparedBy;
if (ApprovalStatus == "Approved")
{
var maildata = obj.Mailsendingviews.Where(x => x.Approver == employeeno && x.PAId == paid).FirstOrDefault();
mails.Body = "<html><meta charset=\"ISO-8859-1\"><head><link rel = 'stylesheet' href = 'https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css' ></head>" +
"<body>" +
"<div class='container'>" +
"<table border='1' class='table table-bordered table-sm'>" +
"<tr>" +
"<td><b>Paid</b></td><td>" + maildata.PAId + "</td>" +
"<td><b>PARequested</b></td><td>" + maildata.parequestedname + "</td>" +
"<td><b>RequestedOn</b></td><td>" + maildata.RequestedOn + "</td>" +
"</tr>" +
"<tr>" +
"<td><b>Approver Name</b></td><td>" + maildata.approvername + "</td>" +
"<td><b>Approver Status</b></td><td>" + maildata.ApprovalStatus + "</td>" +
"<td><b>Approver Remarks</b></td><td>" + maildata.ApproversRemarks + "</td>" +
"</tr>" +
"</table><br/><b>Please click the below link to View:</b><br/> <a href='" + ipaddress + "'>" + ipaddress + " </a></div></body></html>";
mails.ToEmailId = obj.Employees.Where(x => x.EmployeeNo == parequestby).FirstOrDefault <Employee>().EMail;
mails.Subject = "Purchase Authorization Is Approved";
Nullable <byte> buyergroup = obj.MPRRevisions.Where(x => x.RevisionId == mprrevisionid).FirstOrDefault().BuyerGroupId;
string BuyerManager = obj.MPRBuyerGroups.Where(x => x.BuyerGroupId == buyergroup).FirstOrDefault().BuyerManager;
mails.CC = obj.Employees.Where(x => x.EmployeeNo == BuyerManager).FirstOrDefault().EMail;
if (mails.FrmEmailId != "NULL" && mails.ToEmailId != "NULL")
{
sendEmail(mails);
}
mails.ToEmailId = obj.Employees.Where(x => x.EmployeeNo == mprpreparedby).FirstOrDefault().EMail;
mails.Body = "<html><meta charset=\"ISO-8859-1\"><head><link rel = 'stylesheet' href = 'https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css' ></head><body><div class='container'><br/><b>Please click the below link to View:</b><br/> <a href='" + ipaddress1 + "'>" + ipaddress1 + " </a></div></body></html>";
mails.CC = "";
if (mails.FrmEmailId != "NULL" && mails.ToEmailId != "NULL")
{
sendEmail(mails);
}
}
else
{
mails.Body = "<html><meta charset=\"ISO-8859-1\"><head><link rel = 'stylesheet' href = 'https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css' ></head><body><div class='container'><br/><b>Please click the below link to View:</b><br/> <a href='" + ipaddress + "'>" + ipaddress + " </a></div></body></html>";
mails.ToEmailId = obj.Employees.Where(x => x.EmployeeNo == parequestby).FirstOrDefault <Employee>().EMail;
mails.Subject = "Purchase Authorization Is Rejected";
Nullable <byte> buyergroup = obj.MPRRevisions.Where(x => x.RevisionId == mprrevisionid).FirstOrDefault().BuyerGroupId;
string BuyerManager = obj.MPRBuyerGroups.Where(x => x.BuyerGroupId == buyergroup).FirstOrDefault().BuyerManager;
mails.CC = obj.Employees.Where(x => x.EmployeeNo == BuyerManager).FirstOrDefault().EMail;
if (mails.FrmEmailId != "NULL" && mails.ToEmailId != "NULL")
{
sendEmail(mails);
}
mails.ToEmailId = obj.Employees.Where(x => x.EmployeeNo == mprpreparedby).FirstOrDefault().EMail;
mails.Body = "<html><meta charset=\"ISO-8859-1\"><head><link rel = 'stylesheet' href = 'https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css' ></head><body><div class='container'><br/><b>Please click the below link to View:</b><br/> <a href='" + ipaddress1 + "'>" + ipaddress1 + " </a></div></body></html>";
mails.CC = "";
if (mails.FrmEmailId != "NULL" && mails.ToEmailId != "NULL")
{
sendEmail(mails);
}
//mails.Body = "<html><meta charset=\"ISO-8859-1\"><head><link rel = 'stylesheet' href = 'https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css' ></head><body><div class='container'><br/><b>Please Click The Below Link To Approve:</b><br/> <a href='" + ipaddress + "'>" + ipaddress + " </a></div></body></html>";
//mails.ToEmailId = obj.Employees.Where(x => x.EmployeeNo == parequestby).FirstOrDefault().EMail;
//mails.mprpreparedby = obj.Employees.Where(x => x.EmployeeNo == mprpreparedby).FirstOrDefault().EMail;
//mails.Subject = "Purchase Authorization Is Rejected";
//sendEmail(mails);
}
return(true);
}
public bool ScrapApprovalRequest(int scrapid, string approvalname, string Requestedby, string type)
{
var ipaddress = ConfigurationManager.AppSettings["UI_IpAddress"];
ipaddress = ipaddress + "SCM/scrapregister/" + scrapid + "";
EmailSend send = new EmailSend();
if (type == "Approverequest")
{
if (!string.IsNullOrEmpty(Requestedby))
{
send.FrmEmailId = obj.Employees.Where(x => x.EmployeeNo == Requestedby).FirstOrDefault().EMail;
}
if (!string.IsNullOrEmpty(approvalname))
{
send.ToEmailId = obj.Employees.Where(x => x.EmployeeNo == approvalname).FirstOrDefault().EMail;
}
//send.FrmEmailId = "*****@*****.**";
//send.ToEmailId = "*****@*****.**";
send.Subject = "Scrap Request For Approval - " + scrapid;
send.Body = "<html><meta charset=\"ISO-8859-1\"><head><link rel = 'stylesheet' href = 'https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css' ></head><body><div class='container'><br/><b>Please click the below link to Approve Scrap Request:</b><br/> <a href='" + ipaddress + "'>" + ipaddress + " </a></div></body></html>";
}
if (type == "sorequest")
{
if (!string.IsNullOrEmpty(Requestedby))
{
send.FrmEmailId = obj.Employees.Where(x => x.EmployeeNo == Requestedby).FirstOrDefault().EMail;
}
if (!string.IsNullOrEmpty(approvalname))
{
send.ToEmailId = obj.Employees.Where(x => x.EmployeeNo == approvalname).FirstOrDefault().EMail;
}
send.Subject = "Scrap Request Waiting For SO Creation - " + scrapid;
send.Body = "<html><meta charset=\"ISO-8859-1\"><head><link rel = 'stylesheet' href = 'https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css' ></head><body><div class='container'><br/><b>SO Creation is Pending:</b><br/> <a href='" + ipaddress + "'>" + ipaddress + " </a></div></body></html>";
}
if (type == "vatinvoice")
{
if (!string.IsNullOrEmpty(Requestedby))
{
send.FrmEmailId = obj.Employees.Where(x => x.EmployeeNo == Requestedby).FirstOrDefault().EMail;
}
if (!string.IsNullOrEmpty(approvalname))
{
send.ToEmailId = obj.Employees.Where(x => x.EmployeeNo == approvalname).FirstOrDefault().EMail;
}
send.Subject = "Scrap Request Waiting For VAT Invoice Creation - " + scrapid;
send.Body = "<html><meta charset=\"ISO-8859-1\"><head><link rel = 'stylesheet' href = 'https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css' ></head><body><div class='container'><br/><b> Scrap Requset Waiting For Invoice Prepration:</b><br/> <a href='" + ipaddress + "'>" + ipaddress + " </a></div></body></html>";
}
if (type == "FundVerification")
{
if (!string.IsNullOrEmpty(Requestedby))
{
send.FrmEmailId = obj.Employees.Where(x => x.EmployeeNo == Requestedby).FirstOrDefault().EMail;
}
if (!string.IsNullOrEmpty(approvalname))
{
send.ToEmailId = obj.Employees.Where(x => x.EmployeeNo == approvalname).FirstOrDefault().EMail;
}
send.Subject = "Scrap Request Waiting For Fund Verification - " + scrapid;
send.Body = "<html><meta charset=\"ISO-8859-1\"><head><link rel = 'stylesheet' href = 'https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css' ></head><body><div class='container'><br/><b>Scrap Requset Waiting For Fund Verification:</b><br/> <a href='" + ipaddress + "'>" + ipaddress + " </a></div></body></html>";
}
if (type == "ReadyToDisPatch")
{
if (!string.IsNullOrEmpty(Requestedby))
{
send.FrmEmailId = obj.Employees.Where(x => x.EmployeeNo == Requestedby).FirstOrDefault().EMail;
}
if (!string.IsNullOrEmpty(approvalname))
{
send.ToEmailId = obj.Employees.Where(x => x.EmployeeNo == approvalname).FirstOrDefault().EMail;
}
send.Subject = "Scrap Request Waiting For Dispatch Clearance - " + scrapid;
send.Body = "<html><meta charset=\"ISO-8859-1\"><head><link rel = 'stylesheet' href = 'https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css' ></head><body><div class='container'><br/><b>Scrap Requset Waiting For Dispatch Clearance:</b><br/> <a href='" + ipaddress + "'>" + ipaddress + " </a></div></body></html>";
}
if (type == "DisPatchDone")
{
if (!string.IsNullOrEmpty(Requestedby))
{
send.FrmEmailId = obj.Employees.Where(x => x.EmployeeNo == Requestedby).FirstOrDefault().EMail;
}
if (!string.IsNullOrEmpty(approvalname))
{
send.ToEmailId = obj.Employees.Where(x => x.EmployeeNo == approvalname).FirstOrDefault().EMail;
}
send.Subject = "Scrap Request Completed- " + scrapid;
send.Body = "<html><meta charset=\"ISO-8859-1\"><head><link rel = 'stylesheet' href = 'https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css' ></head><body><div class='container'><br/><b>TAX Invoice is Pending:</b><br/> <a href='" + ipaddress + "'>" + ipaddress + " </a></div></body></html>";
}
if (!string.IsNullOrEmpty(send.FrmEmailId) && !string.IsNullOrEmpty(send.ToEmailId))
{
sendEmail(send);
}
return(true);
}
