public JsonResult CreateData(string HD, string RD) { tblholiday tblholiday = new tblholiday(); DateTime Var = Convert.ToDateTime(HD).Date; var duplicateEntry = db.tblholidays.Where(m => m.IsDeleted == 0 && m.HolidayDate == Var).ToList(); if (duplicateEntry.Count > 0) { TempData["Error"] = "Record already exists"; } else { tblholiday.CreatedBy = 1; tblholiday.CreatedOn = DateTime.Now; tblholiday.IsDeleted = 0; tblholiday.HolidayDate = Convert.ToDateTime(HD).Date; tblholiday.Reason = RD; { db.tblholidays.Add(tblholiday); db.SaveChanges(); } } return(Json(tblholiday.HolidayId, JsonRequestBehavior.AllowGet)); }
public JsonResult DeleteData(int id = 0) { tblholiday tblholiday = db.tblholidays.Find(id); tblholiday.IsDeleted = 1; tblholiday.ModifiedBy = 1; tblholiday.ModifiedOn = DateTime.Now; { db.Entry(tblholiday).State = EntityState.Modified; db.SaveChanges(); } return(Json(tblholiday.HolidayId, JsonRequestBehavior.AllowGet)); }
public ActionResult Edit(tblholiday tblholiday) { if ((Session["UserId"] == null) || (Session["UserId"].ToString() == String.Empty)) { return(RedirectToAction("Login", "Login", null)); } ViewBag.Logout = Session["Username"].ToString().ToUpper(); ViewBag.roleid = Session["RoleID"]; tblholiday.ModifiedBy = 1; tblholiday.ModifiedOn = DateTime.Now; tblholiday.IsDeleted = 0; db.Entry(tblholiday).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit(int id = 0) { if ((Session["UserId"] == null) || (Session["UserId"].ToString() == String.Empty)) { return(RedirectToAction("Login", "Login", null)); } ViewBag.Logout = Session["Username"].ToString().ToUpper(); ViewBag.roleid = Session["RoleID"]; tblholiday tblholiday = db.tblholidays.Find(id); ViewBag.EditDate = Convert.ToDateTime(tblholiday.HolidayDate).ToString("dd/MM/yyyy"); if (tblholiday == null) { return(HttpNotFound()); } return(View(tblholiday)); }