public JsonResult GetHoliday() { System.Data.Entity.Core.Objects.ObjectParameter jsonOut = new System.Data.Entity.Core.Objects.ObjectParameter("jsonOut", typeof(string)); AttendanceManagementEntities1 attendanceManagementEntities1 = new AttendanceManagementEntities1(); attendanceManagementEntities1.spHolidayDetails(jsonOut); var json = JsonConvert.DeserializeObject <List <ViewModels.vHolidayDetails> >(jsonOut.Value.ToString()); if (json != null) { return(Json(new { data = json.ToList() }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { data = "" }, JsonRequestBehavior.AllowGet)); } }
public JsonResult GetUserAttendance(string month) { int UserId = (int)Session["UserId"]; System.Data.Entity.Core.Objects.ObjectParameter jsonOut = new System.Data.Entity.Core.Objects.ObjectParameter("jsonOut", typeof(string)); AttendanceManagementEntities1 attendanceManagementEntities1 = new AttendanceManagementEntities1(); attendanceManagementEntities1.spGetMonthlyAttendance(month, UserId, jsonOut); var json = JsonConvert.DeserializeObject <List <ViewModels.vAttendanceDetails> >(jsonOut.Value.ToString()); if (json != null) { return(Json(new { data = json.ToList() }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { data = "" }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Home() { DateTime dateTime = DateTime.Now; List <vDateMonthAttendance> list = new List <vDateMonthAttendance>(); AttendanceManagementEntities1 attendanceManagementEntities1 = new AttendanceManagementEntities1(); System.Data.Entity.Core.Objects.ObjectParameter jsonOut = new System.Data.Entity.Core.Objects.ObjectParameter("jsonOut", typeof(string)); attendanceManagementEntities1.spDateMonthAttendance((int)Session["UserId"], dateTime.Month, jsonOut); var json = JsonConvert.DeserializeObject <List <vDateMonthAttendance> >(jsonOut.Value.ToString()); if (json != null) { list = json.ToList(); return(View(list)); } else { list = null; return(View(list)); } }