/// <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();
}
