public long SetIntoGRNHead(PORtGRNHead GRNHead, string[] conn)
{
BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
if (GRNHead.GRNH_ID == 0)
{
db.PORtGRNHeads.AddObject(GRNHead);
}
else
{
db.PORtGRNHeads.Attach(GRNHead);
db.ObjectStateManager.ChangeObjectState(GRNHead, EntityState.Modified);
}
db.SaveChanges();
if (GRNHead.StatusID > 1)
{
/*Update Issue Status*/
PORtMINHead MINHead = new PORtMINHead();
MINHead = db.PORtMINHeads.Where(r => r.MINH_ID == GRNHead.ReferenceID).FirstOrDefault();
db.PORtMINHeads.Detach(MINHead);
MINHead.StatusID = GRNHead.StatusID;
db.PORtMINHeads.Attach(MINHead);
db.ObjectStateManager.ChangeObjectState(MINHead, EntityState.Modified);
db.SaveChanges();
/*Update Request Status*/
PORtPartRequestHead RequestHead = new PORtPartRequestHead();
RequestHead = db.PORtPartRequestHeads.Where(r => r.PRH_ID == MINHead.PRH_ID).FirstOrDefault();
db.PORtPartRequestHeads.Detach(RequestHead);
RequestHead.StatusID = GRNHead.StatusID;
db.PORtPartRequestHeads.Attach(RequestHead);
db.ObjectStateManager.ChangeObjectState(RequestHead, EntityState.Modified);
db.SaveChanges();
/*End*/
}
return(GRNHead.GRNH_ID);
}
public void GetDefaultConsumptionfromRequestHead()
{
iPartRequestClient objRequestService = new iPartRequestClient();
iPartIssueClient objIssueService = new iPartIssueClient();
iPartReceiptClient objReceiptService = new iPartReceiptClient();
iPartConsumptionClient objConsumptionService = new iPartConsumptionClient();
try
{
HttpContext.Current.Session["PORConsumptionID"] = "0";
CustomProfile profile = CustomProfile.GetProfile();
if (Session["PORReceiptID"] != null)
{
if (Session["PORReceiptID"].ToString() != "0")
{
PORtGRNHead ReceiptHead = new PORtGRNHead();
PORtMINHead IssueHead = new PORtMINHead();
PORtPartRequestHead RequestHead = new PORtPartRequestHead();
ReceiptHead = objReceiptService.GetReceiptHeadByReceiptID(Convert.ToInt64(Session["PORReceiptID"].ToString()), profile.DBConnection._constr);
if (ReceiptHead != null)
{
IssueHead = objIssueService.GetIssueHeadByIssueID(Convert.ToInt64(ReceiptHead.ReferenceID), profile.DBConnection._constr);
}
if (IssueHead != null)
{
RequestHead = objRequestService.GetRequestHeadByRequestID(Convert.ToInt64(IssueHead.PRH_ID), profile.DBConnection._constr);
}
if (RequestHead != null)
{
ddlSites.SelectedIndex = ddlSites.Items.IndexOf(ddlSites.Items.FindByValue(RequestHead.SiteID.ToString()));
UC_DateConsumption.Date = DateTime.Now;
ddlStatus.SelectedIndex = 1;
ddlConsumedBy.DataSource = null;
ddlConsumedBy.DataBind();
ddlConsumedBy.DataSource = WMFillUserList(Convert.ToInt64(RequestHead.SiteID));
ddlConsumedBy.DataBind();
ddlConsumedBy.SelectedIndex = ddlConsumedBy.Items.IndexOf(ddlConsumedBy.Items.FindByValue(profile.Personal.UserID.ToString()));
ddlContainer.DataSource = null;
ddlContainer.DataBind();
ddlContainer.DataSource = WMFillEnginList(Convert.ToInt64(RequestHead.SiteID));
ddlContainer.DataBind();
ddlContainer.SelectedIndex = ddlContainer.Items.IndexOf(ddlContainer.Items.FindByText(RequestHead.Container.ToString()));
lblEngineModel.Text = RequestHead.EngineModel.ToString();
lblEngineSerial.Text = RequestHead.EngineSerial.ToString();
txtFailureHours.Text = RequestHead.FailureHours.ToString();
txtFailureCause.Text = RequestHead.FailureCause.ToString();
txtFailureNature.Text = RequestHead.FailureNature.ToString();
FillPartDetailByReceiptID(Convert.ToInt64(Session["PORReceiptID"].ToString()));
}
}
}
}
catch { }
finally
{
objRequestService.Close();
objIssueService.Close();
objReceiptService.Close();
}
}
