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 { } }
public List <POR_SP_GetReceiptSummaryBySiteIDsOrUserIDOrRequestID_Result> GetReceiptSummaryByRequestID(long RequestID, string[] conn) { List <POR_SP_GetReceiptSummaryBySiteIDsOrUserIDOrRequestID_Result> ReceiptSummary = new List <POR_SP_GetReceiptSummaryBySiteIDsOrUserIDOrRequestID_Result>(); try { BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn)); ReceiptSummary = db.POR_SP_GetReceiptSummaryBySiteIDsOrUserIDOrRequestID("0", 0, RequestID).OrderByDescending(o => o.GRNH_ID).ToList(); } catch { } finally { } return(ReceiptSummary); }