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);
}
