public ActionResult DeleteApprover(int ID)
{
M_Approver approver = new M_Approver();
approver = (from u in db.M_Approver.ToList()
where u.ID == ID
select u).FirstOrDefault();
approver.IsDeleted = true;
approver.UpdateDate = DateTime.Now;
approver.UpdateID = user.UserName;
db.Entry(approver).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { msg = "Success" }, JsonRequestBehavior.AllowGet));
}
public ActionResult EditApprover(M_Approver data)
{
try
{
M_Approver approver = new M_Approver();
approver = (from u in db.M_Approver.ToList()
where u.ID == data.ID
select u).FirstOrDefault();
approver.BIPH_Agency = data.BIPH_Agency;
approver.EmployeeNo = data.EmployeeNo;
approver.Section = data.Section;
approver.Status = data.Status;
approver.UpdateID = "AdminUp";
approver.UpdateDate = DateTime.Now;
M_Approver checker = (from c in db.M_Approver
where c.BIPH_Agency == data.BIPH_Agency &&
c.EmployeeNo == data.EmployeeNo &&
c.Section == data.Section &&
c.Status == data.Status &&
c.IsDeleted == false
select c).FirstOrDefault();
if (checker == null)
{
db.Entry(approver).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 - Approver";
error.ErrorLog = err.Message;
error.DateLog = DateTime.Now;
error.Username = user.UserName;
db.Error_Logs.Add(error);
db.SaveChanges();
}
return(Json(new { msg = "Success" }, JsonRequestBehavior.AllowGet));
}
public ActionResult CreateApprover(M_Approver data)
{
try
{
data.CreateID = user.UserName;
data.CreateDate = DateTime.Now;
data.UpdateID = user.UserName;
data.UpdateDate = DateTime.Now;
M_Approver checker = (from c in db.M_Approver
where c.BIPH_Agency == data.BIPH_Agency &&
c.EmployeeNo == data.EmployeeNo &&
c.Status == data.Status &&
c.IsDeleted == false
select c).FirstOrDefault();
if (checker == null)
{
db.M_Approver.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 = "Masters - Approver";
error.ErrorLog = err.Message;
error.DateLog = DateTime.Now;
error.Username = user.UserName;
db.Error_Logs.Add(error);
db.SaveChanges();
return(Json(new { msg = err.Message }, JsonRequestBehavior.AllowGet));
}
}
