public void bindgrid() { BrilliantWMS.WMSOutbound.iOutboundClient Outbound = new WMSOutbound.iOutboundClient(); try { CustomProfile profile = CustomProfile.GetProfile(); DataSet ds = new DataSet(); string role = profile.Personal.UserType.ToString(); if (role == "Super Admin" || role == "Admin" || role == "Warehouse Admin") { long userCompany = profile.Personal.CompanyID; ds = Outbound.BindOutboundGrid(userCompany, profile.DBConnection._constr); } else { ds = Outbound.BindOutboundGridbyUser(profile.Personal.UserID, profile.DBConnection._constr); } grdSalesOrder.DataSource = ds; grdSalesOrder.DataBind(); grdSalesOrder.AllowMultiRecordSelection = true; grdSalesOrder.AllowRecordSelection = true; } catch { } finally { Outbound.Close(); } }
public static int WMChangeStatus(string SelectedRec) { int Result = 0; BrilliantWMS.WMSOutbound.iOutboundClient Outbound = new WMSOutbound.iOutboundClient(); try { CustomProfile profile = CustomProfile.GetProfile(); Result = Outbound.ChangeStatusToMarkForReturn(SelectedRec, profile.Personal.UserID, profile.DBConnection._constr); BrilliantWMS.WMSOutbound.tReturnHead rtrn = new WMSOutbound.tReturnHead(); string[] OrdrCnt = SelectedRec.Split(','); int TotOrdres = OrdrCnt.Count(); for (int i = 0; i <= TotOrdres - 1; i++) { rtrn.SONo = long.Parse(OrdrCnt[i].ToString()); rtrn.ReturnBy = profile.Personal.UserID; rtrn.ReturnDate = DateTime.Now; rtrn.CreatedBy = profile.Personal.UserID; rtrn.CreationDate = DateTime.Now; rtrn.Status = 49; long rtrnID = Outbound.SaveReturnHead(rtrn, profile.DBConnection._constr); } } catch { } finally { Outbound.Close(); } return(Result); }
public void DisplaySOData() { BrilliantWMS.WMSInbound.iInboundClient Inbound = new WMSInbound.iInboundClient(); BrilliantWMS.WMSOutbound.iOutboundClient Outbound = new WMSOutbound.iOutboundClient(); List <BrilliantWMS.WMSOutbound.WMS_SP_GetPartDetail_ForDispatch_Result> QCDetail = new List <WMSOutbound.WMS_SP_GetPartDetail_ForDispatch_Result>(); try { CustomProfile profile = CustomProfile.GetProfile(); if (Session["QCID"] != null) { long QCID = long.Parse(Session["QCID"].ToString()); int chkJObCart = Inbound.CheckJobCard(Convert.ToInt64(HttpContext.Current.Session["QCID"].ToString()), "Dispatch", profile.DBConnection._constr); if (chkJObCart >= 1) { DataSet dsJCN = new DataSet(); dsJCN = Outbound.CheckSelectedSOJobCardNo(Convert.ToInt64(HttpContext.Current.Session["QCID"].ToString()), "Dispatch", profile.DBConnection._constr); if (dsJCN != null && dsJCN.Tables[0].Rows.Count > 0) { string grpQCID = dsJCN.Tables[0].Rows[0]["OrderNo"].ToString(); QCDetail = Outbound.GetDispatchPartByQCID(grpQCID, "0", Session.SessionID, profile.Personal.UserID.ToString(), ObjectName, profile.DBConnection._constr).ToList(); } } else { QCDetail = Outbound.GetDispatchPartByQCID(QCID.ToString(), "0", Session.SessionID, profile.Personal.UserID.ToString(), ObjectName, profile.DBConnection._constr).ToList(); } } else if (Session["TRID"] != null) { long TRID = long.Parse(Session["TRID"].ToString()); int chkJObCart = Inbound.CheckJobCard(Convert.ToInt64(HttpContext.Current.Session["TRID"].ToString()), "Transfer", profile.DBConnection._constr); if (chkJObCart >= 1) { DataSet dsJCN = new DataSet(); dsJCN = Outbound.CheckSelectedSOJobCardNo(Convert.ToInt64(HttpContext.Current.Session["TRID"].ToString()), "Transfer", profile.DBConnection._constr); if (dsJCN != null && dsJCN.Tables[0].Rows.Count > 0) { string grpQCID = dsJCN.Tables[0].Rows[0]["OrderNo"].ToString(); QCDetail = Outbound.GetDispatchPartByQCID("0", grpQCID, Session.SessionID, profile.Personal.UserID.ToString(), ObjectName, profile.DBConnection._constr).ToList(); } } else { QCDetail = Outbound.GetDispatchPartByQCID("0", TRID.ToString(), Session.SessionID, profile.Personal.UserID.ToString(), ObjectName, profile.DBConnection._constr).ToList(); } } Grid1.DataSource = null; Grid1.DataBind(); Grid1.DataSource = QCDetail; Grid1.DataBind(); } catch (System.Exception ex) { Login.Profile.ErrorHandling(ex, "DispatchDetail.aspx", "DisplayPOData"); } finally { Outbound.Close(); Inbound.Close(); } }
public void BindGrid() { BrilliantWMS.WMSOutbound.iOutboundClient Outbound = new WMSOutbound.iOutboundClient(); try { CustomProfile profile = CustomProfile.GetProfile(); if (Session["SOID"] != null) { hdnPickUpNo.Value = Session["SOID"].ToString(); GridReceipt.DataSource = Outbound.GetPickUpList(Session["SOID"].ToString(), "", Session.SessionID, profile.Personal.UserID.ToString(), ObjectName, profile.DBConnection._constr); GridReceipt.DataBind(); } else if (Session["PKUPID"] != null) { long pkupId = long.Parse(Session["PKUPID"].ToString()); long soID = Outbound.GetSOIDfromPkUpID(pkupId, profile.DBConnection._constr); hdnPickUpNo.Value = soID.ToString(); GridReceipt.DataSource = Outbound.GetPickUpList(soID.ToString(), "", Session.SessionID, profile.Personal.UserID.ToString(), ObjectName, profile.DBConnection._constr); GridReceipt.DataBind(); } if (Session["SOstate"] != null) { if (Session["SOstate"].ToString() == "View") { BtnSequence.Visible = false; } } else if (Session["PKUPstate"] != null) { if (Session["PKUPstate"].ToString() == "View") { BtnSequence.Visible = false; } } else { BtnSequence.Visible = true; } if (Session["TRID"] != null) { GridReceipt.DataSource = Outbound.GetPickUpList("", Session["TRID"].ToString(), Session.SessionID, profile.Personal.UserID.ToString(), ObjectName, profile.DBConnection._constr); GridReceipt.DataBind(); if (Session["TRstate"].ToString() == "View") { BtnSequence.Visible = false; } } } catch { } finally { Outbound.Close(); } }
public void GetTransferDetails(string TransferID) { long TRID = long.Parse(TransferID); BrilliantWMS.WMSOutbound.iOutboundClient Outbound = new WMSOutbound.iOutboundClient(); BrilliantWMS.WMSInbound.iInboundClient Inbound = new WMSInbound.iInboundClient(); CustomProfile profile = CustomProfile.GetProfile(); iUCCommonFilterClient objService = new iUCCommonFilterClient(); List <vGetUserProfileByUserID> UsersList = new List <vGetUserProfileByUserID>(); try { BrilliantWMS.WMSOutbound.tTransferHead trh = new WMSOutbound.tTransferHead(); //= new tTransferHead(); trh = Outbound.GetTransferHeadDetailByTransferID(TRID, profile.DBConnection._constr); lblWTWTransferNo.Text = trh.ID.ToString(); UCWTWTransferDate.Date = trh.TransferDate; fillUser(); ddlWTWTransferBy.SelectedIndex = ddlWTWTransferBy.Items.IndexOf(ddlWTWTransferBy.Items.FindByValue(trh.TransferBy.ToString())); ddlWTWStatus.DataSource = WMFillStatus(); ddlWTWStatus.DataBind(); ddlWTWStatus.SelectedIndex = ddlWTWStatus.Items.IndexOf(ddlWTWStatus.Items.FindByValue(trh.Status.ToString())); fillWarehouse(); ddlFWarehouse.SelectedIndex = ddlFWarehouse.Items.IndexOf(ddlFWarehouse.Items.FindByValue(trh.FromPosition.ToString())); List <BrilliantWMS.WMSInbound.mWarehouseMaster> ToWarehouseList = new List <WMSInbound.mWarehouseMaster>(); long UserID = profile.Personal.UserID; ToWarehouseList = Inbound.GetUserWarehouse(UserID, profile.DBConnection._constr).ToList(); ddlTWarehouse.DataSource = ToWarehouseList; ddlTWarehouse.DataBind(); ddlTWarehouse.SelectedIndex = ddlTWarehouse.Items.IndexOf(ddlTWarehouse.Items.FindByValue(trh.ToPosition.ToString())); WTWTRemark.Text = trh.Remark.ToString(); txtAirwayBill.Text = trh.AirwayBill.ToString(); txtShippingType.Text = trh.ShippingType.ToString(); UC_ShippingDate.Date = trh.ShippingDate; UCExpDeliveryDate.Date = trh.ExpDeliveryDate; txtTransporterName.Text = trh.TransporterName.ToString(); Grid1.DataSource = Outbound.GetTransferPartDetailByTransferID(TRID, long.Parse(trh.FromPosition.ToString()), Session.SessionID, profile.Personal.UserID.ToString(), ObjectName, profile.DBConnection._constr); Grid1.DataBind(); ScriptManager.RegisterStartupScript(this, this.GetType(), "changemodeRequest" + Session.SessionID, "changemode(true, 'divWTWTransferDetail');LoadingOff();", true); } catch { } finally { Outbound.Close(); objService.Close(); UsersList.Clear(); } }
public void bindgrid() { BrilliantWMS.WMSOutbound.iOutboundClient Outbound = new WMSOutbound.iOutboundClient(); try { CustomProfile profile = CustomProfile.GetProfile(); DataSet ds = new DataSet(); ds = Outbound.BindOutboundGridForReturn(profile.DBConnection._constr); grdSalesOrder.DataSource = ds; grdSalesOrder.DataBind(); grdSalesOrder.AllowMultiRecordSelection = true; grdSalesOrder.AllowRecordSelection = true; } catch { } finally { Outbound.Close(); } }
public static int WMRemovePartFromRequest(Int32 Sequence) { int editOrder = 0; BrilliantWMS.WMSOutbound.iOutboundClient Outbound = new WMSOutbound.iOutboundClient(); CustomProfile profile = CustomProfile.GetProfile(); try { Dictionary <string, object> dictionary = new Dictionary <string, object>(); Outbound.RemovePartFromTransfer_TempDataTR(HttpContext.Current.Session.SessionID, profile.Personal.UserID.ToString(), ObjectName, Sequence, profile.DBConnection._constr); editOrder = 1; } catch (System.Exception ex) { Login.Profile.ErrorHandling(ex, "WToWTransferDetail.aspx", "WMRemovePartFromRequest"); } finally { Outbound.Close(); } return(editOrder); }
public static void WMUpdTransferPart(object objTransfer) { BrilliantWMS.WMSOutbound.iOutboundClient Outbound = new WMSOutbound.iOutboundClient(); BrilliantWMS.WMSInbound.iInboundClient Inbound = new WMSInbound.iInboundClient(); try { Dictionary <string, object> dictionary = new Dictionary <string, object>(); dictionary = (Dictionary <string, object>)objTransfer; CustomProfile profile = CustomProfile.GetProfile(); string uom = Inbound.GetUOMName(Convert.ToInt64(dictionary["UOMID"]), profile.DBConnection._constr); BrilliantWMS.WMSOutbound.WMS_SP_GetPartDetail_ForTransfer_Result PartTransfer = new WMSOutbound.WMS_SP_GetPartDetail_ForTransfer_Result(); PartTransfer.Sequence = Convert.ToInt64(dictionary["Sequence"]); PartTransfer.Qty = Convert.ToDecimal(dictionary["Qty"]); //PartRequest.UOM = uom; PartTransfer.UOMID = Convert.ToInt64(dictionary["UOMID"]); Outbound.UpdateTransfer_TempDataTR(HttpContext.Current.Session.SessionID, ObjectName, profile.Personal.UserID.ToString(), PartTransfer, profile.DBConnection._constr); } catch (System.Exception ex) { Login.Profile.ErrorHandling(ex, "WToWTransferDetail.aspx", "WMUpdRequestPart"); } finally { Outbound.Close(); } }
protected void Grid1_OnRebind(object sender, EventArgs e) { BrilliantWMS.WMSOutbound.iOutboundClient Outbound = new WMSOutbound.iOutboundClient(); try { Grid1.DataSource = null; Grid1.DataBind(); CustomProfile profile = CustomProfile.GetProfile(); HiddenField hdn = (HiddenField)UCProductSearchWTW.FindControl("hdnProductSearchSelectedRec"); List <BrilliantWMS.WMSOutbound.WMS_SP_GetPartDetail_ForTransfer_Result> TRPartList = new List <WMSOutbound.WMS_SP_GetPartDetail_ForTransfer_Result>(); if (hdn.Value == "") { TRPartList = Outbound.GetExistingTempDataBySessionIDObjectNameTR(Session.SessionID, profile.Personal.UserID.ToString(), ObjectName, profile.DBConnection._constr).ToList(); } else if (hdn.Value != "") { TRPartList = Outbound.AddPartIntoTransfer_TempDataTR(hdn.Value, Session.SessionID, profile.Personal.UserID.ToString(), ObjectName, Convert.ToInt32(hdnFrmWarehouse.Value), profile.DBConnection._constr).ToList(); } Grid1.DataSource = TRPartList; Grid1.DataBind(); } catch (System.Exception ex) { Login.Profile.ErrorHandling(ex, this, "WToWTransferDetail.aspx", "Grid1_OnRebind"); } finally { Outbound.Close(); } }
public static long WMSaveTransferHead(object objTRHead) { long result = 0; int RSLT = 0; long TRID = 0; BrilliantWMS.WMSOutbound.iOutboundClient Outbound = new WMSOutbound.iOutboundClient(); try { CustomProfile profile = CustomProfile.GetProfile(); BrilliantWMS.WMSOutbound.tTransferHead trH = new WMSOutbound.tTransferHead(); Dictionary <string, object> d = new Dictionary <string, object>(); d = (Dictionary <string, object>)objTRHead; if (HttpContext.Current.Session["TRID"] != null) { if (HttpContext.Current.Session["TRID"].ToString() == "0") { trH.CreatedBy = profile.Personal.UserID; trH.CreationDate = DateTime.Now; } else { trH.ID = Convert.ToInt64(HttpContext.Current.Session["TRID"].ToString()); trH.Modifiedby = profile.Personal.UserID; trH.ModiedDate = DateTime.Now; } trH.Type = 2; trH.TransferDate = Convert.ToDateTime(d["TransferDate"]); trH.FromPosition = Convert.ToInt64(d["FromPosition"]); trH.ToPosition = Convert.ToInt64(d["ToPosition"]); trH.TransferBy = Convert.ToInt64(d["TransferBy"]); trH.Status = Convert.ToInt64(d["Status"]); trH.Remark = d["Remark"].ToString(); trH.CompanyID = profile.Personal.CompanyID; trH.AirwayBill = d["AirwayBill"].ToString(); trH.ShippingType = d["ShippingType"].ToString(); trH.TransporterName = d["TransporterName"].ToString(); trH.ShippingDate = Convert.ToDateTime(d["ShippingDate"]); trH.ExpDeliveryDate = Convert.ToDateTime(d["ExpDeliveryDate"]); trH.ObjectName = "Transfer"; TRID = Outbound.SaveIntotTransferHead(trH, profile.DBConnection._constr); if (TRID > 0) { RSLT = Outbound.FinalSaveTRDetail(HttpContext.Current.Session.SessionID, ObjectName, TRID, profile.Personal.UserID.ToString(), Convert.ToInt16(trH.Status), 0, profile.DBConnection._constr); if (RSLT == 1 || RSLT == 2) { result = TRID; } //"Request saved successfully"; else if (RSLT == 3) { result = -3; } } } } catch (System.Exception ex) { Login.Profile.ErrorHandling(ex, "WToWTransferDetail.aspx", "WMSaveRequestHead"); result = 0; // "Some error occurred"; } finally { Outbound.Close(); } return(result); }
protected void UpdateRecord(object sender, Obout.Grid.GridRecordEventArgs e) { UCApplyTaxService.iUCApplyTaxClient ApplyTaxServie = new UCApplyTaxService.iUCApplyTaxClient(); try { CustomProfile profile = CustomProfile.GetProfile(); object key = "Save"; if (e.Record[key].ToString() == "N") { string ProductID = Request.QueryString["PrdID"].ToString(); if (ProductID == "undefined") { ProductID = "0"; } long PrdID = Convert.ToInt64(ProductID); List <SP_CartBeforeUpdateProductLevelTaxDetail_Result> lst = new List <SP_CartBeforeUpdateProductLevelTaxDetail_Result>(); // lst = ApplyTaxServie.GetCalculatedTaxListBeforeUpdate(Request.QueryString["Object"].ToString(), Session.SessionID, Convert.ToInt64(Request.QueryString["CartSeq"].ToString()), Convert.ToDecimal(lblTaxableAmount.Text), hdnTaxSelectedRec.Value.ToString(), profile.DBConnection._constr).ToList(); lst = ApplyTaxServie.GetCalculatedTaxListBeforeUpdate(Request.QueryString["Object"].ToString(), Session.SessionID, PrdID, Convert.ToDecimal(lblTaxableAmount.Text), hdnTaxSelectedRec.Value.ToString(), profile.DBConnection._constr).ToList(); ApplyTaxServie.Close(); GridTaxList.DataSource = lst; GridTaxList.DataBind(); } else if (e.Record[key].ToString() == "Save") { string TotalTaxAmount = UpdateTaxAmount(); ApplyTaxServie.Close(); string obj = Request.QueryString["Object"].ToString(); if (obj == "PurchaseOrderTax") { BrilliantWMS.WMSInbound.iInboundClient Inbound = new WMSInbound.iInboundClient(); //iInboundClient Inbound = new iInboundClient(); BrilliantWMS.WMSInbound.WMS_SP_GetPartDetail_ForPO_Result PartRequest = new WMSInbound.WMS_SP_GetPartDetail_ForPO_Result(); //WMS_SP_GetPartDetail_ForPO_Result PartRequest = new WMS_SP_GetPartDetail_ForPO_Result(); PartRequest.Sequence = Convert.ToInt64(Request.QueryString["CartSeq"].ToString()); PartRequest.TotalTaxAmount = Convert.ToDecimal(TotalTaxAmount); decimal TtlAftrtax = Convert.ToDecimal(TotalTaxAmount) + Convert.ToDecimal(Request.QueryString["TaxableAmt"].ToString()); PartRequest.AmountAfterTax = TtlAftrtax; //string obj = Request.QueryString["Object"].ToString(); // if (obj == "PurchaseOrderTax") obj = "PurchaseOrder"; // else obj = "SalesOrderTax"; Inbound.UpdatePartRequest_TempData13(Session.SessionID, obj, profile.Personal.UserID.ToString(), PartRequest, profile.DBConnection._constr); Inbound.Close(); } else if (obj == "SalesOrderTax") { BrilliantWMS.WMSOutbound.iOutboundClient Outbound = new WMSOutbound.iOutboundClient(); BrilliantWMS.WMSOutbound.WMS_SP_GetPartDetail_ForSO_Result PartRSO = new WMSOutbound.WMS_SP_GetPartDetail_ForSO_Result(); PartRSO.Sequence = Convert.ToInt64(Request.QueryString["CartSeq"].ToString()); PartRSO.TotalTaxAmount = Convert.ToDecimal(TotalTaxAmount); decimal TtlAftrtax = Convert.ToDecimal(TotalTaxAmount) + Convert.ToDecimal(Request.QueryString["TaxableAmt"].ToString()); PartRSO.AmountAfterTax = TtlAftrtax; obj = "SalesOrder"; Outbound.UpdatePartRequest_TempData13SO(Session.SessionID, obj, profile.Personal.UserID.ToString(), PartRSO, profile.DBConnection._constr); Outbound.Close(); } } } catch (System.Exception ex) { Login.Profile.ErrorHandling(ex, this, "UCApplyTax", "UpdateRecord"); } finally { } }
public void GetDispatchDetails(string QCID) { long selQCID = 0; BrilliantWMS.WMSOutbound.iOutboundClient Outbound = new WMSOutbound.iOutboundClient(); CustomProfile profile = CustomProfile.GetProfile(); iUCCommonFilterClient objService = new iUCCommonFilterClient(); List <vGetUserProfileByUserID> UsersList = new List <vGetUserProfileByUserID>(); try { if (Session["QCID"] != null) { selQCID = long.Parse(QCID.ToString()); BrilliantWMS.WMSOutbound.WMS_VW_GetDispatchDetails dispatchLst = new WMSOutbound.WMS_VW_GetDispatchDetails(); dispatchLst = Outbound.GetDispatchDetailsByQCID(selQCID, profile.DBConnection._constr); lblDispatchNo.Text = dispatchLst.ID.ToString(); UCDispatchDate.Date = dispatchLst.DispatchDate; txtRemark.Text = dispatchLst.Remark.ToString(); txtAirwayBill.Text = dispatchLst.AirwayBill.ToString(); txtShippingType.Text = dispatchLst.ShippingType.ToString(); UC_ShippingDate.Date = dispatchLst.ShippingDate; UCExpDeliveryDate.Date = dispatchLst.ExpDeliveryDate; txtTransporterName.Text = dispatchLst.TransporterName.ToString(); txtTransporterRemark.Text = dispatchLst.TransporterRemark.ToString(); long WarehouseID = long.Parse(dispatchLst.StoreId.ToString()); UsersList = objService.GetUserListByWarehouseID(WarehouseID, profile.DBConnection._constr).ToList(); UsersList = UsersList.Where(x => x.userID == profile.Personal.UserID).ToList(); vGetUserProfileByUserID select = new vGetUserProfileByUserID() { userID = 0, userName = "******" }; UsersList.Insert(0, select); ddlDispatchBy.DataSource = UsersList; ddlDispatchBy.DataBind(); ddlDispatchBy.SelectedIndex = ddlDispatchBy.Items.IndexOf(ddlDispatchBy.Items.FindByValue(dispatchLst.DispatchBy.ToString())); ddlStatus.DataSource = WMFillStatus(); ddlStatus.DataBind(); ddlStatus.SelectedIndex = ddlStatus.Items.IndexOf(ddlStatus.Items.FindByValue(dispatchLst.Status.ToString())); Grid1.DataSource = Outbound.GetDispatchSkuDetailByDispatchID(long.Parse(dispatchLst.ID.ToString()), profile.DBConnection._constr); Grid1.DataBind(); ScriptManager.RegisterStartupScript(this, this.GetType(), "changemodeRequest" + Session.SessionID, "changemode(true, 'dvDDetail');LoadingOff();", true); } else if (Session["DispID"] != null) { selQCID = long.Parse(QCID.ToString()); BrilliantWMS.WMSOutbound.WMS_VW_GetDispatchDetails dispatchLst = new WMSOutbound.WMS_VW_GetDispatchDetails(); dispatchLst = Outbound.GetDispatchDetailsByDispatchID(selQCID, profile.DBConnection._constr); lblDispatchNo.Text = dispatchLst.ID.ToString(); UCDispatchDate.Date = dispatchLst.DispatchDate; txtRemark.Text = dispatchLst.Remark.ToString(); txtAirwayBill.Text = dispatchLst.AirwayBill.ToString(); txtShippingType.Text = dispatchLst.ShippingType.ToString(); UC_ShippingDate.Date = dispatchLst.ShippingDate; UCExpDeliveryDate.Date = dispatchLst.ExpDeliveryDate; txtTransporterName.Text = dispatchLst.TransporterName.ToString(); txtTransporterRemark.Text = dispatchLst.TransporterRemark.ToString(); long WarehouseID = long.Parse(dispatchLst.StoreId.ToString()); UsersList = objService.GetUserListByWarehouseID(WarehouseID, profile.DBConnection._constr).ToList(); UsersList = UsersList.Where(x => x.userID == profile.Personal.UserID).ToList(); vGetUserProfileByUserID select = new vGetUserProfileByUserID() { userID = 0, userName = "******" }; UsersList.Insert(0, select); ddlDispatchBy.DataSource = UsersList; ddlDispatchBy.DataBind(); ddlDispatchBy.SelectedIndex = ddlDispatchBy.Items.IndexOf(ddlDispatchBy.Items.FindByValue(dispatchLst.DispatchBy.ToString())); ddlStatus.DataSource = WMFillStatus(); ddlStatus.DataBind(); ddlStatus.SelectedIndex = ddlStatus.Items.IndexOf(ddlStatus.Items.FindByValue(dispatchLst.Status.ToString())); Grid1.DataSource = Outbound.GetDispatchSkuDetailByDispatchID(long.Parse(dispatchLst.ID.ToString()), profile.DBConnection._constr); Grid1.DataBind(); ScriptManager.RegisterStartupScript(this, this.GetType(), "changemodeRequest" + Session.SessionID, "changemode(true, 'dvDDetail');LoadingOff();", true); } else if (Session["TRID"] != null) { selQCID = long.Parse(QCID.ToString()); BrilliantWMS.WMSOutbound.WMS_VW_GetDispatchDetails dispatchLst = new WMSOutbound.WMS_VW_GetDispatchDetails(); dispatchLst = Outbound.GetDispatchDetailsByQCID(selQCID, profile.DBConnection._constr); lblDispatchNo.Text = dispatchLst.ID.ToString(); UCDispatchDate.Date = dispatchLst.DispatchDate; txtRemark.Text = dispatchLst.Remark.ToString(); txtAirwayBill.Text = dispatchLst.AirwayBill.ToString(); txtShippingType.Text = dispatchLst.ShippingType.ToString(); UC_ShippingDate.Date = dispatchLst.ShippingDate; UCExpDeliveryDate.Date = dispatchLst.ExpDeliveryDate; txtTransporterName.Text = dispatchLst.TransporterName.ToString(); txtTransporterRemark.Text = dispatchLst.TransporterRemark.ToString(); long WarehouseID = long.Parse(dispatchLst.StoreId.ToString()); UsersList = objService.GetUserListByWarehouseID(WarehouseID, profile.DBConnection._constr).ToList(); UsersList = UsersList.Where(x => x.userID == profile.Personal.UserID).ToList(); vGetUserProfileByUserID select = new vGetUserProfileByUserID() { userID = 0, userName = "******" }; UsersList.Insert(0, select); ddlDispatchBy.DataSource = UsersList; ddlDispatchBy.DataBind(); ddlDispatchBy.SelectedIndex = ddlDispatchBy.Items.IndexOf(ddlDispatchBy.Items.FindByValue(dispatchLst.DispatchBy.ToString())); ddlStatus.DataSource = WMFillStatus(); ddlStatus.DataBind(); ddlStatus.SelectedIndex = ddlStatus.Items.IndexOf(ddlStatus.Items.FindByValue(dispatchLst.Status.ToString())); Grid1.DataSource = Outbound.GetDispatchSkuDetailByDispatchID(long.Parse(dispatchLst.ID.ToString()), profile.DBConnection._constr); Grid1.DataBind(); ScriptManager.RegisterStartupScript(this, this.GetType(), "changemodeRequest" + Session.SessionID, "changemode(true, 'dvDDetail');LoadingOff();", true); } } catch { } finally { Outbound.Close(); objService.Close(); UsersList.Clear(); } }
public static long WMSaveDispatchHead(object objDispatch) { long result = 0; int RSLT = 0; long DispatchID = 0; BrilliantWMS.WMSInbound.iInboundClient Inbound = new WMSInbound.iInboundClient(); BrilliantWMS.WMSOutbound.iOutboundClient Outbound = new WMSOutbound.iOutboundClient(); try { CustomProfile profile = CustomProfile.GetProfile(); BrilliantWMS.WMSOutbound.tDispatchHead dh = new WMSOutbound.tDispatchHead(); Dictionary <string, object> d = new Dictionary <string, object>(); d = (Dictionary <string, object>)objDispatch; if (HttpContext.Current.Session["QCID"] != null) { int chkJObCart = Inbound.CheckJobCard(Convert.ToInt64(HttpContext.Current.Session["QCID"].ToString()), "Dispatch", profile.DBConnection._constr); if (chkJObCart >= 1) { DataSet dsJCN = new DataSet(); dsJCN = Outbound.CheckSelectedSOJobCardNo(Convert.ToInt64(HttpContext.Current.Session["QCID"].ToString()), "Dispatch", profile.DBConnection._constr); if (dsJCN != null && dsJCN.Tables[0].Rows.Count > 0) { string grpQCID = dsJCN.Tables[0].Rows[0]["OrderNo"].ToString(); string[] TotQC = grpQCID.Split(','); int QCCnt = TotQC.Count(); for (int p = 0; p <= QCCnt - 1; p++) { dh.CreatedBy = profile.Personal.UserID; dh.CreationDate = DateTime.Now; dh.OID = long.Parse(TotQC[p].ToString()); dh.DispatchDate = Convert.ToDateTime(d["DispatchDate"]); dh.DispatchBy = Convert.ToInt64(d["DispatchBy"].ToString()); dh.Remark = d["Remark"].ToString(); dh.AirwayBill = d["AirwayBill"].ToString(); dh.ShippingType = d["ShippingType"].ToString(); dh.CompanyID = profile.Personal.CompanyID; dh.Status = Convert.ToInt64(d["Status"].ToString()); dh.ShippingDate = Convert.ToDateTime(d["ShippingDate"].ToString()); dh.TransporterName = d["TransporterName"].ToString(); dh.TransporterRemark = d["TransporterRemark"].ToString(); dh.ExpDeliveryDate = Convert.ToDateTime(d["ExpDeliveryDate"].ToString()); dh.ObjectName = "SalesOrder"; DispatchID = Outbound.SavetDispatchHead(dh, profile.DBConnection._constr); if (DispatchID > 0) { RSLT = Outbound.FinalSaveDispatchDetail(long.Parse(TotQC[p].ToString()), HttpContext.Current.Session.SessionID, ObjectName, DispatchID, profile.Personal.UserID.ToString(), Convert.ToInt16(dh.Status), "SalesOrder", profile.DBConnection._constr); if (RSLT == 1 || RSLT == 2) { result = DispatchID; } else if (RSLT == 0) { result = 0; } iUC_AttachDocumentClient DocumentSourceClient = new iUC_AttachDocumentClient();//Document Save DocumentSourceClient.FinalSaveToDBtDocument(HttpContext.Current.Session.SessionID, DispatchID, profile.Personal.UserID.ToString(), ObjectName + "Document", HttpRuntime.AppDomainAppPath.ToString(), profile.DBConnection._constr); } } Outbound.ClearTempDataFromDBDispatch(HttpContext.Current.Session.SessionID, profile.Personal.UserID.ToString(), ObjectName, profile.DBConnection._constr); } } else { dh.CreatedBy = profile.Personal.UserID; dh.CreationDate = DateTime.Now; dh.OID = long.Parse(HttpContext.Current.Session["QCID"].ToString()); dh.DispatchDate = Convert.ToDateTime(d["DispatchDate"]); dh.DispatchBy = Convert.ToInt64(d["DispatchBy"].ToString()); dh.Remark = d["Remark"].ToString(); dh.AirwayBill = d["AirwayBill"].ToString(); dh.ShippingType = d["ShippingType"].ToString(); dh.CompanyID = profile.Personal.CompanyID; dh.Status = Convert.ToInt64(d["Status"].ToString()); dh.ShippingDate = Convert.ToDateTime(d["ShippingDate"].ToString()); dh.TransporterName = d["TransporterName"].ToString(); dh.TransporterRemark = d["TransporterRemark"].ToString(); dh.ExpDeliveryDate = Convert.ToDateTime(d["ExpDeliveryDate"].ToString()); dh.ObjectName = "SalesOrder"; DispatchID = Outbound.SavetDispatchHead(dh, profile.DBConnection._constr); if (DispatchID > 0) { RSLT = Outbound.FinalSaveDispatchDetail(long.Parse(HttpContext.Current.Session["QCID"].ToString()), HttpContext.Current.Session.SessionID, ObjectName, DispatchID, profile.Personal.UserID.ToString(), Convert.ToInt16(dh.Status), "SalesOrder", profile.DBConnection._constr); if (RSLT == 1 || RSLT == 2) { result = DispatchID; } else if (RSLT == 0) { result = 0; } iUC_AttachDocumentClient DocumentSourceClient = new iUC_AttachDocumentClient();//Document Save DocumentSourceClient.FinalSaveToDBtDocument(HttpContext.Current.Session.SessionID, DispatchID, profile.Personal.UserID.ToString(), ObjectName + "Document", HttpRuntime.AppDomainAppPath.ToString(), profile.DBConnection._constr); } Outbound.ClearTempDataFromDBDispatch(HttpContext.Current.Session.SessionID, profile.Personal.UserID.ToString(), ObjectName, profile.DBConnection._constr); } } else if (HttpContext.Current.Session["TRID"] != null) { int chkJObCart = Inbound.CheckJobCard(Convert.ToInt64(HttpContext.Current.Session["TRID"].ToString()), "Transfer", profile.DBConnection._constr); if (chkJObCart >= 1) { DataSet dsJCN = new DataSet(); dsJCN = Outbound.CheckSelectedSOJobCardNo(Convert.ToInt64(HttpContext.Current.Session["TRID"].ToString()), "Transfer", profile.DBConnection._constr); if (dsJCN != null && dsJCN.Tables[0].Rows.Count > 0) { string grpQCID = dsJCN.Tables[0].Rows[0]["OrderNo"].ToString(); string[] TotQC = grpQCID.Split(','); int QCCnt = TotQC.Count(); for (int p = 0; p <= QCCnt - 1; p++) { dh.CreatedBy = profile.Personal.UserID; dh.CreationDate = DateTime.Now; dh.OID = long.Parse(TotQC[p].ToString()); dh.DispatchDate = Convert.ToDateTime(d["DispatchDate"]); dh.DispatchBy = Convert.ToInt64(d["DispatchBy"].ToString()); dh.Remark = d["Remark"].ToString(); dh.AirwayBill = d["AirwayBill"].ToString(); dh.ShippingType = d["ShippingType"].ToString(); dh.CompanyID = profile.Personal.CompanyID; dh.Status = Convert.ToInt64(d["Status"].ToString()); dh.ShippingDate = Convert.ToDateTime(d["ShippingDate"].ToString()); dh.TransporterName = d["TransporterName"].ToString(); dh.TransporterRemark = d["TransporterRemark"].ToString(); dh.ExpDeliveryDate = Convert.ToDateTime(d["ExpDeliveryDate"].ToString()); dh.ObjectName = "Transfer"; DispatchID = Outbound.SavetDispatchHead(dh, profile.DBConnection._constr); if (DispatchID > 0) { RSLT = Outbound.FinalSaveDispatchDetail(long.Parse(TotQC[p].ToString()), HttpContext.Current.Session.SessionID, ObjectName, DispatchID, profile.Personal.UserID.ToString(), Convert.ToInt16(dh.Status), "Transfer", profile.DBConnection._constr); if (RSLT == 1 || RSLT == 2) { result = DispatchID; } else if (RSLT == 0) { result = 0; } iUC_AttachDocumentClient DocumentSourceClient = new iUC_AttachDocumentClient();//Document Save DocumentSourceClient.FinalSaveToDBtDocument(HttpContext.Current.Session.SessionID, DispatchID, profile.Personal.UserID.ToString(), ObjectName + "Document", HttpRuntime.AppDomainAppPath.ToString(), profile.DBConnection._constr); } } Outbound.ClearTempDataFromDBDispatch(HttpContext.Current.Session.SessionID, profile.Personal.UserID.ToString(), ObjectName, profile.DBConnection._constr); } } else { dh.CreatedBy = profile.Personal.UserID; dh.CreationDate = DateTime.Now; dh.OID = long.Parse(HttpContext.Current.Session["TRID"].ToString()); dh.DispatchDate = Convert.ToDateTime(d["DispatchDate"]); dh.DispatchBy = Convert.ToInt64(d["DispatchBy"].ToString()); dh.Remark = d["Remark"].ToString(); dh.AirwayBill = d["AirwayBill"].ToString(); dh.ShippingType = d["ShippingType"].ToString(); dh.CompanyID = profile.Personal.CompanyID; dh.Status = Convert.ToInt64(d["Status"].ToString()); dh.ShippingDate = Convert.ToDateTime(d["ShippingDate"].ToString()); dh.TransporterName = d["TransporterName"].ToString(); dh.TransporterRemark = d["TransporterRemark"].ToString(); dh.ExpDeliveryDate = Convert.ToDateTime(d["ExpDeliveryDate"].ToString()); dh.ObjectName = "Transfer"; DispatchID = Outbound.SavetDispatchHead(dh, profile.DBConnection._constr); if (DispatchID > 0) { RSLT = Outbound.FinalSaveDispatchDetail(long.Parse(HttpContext.Current.Session["TRID"].ToString()), HttpContext.Current.Session.SessionID, ObjectName, DispatchID, profile.Personal.UserID.ToString(), Convert.ToInt16(dh.Status), "Transfer", profile.DBConnection._constr); if (RSLT == 1 || RSLT == 2) { result = DispatchID; } else if (RSLT == 0) { result = 0; } iUC_AttachDocumentClient DocumentSourceClient = new iUC_AttachDocumentClient();//Document Save DocumentSourceClient.FinalSaveToDBtDocument(HttpContext.Current.Session.SessionID, DispatchID, profile.Personal.UserID.ToString(), ObjectName + "Document", HttpRuntime.AppDomainAppPath.ToString(), profile.DBConnection._constr); } Outbound.ClearTempDataFromDBDispatch(HttpContext.Current.Session.SessionID, profile.Personal.UserID.ToString(), ObjectName, profile.DBConnection._constr); } } } catch (System.Exception ex) { Login.Profile.ErrorHandling(ex, "DispatchDetail.aspx", "WMSaveDispatchHead"); result = 0; } finally { Outbound.Close(); } return(result); }
protected void BtnSequence_Click(object sender, EventArgs e) { int RSLT = 0; long PkUpID = 0; string confirmValue = Request.Form["confirm_value"]; BrilliantWMS.WMSOutbound.iOutboundClient Outbound = new WMSOutbound.iOutboundClient(); BrilliantWMS.WMSInbound.iInboundClient Inbound = new WMSInbound.iInboundClient(); try { if (confirmValue == "Yes") { CustomProfile profile = CustomProfile.GetProfile(); BrilliantWMS.WMSOutbound.tPickUpHead pkh = new WMSOutbound.tPickUpHead(); //BrilliantWMS.WMSOutbound.tTransferHead trh = new WMSOutbound.tTransferHead(); if (Session["SOID"] != null) { int chkJObCart = Inbound.CheckJobCard(Convert.ToInt64(HttpContext.Current.Session["SOID"].ToString()), "SalesOrder", profile.DBConnection._constr); if (chkJObCart >= 1) { DataSet dsJCN = new DataSet(); dsJCN = Outbound.CheckSelectedSOJobCardNo(Convert.ToInt64(HttpContext.Current.Session["SOID"].ToString()), "SalesOrder", profile.DBConnection._constr); if (dsJCN != null && dsJCN.Tables[0].Rows.Count > 0) { string grpSOID = dsJCN.Tables[0].Rows[0]["OrderNo"].ToString(); string[] TotOD = grpSOID.Split(','); int ODCnt = TotOD.Count(); for (int q = 0; q <= ODCnt - 1; q++) { pkh.CreatedBy = profile.Personal.UserID; pkh.CreationDate = DateTime.Now; pkh.ObjectName = "SalesOrder"; pkh.OID = long.Parse(TotOD[q].ToString()); pkh.PickUpDate = DateTime.Now; pkh.Status = 38; pkh.CompanyID = profile.Personal.CompanyID; pkh.PickUpBy = profile.Personal.UserID; PkUpID = Outbound.SavetPickUpHead(pkh, profile.DBConnection._constr); if (PkUpID > 0) { RSLT = Outbound.FinalSavePickUpDetail(long.Parse(TotOD[q].ToString()), Session.SessionID, ObjectName, PkUpID, profile.Personal.UserID.ToString(), Convert.ToInt16(pkh.Status), profile.DBConnection._constr); if (RSLT == 1) { this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "showAlert('Products Picked Up Successfully!','info','../WMS/PickUpList.aspx')", true); } else { this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "showAlert('Some Error Occured!','info','../WMS/PickUpList.aspx')", true); } } } Outbound.ClearTempDataFromDBPickUp(HttpContext.Current.Session.SessionID, profile.Personal.UserID.ToString(), ObjectName, profile.DBConnection._constr); } } else { pkh.CreatedBy = profile.Personal.UserID; pkh.CreationDate = DateTime.Now; pkh.ObjectName = "SalesOrder"; pkh.OID = long.Parse(Session["SOID"].ToString()); pkh.PickUpDate = DateTime.Now; pkh.Status = 38; pkh.CompanyID = profile.Personal.CompanyID; pkh.PickUpBy = profile.Personal.UserID; PkUpID = Outbound.SavetPickUpHead(pkh, profile.DBConnection._constr); if (PkUpID > 0) { RSLT = Outbound.FinalSavePickUpDetail(long.Parse(Session["SOID"].ToString()), Session.SessionID, ObjectName, PkUpID, profile.Personal.UserID.ToString(), Convert.ToInt16(pkh.Status), profile.DBConnection._constr); if (RSLT == 1) { this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "showAlert('Products Picked Up Successfully!','info','../WMS/PickUpList.aspx')", true); } else { this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "showAlert('Some Error Occured!','info','../WMS/PickUpList.aspx')", true); } } Outbound.ClearTempDataFromDBPickUp(HttpContext.Current.Session.SessionID, profile.Personal.UserID.ToString(), ObjectName, profile.DBConnection._constr); } } else if (Session["TRID"] != null) { int chkJObCart = Inbound.CheckJobCard(Convert.ToInt64(HttpContext.Current.Session["TRID"].ToString()), "Transfer", profile.DBConnection._constr); if (chkJObCart >= 1) { DataSet dsJCN = new DataSet(); dsJCN = Outbound.CheckSelectedSOJobCardNo(Convert.ToInt64(HttpContext.Current.Session["TRID"].ToString()), "Transfer", profile.DBConnection._constr); if (dsJCN != null && dsJCN.Tables[0].Rows.Count > 0) { string grpSOID = dsJCN.Tables[0].Rows[0]["OrderNo"].ToString(); string[] TotOD = grpSOID.Split(','); int ODCnt = TotOD.Count(); for (int q = 0; q <= ODCnt - 1; q++) { pkh.CreatedBy = profile.Personal.UserID; pkh.CreationDate = DateTime.Now; pkh.ObjectName = "Transfer"; pkh.OID = long.Parse(TotOD[q].ToString()); pkh.PickUpDate = DateTime.Now; pkh.Status = 57; pkh.CompanyID = profile.Personal.CompanyID; pkh.PickUpBy = profile.Personal.UserID; PkUpID = Outbound.SavetPickUpHead(pkh, profile.DBConnection._constr); if (PkUpID > 0) { RSLT = Outbound.FinalSavePickUpDetail(long.Parse(TotOD[q].ToString()), Session.SessionID, ObjectName, PkUpID, profile.Personal.UserID.ToString(), Convert.ToInt16(pkh.Status), profile.DBConnection._constr); if (RSLT == 1) { this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "showAlert('Products Picked Up Successfully!','info','../WMS/Transfer.aspx')", true); } else { this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "showAlert('Some Error Occured!','info','../WMS/Transfer.aspx')", true); } } } Outbound.ClearTempDataFromDBPickUp(HttpContext.Current.Session.SessionID, profile.Personal.UserID.ToString(), ObjectName, profile.DBConnection._constr); } } else { pkh.CreatedBy = profile.Personal.UserID; pkh.CreationDate = DateTime.Now; pkh.ObjectName = "Transfer"; pkh.OID = long.Parse(Session["TRID"].ToString()); pkh.PickUpDate = DateTime.Now; pkh.Status = 57; pkh.CompanyID = profile.Personal.CompanyID; pkh.PickUpBy = profile.Personal.UserID; PkUpID = Outbound.SavetPickUpHead(pkh, profile.DBConnection._constr); if (PkUpID > 0) { RSLT = Outbound.FinalSavePickUpDetail(long.Parse(Session["TRID"].ToString()), Session.SessionID, ObjectName, PkUpID, profile.Personal.UserID.ToString(), Convert.ToInt16(pkh.Status), profile.DBConnection._constr); if (RSLT == 1) { this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "showAlert('Products Picked Up Successfully!','info','../WMS/Transfer.aspx')", true); } else { this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "showAlert('Some Error Occured!','info','../WMS/Transfer.aspx')", true); } } Outbound.ClearTempDataFromDBPickUp(HttpContext.Current.Session.SessionID, profile.Personal.UserID.ToString(), ObjectName, profile.DBConnection._constr); } } } else { this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "showAlert('One or More Product Dones Not Assigned The Location. Please Assign the Location For Product... ','erroe','#')", true); } } catch (Exception ex) { this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "showAlert('" + ex.Message.ToString() + "','Error','#')", true); } finally { Outbound.Close(); } }