コード例 #1
0
 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));
 }
コード例 #2
0
        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));
        }