public SalesTransactionItemDetails[] GetItems(DataTable ItemDataTable)
{
int intIndex = 0;
SalesTransactionItemDetails[] items = new SalesTransactionItemDetails[ItemDataTable.Rows.Count];
foreach (System.Data.DataRow dr in ItemDataTable.Rows)
{
SalesTransactionItemDetails details = new SalesTransactionItemDetails();
details.ProductID = Convert.ToInt32(dr["ProductID"]);
details.ProductCode = Convert.ToString(dr["ProductCode"]);
details.BarCode = Convert.ToString(dr["BarCode"]);
details.Description = Convert.ToString(dr["Description"]);
details.ProductUnitID = Convert.ToInt32(dr["ProductUnitID"]);
details.ProductUnitCode = Convert.ToString(dr["ProductUnitCode"]);
details.Quantity = Convert.ToInt32(dr["Quantity"]);
details.Price = Convert.ToDecimal(dr["Price"]);
details.Discount = Convert.ToDecimal(dr["Discount"]);
details.Amount = Convert.ToDecimal(dr["Amount"]);
details.VariationsMatrixID = Convert.ToInt32(dr["VariationsMatrixID"]);
items[intIndex] = details;
intIndex++;
}
return(items);
}
private void CreateDetails(int iRow)
{
try
{
mDetails = new Data.SalesTransactionItemDetails();
mDetails.TransactionItemsID = Convert.ToInt64(dgItems[iRow, 0]);
mDetails.ProductID = Convert.ToInt64(dgItems[iRow, 1]);
mDetails.ProductCode = dgItems[iRow, 2].ToString();
mDetails.BarCode = dgItems[iRow, 3].ToString();
mDetails.Description = dgItems[iRow, 4].ToString();
mDetails.ProductUnitID = Convert.ToInt32(dgItems[iRow, 5].ToString());
mDetails.ProductUnitCode = dgItems[iRow, 6].ToString();
mDetails.Quantity = Convert.ToDecimal(dgItems[iRow, 7].ToString());
mDetails.Price = Convert.ToDecimal(dgItems[iRow, 8].ToString());
mDetails.Discount = Convert.ToDecimal(dgItems[iRow, 9].ToString());
mDetails.ItemDiscount = Convert.ToDecimal(dgItems[iRow, 10].ToString());
mDetails.ItemDiscountType = (DiscountTypes)Enum.Parse(typeof(DiscountTypes), dgItems[iRow, 11].ToString());
mDetails.Amount = Convert.ToDecimal(dgItems[iRow, 12].ToString());
mDetails.VAT = Convert.ToDecimal(dgItems[iRow, 13].ToString());
mDetails.EVAT = Convert.ToDecimal(dgItems[iRow, 14].ToString());
mDetails.LocalTax = Convert.ToDecimal(dgItems[iRow, 15].ToString());
mDetails.VariationsMatrixID = Convert.ToInt64(dgItems[iRow, 16]);
mDetails.MatrixDescription = dgItems[iRow, 17].ToString();
mDetails.ProductGroup = dgItems[iRow, 18].ToString();
mDetails.ProductSubGroup = dgItems[iRow, 19].ToString();
mDetails.TransactionItemStatus = (TransactionItemStatus)Enum.Parse(typeof(TransactionItemStatus), dgItems[iRow, 20].ToString());
mDetails.DiscountCode = dgItems[iRow, 21].ToString();
mDetails.DiscountRemarks = dgItems[iRow, 22].ToString();
mDetails.ProductPackageID = Convert.ToInt64(dgItems[iRow, 23]);
mDetails.MatrixPackageID = Convert.ToInt64(dgItems[iRow, 24]);
mDetails.PackageQuantity = Convert.ToDecimal(dgItems[iRow, 25]);
mDetails.PromoQuantity = Convert.ToDecimal(dgItems[iRow, 26]);
mDetails.PromoValue = Convert.ToDecimal(dgItems[iRow, 27]);
mDetails.PromoInPercent = Convert.ToBoolean(dgItems[iRow, 28].ToString());
mDetails.PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dgItems[iRow, 29].ToString());
mDetails.PromoApplied = Convert.ToDecimal(dgItems[iRow, 30]);
mDetails.PurchasePrice = Convert.ToDecimal(dgItems[iRow, 31]);
mDetails.PurchaseAmount = Convert.ToDecimal(dgItems[iRow, 32]);
mDetails.SupplierID = Convert.ToInt64(dgItems[iRow, 33]);
mDetails.SupplierCode = dgItems[iRow, 34].ToString();
mDetails.SupplierName = dgItems[iRow, 35].ToString();
mDetails.ItemRemarks = dgItems[iRow, 36].ToString();
mDetails.ReturnTransactionItemsID = Convert.ToInt64(dgItems[iRow, 0]);
}
catch (Exception ex)
{
Event clsEvent = new Event();
clsEvent.AddEventLn("Application error. TRACE: " + ex.Message);
clsEvent.AddEventLn("SOURCE: " + ex.Source, false);
clsEvent.AddEventLn("STACK TRACE: " + ex.StackTrace, false);
throw ex;
}
}
private void CreateDetails(int iRow)
{
mDetails = new Data.SalesTransactionItemDetails();
mDetails.ProductID = Convert.ToInt32(dgItems[iRow, 0]);
mDetails.ProductCode = dgItems[iRow, 1].ToString();
mDetails.BarCode = dgItems[iRow, 2].ToString();
mDetails.Description = dgItems[iRow, 3].ToString();
mDetails.ProductGroup = dgItems[iRow, 4].ToString();
mDetails.ProductSubGroup = dgItems[iRow, 5].ToString();
mDetails.ProductUnitID = Convert.ToInt32(dgItems[iRow, 6].ToString());
mDetails.ProductUnitCode = dgItems[iRow, 7].ToString();
mDetails.Quantity = Convert.ToDecimal(dgItems[iRow, 8].ToString());
mDetails.Price = Convert.ToDecimal(dgItems[iRow, 9].ToString());
mDetails.Discount = Convert.ToDecimal(dgItems[iRow, 10].ToString());
mDetails.VAT = Convert.ToDecimal(dgItems[iRow, 11].ToString());
mDetails.EVAT = Convert.ToDecimal(dgItems[iRow, 12].ToString());
mDetails.LocalTax = Convert.ToDecimal(dgItems[iRow, 13].ToString());
mDetails.Amount = (mDetails.Quantity * mDetails.Price) - (mDetails.Quantity * mDetails.Discount);
}
