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