public async Task <IActionResult> GetPaySlipInfo([FromRoute] long employeeID)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
PayslipVM obj = await _iAXInfoRepository.GetPaySlipInfo(employeeID);
if (obj == null)
{
return(BadRequest("Not Found PaySlip Data "));
}
return(Ok(obj));
}
public async Task <PayslipVM> GetPaySlipInfo(long pEmployeeID)
{
PayslipVM obj = new PayslipVM();
try
{
using (SqlConnection con = new SqlConnection(_configuration.GetConnectionString("DatabaseConnection")))
{
var paramater1 = new DynamicParameters();
paramater1.Add("@EmployeeID", pEmployeeID);
var reader = con.QueryMultiple("[ess].[LoadPaySlipInfo]", paramater1, commandType: CommandType.StoredProcedure);
obj.PayslipHeader = reader.Read <PayslipHeader>().ToList();
obj.PayslipIncome = reader.Read <PayslipIncome>().ToList();
obj.Payslipdeduction = reader.Read <Payslipdeduction>().ToList();
return(obj);
}
}
catch (Exception)
{
return(null);
}
}
