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 void MapObject(UserFunctionality oUserFunctionality, NullHandler oReader) { BusinessObject.Factory.SetID(oUserFunctionality, new ID(oReader.GetInt32("UFPID"))); oUserFunctionality.UFID = oReader.GetInt32("UFID"); oUserFunctionality.User_ID = oReader.GetInt32("user_id"); BusinessObject.Factory.SetObjectState(oUserFunctionality, ObjectState.Saved); }
private void MapObject(AddBranch oAddBranch, NullHandler oReader) { BusinessObject.Factory.SetID(oAddBranch, new ID(oReader.GetInt32("brn_id"))); oAddBranch.ebrn_type = (EnumBrnchType)oReader.GetInt32("brn_type"); oAddBranch.brn_title = oReader.GetString("brn_title"); oAddBranch.brn_location = oReader.GetString("brn_location"); BusinessObject.Factory.SetObjectState(oAddBranch, ObjectState.Saved); }
private void MapObject(MenuPermission oMenuPermission, NullHandler oReader) { BusinessObject.Factory.SetID(oMenuPermission, new ID(oReader.GetInt32("UPID"))); oMenuPermission.MenuID = oReader.GetInt32("MenuID"); oMenuPermission.UserID = oReader.GetInt32("user_id"); BusinessObject.Factory.SetObjectState(oMenuPermission, ObjectState.Saved); }
private void MapObject(UserFunction oUserFunction, NullHandler oReader) { BusinessObject.Factory.SetID(oUserFunction, new ID(oReader.GetInt32("UFID"))); oUserFunction.Is_Parent = oReader.GetBoolean("Is_Parent"); oUserFunction.ParentID = oReader.GetInt32("ParentID"); oUserFunction.Function_Name = oReader.GetString("Function_Name"); oUserFunction.IsCheck = oReader.GetBoolean("IsCheck"); BusinessObject.Factory.SetObjectState(oUserFunction, ObjectState.Saved); }
private void MapObject(ManuInterface oManuInterface, NullHandler oReader) { BusinessObject.Factory.SetID(oManuInterface, new ID(oReader.GetInt32("Menu_id"))); oManuInterface.Parent_id = oReader.GetInt32("Parent_id"); oManuInterface.Is_parent = oReader.GetBoolean("Is_parent"); oManuInterface.Sub_parent = oReader.GetBoolean("Sub_parent"); oManuInterface.Menu_title = oReader.GetString("Menu_title"); oManuInterface.IsCheck = oReader.GetBoolean("IsCheck"); oManuInterface.NevigetUrl = oReader.GetString("Nav_url"); BusinessObject.Factory.SetObjectState(oManuInterface, 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(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); }
private void MapObject(Product oProduct, NullHandler oReader) { BusinessObject.Factory.SetID(oProduct, new ID(oReader.GetInt32("Pro_ID"))); oProduct.Pro_Name = oReader.GetString("Pro_Name"); oProduct.Pro_Cat_ID = oReader.GetInt32("Pro_Cat_ID"); oProduct.catName = oReader.GetString("catName"); //oProduct.modelNumber = oReader.GetString("modelNumber"); BusinessObject.Factory.SetObjectState(oProduct, ObjectState.Saved); }
private void MapObject(LoginInterface oLoginInterface, NullHandler oReader) { BusinessObject.Factory.SetID(oLoginInterface, new ID(oReader.GetInt32("user_id"))); oLoginInterface.user_code = oReader.GetInt32("user_code"); oLoginInterface.user_fst_name = oReader.GetString("user_fst_name"); oLoginInterface.user_lst_name = oReader.GetString("user_lst_name"); oLoginInterface.user_name = oReader.GetString("user_name"); oLoginInterface.user_pass = oReader.GetString("user_pass"); oLoginInterface.user_type = (EnumUserType)oReader.GetInt32("user_type"); oLoginInterface.user_islogon = oReader.GetBoolean("user_islogon"); oLoginInterface.user_lock = oReader.GetBoolean("user_lock"); oLoginInterface.user_status = (EnumUserStatus)oReader.GetInt32("user_status"); //oLoginInterface.IsAuthorise = oReader.GetBoolean("IsAuthorise"); BusinessObject.Factory.SetObjectState(oLoginInterface, 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 void MapObject(ProdCatagory oProdCatagory, NullHandler oReader) { BusinessObject.Factory.SetID(oProdCatagory, new ID(oReader.GetInt32("catId"))); oProdCatagory.catName = oReader.GetString("catName"); BusinessObject.Factory.SetObjectState(oProdCatagory, ObjectState.Saved); }
private void MapObject(UserSecurity oUserSecurity, NullHandler oReader) { BusinessObject.Factory.SetID(oUserSecurity, new ID(oReader.GetInt32("USID"))); oUserSecurity.user_id = oReader.GetInt32("user_id"); oUserSecurity.MacAddress = oReader.GetString("MacAddress"); oUserSecurity.IsAuthorise = oReader.GetBoolean("IsAuthorise"); oUserSecurity.AuthoriseBy = oReader.GetInt32("AuthoriseBy"); oUserSecurity.RequestDate = oReader.GetDateTime("RequestDate"); oUserSecurity.AuthoriseDate = oReader.GetDateTime("AuthoriseDate"); BusinessObject.Factory.SetObjectState(oUserSecurity, 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 void MapObject(NewUser oNewUser, NullHandler oReader) { BusinessObject.Factory.SetID(oNewUser, new ID(oReader.GetInt32("user_id"))); //oNewUser.brn_id = oReader.GetInt32("brn_id"); //oNewUser.BrName = oReader.GetString("BrName"); oNewUser.user_fst_name = oReader.GetString("user_fst_name"); oNewUser.user_lst_name = oReader.GetString("user_lst_name"); oNewUser.user_code = oReader.GetString("user_code"); oNewUser.user_name_ini = oReader.GetString("user_name_ini"); oNewUser.user_name = oReader.GetString("user_name"); oNewUser.user_pass = oReader.GetString("user_pass"); oNewUser.user_type = (EnumUserType)oReader.GetInt32("user_type"); oNewUser.user_islogon = oReader.GetBoolean("user_islogon"); oNewUser.user_lock = oReader.GetBoolean("user_lock"); oNewUser.user_status = (EnumUserStatus)oReader.GetInt32("user_status"); oNewUser.OwnerName = oReader.GetString("OwnerName"); BusinessObject.Factory.SetObjectState(oNewUser, ObjectState.Saved); }
private SRDSR MapSrDsr(DbDataReader dr) { SRDSR srDsr = new SRDSR(); 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"]); return(srDsr); }
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(Challan oChallan, NullHandler oReader) { BusinessObject.Factory.SetID(oChallan, new ID(oReader.GetInt32("ChallanID"))); oChallan.ChallanType = oReader.GetString("ChallanType"); oChallan.ChallanNo = oReader.GetString("ChallanNo"); oChallan.Description = oReader.GetString("Description"); BusinessObject.Factory.SetObjectState(oChallan, ObjectState.Saved); }
private void MapObject(Party oParty, NullHandler oReader) { BusinessObject.Factory.SetID(oParty, new ID(oReader.GetInt32("PartyID"))); oParty.PartyType = (EnumParty)oReader.GetInt32("PartyType"); oParty.AccountCode = oReader.GetString("AccountCode"); oParty.PartyName = oReader.GetString("PartyName"); oParty.Address = oReader.GetString("Address"); oParty.Mobile = oReader.GetString("Mobile"); oParty.Phone = oReader.GetString("Phone"); oParty.Email = oReader.GetString("Email"); oParty.IsActive = oReader.GetBoolean("IsActive"); BusinessObject.Factory.SetObjectState(oParty, ObjectState.Saved); }
private User Mapobject(DbDataReader dr) { User user = new User(); user.userID = NullHandler.GetString(dr["USER_ID"]); user.userName = NullHandler.GetString(dr["USER_NAME"]); user.password = NullHandler.GetString(dr["PASSWORD"]); user.creationDate = NullHandler.GetDateTime(dr["CREATION_DATE"]); user.roleType = (RoleType)NullHandler.GetInt32(dr["ROLE_TYPE"]); user.active = NullHandler.GetBoolean(dr["ACTIVE"]); return(user); }
private void MapObject(ChartOfAcc oChartOfAcc, NullHandler oReader) { BusinessObject.Factory.SetID(oChartOfAcc, new ID(oReader.GetInt32("Coa_id"))); oChartOfAcc.Coa_type = oReader.GetString("Coa_type"); oChartOfAcc.Coa_parent_id = oReader.GetInt32("Coa_parent_id"); oChartOfAcc.Coa_is_perent = oReader.GetBoolean("Coa_is_perent"); oChartOfAcc.Coa_title = oReader.GetString("Coa_title"); oChartOfAcc.Coa_level_code = oReader.GetString("Coa_level_code"); oChartOfAcc.Coa_account_code = oReader.GetString("Coa_account_code"); oChartOfAcc.Coa_legacy_code = oReader.GetString("Coa_legacy_code"); oChartOfAcc.Coa_is_ledgerhead = oReader.GetBoolean("Coa_is_ledgerhead"); BusinessObject.Factory.SetObjectState(oChartOfAcc, ObjectState.Saved); }
private Chalan MapChalan(DbDataReader dr) { Chalan chalan = new Chalan(); chalan.ChalanId = NullHandler.GetString(dr["ChalanId"]); chalan.ChalanNo = NullHandler.GetString(dr["ChalanNo"]); chalan.ItemId = NullHandler.GetString(dr["ItemId"]); chalan.ItemName = NullHandler.GetString(dr["ItemName"]); chalan.CountPerBox = NullHandler.GetInt32(dr["CountPerBox"]); chalan.EntryCount = NullHandler.GetInt32(dr["EntryCount"]); chalan.ChalanDate = NullHandler.GetDateTime(dr["ChalanDate"]); chalan.CalculateBoxesFromTotalChalan(); return(chalan); }
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 ItemStock MapStockItem(DbDataReader dr) { ItemStock stockItem = new ItemStock(); stockItem.CompanyId = NullHandler.GetString(dr["CompanyId"]); stockItem.ItemId = NullHandler.GetString(dr["ItemId"]); stockItem.ItemName = NullHandler.GetString(dr["ItemName"]); stockItem.CountPerBox = NullHandler.GetInt32(dr["CountPerBox"]); stockItem.StockId = NullHandler.GetString(dr["StockId"]); stockItem.CurrentStockTotal = NullHandler.GetInt32(dr["TotalStock"]); stockItem.CurrentDamagedStockTotal = NullHandler.GetInt32(dr["DamagedStock"]); stockItem.ChalanNo = NullHandler.GetString(dr["ChalanNo"]); stockItem.StockEntryDate = NullHandler.GetDateTime(dr["StockEntryDate"]); stockItem.CalculateBoxesFromTotalStock(); stockItem.CalculateBoxesFromDamagedTotalStock(); return(stockItem); }
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(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 DetailPaymentInfo MapPayment(DbDataReader dr) { DetailPaymentInfo detailPaymentInfo = new DetailPaymentInfo(); detailPaymentInfo.PaymentId = NullHandler.GetString(dr["PaymentId"]); detailPaymentInfo.Id = NullHandler.GetString(dr["SrId"]); detailPaymentInfo.CompanyId = NullHandler.GetString(dr["CompanyId"]); detailPaymentInfo.PaymentDate = NullHandler.GetDateTime(dr["PaymentDate"]); detailPaymentInfo.ThousendCount = NullHandler.GetInt32(dr["ThousendCount"]); detailPaymentInfo.FiveHundredCount = NullHandler.GetInt32(dr["FiveHundredCount"]); detailPaymentInfo.OneHundredCount = NullHandler.GetInt32(dr["OneHundredCount"]); detailPaymentInfo.FiftyCount = NullHandler.GetInt32(dr["FiftyCount"]); detailPaymentInfo.TwentyCount = NullHandler.GetInt32(dr["TwentyCount"]); detailPaymentInfo.TenCount = NullHandler.GetInt32(dr["TenCount"]); detailPaymentInfo.FiveCount = NullHandler.GetInt32(dr["FiveCount"]); detailPaymentInfo.TwoCount = NullHandler.GetInt32(dr["TwoCount"]); detailPaymentInfo.OneCount = NullHandler.GetInt32(dr["OneCount"]); detailPaymentInfo.TotalPayment = NullHandler.GetDecimal(dr["TotalPayment"]); return(detailPaymentInfo); }
public SavingState SaveItemsOrder(DataGridView dataGridViewOrder, string companyId, string srDsrId, string marketId, DateTime orderDate, SRDSRDue srDsrDue, bool isFromTemplate = false, bool isItemReturnedFromOrder = false, bool isDamagedItemReturnedFromOrder = false) { SavingState svState = SavingState.Failed; DbCommand thisCommand = null; try { thisCommand = GenericDataAccess.CreateCommand(); thisCommand.CommandType = CommandType.Text; GenericDataAccess.OpenDBConnection(thisCommand); if ((isFromTemplate && !IsSrDsrOrderExist(companyId, srDsrId, marketId, orderDate)) || (!isFromTemplate && IsSrDsrOrderExist(companyId, srDsrId, marketId, orderDate))) { foreach (DataGridViewRow row in dataGridViewOrder.Rows) { int stockAvailableInStore = 0; int damagedItemAvailableInStock = 0; if (string.IsNullOrEmpty(NullHandler.GetString(row.Cells["OrderId"].Value))) { /// insert the item order thisCommand.CommandText = "INSERT INTO IM_Orders (OrderId, CompanyId, SrId, MarketId, ItemId, Date, OrderCount, ReturnCount, SoldCount, DamagedCount) VALUES(@OrderId, @CompanyId, @SrId, @MarketId, @ItemId, @Date, @OrderCount, @ReturnCount, @SoldCount, @DamagedCount)"; CreateParameter.AddParam(thisCommand, "@OrderId", Guid.NewGuid().ToString(), DbType.String); CreateParameter.AddParam(thisCommand, "@CompanyId", companyId, DbType.String); CreateParameter.AddParam(thisCommand, "@SrId", srDsrId, DbType.String); CreateParameter.AddParam(thisCommand, "@MarketId", marketId, DbType.String); CreateParameter.AddParam(thisCommand, "@ItemId", NullHandler.GetString(row.Cells["ItemId"].Value), DbType.String); CreateParameter.AddParam(thisCommand, "@Date", orderDate.Date, DbType.Date); stockAvailableInStore = NullHandler.GetInt32(row.Cells["CurrentStockTotal"].Value) - NullHandler.GetInt32(row.Cells["SellsCount"].Value); damagedItemAvailableInStock = NullHandler.GetInt32(row.Cells["CurrentDamagedStockTotal"].Value); } else { /// update the item order based on OrderId thisCommand.CommandText = "UPDATE IM_Orders SET OrderCount = @OrderCount, ReturnCount = @ReturnCount, SoldCount = @SoldCount, DamagedCount = @DamagedCount WHERE OrderId = @OrderId"; CreateParameter.AddParam(thisCommand, "@OrderId", row.Cells["OrderId"].Value.ToString(), DbType.String); stockAvailableInStore = isItemReturnedFromOrder ? (NullHandler.GetInt32(row.Cells["CurrentStockTotal"].Value) + NullHandler.GetInt32(row.Cells["ReturnCount"].Value)) : NullHandler.GetInt32(row.Cells["CurrentStockTotal"].Value); damagedItemAvailableInStock = isDamagedItemReturnedFromOrder? (NullHandler.GetInt32(row.Cells["CurrentDamagedStockTotal"].Value) + NullHandler.GetInt32(row.Cells["DamageCount"].Value)): NullHandler.GetInt32(row.Cells["CurrentDamagedStockTotal"].Value); } CreateParameter.AddParam(thisCommand, "@OrderCount", row.Cells["OrderCount"].Value, DbType.Int32); CreateParameter.AddParam(thisCommand, "@ReturnCount", row.Cells["ReturnCount"].Value, DbType.Int32); CreateParameter.AddParam(thisCommand, "@DamagedCount", row.Cells["DamageCount"].Value, DbType.Int32); CreateParameter.AddParam(thisCommand, "@SoldCount", row.Cells["SellsCount"].Value, DbType.Int32); GenericDataAccess.ExecuteNonQueryTransaction(thisCommand); thisCommand.Parameters.Clear(); if (!string.IsNullOrEmpty(NullHandler.GetString(row.Cells["StockId"].Value))) { ItemStock stock = new ItemStock(); stock.StockId = NullHandler.GetString(row.Cells["StockId"].Value); stock.ItemId = NullHandler.GetString(row.Cells["ItemId"].Value); stock.ChalanNo = NullHandler.GetString(row.Cells["ChalanNo"].Value); stock.StockEntryDate = NullHandler.GetDateTime(row.Cells["StockEntryDate"].Value); stock.CurrentStockTotal = stockAvailableInStore;//NullHandler.GetInt32(row.Cells["CurrentStockTotal"].Value); stock.CurrentDamagedStockTotal = damagedItemAvailableInStock; svState = SaveStockItem(stock, thisCommand, true); } } } else { svState = SavingState.DuplicateExists; } } catch (Exception ex) { if (ex.Message.ToLower().Contains("duplicate key")) { svState = SavingState.DuplicateExists; } } finally { GenericDataAccess.CloseDBConnection(thisCommand); } if (svState.Equals(SavingState.Success) && !string.IsNullOrEmpty(srDsrDue.Id)) { svState = SRDSRManager.Instance.SaveSrDsrDue(srDsrDue); } return(svState); }