protected void GetRequest_n_IssueHeadByIssueID()
{
iPartIssueClient objService = new iPartIssueClient();
try
{
CustomProfile profile = CustomProfile.GetProfile();
POR_SP_GetIssueSummaryBySiteIDsOrUserIDOrRequestIDOrIssueIDs_Result IssueHead = new POR_SP_GetIssueSummaryBySiteIDsOrUserIDOrRequestIDOrIssueIDs_Result();
IssueHead = objService.GetIssueSummayByIssueIDs(Session["PORIssueID"].ToString(), profile.DBConnection._constr).FirstOrDefault();
if (IssueHead != null)
{
lblIssueNo.Text = IssueHead.MINH_ID.ToString();
hdnIssueID.Value = IssueHead.MINH_ID.ToString();
lblIssueDate.Text = IssueHead.IssueDate.Value.ToString("dd-MMM-yyyy");
lblIssuedBy.Text = IssueHead.IssuedByUserName.ToString();
if (IssueHead.AirwayBill != null)
{
lblAirwayBill.Text = IssueHead.AirwayBill;
}
if (IssueHead.ShippingType != null)
{
lblShippingType.Text = IssueHead.ShippingType;
}
if (IssueHead.ShippingDate != null)
{
lblShippingDate.Text = IssueHead.ShippingDate.Value.ToString("dd-MMM-yyyy");
}
if (IssueHead.ExpectedDelDate != null)
{
lblExpDelDate.Text = IssueHead.ExpectedDelDate.Value.ToString("dd-MMM-yyyy");
}
if (IssueHead.TransporterName != null)
{
lblTransporterName.Text = IssueHead.TransporterName;
}
if (IssueHead.IssueRemark != null)
{
lblIssueRemark.Text = IssueHead.IssueRemark;
}
lblRequestNo.Text = IssueHead.PRH_ID.ToString();
lblRequestNo2.Text = IssueHead.PRH_ID.ToString();
hdnRequestID.Value = IssueHead.PRH_ID.ToString();
lblRequestDate.Text = IssueHead.RequestDate.Value.ToString("dd-MMM-yyyy");
lblRequestStatus.Text = IssueHead.IssueStatus.ToString();
lblSites.Text = IssueHead.SiteName.ToString();
hdnSiteID.Value = IssueHead.SiteID.ToString();
lblRequestType.Text = IssueHead.RequestType.ToString();
lblRequestedBy.Text = IssueHead.RequestByUserName.ToString();
Session["PORRequestID"] = IssueHead.PRH_ID.ToString();
GetReceiptHeadByIssueID();
GetReceiptHistoryByRequestID();
}
}
catch { }
finally { objService.Close(); }
}
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 static POR_SP_GetIssueSummaryBySiteIDsOrUserIDOrRequestIDOrIssueIDs_Result WMGetIssueHead(string IssueID)
{
iPartIssueClient objService = new iPartIssueClient();
POR_SP_GetIssueSummaryBySiteIDsOrUserIDOrRequestIDOrIssueIDs_Result IssueHead = new POR_SP_GetIssueSummaryBySiteIDsOrUserIDOrRequestIDOrIssueIDs_Result();
try
{
CustomProfile profile = CustomProfile.GetProfile();
//IssueHead = objService.GetIssueSummayByIssueIDs(HttpContext.Current.Session["PORIssueID"].ToString(), profile.DBConnection._constr).FirstOrDefault();
IssueHead = objService.GetIssueSummayByIssueIDs(IssueID, profile.DBConnection._constr).FirstOrDefault();
}
catch { }
finally { objService.Close(); }
return(IssueHead);
}
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);
}
