public JsonResult EditHolidays(DateTime id, DateTime start, string htype, byte wday, string remarks, short insid) { string message = ""; try { HRP_HOLIDAY hrp_holiday = db.HRP_HOLIDAY.Find(id); if (hrp_holiday != null) { db.HRP_HOLIDAY.Remove(hrp_holiday); db.SaveChanges(); hrp_holiday.HOLDATE = start; hrp_holiday.HOLTYPE = htype; hrp_holiday.WORKDAY = wday; hrp_holiday.HOLREMARKS = remarks; hrp_holiday.INSERTDT = DateTime.Now; db.HRP_HOLIDAY.Add(hrp_holiday); db.SaveChanges(); } } catch (Exception ex) { message = "failed"; } return(new JsonResult { Data = message, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public JsonResult DeleteHolidays(DateTime id) { string message = ""; try { HRP_HOLIDAY hrp_holiday = db.HRP_HOLIDAY.Find(id); if (hrp_holiday != null) { db.HRP_HOLIDAY.Remove(hrp_holiday); db.SaveChanges(); } else { message = "failedyyyy"; } } catch (Exception ex) { message = "failed"; } return(new JsonResult { Data = message, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public JsonResult Create_Holiday(HRP_HOLIDAY holidyinfo) { string message = ""; try { if (ModelState.IsValid) { using (ProductionPlannerEntities dc = new ProductionPlannerEntities()) { if (holidyinfo != null) { dc.HRP_HOLIDAY.Add(holidyinfo); dc.SaveChanges(); } else { message = "failed"; } } } else { message = "failed"; } } catch (Exception ex) { message = "failed" + ex.ToString(); } return(new JsonResult { Data = message, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public ActionResult Create(DateTime hdate, string htype, byte wday, string remarks) { HRP_HOLIDAY hrp_holiday = new HRP_HOLIDAY(); hrp_holiday.HOLDATE = hdate; hrp_holiday.HOLTYPE = htype; hrp_holiday.WORKDAY = wday; hrp_holiday.HOLREMARKS = remarks; hrp_holiday.INSERTBY = 1; hrp_holiday.INSERTDT = DateTime.Now; try { if (ModelState.IsValid) { db.HRP_HOLIDAY.Add(hrp_holiday); db.SaveChanges(); return(RedirectToAction("Index")); } } catch (Exception ex) { TempData["msg"] = "<script>alert('error to save data !!');</script>"; } return(View("Index")); }
// POST: /Holiday/Delete/5 //[HttpPost, ActionName("Delete")] //[ValidateAntiForgeryToken] public ActionResult DeleteConfirmed(DateTime id) { HRP_HOLIDAY hrp_holiday = db.HRP_HOLIDAY.Find(id); db.HRP_HOLIDAY.Remove(hrp_holiday); db.SaveChanges(); TempData["msg"] = "<script>alert('Deleted Holiday Information Succesfully !!');</script>"; return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "HOLDATE,HOLTYPE,WDAYBEFOREHDAY,WDAYAFTERHDAY,WORKDAY,HOLREMARKS,INSERTBY,INSERTDT,UPDATEBY,UPDATEDT")] HRP_HOLIDAY hrp_holiday) { if (ModelState.IsValid) { db.Entry(hrp_holiday).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(hrp_holiday)); }
// GET: /Holiday/Delete/5 public ActionResult Delete(DateTime id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } HRP_HOLIDAY hrp_holiday = db.HRP_HOLIDAY.Find(id); if (hrp_holiday == null) { return(HttpNotFound()); } return(View(hrp_holiday)); }