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