public void TestSetup() { accessor = new MockRoomTypeAccessor(); roomTypeManager = new RoomTypeManager(accessor); roomTypes = new List <RoomType>(); roomTypes = roomTypeManager.RetrieveAllRoomTypes("all"); }
/// <summary> /// Loads the datagrid with the guest type table /// </summary> public RoomTypes() { InitializeComponent(); roomManager = new RoomTypeManager(); try { _room = roomManager.RetrieveAllRoomTypes("All"); if (_currentRoom == null) { _currentRoom = _room; } dgRooms.ItemsSource = _currentRoom; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// Loads the combo box of room types to choose from /// </summary> public DeleteRoom() { InitializeComponent(); roomManager = new RoomTypeManager(); try { if (cboRoom.Items.Count == 0) { var guestId = roomManager.RetrieveAllRoomTypes(); foreach (var item in guestId) { cboRoom.Items.Add(item); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// Loads the page /// </summary> public AddRoom() { InitializeComponent(); roomManager = new RoomTypeManager(); }
public bool deleteRoomType(IRoomType aRoomType) { try { ds = new DataSet(); string sql = "SELECT * From rooms"; da = new SqlDataAdapter(sql, con); da.MissingSchemaAction = MissingSchemaAction.AddWithKey; cb = new SqlCommandBuilder(da); //Generates da.Fill(ds, "RoomData"); DataRow findRow = ds.Tables["RoomData"].Rows.Find(aRoomType.Name); if (findRow == null) { return true; //ds = new DataSet(); //sql = "SELECT * From roomTypes WHERE name = " + aRoomType.RoomTypeId; //da = new SqlDataAdapter(sql, con); //cb = new SqlCommandBuilder(da); //Generates //da.Fill(ds, "RoomTypeData"); //DataRow findRow2 = ds.Tables["RoomTypeData"].Rows.Find(aRoomType.RoomTypeId); //if (findRow2 != null) //{ // findRow.Delete(); //mark row as deleted //} //da.Update(ds, "RoomTypeData"); //remove row from database table } } catch (System.Exception excep) { MessageBox.Show(excep.Message); if (getConnection().ToString() == "Open") closeConnection(); Application.Exit(); } return true; }
public void addNewRoomTypeToDB(IRoomType theRoomType) { try { DataSet ds = new DataSet(); string sql = "SELECT * From roomTypes"; SqlDataAdapter da = new SqlDataAdapter(sql, con); SqlCommandBuilder cb = new SqlCommandBuilder(da); //Generates da.Fill(ds, "UsersData"); totUsers = ds.Tables["UsersData"].Rows.Count; DataRow dRow = ds.Tables["UsersData"].NewRow(); dRow[0] = theRoomType.RoomTypeId; dRow[1] = theRoomType.Name; dRow[2] = theRoomType.Description; dRow[3] = theRoomType.Capacity; dRow[4] = theRoomType.PricePerNight; ds.Tables["UsersData"].Rows.Add(dRow); da.Update(ds, "UsersData"); } catch (System.Exception excep) { if (con.State.ToString() == "Open") con.Close(); Application.Exit(); //Environment.Exit(0); //Force the application to close } }
public bool updateRoomTypeInDB(IRoomType aRoomType) { try { ds = new DataSet(); string sql = "SELECT * From roomtypes"; da = new SqlDataAdapter(sql, con); da.MissingSchemaAction = MissingSchemaAction.AddWithKey; cb = new SqlCommandBuilder(da); //Generates da.Fill(ds, "RoomTypeData"); DataRow findRow = ds.Tables["RoomTypeData"].Rows.Find(aRoomType.RoomTypeId); if (findRow != null) { findRow[1] = aRoomType.Name; findRow[2] = aRoomType.Capacity; findRow[3] = aRoomType.PricePerNight; } da.Update(ds, "RoomTypeData"); //remove row from database table } catch (System.Exception excep) { MessageBox.Show(excep.Message); if (getConnection().ToString() == "Open") closeConnection(); Application.Exit(); } return true; }
public bool updateRoomType(IRoomType aRoomType, string name) { IRoomType duplicateUser = this.RoomTypeList.FirstOrDefault(rm => rm.Name == name); if (duplicateUser != null) { MessageBox.Show("Error, Cannot rename a roomtype to be the same as another existing roomtype"); return false; } else { aRoomType.Name = name; DataLayer.updateRoomTypeInDB(aRoomType); _roomTypeList = DataLayer.getAllRoomTypes(); MessageBox.Show("Room Type Updated"); return true; } }
public bool deleteRoomType(IRoomType aRoomType) { DataLayer.deleteRoomType(aRoomType); RoomTypeList.Remove(aRoomType); //remove object from collection return true; }
public static void SetNewRoomType(IRoomType aRoomType) { newRoomType = aRoomType; }