public async Task <AttendeesVM> GetAttendeesInfo(long pEmployeeID, string pFromDate, string pToDate)
{
AttendeesVM obj = new AttendeesVM();
try
{
using (SqlConnection con = new SqlConnection(_configuration.GetConnectionString("DatabaseConnection")))
{
var paramater = new DynamicParameters();
paramater.Add("@EmployeeID", pEmployeeID);
paramater.Add("@FromDate", pFromDate);
paramater.Add("@ToDate", pToDate);
var reader = con.QueryMultiple("[ess].[LoadAttendeesInfo]", paramater, commandType: CommandType.StoredProcedure);
obj.AttendeesToDay = reader.Read <Attendees>().ToList();
obj.AttendeesList = reader.Read <Attendees>().ToList();
return(obj);
}
}
catch (Exception)
{
return(null);
}
}
public async Task <IActionResult> GetAttendeesInfo([FromBody] CommonVM commonVM)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
AttendeesVM obj = await _iAXInfoRepository.GetAttendeesInfo(commonVM.employeeID, commonVM.fromDate, commonVM.toDate);
if (obj == null)
{
return(BadRequest("Not Found Attendees Data "));
}
return(Ok(obj));
}
