/// <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; }
/// <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 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); }
/// <summary> /// Saves the weighted average log. /// </summary> /// <param name="Userid">The userid.</param> public void SaveWeightedAverageLog(int Userid) { MovingAverageHistory wal = new MovingAverageHistory(); wal.AddNew(); if (ReceiptID != null) { wal.ReceiptId = (int)ReceiptID; } wal.ItemID = ItemID; if (UnitID != null) { wal.UnitID = (int)UnitID; } wal.SupplierID = SupplierID; wal.ManufacturerID = ManufacturerID; wal.UserID = Userid; wal.StoreID = StoreID; wal.UPQty = UnpricedQuantity; if (UnpricedQuantity != 0) { wal.UPUnitCost = Math.Round(UnPricedTotalCost / UnpricedQuantity, BLL.Settings.NoOfDigitsAfterTheDecimalPoint); } else { wal.UPUnitCost = 0; } wal.UPTotalCost = UnPricedTotalCost; wal.PQty = OldQuantity; wal.PUnitCost = OldUnitCost; wal.PTotalCost = OldTotalCost; wal.NQty = NewQuantity; wal.NUnitCost = NewUnitCost; wal.NTotalCost = NewTotalCost; wal.Insurance = AdditionalCost; if (!Double.IsNaN(PriceDifference)) { wal.PriceDifference = PriceDifference; } wal.Margin = Margin; wal.Price = NewSellingPrice; wal.Date = DateTimeHelper.ServerDateTime; //wal.Remark = Remark; wal.Save(); }
public void SaveWeightedAverageLog(int Userid, int ReceiptID, double Margin, double NewSellingPrice) { MovingAverageHistory wal = new MovingAverageHistory(); wal.AddNew(); wal.ReceiptId = ReceiptID; wal.ItemID = CostElements.ItemID; wal.UnitID = CostElements.ItemUnitID; wal.SupplierID = 0; wal.ManufacturerID = CostElements.ManufacturerID; wal.UserID = Userid; wal.StoreID = CostElements.MovingAverageID; wal.UPQty = Convert.ToInt32(_receivedQty); if (_receivedUnitCost != 0) { wal.UPUnitCost = _receivedUnitCost; } else { wal.UPUnitCost = 0; } wal.UPTotalCost = _receivedTotalCost; wal.PQty = Convert.ToInt32(_previousQty); wal.PUnitCost = _previousUnitCost; wal.PTotalCost = _previousTotalCost; wal.NQty = Convert.ToInt32(_newQty); wal.NUnitCost = _newUnitCost; wal.NTotalCost = _newTotalCost; if (!Double.IsNaN(_priceDifference)) { wal.PriceDifference = _priceDifference; } wal.Margin = Margin; wal.Price = NewSellingPrice; wal.Date = DateTimeHelper.ServerDateTime; //wal.Remark = Remark;P wal.Save(); }
private void WeightedAverageHistory_Load(object sender, EventArgs e) { MovingAverageHistory history = new MovingAverageHistory(); gridBeggining.DataSource = history.GetBeginningBalance(costElement); gridAllSimilarItems.DataSource = history.GetHistory(costElement); }
/// <summary> /// Load All Neccessary Data and Bind To DataSource /// </summary> void LoadAndBind() { //Bind //Load Detail Table To Grid Item item = new Item(); gridReceiveDoc.DataSource = item.GetReceiveDocDetailForDiagnostics(ItemId, ManufacturerId, UnitId, MovingAverageId); gridJournalEntries.DataSource = item.GetJournalEntriesForDiagnostics(AffectedLedgerID); MovingAverageHistory history = new MovingAverageHistory(); CostElement costElement = new CostElement(ItemId, MovingAverageId, ManufacturerId, UnitId, ManufacturerId); gridAllSimilarItems.DataSource = history.GetHistory(costElement); //Load Header Information From first row to be displayed txtItemName.EditValue = Item; txtItemUnit.EditValue = Unit; txtManufacturerName.EditValue = Manufacturer; txtActivityName.EditValue = MovingAverage; txtUnitCost.EditValue = UnitCost; txtMargin.EditValue = Margin; txtSellingPrice.EditValue = SellingPrice; }
/// <summary> /// Saves the weighted average log. /// </summary> /// <param name="Userid">The userid.</param> public void SaveWeightedAverageLog(int Userid) { MovingAverageHistory wal = new MovingAverageHistory(); wal.AddNew(); if (ReceiptID != null) wal.ReceiptId = (int)ReceiptID; wal.ItemID = ItemID; if (UnitID != null) wal.UnitID = (int)UnitID; wal.SupplierID = SupplierID; wal.ManufacturerID = ManufacturerID; wal.UserID = Userid; wal.StoreID = StoreID; wal.UPQty = UnpricedQuantity; if (UnpricedQuantity != 0) wal.UPUnitCost = Math.Round(UnPricedTotalCost / UnpricedQuantity, BLL.Settings.NoOfDigitsAfterTheDecimalPoint); else wal.UPUnitCost = 0; wal.UPTotalCost = UnPricedTotalCost; wal.PQty = OldQuantity; wal.PUnitCost = OldUnitCost; wal.PTotalCost = OldTotalCost; wal.NQty = NewQuantity; wal.NUnitCost = NewUnitCost; wal.NTotalCost = NewTotalCost; wal.Insurance = AdditionalCost; if (!Double.IsNaN(PriceDifference)) wal.PriceDifference = PriceDifference; wal.Margin = Margin; wal.Price = NewSellingPrice; wal.Date = DateTimeHelper.ServerDateTime; //wal.Remark = Remark; wal.Save(); }
public void SaveWeightedAverageLog(int Userid,int ReceiptID,double Margin,double NewSellingPrice) { MovingAverageHistory wal = new MovingAverageHistory(); wal.AddNew(); wal.ReceiptId = ReceiptID; wal.ItemID = CostElements.ItemID; wal.UnitID = CostElements.ItemUnitID; wal.SupplierID = 0; wal.ManufacturerID = CostElements.ManufacturerID; wal.UserID = Userid; wal.StoreID = CostElements.MovingAverageID; wal.UPQty = Convert.ToInt32(_receivedQty); if (_receivedUnitCost != 0) wal.UPUnitCost = _receivedUnitCost; else wal.UPUnitCost = 0; wal.UPTotalCost = _receivedTotalCost; wal.PQty = Convert.ToInt32(_previousQty); wal.PUnitCost = _previousUnitCost; wal.PTotalCost = _previousTotalCost; wal.NQty = Convert.ToInt32(_newQty); wal.NUnitCost = _newUnitCost; wal.NTotalCost = _newTotalCost; if (!Double.IsNaN(_priceDifference)) wal.PriceDifference = _priceDifference; wal.Margin = Margin; wal.Price = NewSellingPrice; wal.Date = DateTimeHelper.ServerDateTime; //wal.Remark = Remark;P wal.Save(); }