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