public ActionResult Index()
{
ViewBag.Active = "BinderAllotQty";
List <BinderAllotQuantity> listBinderAllotQuantity = new List <BinderAllotQuantity>();
try
{
DataTable GetBinderAllotQtyDtl = objDbTrx.GetBinderAllotQty();
if (GetBinderAllotQtyDtl.Rows.Count > 0)
{
for (int iCnt = 0; iCnt < GetBinderAllotQtyDtl.Rows.Count; iCnt++)
{
BinderAllotQuantity objBinderAllotQuantity = new BinderAllotQuantity();
objBinderAllotQuantity.ID = Convert.ToInt16(GetBinderAllotQtyDtl.Rows[iCnt]["ID"].ToString());
objBinderAllotQuantity.BinderId = Convert.ToInt16(GetBinderAllotQtyDtl.Rows[iCnt]["BINDER_ID"].ToString());
objBinderAllotQuantity.ChallanCategoryId = Convert.ToInt16(GetBinderAllotQtyDtl.Rows[iCnt]["CHALLAN_CATEGORY_ID"].ToString());
objBinderAllotQuantity.BookId = GetBinderAllotQtyDtl.Rows[iCnt]["BOOK_ID"].ToString();
objBinderAllotQuantity.TotQty = Convert.ToInt16(GetBinderAllotQtyDtl.Rows[iCnt]["TOT_QTY"].ToString());
objBinderAllotQuantity.Lot = Convert.ToInt16(GetBinderAllotQtyDtl.Rows[iCnt]["LOT"].ToString());
//objBinderAllotQuantity.LotFrom = Convert.ToInt16(GetBinderAllotQtyDtl.Rows[iCnt]["LOT_FROM"].ToString());
//objBinderAllotQuantity.LotTo = Convert.ToInt16(GetBinderAllotQtyDtl.Rows[iCnt]["LOT_TO"].ToString());
objBinderAllotQuantity.BookCategoryName = GetBinderAllotQtyDtl.Rows[iCnt]["CHALLAN_BOOK_CATEGORY"].ToString();
objBinderAllotQuantity.BookName = GetBinderAllotQtyDtl.Rows[iCnt]["BOOK_NAME"].ToString();
objBinderAllotQuantity.LanguageName = GetBinderAllotQtyDtl.Rows[iCnt]["LANGUAGE"].ToString();
objBinderAllotQuantity.BinderName = GetBinderAllotQtyDtl.Rows[iCnt]["BinderName"].ToString();
objBinderAllotQuantity.AllotmentDate = Convert.ToDateTime(GetBinderAllotQtyDtl.Rows[iCnt]["ALLOTMENT_DATE"].ToString()).ToString("dd-MMM-yyyy").ToUpper();
listBinderAllotQuantity.Add(objBinderAllotQuantity);
}
}
}
catch (Exception ex)
{
objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress);
}
return(View(listBinderAllotQuantity));
}