protected void FillGVRequest(string FillBy) { iPartIssueClient objServie = new iPartIssueClient(); try { CustomProfile profile = CustomProfile.GetProfile(); GVIssue.DataSource = null; GVIssue.DataBind(); if (FillBy == "UserID") { GVIssue.DataSource = objServie.GetIssueSummayByUserID(profile.Personal.UserID, profile.DBConnection._constr); } else if (FillBy == "SiteID") { GVIssue.DataSource = objServie.GetIssueSummayBySiteIDs(Session["SiteIDs"].ToString(), profile.DBConnection._constr); } else if (FillBy == "RequestID") { GVIssue.DataSource = objServie.GetIssueSummayByRequestID(Convert.ToInt64(Session["PORRequestID"].ToString()), profile.DBConnection._constr); } GVIssue.DataBind(); } catch { } finally { objServie.Close(); } }
public static List <BrilliantWMS.PORServicePartIssue.mStatu> WMFillStatus() { string state = HttpContext.Current.Session["PORstate"].ToString(); iPartIssueClient objService = new iPartIssueClient(); List <BrilliantWMS.PORServicePartIssue.mStatu> StatusList = new List <BrilliantWMS.PORServicePartIssue.mStatu>(); try { CustomProfile profile = CustomProfile.GetProfile(); if ((HttpContext.Current.Session["PORIssueID"] != null) && (state == "Add" || state == "Edit")) { BrilliantWMS.PORServicePartIssue.mStatu IssueStatus = new BrilliantWMS.PORServicePartIssue.mStatu() { ID = 100, Status = "Issue" }; StatusList = objService.GetStatusListForIssue("All", state, profile.Personal.UserID, profile.DBConnection._constr).ToList(); StatusList.Insert(1, IssueStatus); } else if (HttpContext.Current.Session["PORIssueID"].ToString() != "0" && state == "View") { StatusList = objService.GetStatusListForIssue("", "", 0, profile.DBConnection._constr).ToList(); } BrilliantWMS.PORServicePartIssue.mStatu select = new BrilliantWMS.PORServicePartIssue.mStatu() { ID = 0, Status = "-Select-" }; StatusList.Insert(0, select); } catch { } finally { objService.Close(); } return(StatusList); }
protected void Grid1_OnRebind(object sender, EventArgs e) { iPartIssueClient objService = new iPartIssueClient(); try { CustomProfile profile = CustomProfile.GetProfile(); List <POR_SP_GetPartDetails_OfMIN_Result> IssuePartList = new List <POR_SP_GetPartDetails_OfMIN_Result>(); if (hdnPendingSelectedRec.Value == "") { IssuePartList = objService.GetExistingTempDataBySessionIDObjectName(Session.SessionID, profile.Personal.UserID.ToString(), ObjectName, profile.DBConnection._constr).ToList(); } else if (hdnPendingSelectedRec.Value != "") { IssuePartList = objService.AddPartIntoIssue_TempData(hdnPendingSelectedRec.Value, 0, 0, "true", Session.SessionID, profile.Personal.UserID.ToString(), ObjectName, profile.DBConnection._constr).ToList(); hdnPendingSelectedRec.Value = ""; } Grid1.DataSource = null; Grid1.DataBind(); // IssuePartList.Where(r => r.Installable == Convert.ToBoolean(1)).FirstOrDefault(); Grid1.DataSource = IssuePartList; Grid1.DataBind(); } catch { } finally { objService.Close(); } }
public static string WMSaveTransferHead(object objTrans) { string result = ""; long TransferedID = 0; iPartIssueClient objService = new iPartIssueClient(); try { CustomProfile profile = CustomProfile.GetProfile(); PORtTransHead TransHead = new PORtTransHead(); Dictionary <string, object> dictionary = new Dictionary <string, object>(); dictionary = (Dictionary <string, object>)objTrans; TransHead.CreatedBy = profile.Personal.UserID; TransHead.CreationDt = DateTime.Now; TransHead.ToSiteID = Convert.ToInt64(dictionary["ToSiteID"]); TransHead.MIN_No = "N/A"; TransHead.TransferDate = Convert.ToDateTime(dictionary["TransferDate"]); TransHead.TransferedByUserID = Convert.ToInt64(dictionary["TransferedByUserID"]); TransHead.StatusID = Convert.ToInt64(dictionary["StatusID"]); TransHead.AirwayBill = dictionary["AirwayBill"].ToString(); TransHead.ShippingType = dictionary["ShippingType"].ToString(); if (dictionary["ShippingDate"].ToString() != "") { TransHead.ShippingDate = Convert.ToDateTime(dictionary["ShippingDate"].ToString()); } if (dictionary["ExpectedDelDate"].ToString() != "") { TransHead.ExpectedDelDate = Convert.ToDateTime(dictionary["ExpectedDelDate"].ToString()); } TransHead.TransporterName = dictionary["TransporterName"].ToString(); TransHead.Remark = dictionary["Remark"].ToString(); TransHead.IsSubmit = Convert.ToBoolean(dictionary["IsSubmit"]); TransHead.FromSiteID = Convert.ToInt64(dictionary["FromSiteID"]); TransHead.PRH_ID = Convert.ToInt64(HttpContext.Current.Session["PORRequestID"].ToString()); TransferedID = objService.SetIntoTransHead(TransHead, profile.DBConnection._constr); if (TransferedID > 0) { string TransferStatus = "NA"; if (TransHead.StatusID != 1 && TransHead.StatusID != 10) { TransferStatus = "Transfer"; } objService.FinalSaveTransferPartDetail(HttpContext.Current.Session.SessionID, ObjectName, TransferedID, Convert.ToInt64(TransHead.PRH_ID), profile.Personal.UserID.ToString(), TransferStatus, Convert.ToInt64(TransHead.FromSiteID), profile.DBConnection._constr); result = "Material Transfer record saved successfully"; } } catch { result = "Some error occurred"; } finally { objService.Close(); } result = Convert.ToString(TransferedID); return(result); }
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(); } }
public static void WMRemovePartFromIssue(Int32 Sequence) { iPartIssueClient objService = new iPartIssueClient(); try { Dictionary <string, object> dictionary = new Dictionary <string, object>(); CustomProfile profile = CustomProfile.GetProfile(); objService.RemovePartFromIssue_TempData(HttpContext.Current.Session.SessionID, profile.Personal.UserID.ToString(), ObjectName, Sequence, profile.DBConnection._constr); } catch { } finally { objService.Close(); } }
public static int WMGetIssueSummaryByRequestID() { int result = 0; iPartIssueClient objService = new iPartIssueClient(); try { CustomProfile profile = CustomProfile.GetProfile(); result = objService.GetIssueSummayByRequestID(Convert.ToInt64(HttpContext.Current.Session["PORRequestID"].ToString()), profile.DBConnection._constr).Count(); } catch { } finally { objService.Close(); } return(result); }
protected void Grid2_OnRebind(object sender, EventArgs e) { iPartIssueClient objService = new iPartIssueClient(); try { CustomProfile profile = CustomProfile.GetProfile(); Grid2.DataSource = null; Grid2.DataBind(); Grid2.DataSource = objService.GetPendingIssuePartList(Session.SessionID, profile.Personal.UserID.ToString(), ObjectName, Convert.ToInt64(Session["PORRequestID"].ToString()), profile.DBConnection._constr); Grid2.DataBind(); } catch { } finally { objService.Close(); } }
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); }
public static PORtMINHead WMSetSessionIssue(string InvokerObject, long IssueID, string state) { iPartIssueClient objService = new iPartIssueClient(); PORtMINHead IssueHead = new PORtMINHead(); try { CustomProfile profile = CustomProfile.GetProfile(); HttpContext.Current.Session["PORIssueID"] = IssueID; HttpContext.Current.Session["PORstate"] = state; objService.ClearTempDataFromDB(HttpContext.Current.Session.SessionID, profile.Personal.UserID.ToString(), ObjectName, profile.DBConnection._constr); objService.GetIssuePartDetailByIssueID(IssueID, HttpContext.Current.Session.SessionID, profile.Personal.UserID.ToString(), ObjectName, "true", profile.DBConnection._constr).ToList(); IssueHead = objService.GetIssueHeadByIssueID(IssueID, profile.DBConnection._constr); } catch { } finally { objService.Close(); } return(IssueHead); }
public static void WMpageAddNew() { iPartIssueClient objService = new iPartIssueClient(); try { CustomProfile profile = CustomProfile.GetProfile(); HttpContext.Current.Session["PORIssueID"] = "0"; HttpContext.Current.Session["PORstate"] = "Add"; objService.ClearTempDataFromDB(HttpContext.Current.Session.SessionID, profile.Personal.UserID.ToString(), ObjectName, profile.DBConnection._constr); // objService.GetIssuePartDetailByRequestID(Convert.ToInt64(HttpContext.Current.Session["PORRequestID"].ToString()), HttpContext.Current.Session.SessionID, profile.Personal.UserID.ToString(), ObjectName, "true", profile.DBConnection._constr).ToList(); } catch { } finally { objService.Close(); } }
protected void FillGrid1ByRequestID(long RequestID) { iPartIssueClient objService = new iPartIssueClient(); try { CustomProfile profile = CustomProfile.GetProfile(); List <POR_SP_GetPartDetails_OfMIN_Result> IssuePartList = new List <POR_SP_GetPartDetails_OfMIN_Result>(); IssuePartList = objService.GetIssuePartDetailByRequestID(RequestID, Session.SessionID, profile.Personal.UserID.ToString(), ObjectName, "true", profile.DBConnection._constr).ToList(); Grid1.DataSource = null; Grid1.DataBind(); Grid1.DataSource = IssuePartList; Grid1.DataBind(); } catch { } finally { objService.Close(); } }
public static string WMUpdateHQStock(object objHQ) { string HQQty = ""; iPartIssueClient objService = new iPartIssueClient(); try { Dictionary <string, object> dictionary = new Dictionary <string, object>(); dictionary = (Dictionary <string, object>)objHQ; CustomProfile profile = CustomProfile.GetProfile(); POR_SP_GetPartDetails_OfMIN_Result IssuePart = new POR_SP_GetPartDetails_OfMIN_Result(); IssuePart.Sequence = Convert.ToInt64(dictionary["Sequence"]); IssuePart.IssuedQty = Convert.ToDecimal(dictionary["IssuedQty"]); HQQty = objService.UpdateHQStock_TempData(HttpContext.Current.Session.SessionID, ObjectName, profile.Personal.UserID.ToString(), IssuePart, profile.DBConnection._constr); } catch { } finally { objService.Close(); } return(HQQty); }
public static string WMSaveIssueHead(object objIssue) { string result = ""; iPartIssueClient objService = new iPartIssueClient(); try { CustomProfile profile = CustomProfile.GetProfile(); PORtMINHead IssueHead = new PORtMINHead(); Dictionary <string, object> dictionary = new Dictionary <string, object>(); dictionary = (Dictionary <string, object>)objIssue; if (HttpContext.Current.Session["PORIssueID"] != null) { if (HttpContext.Current.Session["PORIssueID"].ToString() == "0") { IssueHead.CreatedBy = profile.Personal.UserID; IssueHead.CreationDt = DateTime.Now; } else { IssueHead = objService.GetIssueHeadByIssueID(Convert.ToInt64(HttpContext.Current.Session["PORIssueID"]), profile.DBConnection._constr); IssueHead.LastModifiedBy = profile.Personal.UserID; IssueHead.LastModifiedDt = DateTime.Now; } IssueHead.SiteID = Convert.ToInt64(dictionary["SiteID"]); IssueHead.PRH_ID = Convert.ToInt64(HttpContext.Current.Session["PORRequestID"].ToString()); IssueHead.MIN_No = "N/A"; IssueHead.IssueDate = Convert.ToDateTime(dictionary["IssueDate"]); IssueHead.IssuedByUserID = Convert.ToInt64(dictionary["IssuedByUserID"]); IssueHead.StatusID = Convert.ToInt64(dictionary["StatusID"]); IssueHead.AirwayBill = dictionary["AirwayBill"].ToString(); IssueHead.ShippingType = dictionary["ShippingType"].ToString(); if (dictionary["ShippingDate"].ToString() != "") { IssueHead.ShippingDate = Convert.ToDateTime(dictionary["ShippingDate"].ToString()); } if (dictionary["ExpectedDelDate"].ToString() != "") { IssueHead.ExpectedDelDate = Convert.ToDateTime(dictionary["ExpectedDelDate"].ToString()); } IssueHead.TransporterName = dictionary["TransporterName"].ToString(); IssueHead.Remark = dictionary["Remark"].ToString(); IssueHead.IsSubmit = Convert.ToBoolean(dictionary["IsSubmit"]); if (IssueHead.StatusID != 1 && IssueHead.StatusID != 10) { IssueHead.StatusID = objService.GetStatusOfIssueHead(HttpContext.Current.Session.SessionID.ToString(), profile.Personal.UserID.ToString(), ObjectName, Convert.ToInt64(IssueHead.PRH_ID), profile.DBConnection._constr); } long IssueID = objService.SetIntoMINHead(IssueHead, profile.DBConnection._constr); if (IssueID > 0) { string IssueStatus = "NA"; if (IssueHead.StatusID != 1 && IssueHead.StatusID != 10) { IssueStatus = "Issue"; } objService.FinalSaveIssuePartDetail(HttpContext.Current.Session.SessionID, ObjectName, IssueID, Convert.ToInt64(IssueHead.PRH_ID), profile.Personal.UserID.ToString(), IssueStatus, profile.DBConnection._constr); result = "Material Issue record saved successfully"; } } } catch { result = "Some error occurred"; } finally { objService.Close(); } return(result); }
protected void GetIssueHead() { iPartIssueClient objServiceIssue = new iPartIssueClient(); iPartRequestClient objServiceRequest = new iPartRequestClient(); try { CustomProfile profile = CustomProfile.GetProfile(); PORtMINHead IssueHead = new PORtMINHead(); IssueHead = objServiceIssue.GetIssueHeadByIssueID(Convert.ToInt64(HttpContext.Current.Session["PORIssueID"]), profile.DBConnection._constr); ddlStatus.DataSource = WMFillStatus(); ddlStatus.DataBind(); ddlStatus.SelectedIndex = ddlStatus.Items.IndexOf(ddlStatus.Items.FindByValue(IssueHead.StatusID.ToString())); lblIssueNo.Text = IssueHead.MINH_ID.ToString(); UC_IssueDate.Date = DateTime.Now; if (IssueHead.IssueDate != null) { UC_IssueDate.Date = IssueHead.IssueDate; } FillUserList(1); ddlIssuedBy.SelectedIndex = ddlIssuedBy.Items.IndexOf(ddlIssuedBy.Items.FindByValue(IssueHead.IssuedByUserID.ToString())); if (ddlIssuedBy.SelectedIndex == 0) { ddlIssuedBy.SelectedIndex = ddlIssuedBy.Items.IndexOf(ddlIssuedBy.Items.FindByValue(profile.Personal.UserID.ToString())); } /*Transport detail*/ if (IssueHead.AirwayBill != null) { txtAirwayBill.Text = IssueHead.AirwayBill; } if (IssueHead.ShippingType != null) { txtShippingType.Text = IssueHead.ShippingType; } UC_ShippingDate.Date = DateTime.Now; if (IssueHead.ShippingDate != null) { UC_ShippingDate.Date = IssueHead.ShippingDate; } UC_ExpDeliveryDate.Date = DateTime.Now; if (IssueHead.ExpectedDelDate != null) { UC_ExpDeliveryDate.Date = IssueHead.ExpectedDelDate; } if (IssueHead.TransporterName != null) { txtTransporterName.Text = IssueHead.TransporterName; } if (IssueHead.Remark != null) { txtIssueRemark.Text = IssueHead.Remark; } FillGrid1ByIssueID(IssueHead.MINH_ID); Session["PORRequestID"] = IssueHead.PRH_ID.ToString(); DisplayRequestData(); // iframePORIssue.Attributes.Add("src", "../PowerOnRent/GridIssueSummary.aspx?FillBy=RequestID"); divDisabled(); } catch { } finally { objServiceIssue.Close(); } }
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(); } }