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