public ActionResult ProductsToExpire(string InitDate, string EndDate) { if (InitDate == null || InitDate == "") { InitDate = "1900-01-01"; } if (EndDate == null || EndDate == "") { EndDate = "2900-01-01"; } var dataReport = db.sp_consulta_productos_por_vencer(InitDate, EndDate).ToList(); var list = new { data = dataReport }; return(Json(list, JsonRequestBehavior.AllowGet)); }