/// <summary>
/// Gets RowSeat by id
/// </summary>
/// <param name="id">id of the RowSeat</param>
/// <returns>RowSeat object</returns>
public RowSeat Get(int id)
{
RowSeat rowSeat = null;
using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["SqlServerConnString"].ConnectionString))
{
db.Open();
rowSeat = db.Query <RowSeat>("SELECT * FROM RowSeat " +
"WHERE Id = @id", new { id }).SingleOrDefault();
}
return(rowSeat);
}
public ActionResult Create(CinemaViewModel model)
{
var cinema = new Cinema();
if (model == null)
{
return(View());
}
if (ModelState.IsValid)
{
cinema.CinemaName = model.CinemaName;
cinema.CinemaAddress = model.CinemaAddress;
cinema.CinemaManager = model.CinemaManager;
cinema.CinemaPhone = model.CinemaPhone;
cinema.CinemaSeatCapacity = model.CinemaSeatCapacity;
_context.Cinemas.Add(cinema);
_context.Entry(cinema).State = EntityState.Added;
_context.SaveChanges();
ModelState.Clear();
}
var result = new RowSeat();
var rows = model.CinemaSeatCapacity / 10;
var cinemaId = _context.Cinemas.FirstOrDefault(x => x.CinemaName.Equals(model.CinemaName)).Id;
for (var i = 0; i < rows; i++)
{
result.RowNumber = i + 1;
result.CinemaId = cinemaId;
for (var j = 0; j < 10; j++)
{
result.SeatNumber = j + 1;
_context.RowSeats.Add(result);
_context.Entry(result).State = EntityState.Added;
_context.SaveChanges();
}
}
return(View());
}
