/// <summary>
/// Gets the moving average by receipt ID.
/// </summary>
/// <param name="ReceiptID">The receipt ID.</param>
/// <returns></returns>
public static DataTable GetMovingAverageByReceiptID(int ReceiptID)
{
MovingAverageHistory wal = new MovingAverageHistory();
var query = HCMIS.Repository.Queries.MovingAverageHistory.SelectGetMovingAverageByReceiptId(ReceiptID);
wal.LoadFromRawSql(query);
return wal.DataTable;
}
/// <summary>
/// Gets the list for GRV pricing.
/// </summary>
/// <returns></returns>
public static DataView GetListForGRVPricing()
{
MovingAverageHistory wal = new MovingAverageHistory();
var query = HCMIS.Repository.Queries.MovingAverageHistory.SelectGetListForGRVPricing(ReceiptType.CONSTANTS.BEGINNING_BALANCE);
wal.LoadFromRawSql(query);
return wal.DefaultView;
}