public async Task <IActionResult> GetLoansInfo([FromRoute] long employeeID)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
LoanVm loanvms = await _iAXInfoRepository.GetLoansInfo(employeeID);
if (loanvms == null)
{
return(BadRequest("Not Found Loans Data "));
}
return(Ok(loanvms));
}
public async Task <LoanVm> GetLoansInfo(long pEmployeeID)
{
LoanVm obj = new LoanVm();
try
{
using (SqlConnection con = new SqlConnection(_configuration.GetConnectionString("DatabaseConnection")))
{
var paramater1 = new DynamicParameters();
paramater1.Add("@EmployeeID", pEmployeeID);
var reader = con.QueryMultiple("[ess].[LoadLoansInfo]", paramater1, commandType: CommandType.StoredProcedure);
obj.LoanSum = reader.Read <LoanSum>().FirstOrDefault();
obj.LoanHeader = reader.Read <LoanHeader>().ToList();
obj.LoanDetails = reader.Read <LoanDetails>().ToList();
return(obj);
}
}
catch (Exception)
{
return(null);
}
}
