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