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 EMailGetReceiptDetail(POR_SP_GetReceiptSummaryBySiteIDsOrUserIDOrRequestID_Result ReceiptRec)
{
string result = "";
result = "<br/><br/>===================================================" +
"<br/><b>Material Receipt Details </b><br/>" +
"<br/>" +
"Receipt No. : <b>" + ReceiptRec.GRNH_ID.ToString() + "</b>" +
"<br/>" +
"Receipt Date : <b>" + ReceiptRec.GRN_Date.Value.ToString("dd-MMM-yyyy") + "</b>" +
"<br/>" +
"Status : <b>" + ReceiptRec.ReceiptStatus + "</b>" +
"<br/>" +
"Site / Warehouse : <b>" + ReceiptRec.SiteName + "</b>" +
"<br/>" +
"Received By : <b>" + ReceiptRec.ReceiptByUserName + "</b>";
return(result);
}
