protected void EmailSendWhenMaterialReceived(long ReceiptID, string[] conn) { try { string MailSubject; string MailBody; int E_ID; BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn)); PORtGRNHead GRNHead1 = new PORtGRNHead(); GRNHead1 = db.PORtGRNHeads.Where(g => g.GRNH_ID == ReceiptID).FirstOrDefault(); POR_SP_GetIssueSummaryBySiteIDsOrUserIDOrRequestIDOrIssueIDs_Result IssueRec = new POR_SP_GetIssueSummaryBySiteIDsOrUserIDOrRequestIDOrIssueIDs_Result(); IssueRec = db.POR_SP_GetIssueSummaryBySiteIDsOrUserIDOrRequestIDOrIssueIDs(GRNHead1.SiteID.Value.ToString(), 0, 0, GRNHead1.ReferenceID.ToString()).FirstOrDefault(); POR_SP_GetReceiptSummaryBySiteIDsOrUserIDOrRequestID_Result ReceiptRec = new POR_SP_GetReceiptSummaryBySiteIDsOrUserIDOrRequestID_Result(); ReceiptRec = db.POR_SP_GetReceiptSummaryBySiteIDsOrUserIDOrRequestID(IssueRec.SiteID.ToString(), 0, IssueRec.PRH_ID).Where(r => r.GRNH_ID == GRNHead1.GRNH_ID).FirstOrDefault(); string partdetail = EMailGetReceiptPratDetail(GRNHead1.GRNH_ID, Convert.ToInt32(GRNHead1.SiteID), conn); /*Acknowledgement Email to Issuer [Project Lead]*/ MailSubject = "Acknowledgement of Material Receipt of " + ReceiptRec.SiteName + " & Receipt No. " + ReceiptRec.GRNH_ID.ToString() + " against Issue No. " + IssueRec.MINH_ID.ToString(); MailBody = " Hello, <br/><b> " + IssueRec.IssuedByUserName + " </b> <br/><br/>" + " This is an automatically generated message in reference to a Material issued for " + ReceiptRec.SiteName + " - ID " + ReceiptRec.GRNH_ID.ToString() + "." + " Material has been received at " + ReceiptRec.SiteName + ", received by " + IssueRec.RequestByUserName + "." + " <br/>" + " Issue & Receipt Details are provided below : "; MailBody = MailBody + "<br/><br/>" + EmailGetIssueDetail(IssueRec.MINH_ID, conn); MailBody = MailBody + EMailGetReceiptDetail(ReceiptRec); MailBody = MailBody + partdetail; SendMail(MailBody + MailGetFooter(), MailSubject, EmailGetEmailIDsByUserID(Convert.ToInt64(IssueRec.IssuedByUserID), conn)); // SaveInboxData(Convert.ToInt64(IssueRec.IssuedByUserID), IssueRec.SiteID, "Receipt", MailSubject, MailBody, Convert.ToInt64(IssueRec.StatusID), conn); /*End*/ /*Information mail to Operation Manger*/ string[] MailTo = new string[] { }; MailTo = EmailGetEmailIDsBySiteIDApprovalLevel(IssueRec.SiteID, 1, conn); string[] MailToName = MailTo[0].Split('|'); string[] MailToEmailID = MailTo[1].Split(','); for (int i = 0; i < MailToName.Count(); i++) { MailBody = " Hello, <br/><b> " + MailToName[i] + " </b> <br/><br/>" + " This is an automatically generated message in reference to a Material issued for " + ReceiptRec.SiteName + " - ID " + ReceiptRec.GRNH_ID.ToString() + "." + " Material has been received at " + ReceiptRec.SiteName + ", received by " + IssueRec.RequestByUserName + "." + " <br/>" + " Issue & Receipt Details are provided below : "; MailBody = MailBody + "<br/><br/>" + EmailGetIssueDetail(IssueRec.MINH_ID, conn); MailBody = MailBody + EMailGetReceiptDetail(ReceiptRec); MailBody = MailBody + partdetail; SendMail(MailBody + MailGetFooter(), MailSubject, MailToEmailID[i]); // E_ID = Convert.ToInt32(GetIDFromEmailName(MailTo[0], MailTo[1], conn)); // SaveInboxData(E_ID, IssueRec.SiteID, "Receipt", MailSubject, MailBody, Convert.ToInt64(IssueRec.StatusID), conn); } } catch { } finally { } }
protected string EmailGetIssueDetail(long IssueID, string[] conn) { string result = ""; try { BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn)); POR_SP_GetIssueSummaryBySiteIDsOrUserIDOrRequestIDOrIssueIDs_Result IssueHead = new POR_SP_GetIssueSummaryBySiteIDsOrUserIDOrRequestIDOrIssueIDs_Result(); IssueHead = db.POR_SP_GetIssueSummaryBySiteIDsOrUserIDOrRequestIDOrIssueIDs("0", 0, 0, IssueID.ToString()).FirstOrDefault(); if (IssueHead != null) { result = "<br/><br/>===================================================" + "<br/><b>Material Issue Details </b><br/>" + "Issue No. : <b>" + IssueHead.IssueNo.ToString() + "</b>" + "<br/>" + "Issue Date : <b>" + IssueHead.IssueDate.Value.ToString("dd-MMM-yyyy") + "</b>" + "<br/>" + "Status : <b>" + IssueHead.IssueStatus + "</b>" + "<br/>" + "Issued By : <b>" + IssueHead.IssuedByUserName + "</b>" + "<br/><br/>===================================================" + "<br/>" + "<b>Transport Detail </b><br/>" + "<br/>" + "Airway Bill : <b>" + IssueHead.AirwayBill + "</b>" + "<br/>" + "Shipping Type : <b>" + IssueHead.ShippingType + "</b>" + "<br/>" + "Shipping Date : <b>" + IssueHead.ShippingDate + "</b>" + "<br/>" + "Exp.Deliver Date : <b>" + IssueHead.ExpectedDelDate + "</b>" + "<br/>" + "Transporter Name : <b>" + IssueHead.TransporterName + "</b>"; } } catch { } return(result); }