public void AddPeople(ModAppEstablishment establishment) { var query = $"update Establishment set CurrentCapacity = {establishment.CurrentCapacity} where Id = {establishment.Id}"; using (SqlConnection connection = new SqlConnection(database)) { SqlCommand command = new SqlCommand(query, connection); command.Connection.Open(); var data = command.ExecuteReader(); } }
public void NewEstablishment(ModAppEstablishment establishment) { var query = $"INSERT INTO Establishment (Name, CurrentCapacity, MaximumCapacity, City) VALUES('{establishment.Name}', 0, {establishment.MaximumCapacity}, '{establishment.City}');"; using (SqlConnection connection = new SqlConnection(database)) { SqlCommand command = new SqlCommand(query, connection); command.Connection.Open(); command.ExecuteReader(); } }
public void AddPeople(ModAppEstablishment establishment) { establishment.AddPeople(); _establishmentRepository.AddPeople(establishment); }
public void NewEstablishment(ModAppEstablishment establishment) { _establishmentRepository.NewEstablishment(establishment); }
public void AddPeople([FromBody] ModAppEstablishment establishment) { establishmentService.AddPeople(establishment); }
public void NewEstablishment([FromBody] ModAppEstablishment establishment) { establishmentService.NewEstablishment(establishment); }