/// <summary> /// Fixes the reserved stock problems. /// </summary> public static void FixReservedStockProblems() { ReceivePallet rp=new ReceivePallet(); string query = HCMIS.Repository.Queries.ReceivePallet.UpdateFixReservedStockProblems(); rp.LoadFromRawSql(query); query = HCMIS.Repository.Queries.ReceivePallet.UpdateFixReservedStockProblemsMakeReservationSameAsBalance(); rp.LoadFromRawSql(query); query = HCMIS.Repository.Queries.ReceivePallet.UpdateFixReservedStockProblemsCancelReservations(); rp.LoadFromRawSql(query); }
/// <summary> /// Drops the procedure receive doc receive pallet. /// </summary> private static void DropProcedureReceiveDocReceivePallet() { ReceivePallet rp = new ReceivePallet(); var query = HCMIS.Repository.Queries.ReceivePallet.DropTriggerProcedureReceiveDocReceivePallet(); rp.LoadFromRawSql(query); }
/// <summary> /// Creates the procedure receive doc receive pallet. /// </summary> private static void CreateProcedureReceiveDocReceivePallet() { ReceivePallet rp = new ReceivePallet(); string storedProc = HCMIS.Repository.Queries.ReceivePallet.SpCreateProcedureReceiveDocReceivePallet(); rp.LoadFromRawSql(storedProc); }
/// <summary> /// Fixes the reserved stock problems. /// </summary> public static void FixReservedStockProblems() { ReceivePallet rp = new ReceivePallet(); string query = HCMIS.Repository.Queries.ReceivePallet.UpdateFixReservedStockProblems(); rp.LoadFromRawSql(query); query = HCMIS.Repository.Queries.ReceivePallet.UpdateFixReservedStockProblemsMakeReservationSameAsBalance(); rp.LoadFromRawSql(query); query = HCMIS.Repository.Queries.ReceivePallet.UpdateFixReservedStockProblemsCancelReservations(); rp.LoadFromRawSql(query); }
/// <summary> /// Gets the facilities items reserved for. /// </summary> /// <returns></returns> public DataTable GetFacilitiesItemsReservedFor() { string query = HCMIS.Repository.Queries.ReceivePallet.SelectGetFacilitiesItemsReservedFor(this.ID, OrderStatus.Constant.PICK_LIST_GENERATED, OrderStatus.Constant.PICK_LIST_CONFIRMED); ReceivePallet rp = new ReceivePallet(); rp.LoadFromRawSql(query); return(rp.DefaultView.ToTable()); }
/// <summary> /// Drops the procedure receive doc receive pallet. /// </summary> private static void DropProcedureReceiveDocReceivePallet() { ReceivePallet rp = new ReceivePallet(); var query = HCMIS.Repository.Queries.ReceivePallet.DropTriggerProcedureReceiveDocReceivePallet(); rp.LoadFromRawSql(query); }
/// <summary> /// Creates the procedure receive doc receive pallet. /// </summary> private static void CreateProcedureReceiveDocReceivePallet() { ReceivePallet rp = new ReceivePallet(); string storedProc = HCMIS.Repository.Queries.ReceivePallet.SpCreateProcedureReceiveDocReceivePallet(); rp.LoadFromRawSql(storedProc); }
/// <summary> /// Gets the facilities items reserved for. /// </summary> /// <returns></returns> public DataTable GetFacilitiesItemsReservedFor() { string query = HCMIS.Repository.Queries.ReceivePallet.SelectGetFacilitiesItemsReservedFor(this.ID, OrderStatus.Constant.PICK_LIST_GENERATED, OrderStatus.Constant.PICK_LIST_CONFIRMED); ReceivePallet rp = new ReceivePallet(); rp.LoadFromRawSql(query); return rp.DefaultView.ToTable(); }