public JsonResult GetRequisitionByClient(string documentID)
        {
            var usr = (Login)System.Web.HttpContext.Current.Session["usr"];

            if (usr == null)
            {
                RedirectToAction("Index", "Home");
                return(null);
            }
            var requisition = new MangerRequisition().GetLoanInformationByCustomer(double.Parse(documentID));

            return(new JsonResult {
                Data = requisition, JsonRequestBehavior = JsonRequestBehavior.AllowGet
            });
        }
        public JsonResult GetLoanDetail(string folder)
        {
            var usr = (Login)System.Web.HttpContext.Current.Session["usr"];

            if (usr == null)
            {
                RedirectToAction("Index", "Home");
                return(null);
            }
            double folderNumber = double.Parse(folder);
            var    requisition  = new MangerRequisition().GetLoanDetailList(folderNumber);

            return(new JsonResult {
                Data = requisition, JsonRequestBehavior = JsonRequestBehavior.AllowGet
            });
        }
        public JsonResult GetRequisitionByDate(string pStartDate, string pEndDate)
        {
            DateTime startDate = new DateTime(), endDate = new DateTime();
            var      usr = (Login)System.Web.HttpContext.Current.Session["usr"];

            if (usr == null)
            {
                RedirectToAction("Index", "Home");
                return(null);
            }
            if (pStartDate != null && pEndDate != null)
            {
                startDate = Convert.ToDateTime(pStartDate);
                endDate   = Convert.ToDateTime(pEndDate);
            }

            var requisition = new MangerRequisition().GetLoanInformationByLoanOfficer(Double.Parse(usr.userName), startDate, endDate);

            return(new JsonResult {
                Data = requisition, JsonRequestBehavior = JsonRequestBehavior.AllowGet
            });
        }