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