public List <Entity.ElevatorMaintenanceResponse> GetUpComingList(Entity.ElevatorMaintenanceRequest request)
{
List <Entity.ElevatorMaintenanceResponse> result = new List <Entity.ElevatorMaintenanceResponse>();
try
{
logger.InfoLog(Constants.ACTION_ENTRY, "ElevatorMaintenanceRepository.GetUpComingList");
using (var sqlDataAccess = new SqlDataAccess(ConnectionString))
{
List <DbParameter> parameters = sqlDataAccess.CreateParams(component.helper.SolutionConfiguration.CurrentUserId, "v1");
parameters.Add(sqlDataAccess.CreateParameter("companyguid", component.helper.SolutionConfiguration.CompanyId, DbType.Guid, ParameterDirection.Input));
if (request.BuildingGuid.HasValue)
{
parameters.Add(sqlDataAccess.CreateParameter("entityGuid", request.BuildingGuid, DbType.Guid, ParameterDirection.Input));
}
if (request.ElevatorGuid.HasValue)
{
parameters.Add(sqlDataAccess.CreateParameter("guid", request.ElevatorGuid, DbType.Guid, ParameterDirection.Input));
}
parameters.Add(sqlDataAccess.CreateParameter("count", DbType.Int32, ParameterDirection.Output, 16));
DbDataReader dbDataReader = sqlDataAccess.ExecuteReader(sqlDataAccess.CreateCommand("[ElevatorMaintenance_UpComingList]", CommandType.StoredProcedure, null), parameters.ToArray());
result = DataUtils.DataReaderToList <Entity.ElevatorMaintenanceResponse>(dbDataReader, null);
}
logger.InfoLog(Constants.ACTION_EXIT, "ElevatorMaintenanceRepository.GetUpComingList");
}
catch (Exception ex)
{
logger.ErrorLog(Constants.ACTION_EXCEPTION, ex);
}
return(result);
}
public List <Entity.ElevatorMaintenanceResponse> GetUpComingList(Entity.ElevatorMaintenanceRequest request)
{
try
{
return(_elevatorMaintenanceRepository.GetUpComingList(request));
}
catch (Exception ex)
{
_logger.Error(Constants.ACTION_EXCEPTION, $"ElevatorMaintenanceService.List, Error: {ex.Message}");
return(new List <Entity.ElevatorMaintenanceResponse>());
}
}
