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));
}
}
