public List <Entity.DeviceMaintenanceResponse> GetUpComingList(Entity.DeviceMaintenanceRequest request)
{
List <Entity.DeviceMaintenanceResponse> result = new List <Entity.DeviceMaintenanceResponse>();
try
{
logger.InfoLog(Constants.ACTION_ENTRY, "DeviceMaintenanceRepository.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.EntityGuid.HasValue)
{
parameters.Add(sqlDataAccess.CreateParameter("entityGuid", request.EntityGuid.Value, DbType.Guid, ParameterDirection.Input));
}
if (request.DeviceGuid.HasValue)
{
parameters.Add(sqlDataAccess.CreateParameter("guid", request.DeviceGuid, DbType.Guid, ParameterDirection.Input));
}
parameters.Add(sqlDataAccess.CreateParameter("currentDate", request.currentDate, DbType.DateTime, ParameterDirection.Input));
parameters.Add(sqlDataAccess.CreateParameter("count", DbType.Int32, ParameterDirection.Output, 16));
DbDataReader dbDataReader = sqlDataAccess.ExecuteReader(sqlDataAccess.CreateCommand("[DeviceMaintenance_UpComingList]", CommandType.StoredProcedure, null), parameters.ToArray());
result = DataUtils.DataReaderToList <Entity.DeviceMaintenanceResponse>(dbDataReader, null);
}
logger.InfoLog(Constants.ACTION_EXIT, "DeviceMaintenanceRepository.GetUpComingList");
}
catch (Exception ex)
{
logger.ErrorLog(Constants.ACTION_EXCEPTION, ex);
}
return(result);
}
public List <Entity.DeviceMaintenanceResponse> GetUpComingList(Entity.DeviceMaintenanceRequest request)
{
try
{
if (request.currentDate.HasValue)
{
DateTime dateValue;
if (DateTime.TryParse(request.currentDate.Value.ToString(), out dateValue))
{
dateValue = dateValue.AddMinutes(-double.Parse(request.timeZone));
}
request.currentDate = dateValue;
}
return(_deviceMaintenanceRepository.GetUpComingList(request));
}
catch (Exception ex)
{
_logger.Error(Constants.ACTION_EXCEPTION, $"DeviceMaintenanceService.List, Error: {ex.Message}");
return(new List <Entity.DeviceMaintenanceResponse>());
}
}
public Entity.BaseResponse <Entity.DeviceSceduledMaintenanceResponse> GetDeviceScheduledMaintenance(Entity.DeviceMaintenanceRequest request)
{
Entity.BaseResponse <List <Entity.DeviceSceduledMaintenanceResponse> > result = new Entity.BaseResponse <List <Entity.DeviceSceduledMaintenanceResponse> >();
var deviceDetail = new Entity.BaseResponse <Entity.DeviceSceduledMaintenanceResponse>();
try
{
logger.InfoLog(Constants.ACTION_ENTRY, "DeviceMaintenanceRepository.GetDeviceScheduledMaintenence");
using (var sqlDataAccess = new SqlDataAccess(ConnectionString))
{
DateTime dateValue;
if (DateTime.TryParse(request.currentDate.ToString(), out dateValue))
{
dateValue = dateValue.AddMinutes(-double.Parse(request.timeZone));
}
List <DbParameter> parameters = sqlDataAccess.CreateParams(component.helper.SolutionConfiguration.CurrentUserId, "v1");
if (request.DeviceGuid.HasValue && !request.DeviceGuid.Value.Equals(Guid.Empty))
{
parameters.Add(sqlDataAccess.CreateParameter("guid", request.DeviceGuid.Value, DbType.Guid, ParameterDirection.Input));
}
if (request.EntityGuid.HasValue && !request.EntityGuid.Value.Equals(Guid.Empty))
{
parameters.Add(sqlDataAccess.CreateParameter("entityGuid", request.EntityGuid.Value, DbType.Guid, ParameterDirection.Input));
}
parameters.Add(sqlDataAccess.CreateParameter("currentDate", dateValue, DbType.DateTime, ParameterDirection.Input));
parameters.Add(sqlDataAccess.CreateParameter("culture", component.helper.SolutionConfiguration.Culture, DbType.String, ParameterDirection.Input));
parameters.Add(sqlDataAccess.CreateParameter("enableDebugInfo", component.helper.SolutionConfiguration.EnableDebugInfo, DbType.String, ParameterDirection.Input));
parameters.Add(sqlDataAccess.CreateParameter("syncDate", DateTime.UtcNow, DbType.DateTime, ParameterDirection.Output));
DbDataReader dbDataReader = sqlDataAccess.ExecuteReader(sqlDataAccess.CreateCommand("[DeviceStatistics_Get]", CommandType.StoredProcedure, null), parameters.ToArray());
result.Data = DataUtils.DataReaderToList <Entity.DeviceSceduledMaintenanceResponse>(dbDataReader, null);
if (parameters.Where(p => p.ParameterName.Equals("syncDate")).FirstOrDefault() != null)
{
result.LastSyncDate = Convert.ToString(parameters.Where(p => p.ParameterName.Equals("syncDate")).FirstOrDefault().Value);
}
Entity.DeviceSceduledMaintenanceResponse obj = new Entity.DeviceSceduledMaintenanceResponse();
obj.UniqueId = "";
obj.Day = "0";
obj.Hour = "0";
obj.Minute = "0";
if (result.Data != null && result.Data.Count > 0)
{
var data = result.Data[0];
if (data.startDateTime != DateTime.MinValue)
{
dateValue = data.startDateTime; //.AddMinutes(-double.Parse(request.timeZone));// TimeZoneInfo.ConvertTimeBySystemTimeZoneId(data.startDateTime, "UTC", request.timeZone);
TimeSpan span = (dateValue - DateTime.UtcNow); // request.currentDate.Value);
obj.Day = Convert.ToString(span.Days);
obj.Hour = Convert.ToString(span.Hours);
obj.Minute = Convert.ToString(span.Minutes);
obj.UniqueId = data.UniqueId;
}
}
obj.startDateTime = dateValue;
deviceDetail.Data = obj;
deviceDetail.LastSyncDate = result.LastSyncDate;
deviceDetail.IsSuccess = true;
}
logger.InfoLog(Constants.ACTION_EXIT, "DeviceMaintenanceRepository.GetDeviceScheduledMaintenence");
}
catch (Exception ex)
{
logger.ErrorLog(Constants.ACTION_EXCEPTION, ex);
}
return(deviceDetail);
}
public Entity.BaseResponse <Entity.DeviceSceduledMaintenanceResponse> GetDeviceScheduledMaintenance(Entity.DeviceMaintenanceRequest request)
{
try
{
return(_deviceMaintenanceRepository.GetDeviceScheduledMaintenance(request));
}
catch (Exception ex)
{
_logger.Error(Constants.ACTION_EXCEPTION, $"DeviceMaintenanceService.Get, Error: {ex.Message}");
return(new Entity.BaseResponse <Entity.DeviceSceduledMaintenanceResponse>());
}
}