public ActionResult DeleteForecast(long ID) { FC_EmployeeForecast users = new FC_EmployeeForecast(); users = (from u in db.FC_EmployeeForecast.ToList() where u.ID == ID select u).FirstOrDefault(); users.IsDeleted = true; users.UpdateDate = DateTime.Now; users.UpdateID = user.UserName; db.Entry(users).State = EntityState.Modified; db.SaveChanges(); return(Json(new { msg = "Success" }, JsonRequestBehavior.AllowGet)); }
public ActionResult EditForecastPos(FC_EmployeeForecast data) { try { FC_EmployeeForecast agency = new FC_EmployeeForecast(); agency = (from u in db.FC_EmployeeForecast.ToList() where u.ID == data.ID select u).FirstOrDefault(); agency.Position = data.Position; agency.ClassE = data.ClassE; agency.ClassJ = data.ClassJ; agency.Unit = data.Unit; agency.UpdateID = user.UserName; agency.UpdateDate = DateTime.Now;; FC_EmployeeForecast checker = (from c in db.FC_EmployeeForecast where c.Position == data.Position && c.ClassJ == data.ClassJ && c.ClassE == data.ClassE && c.Unit == data.Unit && c.IsDeleted == false select c).FirstOrDefault(); if (checker == null) { db.Entry(agency).State = EntityState.Modified; db.SaveChanges(); } else { return(Json(new { msg = "Failed" }, JsonRequestBehavior.AllowGet)); } } catch (Exception err) { Error_Logs error = new Error_Logs(); error.PageModule = "Master - Agency"; error.ErrorLog = err.Message; error.DateLog = db.TT_GETTIME().FirstOrDefault();//DateTime.Now;; error.Username = user.UserName; db.Error_Logs.Add(error); db.SaveChanges(); } return(Json(new { msg = "Success" }, JsonRequestBehavior.AllowGet)); }
public ActionResult CreateForecastPos(FC_EmployeeForecast data) { try { data.CreateID = user.UserName; data.CreateDate = DateTime.Now;; data.UpdateID = user.UserName; data.UpdateDate = DateTime.Now;; FC_EmployeeForecast checker = (from c in db.FC_EmployeeForecast where c.Position == data.Position && c.ClassJ == data.ClassJ && c.ClassE == data.ClassE && c.IsDeleted == false select c).FirstOrDefault(); if (checker == null) { db.FC_EmployeeForecast.Add(data); db.SaveChanges(); return(Json(new { msg = "Success" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { msg = "Failed" }, JsonRequestBehavior.AllowGet)); } } catch (Exception err) { Error_Logs error = new Error_Logs(); error.PageModule = "Master - Agency"; error.ErrorLog = err.Message; error.DateLog = db.TT_GETTIME().FirstOrDefault();//DateTime.Now;; error.Username = user.UserName; db.Error_Logs.Add(error); db.SaveChanges(); return(Json(new { msg = err.Message }, JsonRequestBehavior.AllowGet)); } }