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