public JsonResult GetBinderDetails() { try { List <Binder> lstBinder = new List <Binder>(); DataTable dtMast = objDbTrx.GetBinderMaster(); if (dtMast.Rows.Count > 0) { for (int iCnt = 0; iCnt < dtMast.Rows.Count; iCnt++) { Binder onjBinder = new Binder(); onjBinder.BinderName = Convert.ToString(dtMast.Rows[iCnt]["BinderName"].ToString()); onjBinder.BinderId = Convert.ToInt32(dtMast.Rows[iCnt]["ID"].ToString()); lstBinder.Add(onjBinder); } dtMast.Dispose(); } ViewBag.ObjBinderList = new SelectList(lstBinder, "BinderId", "BinderName"); } catch (Exception ex) { objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress); } return(Json(ViewBag.ObjBinderList)); }
public ActionResult Index() { BinderWiseBookQtyRpt objBinderWiseBookQtyRpt = new BinderWiseBookQtyRpt(); DataTable dtChallanRemarks = new DataTable(); dtChallanRemarks = objDbTrx.GetBinderMaster(); List <ChallanRemarks> ObjChallanRemarks = new List <ChallanRemarks>(); if (dtChallanRemarks.Rows.Count > 0) { for (int iCnt = 0; iCnt < dtChallanRemarks.Rows.Count; iCnt++) { ChallanRemarks chlnRemrks = new ChallanRemarks(); chlnRemrks.RemId = Convert.ToInt32(dtChallanRemarks.Rows[iCnt]["ID"].ToString()); chlnRemrks.Remarks = dtChallanRemarks.Rows[iCnt]["BinderName"].ToString(); ObjChallanRemarks.Add(chlnRemrks); } } // objBinderWiseBookQtyRpt.startDate = Convert.ToDateTime(Convert.ToDateTime(DateTime.Now).ToString("dd-MMM-yyyy") + " 00:00:00.000"); //objBinderWiseBookQtyRpt.endDate = Convert.ToDateTime(Convert.ToDateTime(DateTime.Now).ToString("dd-MMM-yyyy") + " 23:59:59.999"); objBinderWiseBookQtyRpt.ChallanRemarksCollection = ObjChallanRemarks; return(View(objBinderWiseBookQtyRpt)); }