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(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(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(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(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(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 SRDSRDue MapSrDsrDue(DbDataReader dr)
{
SRDSRDue srDsrDue = new SRDSRDue();
srDsrDue.Id = NullHandler.GetString(dr["SrId"]);
srDsrDue.Due = NullHandler.GetDouble(dr["TotalDue"]);
return(srDsrDue);
}
private Company MapCompany(DbDataReader dr)
{
Company company = new Company();
company.companyId = NullHandler.GetString(dr["CompanyId"]);
company.companyName = NullHandler.GetString(dr["CompanyName"]);
return(company);
}
private Market MapMarket(DbDataReader dr)
{
Market market = new Market();
market.Id = NullHandler.GetString(dr["Id"]);
market.Name = NullHandler.GetString(dr["Name"]);
return(market);
}
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 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 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 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 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(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 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(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(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);
}
//protected String BuildActionLinks(DataRowView row)
//{
// String[] fields = BuildQueryStringValues(row);
// String editLink = String.Format(this.EditLink, fields);
// String deleteLink = String.Format(this.DeleteLink, fields);
// return String.Format("<a href='{0}'>Edit</a> <a href='{1}'>Delete</a>", editLink, deleteLink);
//}
protected String[] BuildQueryStringValues(DataRowView row)
{
if (this.LinkFields.IsNullOrEmpty())
{
throw new ArgumentException("The property 'LinkFields' must be defined to create Edit or Delete link");
}
String[] fields = this.LinkFields.Split(',');
IList <String> values = new List <String>();
foreach (String filed in fields)
{
values.Add(NullHandler.GetString(row[filed.Trim()]));
}
return(values.ToArray());
}
private String getFormattedData(object data)
{
if (data.GetType() == typeof(String))
{
String text = NullHandler.GetString(data);
if (!this.ListFullText && text.WordCount() > 30)
{
text = text.GetWords(30);
}
return(WebUtil.FormatText(text));
}
else
{
return(WebUtil.FormatData(data));
}
}
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 String GetCheckBoxValue(DataRowView row)
{
if (this.SelectionCheckBoxField.IndexOf(',') > -1)
{
String[] fields = this.SelectionCheckBoxField.Split(',');
StringBuilder sb = new StringBuilder(10);
foreach (String field in fields)
{
if (!field.IsNullOrEmpty())
{
sb.Append(NullHandler.GetString(row[field.Trim()]));
}
}
return(sb.ToString());
}
return(NullHandler.GetString(row[this.SelectionCheckBoxField]));
}
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(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 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);
}
