private void MapObject(DueCollection oDueCollection, NullHandler oReader)
{
BusinessObject.Factory.SetID(oDueCollection, new ID(oReader.GetInt32("TrnID")));
oDueCollection.TrnRef = oReader.GetString("TrnRef");
oDueCollection.TranRefPrint = oReader.GetString("TranRefPrint");
oDueCollection.LegacyRef = oReader.GetString("LegacyRef");
oDueCollection.PartyType = (EnumParty)oReader.GetInt32("PartyType");
oDueCollection.AccountCode = oReader.GetString("AccountCode");
oDueCollection.PartyName = oReader.GetString("PartyName");
oDueCollection.TranLastDate = oReader.GetDateTime("TranLastDate");
oDueCollection.OutStdBalance = oReader.GetDouble("OutStdBalance");
oDueCollection.TotalBill = oReader.GetDouble("TotalBill");
oDueCollection.ReceivedBalance = oReader.GetDouble("PaidAmnt");
BusinessObject.Factory.SetObjectState(oDueCollection, ObjectState.Saved);
}
private ItemOrder MapItemOrder(DbDataReader dr)
{
ItemOrder itemOrder = new ItemOrder();
itemOrder.OrderId = NullHandler.GetString(dr["OrderId"]);
itemOrder.SrId = NullHandler.GetString(dr["SrId"]);
itemOrder.MarketId = NullHandler.GetString(dr["MarketId"]);
itemOrder.OrderDate = NullHandler.GetDateTime(dr["Date"]);
itemOrder.OrderCount = NullHandler.GetInt32(dr["OrderCount"]);
itemOrder.ReturnCount = NullHandler.GetInt32(dr["ReturnCount"]);
itemOrder.DamageCount = NullHandler.GetInt32(dr["DamagedCount"]);
itemOrder.SellsCount = NullHandler.GetInt32(dr["SoldCount"]);
itemOrder.CompanyId = NullHandler.GetString(dr["CompanyId"]);
itemOrder.ItemId = NullHandler.GetString(dr["ItemId"]);
itemOrder.ItemName = NullHandler.GetString(dr["ItemName"]);
itemOrder.CountPerBox = NullHandler.GetInt32(dr["CountPerBox"]);
itemOrder.Price = NullHandler.GetDouble(dr["Price"]);
itemOrder.TotalPrice = Math.Round(itemOrder.Price * itemOrder.SellsCount, 2);
itemOrder.StockId = NullHandler.GetString(dr["StockId"]);
itemOrder.CurrentStockTotal = NullHandler.GetInt32(dr["TotalStock"]);
itemOrder.CurrentDamagedStockTotal = NullHandler.GetInt32(dr["DamagedStock"]);
itemOrder.ChalanNo = NullHandler.GetString(dr["ChalanNo"]);
itemOrder.StockEntryDate = NullHandler.GetDateTime(dr["StockEntryDate"]);
itemOrder.CalculateBoxesFromTotalStock();
itemOrder.CalculateOrdersInBox();
return(itemOrder);
}
private SRDSRDue MapSrDsrDue(DbDataReader dr)
{
SRDSRDue srDsrDue = new SRDSRDue();
srDsrDue.Id = NullHandler.GetString(dr["SrId"]);
srDsrDue.Due = NullHandler.GetDouble(dr["TotalDue"]);
return(srDsrDue);
}
private SRDSRDue MapSrDsrWithDue(DbDataReader dr)
{
SRDSRDue srDsr = new SRDSRDue();
srDsr.Id = NullHandler.GetString(dr["Id"]);
srDsr.Name = NullHandler.GetString(dr["Name"]);
srDsr.Type = (SRType)NullHandler.GetInt32(dr["Type"]);
srDsr.CellNo = NullHandler.GetString(dr["CellNo"]);
srDsr.Due = NullHandler.GetDouble(dr["TotalDue"]);
return(srDsr);
}
private Item MapItem(DbDataReader dr)
{
Item item = new Item();
item.CompanyId = NullHandler.GetString(dr["CompanyId"]);
item.ItemId = NullHandler.GetString(dr["ItemId"]);
item.ItemName = NullHandler.GetString(dr["ItemName"]);
item.CountPerBox = NullHandler.GetInt32(dr["CountPerBox"]);
item.Price = NullHandler.GetDouble(dr["Price"]);
return(item);
}
private void MapObject(Transaction oTransaction, NullHandler oReader)
{
BusinessObject.Factory.SetID(oTransaction, new ID(oReader.GetInt32("TrnID")));
oTransaction.TranRef = oReader.GetString("TranRef");
oTransaction.LegacyRef = oReader.GetString("LegacyRef");
oTransaction.TranHead = oReader.GetString("TranHead");
oTransaction.CurrBalance = oReader.GetDouble("CurrBalance");
oTransaction.DrAmount = oReader.GetDouble("DrAmount");
oTransaction.CrAmount = oReader.GetDouble("CrAmount");
oTransaction.TranDate = oReader.GetDateTime("TranDate");
oTransaction.Perticular = oReader.GetString("Perticular");
BusinessObject.Factory.SetObjectState(oTransaction, ObjectState.Saved);
}
private void MapObject(ProductConfigure oProductConfigure, NullHandler oReader)
{
BusinessObject.Factory.SetID(oProductConfigure, new ID(oReader.GetInt32("PCID")));
oProductConfigure.prodId = oReader.GetInt32("prodId");
oProductConfigure.Pro_Name = oReader.GetString("Pro_Name");
oProductConfigure.unitQty = oReader.GetDouble("unitQty");
oProductConfigure.unitType = (EnumUnitType)oReader.GetInt32("unitType");
BusinessObject.Factory.SetObjectState(oProductConfigure, ObjectState.Saved);
}
private void MapObject(BankAccount oBankAccount, NullHandler oReader)
{
BusinessObject.Factory.SetID(oBankAccount, new ID(oReader.GetInt32("ObjectID")));
oBankAccount.bankName = oReader.GetString("bankName");
oBankAccount.branchName = oReader.GetString("branchName");
oBankAccount.accountNumber = oReader.GetString("accountNumber");
oBankAccount.GLhead = oReader.GetString("GLhead");
oBankAccount.currentBalance = oReader.GetDouble("currentBalance");
oBankAccount.EnumAccountType = (EnumAccountType)oReader.GetInt32("accountType");
oBankAccount.bankID = oReader.GetInt32("bankID");
BusinessObject.Factory.SetObjectState(oBankAccount, ObjectState.Saved);
}
private void MapObject(SaleOrderDetail oSaleOrderDetail, NullHandler oReader)
{
BusinessObject.Factory.SetID(oSaleOrderDetail, new ID(oReader.GetInt32("SaleID")));
oSaleOrderDetail.SONumber = oReader.GetString("SONumber");
oSaleOrderDetail.saleDate = oReader.GetDateTime("saleDate");
oSaleOrderDetail.PONumber = oReader.GetString("PONumber");
oSaleOrderDetail.printBillRef = oReader.GetString("printBillRef");
oSaleOrderDetail.memoNo = oReader.GetString("memoNo");
oSaleOrderDetail.Pro_ID = oReader.GetInt32("Pro_ID");
oSaleOrderDetail.discount = oReader.GetDouble("discount");
oSaleOrderDetail.newCus = oReader.GetString("newCus");
oSaleOrderDetail.newCusContact = oReader.GetString("newCusContact");
oSaleOrderDetail.PartyID = oReader.GetString("PartyID");
oSaleOrderDetail.prodUnit = oReader.GetString("prodUnit");
oSaleOrderDetail.bagQty = oReader.GetDouble("bagQty");
oSaleOrderDetail.unitPrice = oReader.GetDouble("unitPrice");
oSaleOrderDetail.unitPerBag = oReader.GetDouble("unitPerBag");
oSaleOrderDetail.transportCost = oReader.GetDouble("transportCost");
oSaleOrderDetail.returnQty = oReader.GetDouble("returnQty");
oSaleOrderDetail.totalSaleQty = oReader.GetDouble("totalSaleQty");
oSaleOrderDetail.totalAmount = oReader.GetDouble("totalAmount");
oSaleOrderDetail.comments = oReader.GetString("comments");
BusinessObject.Factory.SetObjectState(oSaleOrderDetail, ObjectState.Saved);
}
private ItemOrder MapItemOrderTemplate(DbDataReader dr)
{
ItemOrder itemOrderTemplate = new ItemOrder();
itemOrderTemplate.OrderId = string.Empty;
itemOrderTemplate.SrId = string.Empty;
itemOrderTemplate.MarketId = string.Empty;
itemOrderTemplate.OrderDate = DateTime.Now;
itemOrderTemplate.OrderCount = 0;
itemOrderTemplate.OrderBoxCount = 0;
itemOrderTemplate.OrderExtraCount = 0;
itemOrderTemplate.ReturnCount = 0;
itemOrderTemplate.ReturnBoxCount = 0;
itemOrderTemplate.ReturnExtraCount = 0;
itemOrderTemplate.DamageCount = 0;
itemOrderTemplate.DamageBoxCount = 0;
itemOrderTemplate.DamageExtraCount = 0;
itemOrderTemplate.SellsCount = 0;
itemOrderTemplate.SellsBoxCount = 0;
itemOrderTemplate.SellsExtraCount = 0;
itemOrderTemplate.CompanyId = NullHandler.GetString(dr["CompanyId"]);
itemOrderTemplate.ItemId = NullHandler.GetString(dr["ItemId"]);
itemOrderTemplate.ItemName = NullHandler.GetString(dr["ItemName"]);
itemOrderTemplate.CountPerBox = NullHandler.GetInt32(dr["CountPerBox"]);
itemOrderTemplate.Price = NullHandler.GetDouble(dr["Price"]);
itemOrderTemplate.StockId = NullHandler.GetString(dr["StockId"]);
itemOrderTemplate.CurrentStockTotal = NullHandler.GetInt32(dr["TotalStock"]);
itemOrderTemplate.CurrentDamagedStockTotal = NullHandler.GetInt32(dr["DamagedStock"]);
itemOrderTemplate.ChalanNo = NullHandler.GetString(dr["ChalanNo"]);
itemOrderTemplate.StockEntryDate = NullHandler.GetDateTime(dr["StockEntryDate"]);
itemOrderTemplate.CalculateBoxesFromTotalStock();
//itemOrderTemplate.CalculateOrdersInBox();
return(itemOrderTemplate);
}
private void MapObject(ProductLot oProductLot, NullHandler oReader)
{
BusinessObject.Factory.SetID(oProductLot, new ID(oReader.GetInt32("Lot_ID")));
oProductLot.LotNo = oReader.GetString("LotNo");
oProductLot.Pro_ID = oReader.GetInt32("Pro_ID");
oProductLot.barCode = oReader.GetString("barCode");
oProductLot.Total_Qty = oReader.GetDouble("Total_Qty");
oProductLot.Bag_Qty = oReader.GetDouble("Bag_Qty");
oProductLot.Sale_Qty = oReader.GetDouble("Sale_Qty");
oProductLot.Ret_Qty = oReader.GetDouble("Ret_Qty");
oProductLot.purchesPrice = oReader.GetDouble("purchesPrice");
oProductLot.salePrice = oReader.GetDouble("salePrice");
BusinessObject.Factory.SetObjectState(oProductLot, ObjectState.Saved);
}
private void MapObject(PurchaseOrderDetail oPurchaseOrderDetail, NullHandler oReader)
{
BusinessObject.Factory.SetID(oPurchaseOrderDetail, new ID(oReader.GetInt32("PPID")));
oPurchaseOrderDetail.lotNumber = oReader.GetString("lotNumber");
oPurchaseOrderDetail.PartyID = oReader.GetString("PartyID");
oPurchaseOrderDetail.Pro_ID = oReader.GetInt32("Pro_ID");
oPurchaseOrderDetail.ProdName = oReader.GetString("ProdName");
oPurchaseOrderDetail.prodUnit = oReader.GetString("prodUnit");
oPurchaseOrderDetail.PONumber = oReader.GetString("PONumber");
oPurchaseOrderDetail.memoNo = oReader.GetString("memoNo");
oPurchaseOrderDetail.bagQty = oReader.GetDouble("bagQty");
oPurchaseOrderDetail.unitPrice = oReader.GetDouble("unitPrice");
oPurchaseOrderDetail.unitPerBag = oReader.GetDouble("unitPerBag");
oPurchaseOrderDetail.totalQty = oReader.GetDouble("totalQty");
oPurchaseOrderDetail.saleQtyBag = oReader.GetDouble("saleQtyBag");
oPurchaseOrderDetail.saleQty = oReader.GetDouble("saleQty");
oPurchaseOrderDetail.returnQty = oReader.GetDouble("returnQty");
oPurchaseOrderDetail.wastageQty = oReader.GetDouble("wastageQty");
oPurchaseOrderDetail.truckCost = oReader.GetDouble("truckCost");
oPurchaseOrderDetail.labourCost = oReader.GetDouble("labourCost");
oPurchaseOrderDetail.bagCost = oReader.GetDouble("bagCost");
oPurchaseOrderDetail.otherCost = oReader.GetDouble("otherCost");
oPurchaseOrderDetail.purchasePrice = oReader.GetDouble("purchasePrice");
oPurchaseOrderDetail.comments = oReader.GetString("comments");
BusinessObject.Factory.SetObjectState(oPurchaseOrderDetail, ObjectState.Saved);
}
