public void Add(string caption, string address, int?cinemaNetworkId, string city, string description, string email, string phoneNumber)
{
CinemaNetworkEntity network = this.unitOfWork.CinemaNetworkRepository.GetById(cinemaNetworkId ?? 1);
if (network == null)
{
network = new CinemaNetworkEntity()
{
Id = 1, WebSite = "Vizoria.ua"
};
this.unitOfWork.CinemaNetworkRepository.Add(network);
this.unitOfWork.SaveChanges();
}
CinemaEntity cinema = new CinemaEntity()
{
CinemaNetworkId = network?.Id,
Address = address,
Caption = caption,
Description = description,
City = CityConverter.ConvertStringToEnum(city),
Email = email,
PhoneNumber = phoneNumber
};
this.unitOfWork.CinemaRepository.Add(cinema);
this.unitOfWork.SaveChanges();
}
public City GetCity(int id)
{
IList <DbParameter> parameters = new List <DbParameter>()
{
new MySqlParameter("@id", id)
};
DataRow row = _dbContext.GetDataRow(Tables.Cities.Select, parameters);
return(CityConverter.RowToCity(row));
}
public void Update(int id, string caption, string address, int?cinemaNetworkId, string city, string description, string email, string phoneNumber)
{
CinemaEntity cinema = this.unitOfWork.CinemaRepository.GetById(id);
CinemaNetworkEntity network = this.unitOfWork.CinemaNetworkRepository.GetById(cinemaNetworkId ?? 0);
cinema.CinemaNetworkId = network.Id;
cinema.Address = address;
cinema.Caption = caption;
cinema.Description = description;
cinema.City = CityConverter.ConvertStringToEnum(city);
cinema.Email = email;
cinema.PhoneNumber = phoneNumber;
this.unitOfWork.CinemaRepository.Update(cinema);
this.unitOfWork.SaveChanges();
}
public List <City> GetCitiesByCountry(int id)
{
IList <DbParameter> parameters = new List <DbParameter>()
{
new MySqlParameter("@id", id),
};
string sql = $"SELECT {Tables.Cities.TableName}.*" +
$" FROM {Tables.Cities.TableName}" +
$" WHERE {Tables.Cities.CountryId.Name}=@id";
DataTable table = _dbContext.GetDataTable(sql, parameters);
if (table != null)
{
return(CityConverter.TableToCities(table));
}
return(new List <City>());
}
