public ActionResult Dashboard() { if (string.IsNullOrEmpty((string)Session["DealerCode"])) { return(RedirectToAction("NewLogin", "Home")); } dealerCode = Session["DealerCode"].ToString(); List <BookOrdMasterVM> lstBO = new List <BookOrdMasterVM>(); DataTable dt = new DataTable(); List <SalesPersonPerformanceVM> model = new List <SalesPersonPerformanceVM>(); model = DashboardMethods.Select_SalesPersonPerformance(dealerCode); SqlParameter[] sqlParam = { new SqlParameter("@DealerCode", dealerCode) }; dt = DataAccess.getDataTable("SP_Get_BookRefModal", sqlParam, General.GetBMSConString()); if (dt.Rows.Count > 0) { lstBO = EnumerableExtension.ToList <BookOrdMasterVM>(dt); } List <RequestDeliveryOrderVM> lstDO = DeliveryOrderMethods.GetDOModalList(dealerCode); ViewBag.BookingOrders = lstBO; ViewBag.DeliveryOrders = lstDO; return(View(model)); }
public JsonResult GetDataFromDates(string FromDate, string ToDate) { string data; bool result = false; data = DashboardMethods.Select_SalesPersonPerformanceWithDatesRange(Session["DealerCode"].ToString(), FromDate, ToDate); if (!string.IsNullOrEmpty(data)) { result = true; } return(Json(new { Success = result, Response = data }, JsonRequestBehavior.AllowGet)); }