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