public ActionResult UpdateLeaveHistoryType(EmployeeLeaveHistory LeaveHistoryIformation)
{
try
{
var leaveHistory = db.EmployeeLeaveHistories.Where(s => s.EmployeeLeaveHistoryID == LeaveHistoryIformation.EmployeeLeaveHistoryID);
LeaveHistoryIformation.Status = AppUtils.TableStatusIsActive;
db.Entry(leaveHistory.SingleOrDefault()).CurrentValues.SetValues(LeaveHistoryIformation);
db.SaveChanges();
var LeaveHistory =
new EmployeeLeaveViewModel()
{
ID = LeaveHistoryIformation.EmployeeLeaveHistoryID,
Reason = LeaveHistoryIformation.Reason,
LeaveTypeName = db.LeaveSallaryTypes.Find(LeaveHistoryIformation.LeaveType).LeaveTypeName,
StartDate = LeaveHistoryIformation.StartDate,
EndDate = LeaveHistoryIformation.EndDate,
LoginName = db.Employee.Find(LeaveHistoryIformation.EmployeeID).LoginName,
};
var JSON = Json(new { UpdateSuccess = true, EMPLH = LeaveHistory }, JsonRequestBehavior.AllowGet);
JSON.MaxJsonLength = int.MaxValue;
return(JSON);
}
catch
{
return(Json(new { UpdateSuccess = false, EMPLH = "" }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult InsertEmployeLeaveHistory(EmployeeLeaveHistory LeaveStory)
{
int leaveHistories = db.EmployeeLeaveHistories.Count();
try
{
LeaveStory.Status = AppUtils.TableStatusIsActive;
db.EmployeeLeaveHistories.Add(LeaveStory);
db.SaveChanges();
EmployeeLeaveViewModel LeaveHistoryInfo = new EmployeeLeaveViewModel
{
ID = LeaveStory.EmployeeLeaveHistoryID,
LoginName = db.Employee.Find(LeaveStory.EmployeeID).LoginName,
Reason = LeaveStory.Reason,
StartDate = LeaveStory.EndDate,
EndDate = LeaveStory.EndDate,
LeaveTypeName = db.LeaveSallaryTypes.Find(LeaveStory.LeaveType).LeaveTypeName,
};
return(Json(new { SuccessInsert = true, LeaveHistoryInfo = LeaveHistoryInfo, leaveHistories = leaveHistories }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { SuccessInsert = false }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult DelecteLeaveHistory(int id)
{
EmployeeLeaveHistory leaveHistory = new EmployeeLeaveHistory();
leaveHistory = db.EmployeeLeaveHistories.Find(id);
leaveHistory.EmployeeID = leaveHistory.EmployeeID;
leaveHistory.Reason = leaveHistory.Reason;
leaveHistory.StartDate = leaveHistory.EndDate;
leaveHistory.LeaveType = leaveHistory.LeaveType;
leaveHistory.Status = AppUtils.TableStatusIsDelete;
db.Entry(leaveHistory).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { leaveHistoryID = leaveHistory.EmployeeLeaveHistoryID, success = true }, JsonRequestBehavior.AllowGet));
}
