public async Task <IActionResult> Create(int id, HRServiceStaff hrStaff)
{
if (ModelState.IsValid)
{
HRServiceStaff newCase = new HRServiceStaff
{
CaseID = id,
EmployeeName = hrStaff.EmployeeName,
RequestType = hrStaff.RequestType,
BasePayChange = hrStaff.BasePayChange,
AllowanceChange = hrStaff.AllowanceChange,
TerminationReason = hrStaff.TerminationReason,
Offboarding = hrStaff.Offboarding,
LeaveWA = hrStaff.LeaveWA,
ClosePosition = hrStaff.ClosePosition,
Amount = hrStaff.Amount,
WorkerType = hrStaff.WorkerType,
EffectiveStartDate = hrStaff.EffectiveStartDate,
EffectiveEndDate = hrStaff.EffectiveEndDate,
SupOrg = hrStaff.SupOrg,
EmployeeEID = hrStaff.EmployeeEID,
Note = hrStaff.Note,
BudgetNumbers = hrStaff.BudgetNumbers
};
_context.Add(newCase);
await _context.SaveChangesAsync();
var cid = id;
return(RedirectToAction("Details", "Cases", new { id = cid, area = "" }));
//return RedirectToAction("Index", "Home");
}
return(View(hrStaff));
}
public IActionResult Edit(int?id)
{
if (id == null)
{
return(NotFound());
}
HRServiceStaff editCase = _context.HRServiceStaff.Find(id);
if (editCase == null)
{
return(NotFound());
}
return(View(editCase));
}
public async Task <IActionResult> Edit(int id, [Bind("CaseID,EmployeeName,RequestType,BasePayChange,AllowanceChange,EffectiveStartDate,EffectiveEndDate,TerminationReason,Offboarding,Note,ClosePosition,LeaveWA,WorkerType,Amount,SupOrg,EmployeeEID,BudgetNumbers")] HRServiceStaff hrStaff)
{
if (id != hrStaff.CaseID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
IQueryable <HRServiceStaff> beforeCases = _context.HRServiceStaff.Where(c => c.CaseID == id).AsNoTracking <HRServiceStaff>();
HRServiceStaff beforeCase = beforeCases.FirstOrDefault();
if (beforeCase == null)
{
return(NotFound());
}
else
{
// Creating an audit log
var audit = new CaseAudit {
AuditLog = "Case Specific Details Edited", CaseID = id, LocalUserID = User.Identity.Name
};
_context.Add(audit);
await _context.SaveChangesAsync();
// Adding old details to tracking
var old_details = new HRServiceStaffTracking
{
Status = "old",
CaseAuditID = audit.CaseAuditID,
CaseID = beforeCase.CaseID,
EmployeeName = beforeCase.EmployeeName,
RequestType = beforeCase.RequestType,
BasePayChange = beforeCase.BasePayChange,
AllowanceChange = beforeCase.AllowanceChange,
TerminationReason = beforeCase.TerminationReason,
Offboarding = beforeCase.Offboarding,
LeaveWA = beforeCase.LeaveWA,
ClosePosition = beforeCase.ClosePosition,
Amount = beforeCase.Amount,
WorkerType = beforeCase.WorkerType,
EffectiveStartDate = beforeCase.EffectiveStartDate,
EffectiveEndDate = beforeCase.EffectiveEndDate,
SupOrg = beforeCase.SupOrg,
EmployeeEID = beforeCase.EmployeeEID,
Note = beforeCase.Note,
BudgetNumbers = beforeCase.BudgetNumbers
};
_context.Add(old_details);
// Adding current details to tracking
var new_details = new HRServiceStaffTracking
{
Status = "new",
CaseAuditID = audit.CaseAuditID,
CaseID = hrStaff.CaseID,
EmployeeName = hrStaff.EmployeeName,
RequestType = hrStaff.RequestType,
BasePayChange = hrStaff.BasePayChange,
AllowanceChange = hrStaff.AllowanceChange,
TerminationReason = hrStaff.TerminationReason,
Offboarding = hrStaff.Offboarding,
LeaveWA = hrStaff.LeaveWA,
ClosePosition = hrStaff.ClosePosition,
Amount = hrStaff.Amount,
WorkerType = hrStaff.WorkerType,
EffectiveStartDate = hrStaff.EffectiveStartDate,
EffectiveEndDate = hrStaff.EffectiveEndDate,
SupOrg = hrStaff.SupOrg,
EmployeeEID = hrStaff.EmployeeEID,
Note = hrStaff.Note,
BudgetNumbers = hrStaff.BudgetNumbers
};
_context.Add(new_details);
// Adding current details to actual Case Type entity
_context.Update(hrStaff);
await _context.SaveChangesAsync();
}
}
catch (DbUpdateConcurrencyException)
{
if (!HRServiceStaffExists(hrStaff.CaseID))
{
return(NotFound());
}
else
{
throw;
}
}
var cid = id;
return(RedirectToAction("Details", "Cases", new { id = cid, area = "" }));
}
return(View(hrStaff));
}
public async Task <IActionResult> Edit(int id, [Bind("CaseID,EmployeeName,RequestType,BasePayChange,AllowanceChange,EffectiveStartDate,EffectiveEndDate,TerminationReason,Offboarding,Note,ClosePosition,LeaveWA,WorkerType,Amount,SupOrg,EmployeeEID,BudgetNumbers")] HRServiceStaff hrStaff)
{
/** First check important fields to see if values have changed and if so add to audit log **/
string strAudit = "Case Edited. Values updated (old,new). ";
IQueryable <HRServiceStaff> beforeCases = _context.HRServiceStaff.Where(c => c.CaseID == id).AsNoTracking <HRServiceStaff>();
HRServiceStaff beforeCase = beforeCases.FirstOrDefault();
if (beforeCase == null)
{
return(NotFound());
}
if (ModelState.IsValid)
{
string bcRequest = beforeCase.RequestType.ToString();
string currRequest = hrStaff.RequestType.ToString();
string bcBase = beforeCase.BasePayChange.ToString();
string currBase = hrStaff.BasePayChange.ToString();
string bcAllow = beforeCase.AllowanceChange.ToString();
string currAllow = hrStaff.AllowanceChange.ToString();
string bcTerm = beforeCase.TerminationReason.ToString();
string currTerm = hrStaff.TerminationReason.ToString();
string bcOff = beforeCase.Offboarding.ToString();
string bcLeave = beforeCase.LeaveWA.ToString();
string bcClose = beforeCase.ClosePosition.ToString();
string currOff = hrStaff.Offboarding.ToString();
string currLeave = hrStaff.LeaveWA.ToString();
string currClose = hrStaff.ClosePosition.ToString();
string currAmount = "";
if (!String.IsNullOrEmpty(hrStaff.Amount))
{
currAmount = hrStaff.Amount;
}
string bcAmount = "";
if (!String.IsNullOrEmpty(beforeCase.Amount))
{
bcAmount = beforeCase.Amount;
}
if (bcRequest != currRequest)
{
if (currRequest != "Termination")
{
hrStaff.TerminationReason = null;
hrStaff.Offboarding = false;
hrStaff.LeaveWA = false;
hrStaff.ClosePosition = false;
currTerm = null;
currOff = "False";
currLeave = "False";
currClose = "False";
}
if (currRequest != "Allowance")
{
hrStaff.AllowanceChange = null;
currAllow = "";
}
if (currRequest != "Base")
{
hrStaff.BasePayChange = null;
currBase = "";
hrStaff.Amount = "";
currAmount = "";
}
}
if (beforeCase.EmployeeName != hrStaff.EmployeeName)
{
strAudit += "Employee: (" + beforeCase.EmployeeName + "," + hrStaff.EmployeeName + ") ";
}
if (beforeCase.WorkerType.ToString() != hrStaff.WorkerType.ToString())
{
strAudit += "WorkerType: (" + beforeCase.WorkerType.ToString() + "," + hrStaff.WorkerType.ToString() + ") ";
}
if (beforeCase.RequestType.ToString() != hrStaff.RequestType.ToString())
{
strAudit += "RequestType: (" + beforeCase.RequestType.ToString() + "," + hrStaff.RequestType.ToString() + ") ";
}
if (bcBase != currBase)
{
strAudit += "BasePayChange: (" + bcBase + "," + currBase + ") ";
}
if (bcAmount != currAmount)
{
strAudit += "Amount: (" + bcAmount + "," + currAmount + ") ";
}
if (bcAllow != currAllow)
{
strAudit += "AllowanceChange: (" + bcAllow + "," + currAllow + ") ";
}
if (bcTerm != currTerm)
{
strAudit += "TerminationReason: (" + bcTerm + "," + currTerm + ") ";
}
if (bcOff != currOff)
{
strAudit += "Offboarding: (" + bcOff + "," + currOff + ") ";
}
if (bcLeave != currLeave)
{
strAudit += "LeaveWA: (" + bcLeave + "," + currLeave + ") ";
}
if (bcClose != currClose)
{
strAudit += "ClosePosition: (" + bcClose + "," + currClose + ") ";
}
if (beforeCase.EffectiveStartDate.ToShortDateString() != hrStaff.EffectiveStartDate.ToShortDateString())
{
strAudit += "StartDate: (" + beforeCase.EffectiveStartDate.ToShortDateString() + "," + hrStaff.EffectiveStartDate.ToShortDateString() + "),";
}
DateTime beforeEffectDate = beforeCase.EffectiveEndDate.GetValueOrDefault();
DateTime curEffectDate = hrStaff.EffectiveEndDate.GetValueOrDefault();
if (beforeEffectDate.ToShortDateString() != curEffectDate.ToShortDateString())
{
strAudit += "EndDate: (" + beforeEffectDate.ToShortDateString() + "," + curEffectDate.ToShortDateString() + ") ";
}
if (beforeCase.SupOrg.ToString() != hrStaff.SupOrg.ToString())
{
strAudit += "SupOrg: (" + beforeCase.SupOrg.ToString() + "," + hrStaff.SupOrg.ToString() + ") ";
}
if (beforeCase.EmployeeEID.ToString() != hrStaff.EmployeeEID.ToString())
{
strAudit += "EmployeeEID: (" + beforeCase.EmployeeEID.ToString() + "," + hrStaff.EmployeeEID.ToString() + ") ";
}
if (!String.IsNullOrEmpty(beforeCase.BudgetNumbers) && !String.IsNullOrEmpty(hrStaff.BudgetNumbers))
{
if (beforeCase.BudgetNumbers.ToString() != hrStaff.BudgetNumbers.ToString())
{
strAudit += "Budgets: (" + beforeCase.BudgetNumbers.ToString() + "," + hrStaff.BudgetNumbers.ToString() + ") ";
}
}
var audit = new CaseAudit {
AuditLog = strAudit, CaseID = id, LocalUserID = User.Identity.Name
};
_context.Add(audit);
_context.Entry(hrStaff).State = EntityState.Modified;
await _context.SaveChangesAsync();
var cid = id;
return(RedirectToAction("Details", "Cases", new { id = cid, area = "" }));
//return RedirectToAction("Index", "Home");
}
return(View(hrStaff));
}
