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