public void SaveCostCoefficient(int userID) { ReceiveDoc grvFullDetail = new ReceiveDoc(); grvFullDetail.FlushData(); grvFullDetail.LoadAllByReceiptID(GRV.ID); CostBuildUp.SaveChange(); while (!grvFullDetail.EOF) { //Insurance here is costCoefficient ReceiveDoc receivedoc = new ReceiveDoc(); receivedoc.LoadByPrimaryKey(grvFullDetail.ID); //Use Custom StoreProcedure for Costing receivedoc.Insurance = CostCoefficient; receivedoc.Save(); ReceiveDoc.SetUnitCostByReceiveDoc(grvFullDetail.ID, Math.Round(receivedoc.PricePerPack * CostCoefficient, 2), userID); ReceiveDoc.SetAverageCostByReceiveDoc(grvFullDetail.ID, Math.Round(receivedoc.PricePerPack * CostCoefficient, 2), userID); grvFullDetail.MoveNext(); } }
public void SaveCostCoefficientAndTotalValue(int userID) { ReceiveDoc grvFullDetail = new ReceiveDoc(); grvFullDetail.FlushData(); grvFullDetail.LoadAllByReceiptID(GRV.ID); while (!grvFullDetail.EOF) { //Insurance here is costCoefficient ReceiveDoc receivedoc = new ReceiveDoc(); receivedoc.LoadByPrimaryKey(grvFullDetail.ID); //Use Custom StoreProcedure for Costing receivedoc.Insurance = CostCoefficient; receivedoc.Save(); ReceiveDoc.SetUnitCostByReceiveDoc(grvFullDetail.ID,Math.Round(receivedoc.PricePerPack * CostCoefficient,2),userID); ReceiveDoc.SetAverageCostByReceiveDoc(grvFullDetail.ID,Math.Round(receivedoc.PricePerPack * CostCoefficient,2),userID); grvFullDetail.MoveNext(); } }
private void LoadSTVDetails() { int documentID = Convert.ToInt32(grdViewReceivedSTVs.GetFocusedDataRow()["DocumentID"]); BLL.Document document = new Document(); document.LoadByPrimaryKey(documentID); DocumentExchange.Documents.XmlMappings.STV stv = DocumentExchange.Documents.XmlMappings.STV.Load(document.DocumentContent); //Clean up the receivedoc entry receiveDoc.FlushData(); STVNo = Convert.ToInt32(stv.DocumentNumber); lblDaysAgo.Text = string.Format("Printed: {0}", Helpers.DateTimeFunctions.GetDateSpan(stv.PrintedDate)); for (int i = 0; i < stv.DocumentDetails.Count; i++) { STVDetail detail = stv.DocumentDetails[i]; receiveDoc.AddNew(); //Add columns for display purposes and for storing temporary information if (!receiveDoc.DefaultView.ToTable().Columns.Contains("FullItemName")) { receiveDoc.AddColumn("FullItemName", typeof(string)); receiveDoc.AddColumn("UnitName", typeof(string)); receiveDoc.AddColumn("ManufacturerName", typeof(string)); receiveDoc.AddColumn("ActivityName", typeof(string)); receiveDoc.AddColumn("StockCode", typeof(string)); receiveDoc.AddColumn("PalletLocationID", typeof(int)); receiveDoc.AddColumn("GUID", typeof(string)); } //Fill in the data receiveDoc.ItemID = detail.ItemID; receiveDoc.UnitID = detail.UnitID; receiveDoc.StoreID = detail.ActivityID; receiveDoc.ManufacturerId = detail.ManufacturerID; receiveDoc.SetColumn("BatchNo", detail.BatchNumber); receiveDoc.SetColumn("ExpDate", detail.ExpiryDate); receiveDoc.SetColumn("GUID", Guid.NewGuid()); BLL.Item item = new Item(); item.LoadByPrimaryKey(detail.ItemID); receiveDoc.SetColumn("FullItemName", item.FullItemName); BLL.ItemUnit unit = new ItemUnit(); unit.LoadByPrimaryKey(detail.UnitID); receiveDoc.SetColumn("UnitName", unit.Text); receiveDoc.QtyPerPack = unit.QtyPerUnit; BLL.Manufacturer manufacturer = new Manufacturer(); manufacturer.LoadByPrimaryKey(detail.ManufacturerID); receiveDoc.SetColumn("ManufacturerName", manufacturer.Name); var activity = new Activity(); activity.LoadByPrimaryKey(detail.ActivityID); receiveDoc.SetColumn("ActivityName", activity.FullActivityName); receiveDoc.SetColumn("StockCode", item.StockCode); //Financial Info receiveDoc.InvoicedNoOfPack = detail.Quantity; receiveDoc.Margin = detail.Margin; receiveDoc.PricePerPack = detail.UnitPrice; } grdSTVDetails.DataSource = receiveDoc.DefaultView; }