public ActionResult AddHolidays(int id = 0) { using (mmpEntities mP = new mmpEntities()) { mP.Configuration.ProxyCreationEnabled = false; holiday_year hy = mP.holiday_year.Where(x => x.year == DateTime.Now.Year).OrderByDescending(x => x.hy_id).First <holiday_year>(); List <AddHolidays> AHD = new List <AddHolidays> { new AddHolidays { hd_name = "", hd_from = DateTime.Now, hd_to = DateTime.Now, hy_id = 0 } }; return(View(AHD)); } }
public ActionResult GetData() { using (mmpEntities mP = new mmpEntities()) { mP.Configuration.ProxyCreationEnabled = false; DateTime date = DateTime.Now; ViewBag.Year = date.Year; var year = mP.holiday_year.Where(x => x.year == DateTime.Now.Year).FirstOrDefault <holiday_year>(); if (year == null) { holiday_year hy = new holiday_year() { //hy_name = "Holiday list for " + date.Year.ToString(), hy_name = "Holiday list", creation_date = date, year = (Int16)date.Year // Cast int to short }; mP.holiday_year.Add(hy); mP.SaveChanges(); return(Json(new { data = year }, JsonRequestBehavior.AllowGet)); } else { /*var holidays = (from hd in mP.holiday_details * join hy in mP.holiday_year on hd.hy_id equals hy.hy_id * select new * { * hd, * year = hy.year * }).OrderByDescending(x => x.year);*/ var holidays = (from hd in mP.holiday_details select new { hd, year = hd.hd_to.Year }).OrderByDescending(x => x.year); return(Json(new { data = holidays.AsNoTracking().ToList() }, JsonRequestBehavior.AllowGet)); } } }