public ActionResult <CashbalVsAdvancedVM> GetEmpCashBalanceVsAdvanced(int id)
{
CashbalVsAdvancedVM cashbalVsAdvancedVM = new();
if (id == 0) // atominos admin doesnt have a wallet balance
{
cashbalVsAdvancedVM.CurCashBal = 0;
cashbalVsAdvancedVM.MaxCashAllowed = 0;
return(Ok(cashbalVsAdvancedVM));
}
//Check if employee cash balance is availabel in the EmpCurrentPettyCashBalance table, if NOT then ADD
if (!_context.EmpCurrentPettyCashBalances.Where(e => e.EmployeeId == id).Any())
{
var emp = _context.Employees.Find(id);
if (emp != null)
{
Double empPettyCashAmountEligible = _context.JobRoles.Find(_context.Employees.Find(id).RoleId).MaxPettyCashAllowed;
_context.EmpCurrentPettyCashBalances.Add(new EmpCurrentPettyCashBalance()
{
EmployeeId = id,
CurBalance = empPettyCashAmountEligible,
UpdatedOn = DateTime.Now
});
_context.SaveChanges();
}
var empCurPettyBal = _context.EmpCurrentPettyCashBalances.Where(e => e.EmployeeId == id).FirstOrDefault();
if (empCurPettyBal == null)
{
cashbalVsAdvancedVM.CurCashBal = 0;
}
else
{
cashbalVsAdvancedVM.CurCashBal = empCurPettyBal.CurBalance;
}
if (_context.Employees.Find(id).RoleId != 0)
{
cashbalVsAdvancedVM.MaxCashAllowed = _context.JobRoles.Find(_context.Employees.Find(id).RoleId).MaxPettyCashAllowed;
}
else
{
cashbalVsAdvancedVM.MaxCashAllowed = 0;
}
}
return(Ok(cashbalVsAdvancedVM));
}