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)); }