public ActionResult UpdateHoliday(FormCollection frmcollection)
        {
            HolidayTable holiinfo    = null;
            int          ParsedIntID = int.Parse(frmcollection["ID"]);

            holiinfo = db.HolidayTable.Find(ParsedIntID);

            if (holiinfo != null)
            {
                //compinfo.CompanyCode = frmcollection["CompanyCode"].ToString();
                holiinfo.HolidayTableDate        = Convert.ToDateTime(frmcollection["Date"].ToString()).Date;
                holiinfo.HolidayTableDescription = frmcollection["Description"].ToString();
                db.Entry(holiinfo).State         = System.Data.Entity.EntityState.Modified;
                db.SaveChanges();
            }
            else
            {
                throw new Exception("Invalid transaction.");
            }
            int parsedID = int.Parse(frmcollection["ID"]);
            SearchHolidayTableViewModel searchholiday = new SearchHolidayTableViewModel();

            searchholiday.HolidayList = db.HolidayTable.SqlQuery("Select * from HolidayTables").ToList();
            return(View("ViewHolidayTable", searchholiday));
        }
        public ActionResult AddHoliday(string Month, string Day, string Year, string Description)
        {
            SearchHolidayTableViewModel SearchHolidayViewModels = new SearchHolidayTableViewModel();

            HolidayTable HolidayAssignment = new HolidayTable();
            //CONDITION
            string Date = Month + "/" + Day + "/" + Year;

            HolidayAssignment.HolidayTableDate        = Convert.ToDateTime(Date).Date;
            HolidayAssignment.HolidayTableDescription = Description;
            db.HolidayTable.Add(HolidayAssignment);
            db.SaveChanges();

            SearchHolidayViewModels.HolidayList = db.HolidayTable.SqlQuery("Select * from HolidayTables").ToList();

            return(View("ViewHolidayTable", SearchHolidayViewModels));
        }
        // GET: MaintenanceHolidayTable

        public ActionResult ViewHolidayTable(FormCollection frm)
        {
            if (frm.Count == 0)
            {
                SearchHolidayTableViewModel SearchHolidayViewModels = new SearchHolidayTableViewModel();
                SearchHolidayViewModels.HolidayList = db.HolidayTable.SqlQuery("Select * from HolidayTables").ToList();
                return(View(SearchHolidayViewModels));
            }
            else if (frm.Count >= 1)
            {
                int          parsedID = int.Parse(frm["HolidayTableId"]);
                HolidayTable holiday  = db.HolidayTable.Find(parsedID);
                db.HolidayTable.Remove(holiday);
                db.SaveChanges();
                return(RedirectToAction("ViewHolidayTable"));
            }
            return(View());
        }