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