public async Task <dynamic> postMaintenanceFlag([FromBody] MaintenanceDTO request) { var existingData = db.ServerFlags.Where(acs => acs.ServerFlag == "maintenance_mode").FirstOrDefault(); if (existingData != null) { existingData.Value = request.IsActive.ToString(); existingData.FromDt = request.FromDt; existingData.ToDt = request.ToDt; db.ServerFlags.Attach(existingData); db.Entry(existingData).State = EntityState.Modified; } else { var flag = new ServerFlags() { ServerFlag = "maintenance_mode", FromDt = request.FromDt, ToDt = request.ToDt, Value = request.IsActive.ToString() }; db.ServerFlags.Add(flag); } db.SaveChanges(); return(Ok("Maintenance Flag Added")); }
public MaintenanceDTO Read(int maintenanceID) { using var connection = Connection.GetConnection(); { connection.OpenAsync(); using var command = connection.CreateCommand(); command.CommandText = "SELECT * FROM `Maintenance` WHERE MaintenanceID = @maintenanceID"; command.Parameters.AddWithValue("@maintenanceID", maintenanceID); var reader = command.ExecuteReader(); if (!reader.Read()) { return(null); } var maintenanceobj = new MaintenanceDTO() { MaintenanceID = reader.GetInt32("MaintenanceID"), BusID = reader.GetInt32("BusID"), TimeRepaired = reader.GetDateTime("TimeRepaired"), RepairedBy = reader.GetInt32("RepairedBy"), Type = reader.GetInt32("Type"), Status = reader.GetInt32("Status") }; return(maintenanceobj); } }
public async void Post_CreateMaintenance_ShouldWork() { var expected = new MaintenanceDTO(); var createMaintenanceRequest = new CreateMaintenanceRequest() { Date = DateTime.Now, Service = "service" }; var mediatorMock = new Mock <IMediator>(); var logger = new Mock <ILogger <CarController> >(); mediatorMock.Setup(t => t.Send(It.IsAny <CreateMaintenanceCommand>(), It.IsAny <CancellationToken>())) .Returns(() => Task.FromResult(expected)); var controller = new CarController(mediatorMock.Object, logger.Object); ValidateModelState(createMaintenanceRequest, controller); var response = await controller.Post(Guid.NewGuid(), createMaintenanceRequest); var okResult = Assert.IsType <CreatedResult>(response); var maintenance = Assert.IsAssignableFrom <MaintenanceDTO>(okResult.Value); Assert.Equal(expected, maintenance); }
/// <summary> /// UPDATE /// </summary> /// <param name="maintenanceDto"></param> /// <returns></returns> public MaintenanceDTO UpdateMaintenance(MaintenanceDTO maintenanceDto) { Maintenance maintenance = _mapper.Map <Maintenance>(maintenanceDto); _dbContext.Entry(maintenance).State = EntityState.Modified; _dbContext.SaveChanges(); return(_mapper.Map <MaintenanceDTO>(maintenance)); }
/// <summary> /// CREATE MAINTENANCE /// </summary> public MaintenanceDTO CreateMaintenance(MaintenanceDTO maintenanceDto) { Maintenance maintenance = _mapper.Map <Maintenance>(maintenanceDto); maintenance.Id = new Guid(); _dbContext.Maintenances.Add(maintenance); _dbContext.SaveChanges(); return(_mapper.Map <MaintenanceDTO>(maintenance)); }
public void AddTramToCleaning(ConductorView Train) { if (Train.Cleaning == true) { CleaningDTO cleaning = new CleaningDTO() { TramNumber = Train.TramNumber, Annotation = "de tram licht vol met bierblikjes van carnaval." }; DataBase.AddCleaning(cleaning); } if (Train.Maintenance == true) { MaintenanceDTO maintenance = new MaintenanceDTO() { TramNumber = Train.TramNumber, Annotation = "de trams remmen maken een gek geluid" }; DataBase.AddService(maintenance); } }
public bool RemoveService(MaintenanceDTO maintenance) { try { _connect.Con.Open(); MySqlCommand cmd = _connect.Con.CreateCommand(); cmd.CommandText = "DELETE FROM service WHERE idTram = (SELECT idTram FROM Tram WHERE Number = @TramNumber)"; //TODO: require AuthKey cmd.Parameters.AddWithValue("@TramNumber", maintenance.TramNumber); cmd.ExecuteNonQuery(); } catch (Exception) { throw; } finally { _connect.Con.Close(); } return(true); }
private bool RemoveService(MaintenanceView maintenanceView) { try { var service = new MaintenanceDTO(); service.TramNumber = maintenanceView.TargetNumber; service.AuthKey = maintenanceView.Key; if (this.DatabaseMaintenance.RemoveService(service)) { return(true); } else { return(false); } } catch (Exception e) { Console.WriteLine(e); throw; } }
public List <MaintenanceDTO> GetServiceList() { List <MaintenanceDTO> maintenanceList = new List <MaintenanceDTO>(); try { _connect.Con.Open(); string query = "SELECT Tram.Number, service.Size, service.Priority, service.Description FROM service" + " INNER JOIN Tram ON Tram.idTram = service.idTram"; MySqlCommand cmd = new MySqlCommand(query, _connect.Con); var dataReader = cmd.ExecuteReader(); if (dataReader.HasRows) { while (dataReader.Read()) { MaintenanceDTO maintenance = new MaintenanceDTO { TramNumber = dataReader.GetInt32("Number"), Annotation = dataReader.GetString("Description"), Urgent = dataReader.GetBoolean("Priority") }; maintenanceList.Add(maintenance); } } dataReader.Close(); } catch (Exception) { throw; } finally { _connect.Con.Close(); } return(maintenanceList); }
public bool Create(MaintenanceDTO maintenanceDTO) { using var connection = Connection.GetConnection(); { try { using var command = connection.CreateCommand(); command.CommandText = "INSERT INTO Maintenance(BusID, RepairedBy, TimeRepaired, Type, Status) VALUES(@busID, @repairedBy, @timeRepaired, @type, @status);"; command.Parameters.AddWithValue("@busID", maintenanceDTO.BusID); command.Parameters.AddWithValue("@repairedBy", maintenanceDTO.RepairedBy); command.Parameters.AddWithValue("@timeRepaired", maintenanceDTO.TimeRepaired); command.Parameters.AddWithValue("@type", maintenanceDTO.Type); command.Parameters.AddWithValue("@status", maintenanceDTO.Status); connection.Open(); command.ExecuteNonQuery(); connection.Close(); return(true); } catch { connection.Close(); return(false); } } }
public bool AddService(MaintenanceDTO maintenance) { try { _connect.Con.Open(); MySqlCommand cmd = _connect.Con.CreateCommand(); cmd.CommandText = "INSERT INTO `service` (`idTram`, `Size`, `Priority`, `Description`) VALUES ((SELECT idTram FROM Tram WHERE Number = @TramNumber), @Size, @Priority, @Description)"; cmd.Parameters.AddWithValue("@TramNumber", maintenance.TramNumber); cmd.Parameters.AddWithValue("@Size", "1"); cmd.Parameters.AddWithValue("@Priority", maintenance.Urgent); cmd.Parameters.AddWithValue("@Description", maintenance.Annotation); cmd.ExecuteNonQuery(); } catch (Exception) { throw; } finally { _connect.Con.Close(); } return(true); }
public bool IndicateCompleteService(MaintenanceView maintenanceView) { try { MaintenanceDTO service = new MaintenanceDTO(); service.TramNumber = maintenanceView.TargetNumber; service.AuthKey = maintenanceView.Key; service.Annotation = maintenanceView.TargetAnnotation; if (this.DatabaseMaintenance.IndicateCompleteService(service)) { return(true); } else { return(false); } } catch (Exception e) { Console.WriteLine(e); throw; } }
public bool IndicateCompleteService(MaintenanceDTO maintenance) { try { _connect.Con.Open(); MySqlCommand cmd = _connect.Con.CreateCommand(); cmd.CommandText = "INSERT INTO `servicehistory` (`idTram`, `idUser`, `ServiceDate`, `Description`) VALUES ((SELECT idTram FROM Tram WHERE Number = @TramNumber), (SELECT idUser FROM authorisationlist WHERE UniqueKey = @AuthKey), @Date, @Annotation)"; cmd.Parameters.AddWithValue("@TramNumber", maintenance.TramNumber); cmd.Parameters.AddWithValue("@AuthKey", maintenance.AuthKey); cmd.Parameters.AddWithValue("@Annotation", maintenance.Annotation); cmd.Parameters.AddWithValue("@Date", DateTime.Now); cmd.ExecuteNonQuery(); } catch (Exception) { throw; } finally { _connect.Con.Close(); } RemoveService(maintenance); return(true); }
public void Update(MaintenanceDTO item) { //item.TimeStamps = DateTime.Now; _unitOfWork.EFRepository <Maintenance>().Update(_mapper.Map <Maintenance>(item)); }
public void Create(MaintenanceDTO item) { item.Id = Guid.NewGuid().ToString(); //item.TimeStamps = DateTime.Now; _unitOfWork.EFRepository <Maintenance>().CreateAsync(_mapper.Map <Maintenance>(item)); }
public MaintenanceDTO AddMaintenance(MaintenanceDTO maintenanceDto) { return(_manager.CreateMaintenance(maintenanceDto)); }
public MaintenanceDTO UpdateMaintenance(MaintenanceDTO maintenanceDto) { return(_manager.UpdateMaintenance(maintenanceDto)); }