public void Setup() { var provider = Substitute.For <IUserNameProvider>(); var optionBuilder = new DbContextOptionsBuilder <AppDbContext>(); optionBuilder.UseInMemoryDatabase(Guid.NewGuid().ToString()); _context = new AppDbContext(optionBuilder.Options, provider); _context.Database.EnsureDeleted(); _context.Database.EnsureCreated(); using (var context = new AppDbContext(optionBuilder.Options, provider)) { var date1 = new Availability { Id = Id, Active = true, PricePerNightForAdult = 0, PricePerNightForChild = 0, PricePerPerson = false, RoomsAvailable = 1, RoomId = roomId, From = DateTime.Now, To = DateTime.Now.AddDays(5) }; var date2 = new Availability { Active = true, PricePerNightForAdult = 0, PricePerNightForChild = 0, RoomId = roomId, PricePerPerson = false, RoomsAvailable = 1, From = DateTime.Now.AddDays(4), To = DateTime.Now.AddDays(15) }; context.Availabilities.AddRange(new List <Availability>() { date1, date2 }); context.SaveChanges(); var room = new Domain.Room { Id = roomId, PropertyId = propertyId }; context.Rooms.Add(room); context.SaveChanges(); }; uow = Substitute.For <AppUnitOfWork>(_context); _service = new AvailabilityService(uow); }
/// <summary> /// Adds the features to room. /// </summary> /// <param name="room">The room.</param> private void AddFeaturesToRoom(Room room) { foreach (DataGridViewRow row in this.Form.FeaturesDataGridView.Rows) { var cell = row.Cells[IsAddedColumnName] as DataGridViewCheckBoxCell; var featureId = (int)row.Cells[IdColumnName].Value; Feature feature = DataAccess.Instance.Features.Single(f => f.Id == featureId); if (Convert.ToBoolean(cell.Value) == true) { room.Features.Add(feature); } else { room.Features.Remove(feature); } } }
public async Task <Unit> Handle(Command request, CancellationToken cancellationToken) { Domain.Room newRoom = new Domain.Room { Title = request.Title, Id = request.Id, CreatedAt = DateTime.Now, About = request.About, Username = request.Username }; _context.Rooms.Add(newRoom); var success = await _context.SaveChangesAsync() > 0; if (success) { return(Unit.Value); } throw new Exception("Problem saving room"); }
/// <summary> /// Insert Room to the database /// </summary> /// <param name="room">The Room to be inserted</param> public void insertRoom(Room room) { string sql; sql = "INSERT INTO Room (Number, Capacity, RoomType, SlotsOff, Deleted) VALUES("; sql += "'"+room.roomNumber+"', "; sql += room.capacity + ", "; sql += "'" + room.roomType + "', "; sql += "'" + room.slotsOff + "', false "; excuteNonQuery(sql); }
/// <summary> /// Update a Room in the database /// </summary> /// <param name="room">The updated Room</param> public void updateRoom(Room room) { string sql; sql = "UPDATE Room"; sql += "Number='" + room.roomNumber + "', "; sql += "BuildingID='" + room.buildingId + "', "; sql += "Capacity=" + room.capacity + ", "; sql += "RoomType='" + room.roomType + "', "; sql += "SlotsOff='" + room.slotsOff + "', "; sql += "WHERE ID LIKE " + room.ID; excuteNonQuery(sql); }
public void addRoom(Room theRoom) { dataBaseHelper.insertRoom(theRoom); dataBaseHelper.update(); }
/// <summary> /// Update a Room in the database /// </summary> /// <param name="room">The updated Room</param> private void updateRoom(Room room) { string sql; sql = "UPDATE Room"; sql += "Number='" + room.getRoomNumber() + "', "; sql += "Capacity=" + room.getCapacity() + ", "; sql += "RoomType='" + room.getRoomType() + "', "; sql += "SlotsOff='" + room.getSlotsOff() + "', "; sql += "WHERE ID LIKE " + room.getID(); excuteNonQuery(sql); }
/// <summary> /// Insert Room to the database /// </summary> /// <param name="room">The Room to be inserted</param> private void insertRoom(Room room) { string sql; sql = "INSERT INTO Room (Number, Capacity, RoomType, SlotsOff, Deleted) VALUES("; sql += "'"+room.getRoomNumber()+"', "; sql += room.getCapacity() + ", "; sql += "'" + room.getRoomType() + "', "; sql += "'" + room.getSlotsOff() + "', false "; excuteNonQuery(sql); }
/// <summary> /// The constructor of Lesson object with a set of properties. /// </summary> /// <param name="lecturer">The name of the Lecturer</param> /// <param name="module">The name of the Module</param> /// <param name="room">The name/number of the Room</param> public Lesson(Lecturer lecturer, Module module, Room room) { setLecturer(lecturer); setModule(module); setRoom(room); }
/// <summary> /// Check is a room part on the roomList for this Building /// </summary> /// <param name="room">Room object to search for in the list</param> /// <returns>Wether or not the room is on the lisr</returns> public bool isPartOf(Room room) { return roomList.searchList(room); }
/// <summary> /// The constructor of Lesson object with a set of properties. /// </summary> /// <param name="lecturer">The name of the Lecturer</param> /// <param name="module">The name of the Module</param> /// <param name="room">The name/number of the Room</param> public Lesson(Lecturer lecturer, Module module, Room room) { this.lecturer = lecturer; this.module = module; this.room = room; }
/// <summary> /// Deprecated Method for adding a new object to the Rooms EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToRooms(Room room) { base.AddObject("Rooms", room); }
/// <summary> /// Create a new Room object. /// </summary> /// <param name="number">Initial value of the Number property.</param> /// <param name="typeId">Initial value of the TypeId property.</param> /// <param name="capacity">Initial value of the Capacity property.</param> /// <param name="floor">Initial value of the Floor property.</param> /// <param name="vacancy">Initial value of the Vacancy property.</param> public static Room CreateRoom(global::System.Int32 number, global::System.Int32 typeId, global::System.Int32 capacity, global::System.Int32 floor, global::System.Boolean vacancy) { Room room = new Room(); room.Number = number; room.TypeId = typeId; room.Capacity = capacity; room.Floor = floor; room.Vacancy = vacancy; return room; }
/// <summary> /// Handles the Click event of the OkButton control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs" /> instance containing the event data.</param> private void OkButton_Click(object sender, EventArgs e) { int roomNumber = 0; int roomFloor = 0; int roomCapacity = 0; int roomType = 0; int.TryParse(this.Form.NumberTextBox.Text, out roomNumber); int.TryParse(this.Form.FloorTextBox.Text, out roomFloor); int.TryParse(this.Form.CapacityTextBox.Text, out roomCapacity); int.TryParse(this.Form.TypeComboBox.SelectedValue.ToString(), out roomType); if (roomNumber <= 0 || roomFloor < 0 || roomCapacity <= 0 || roomType <= 0) { MessageBox.Show( "Podane wartości nie są prawidłowe lub pozostawiono niewypełnione pola.", "Błąd", MessageBoxButtons.OK, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1); return; } Room room = null; if (this.IsEditForm) { room = DataAccess.Instance.Rooms.Single(r => r.Number == this.ItemToEditID); room.Number = roomNumber; room.Capacity = roomCapacity; room.Floor = roomFloor; room.TypeId = roomType; this.AddFeaturesToRoom(room); } else { room = new Room { Number = roomNumber, Capacity = roomCapacity, Floor = roomFloor, TypeId = roomType }; DataAccess.Instance.Rooms.Add(room); this.AddFeaturesToRoom(room); } try { DataAccess.Instance.UnitOfWork.Commit(); } catch (Exception) { MessageBox.Show("Pokój o danym numerze już istnieje!"); DataAccess.Instance.UnitOfWork.Refresh(room); } this.Form.Dispose(); }
/// <summary> /// load room list from the database /// </summary> private void loadRoomList() { Room tempRoom; string sqlStatment = "SELECT * FROM Room "; try { OpenConection(); cmd = new OleDbCommand(sqlStatment, conn); reader = cmd.ExecuteReader(); while (reader.Read()) { if (reader["Deleted"].ToString().Equals("False")) { tempRoom = new Room( reader["Id"].ToString(), reader["Number"].ToString(), Convert.ToInt32(reader["Capacity"]), reader["RoomType"].ToString(), reader["SlotsOff"].ToString(), reader["BuildingID"].ToString()); roomList.addAtTail(tempRoom); } } CloseConnection(); } catch (Exception e) { MessageBox.Show(e.ToString()); } }
public void insertLessons(Lesson[][] thelessons, Room[] roomList) =======
/// <summary> /// Adds a room to the roomList /// </summary> /// <param name="room">Room object to be added to the list</param> public void addRoom(Room room) { roomList.addAtTail(room); }
/// <summary> /// Load the LinkedList of Room for a Building /// </summary> /// <param name="building">The Building the Rooms are in</param> /// <returns>Linked List of rooms</returns> public LinkedList loadRoomList(Building building) { LinkedList roomList = new LinkedList(); Room tempRoom; string sqlStatment = "SELECT * FROM Room WHERE BuildingID LIKE " + building.getID(); try { OpenConection(); cmd = new OleDbCommand(sqlStatment, conn); reader = cmd.ExecuteReader(); while (reader.Read()) { if (reader["Deleted"].ToString().Equals("False")) { tempRoom = new Room(); tempRoom.setID(reader["ID"].ToString()); tempRoom.setRoomNumber(reader["Number"].ToString()); tempRoom.setCapacity(Convert.ToInt32(reader["Capacity"])); tempRoom.setRoomType(reader["RoomType"].ToString()); tempRoom.setSlotsOff(reader["SlotsOff"].ToString()); roomList.addAtTail(tempRoom); } } CloseConnection(); } catch { // MessageBox.Show("Failed to get data from source"); } return roomList; }
/// <summary> /// The parameter received will used for setting the room for the Lesson. /// </summary> /// <param name="room">Room details</param> public void setRoom(Room room) { this.room = room; }