예제 #1
0
        public Entity.DeviceMaintenance Get(Guid id, DateTime currentDate, string timeZone)
        {
            List <Entity.DeviceMaintenance> result = new List <Entity.DeviceMaintenance>();

            Entity.DeviceMaintenance maintenanceDetail = new Entity.DeviceMaintenance();
            try
            {
                DateTime dateValue;
                if (DateTime.TryParse(currentDate.ToString(), out dateValue))
                {
                    dateValue = dateValue.AddMinutes(-double.Parse(timeZone));
                }
                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("guid", id, DbType.Guid, ParameterDirection.Input));
                    parameters.Add(sqlDataAccess.CreateParameter("currentDate", dateValue, DbType.DateTime, ParameterDirection.Input));
                    DbDataReader dbDataReader = sqlDataAccess.ExecuteReader(sqlDataAccess.CreateCommand("[DeviceMaintenance_Get]", CommandType.StoredProcedure, null), parameters.ToArray());
                    result = DataUtils.DataReaderToList <Entity.DeviceMaintenance>(dbDataReader, null);
                    if (result.Count > 0)
                    {
                        maintenanceDetail = result[0];
                    }
                }
                logger.InfoLog(Constants.ACTION_EXIT, "DeviceMaintenanceRepository.GetUpComingList");
            }
            catch (Exception ex)
            {
                logger.ErrorLog(Constants.ACTION_EXCEPTION, ex);
            }
            return(maintenanceDetail);
        }
예제 #2
0
 public Entity.DeviceMaintenance Get(Guid id, DateTime currentDate, string timeZone)
 {
     Entity.DeviceMaintenance maintenance = new Entity.DeviceMaintenance();
     try
     {
         maintenance = _deviceMaintenanceRepository.Get(id, currentDate, timeZone);
         return(maintenance);
     }
     catch (Exception ex)
     {
         _logger.Error(Constants.ACTION_EXCEPTION, "DeviceMaintenance.Get " + ex);
         return(null);
     }
 }
예제 #3
0
 public Entity.BaseResponse <Entity.DeviceMaintenance> Manage([FromBody] Entity.DeviceMaintenance request)
 {
     Entity.BaseResponse <Entity.DeviceMaintenance> response = new Entity.BaseResponse <Entity.DeviceMaintenance>(true);
     try
     {
         var status = _maintenanceService.Manage(request);
         response.IsSuccess = status.Success;
         response.Message   = status.Message;
         response.Data      = status.Data;
     }
     catch (Exception ex)
     {
         return(new Entity.BaseResponse <Entity.DeviceMaintenance>(false, ex.Message));
     }
     return(response);
 }
예제 #4
0
        public Entity.ActionStatus Manage(Entity.DeviceMaintenance request)
        {
            Entity.ActionStatus actionStatus = new Entity.ActionStatus(true);
            try
            {
                if (request.Guid == null || request.Guid == Guid.Empty)
                {
                    var dbDeviceMaintenance = Mapper.Configuration.Mapper.Map <Entity.DeviceMaintenance, Model.DeviceMaintenance>(request);
                    dbDeviceMaintenance.Guid        = request.Guid;
                    dbDeviceMaintenance.CompanyGuid = SolutionConfiguration.CompanyId;
                    DateTime dateValue;
                    if (DateTime.TryParse(request.StartDateTime.ToString(), out dateValue))
                    {
                        dbDeviceMaintenance.StartDateTime = dateValue.AddMinutes(-double.Parse(request.TimeZone));
                    }

                    if (DateTime.TryParse(request.EndDateTime.ToString(), out dateValue))
                    {
                        dbDeviceMaintenance.EndDateTime = dateValue.AddMinutes(-double.Parse(request.TimeZone));
                    }

                    actionStatus = _deviceMaintenanceRepository.Manage(dbDeviceMaintenance);
                    if (actionStatus.Data != null)
                    {
                        dbDeviceMaintenance.Guid = actionStatus.Data;
                        actionStatus.Data        = Mapper.Configuration.Mapper.Map <Model.DeviceMaintenance, Entity.DeviceMaintenance>(dbDeviceMaintenance); //Get(actionStatus.Data,DateTime.UtcNow,request.TimeZone);
                    }
                    if (!actionStatus.Success)
                    {
                        _logger.Error($"DeviceMaintenance is not added, Error: {actionStatus.Message}");
                        actionStatus.Success = false;
                        actionStatus.Message = actionStatus.Message;
                    }
                }
                else
                {
                    var olddbElevatorMaintenance = _deviceMaintenanceRepository.FindBy(x => x.Guid.Equals(request.Guid)).FirstOrDefault();
                    if (olddbElevatorMaintenance == null)
                    {
                        throw new NotFoundCustomException($"{CommonException.Name.NoRecordsFound} : DeviceMaintenance");
                    }
                    var dbElevatorMaintenance = Mapper.Configuration.Mapper.Map(request, olddbElevatorMaintenance);
                    dbElevatorMaintenance.CompanyGuid = SolutionConfiguration.CompanyId;
                    DateTime dateValue;
                    double   minutes = double.Parse(request.TimeZone);
                    if (DateTime.TryParse(request.StartDateTime.ToString(), out dateValue))
                    {
                        dbElevatorMaintenance.StartDateTime = dateValue.AddMinutes(-double.Parse(request.TimeZone));
                    }
                    if (DateTime.TryParse(request.EndDateTime.ToString(), out dateValue))
                    {
                        dbElevatorMaintenance.EndDateTime = dateValue.AddMinutes(-double.Parse(request.TimeZone));
                    }
                    actionStatus = _deviceMaintenanceRepository.Manage(dbElevatorMaintenance);
                    if (actionStatus.Data != null)
                    {
                        actionStatus.Data = Mapper.Configuration.Mapper.Map <Model.DeviceMaintenance, Entity.DeviceMaintenance>(dbElevatorMaintenance);
                    }
                    if (!actionStatus.Success)
                    {
                        _logger.Error($"DeviceMaintenance is not updated , Error: {actionStatus.Message}");
                        actionStatus.Success = false;
                        actionStatus.Message = actionStatus.Message;
                    }
                }
            }
            catch (Exception ex)
            {
                _logger.Error(Constants.ACTION_EXCEPTION, "DeviceMaintenanceManager.Delete " + ex);
                actionStatus.Success = false;
                actionStatus.Message = ex.Message;
            }
            return(actionStatus);
        }