public SeatsRow UpdateSeatsRow(SeatsRow sr)
{
var seats = from m in db.MIEJSCE
where m.FK_IdSali == sr.RoomId && m.Rzad == sr.RowNumber
orderby m.Miejsce1
select m;
List <MIEJSCE> backup = seats.ToList();
if (sr.SeatsCount == seats.Count())
{
return(sr);
}
else if (sr.SeatsCount < seats.Count())
{
for (int i = seats.Count() - 1; i > sr.SeatsCount - 1; i--)
{
db.MIEJSCE.Remove(seats.ToList().ElementAt(i));
}
}
else if (sr.SeatsCount > seats.Count())
{
for (int i = seats.Count() + 1; i <= sr.SeatsCount; i++)
{
db.MIEJSCE.Add(new MIEJSCE {
FK_IdSali = sr.RoomId, Miejsce1 = i, Rzad = sr.RowNumber
});
}
}
return(sr);
}
public RoomSeats GetRoomSeats(int roomId)
{
SALA room = db.SALA.Find(roomId);
RoomSeats roomSeats = new RoomSeats();
roomSeats.Room = room;
var seats = from m in db.MIEJSCE
where m.FK_IdSali == roomId
select m;
var query2 = from s in seats
orderby s.Rzad
select s.Rzad;
List <int> rowNumbers = query2.Distinct().ToList();
roomSeats.Rows = new List <SeatsRow>();
foreach (int n in rowNumbers)
{
SeatsRow row = new SeatsRow();
row.RowNumber = n;
row.Seats = seats.Where(s => s.Rzad == n).ToList();
row.SeatsCount = seats.Where(s => s.Rzad == n).Count();
roomSeats.Rows.Add(row);
}
roomSeats.RowsCount = roomSeats.Rows.Count();
roomSeats.SeatsCount = seats.Count();
return(roomSeats);
}
public RoomSeats GetRoomSeats(int roomId)
{
SALA room = db.SALA.Find(roomId);
RoomSeats roomSeats = new RoomSeats();
roomSeats.Room = room;
var seats = from m in db.MIEJSCE
where m.FK_IdSali == roomId
select m;
var query2 = from s in seats
orderby s.Rzad
select s.Rzad;
List<int> rowNumbers = query2.Distinct().ToList();
roomSeats.Rows = new List<SeatsRow>();
foreach (int n in rowNumbers)
{
SeatsRow row = new SeatsRow();
row.RowNumber = n;
row.Seats = seats.Where(s => s.Rzad == n).ToList();
row.SeatsCount = seats.Where(s => s.Rzad == n).Count();
roomSeats.Rows.Add(row);
}
roomSeats.RowsCount = roomSeats.Rows.Count();
roomSeats.SeatsCount = seats.Count();
return roomSeats;
}
public SeatsRow GetSeatsRow(int roomId, int rowNr)
{
RoomSeats rs = GetRoomSeats(roomId);
SeatsRow row = rs.Rows.FirstOrDefault(r => r.RowNumber == rowNr);
row.RoomId = roomId;
return(row);
}
public SeatsRow AddSeatsRow(SeatsRow sr)
{
for (int i = 1; i <= sr.SeatsCount; i++)
{
db.MIEJSCE.Add(new MIEJSCE {
FK_IdSali = sr.RoomId, Rzad = sr.RowNumber, Miejsce1 = i
});
}
return(sr);
}
public SeatsRow UpdateSeatsRow(SeatsRow sr)
{
var seats = from m in db.MIEJSCE
where m.FK_IdSali == sr.RoomId && m.Rzad == sr.RowNumber
orderby m.Miejsce1
select m;
List<MIEJSCE> backup = seats.ToList();
if (sr.SeatsCount == seats.Count())
{
return sr;
}
else if (sr.SeatsCount < seats.Count())
{
for (int i = seats.Count() - 1; i > sr.SeatsCount - 1; i--)
{
db.MIEJSCE.Remove(seats.ToList().ElementAt(i));
}
}
else if (sr.SeatsCount > seats.Count())
{
for (int i = seats.Count() + 1; i <= sr.SeatsCount; i++)
{
db.MIEJSCE.Add(new MIEJSCE { FK_IdSali = sr.RoomId, Miejsce1 = i, Rzad = sr.RowNumber });
}
}
return sr;
}
public SeatsRow AddSeatsRow(SeatsRow sr)
{
for (int i = 1; i <= sr.SeatsCount; i++)
{
db.MIEJSCE.Add(new MIEJSCE { FK_IdSali = sr.RoomId, Rzad = sr.RowNumber, Miejsce1 = i });
}
return sr;
}
public ActionResult CreateSeatsRow(SeatsRow model)
{
if(repository.SeatsRowExists(model.RoomId,model.RowNumber))
{
ModelState.AddModelError("RowNumber","Rząd o podanym numerze już istnieje");
}
if(ModelState.IsValid)
{
repository.AddSeatsRow(model);
repository.Save();
return RedirectToAction("RoomSeats",new { id = model.RoomId });
}
else
{
return View(model);
}
}
public ActionResult CreateSeatsRow(int roomId)
{
SeatsRow sr = new SeatsRow();
sr.RoomId = roomId;
return View(sr);
}
public ActionResult EditSeatsRow(SeatsRow model)
{
if(ModelState.IsValid)
{
repository.UpdateSeatsRow(model);
repository.Save();
return RedirectToAction("RoomSeats", new { id = model.RoomId });
}
else
{
return View(model);
}
}
