public ActionResult RequestCheckEdit(int?id, FormCollection collection)
{
var verifyItem = _context.LeaveHistories.Where(l => l.LeaveId == id).FirstOrDefault();
if (Request.HttpMethod == "POST")
{
var leaveHistory = new LMLeaveHistory()
{
LeaveId = Convert.ToInt32(collection.Get("LeaveId")),
EmpId = Convert.ToInt32(collection.Get("EmpId")),
ApplicationDate = Convert.ToDateTime(collection.Get("ApplicationDate")),
LeaveStartDate = Convert.ToDateTime(collection.Get("LeaveStartDate")),
LeaveEndDate = Convert.ToDateTime(collection.Get("LeaveEndDate")),
LeaveType = collection.Get("LeaveType"),
LeaveDesc = collection.Get("LeaveDesc"),
LeaveState = collection.Get("LeaveState"),
StateReason = collection.Get("StateReason")
};
//_context.LeaveHistories.AddOrUpdate(leaveHistory);
//context.SaveChanges();
_context.InsertLeave(leaveHistory);
//ntext.SaveChanges();
return(RedirectToAction("RequestCheck"));
}
return(View(verifyItem));
}
public int InsertLeave(LMLeaveHistory leave)
{
int result = -1;
try {
LeaveHistories.AddOrUpdate(leave);
result = this.SaveChanges();
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
if (result != -1)
{
result = 1;
}
return(result);
}
public ActionResult LeaveRequest(FormCollection collection)
{
ViewData["uname"] = User.Identity.Name;
if (Request.HttpMethod == "POST")
{
var leaveRequest = new LMLeaveHistory()
{
LeaveId = Convert.ToInt32(collection.Get("LeaveId")),
EmpId = Convert.ToInt32(collection.Get("EmpId")),
ApplicationDate = Convert.ToDateTime(collection.Get("ApplicationDate")),
LeaveStartDate = Convert.ToDateTime(collection.Get("LeaveStartDate")),
LeaveEndDate = Convert.ToDateTime(collection.Get("LeaveEndDate")),
LeaveType = collection.Get("LeaveType"),
LeaveDesc = collection.Get("LeaveDesc"),
LeaveState = collection.Get("LeaveState"),
StateReason = ""
};
//_context.LeaveHistories.Add(leaveRequest);
//var result = _context.SaveChanges();
var result = _context.InsertLeave(leaveRequest);
if (result == 1)
{
ViewData["action"] = "The request was transferred successfully.";
}
else
{
ViewData["action"] = "The is a problem, please contact the administrator.";
}
}
return(View());
}
