/// <summary>
/// Author: Dalton Cleveland
/// Created : 3/27/2019
/// This constructor is used for Reading and Updating a HouseKeepingRequest
/// </summary>
public CreateHouseKeepingRequest(HouseKeepingRequest existingHouseKeepingRequest, IHouseKeepingRequestManager houseKeepingRequestManager)
{
InitializeComponent();
_houseKeepingRequestManager = houseKeepingRequestManager;
_existingHouseKeepingRequest = existingHouseKeepingRequest;
txtWorkingEmployee.Equals(null);
populateFormReadOnly();
}
/// <summary>
/// Author: Dalton Cleveland
/// Created : 3/27/2019
/// This Constructor requires a HouseKeepingRequest and an instance of the IHouseKeepingRequestManager
/// </summary>
public DeactivateHouseKeepingRequest(HouseKeepingRequest houseKeepingRequest, IHouseKeepingRequestManager houseKeepingRequestManager)
{
InitializeComponent();
_houseKeepingRequestManager = houseKeepingRequestManager;
_houseKeepingRequest = houseKeepingRequest;
txtTitleContent.Text = "Are you sure you want to delete this HouseKeepingRequest?";
txtBodyContent.Text = "Deleting this Item will remove it from our system. If you are unsure whether you should delete this please click cancel and ask your superior";
}
private void setHouseKeepingRequests(HouseKeepingRequest oldHouseKeepingRequest, HouseKeepingRequest newHouseKeepingRequest)
{
newHouseKeepingRequest.HouseKeepingRequestID = oldHouseKeepingRequest.HouseKeepingRequestID;
newHouseKeepingRequest.BuildingNumber = oldHouseKeepingRequest.BuildingNumber;
newHouseKeepingRequest.RoomNumber = oldHouseKeepingRequest.RoomNumber;
newHouseKeepingRequest.WorkingEmployeeID = oldHouseKeepingRequest.WorkingEmployeeID;
newHouseKeepingRequest.Description = oldHouseKeepingRequest.Description;
newHouseKeepingRequest.Active = oldHouseKeepingRequest.Active;
}
/// <summary>
/// Author: Dalton Cleveland
/// Created : 3/27/2019
/// The function which runs when Save is clicked
/// </summary>
private void btnSave_Click(object sender, RoutedEventArgs e)
{
if (((string)btnSave.Content) == "Submit")
{
if (!ValidateInput())
{
return;
}
HouseKeepingRequest newHouseKeepingRequest = new HouseKeepingRequest();
newHouseKeepingRequest.Active = (bool)chkActive.IsChecked;
newHouseKeepingRequest.BuildingNumber = int.Parse(txtBuildingNumber.Text);
newHouseKeepingRequest.RoomNumber = int.Parse(txtRoomNumber.Text);
newHouseKeepingRequest.Description = txtDescription.Text;
try
{
if (_existingHouseKeepingRequest == null)
{
_houseKeepingRequestManager.AddHouseKeepingRequest(newHouseKeepingRequest);
SetError("");
MessageBox.Show("House Keeping Request Created Successfully: " +
"\nBuildingNumber: " + newHouseKeepingRequest.BuildingNumber +
"\nRoomNumber: " + newHouseKeepingRequest.RoomNumber +
"\nDescription: " + newHouseKeepingRequest.Description);
}
else
{
newHouseKeepingRequest.Active = (bool)chkActive.IsChecked;
newHouseKeepingRequest.WorkingEmployeeID = int.Parse(txtWorkingEmployee.Text);
_houseKeepingRequestManager.EditHouseKeepingRequest(_existingHouseKeepingRequest, newHouseKeepingRequest);
SetError("");
MessageBox.Show("House Keeping Request Updated Successfully: " +
"\nOld BuildingNumber: " + _existingHouseKeepingRequest.BuildingNumber +
"\nOld RoomNumber: " + _existingHouseKeepingRequest.RoomNumber +
"\nOld Description: " + _existingHouseKeepingRequest.Description +
"\n" +
"\nNew BuidlingNumber: " + newHouseKeepingRequest.BuildingNumber +
"\nNew RoomNumber: " + newHouseKeepingRequest.RoomNumber +
"\nNew Description: " + newHouseKeepingRequest.Description +
"\nNew WorkingEmployeeID: " + newHouseKeepingRequest.WorkingEmployeeID);
}
}
catch (Exception ex)
{
SetError(ex.Message);
}
Close();
}
else if (((string)btnSave.Content) == "Update")
{
setEditable();
}
else
{
MessageBox.Show(btnSave.Content.GetType() + " " + btnSave.Content);
}
}
public void TestUpdateHouseKeepingRequestInValidRoomNumber()
{
//Arrange
HouseKeepingRequest newHouseKeepingRequest = new HouseKeepingRequest();
setHouseKeepingRequests(_houseKeepingRequests[0], newHouseKeepingRequest);
newHouseKeepingRequest.RoomNumber = -1;
//Act
_houseKeepingRequestManager.EditHouseKeepingRequest(_houseKeepingRequests[0], newHouseKeepingRequest);
}
/// <summary>
/// Author: Dalton Cleveland
/// Created : 3/27/2019
/// Select HouseKeepingRequest by ID will attempt to select and return a HouseKeepingRequest from our MSSQL database with the matching ID
/// </summary>
public HouseKeepingRequest RetrieveHouseKeepingRequest(int HouseKeepingRequestID)
{
HouseKeepingRequest houseKeepingRequest = new HouseKeepingRequest();
// get a connection
var conn = DBConnection.GetDbConnection();
// command text
string cmdText = @"sp_select_house_keeping_request_by_id";
// command objects
var cmd1 = new SqlCommand(cmdText, conn);
// set the command type
cmd1.CommandType = CommandType.StoredProcedure;
// parameters
//We do not have a WorkOrderID since we have not created the WorkOrder in our database yet
cmd1.Parameters.AddWithValue("@HouseKeepingRequestID", HouseKeepingRequestID);
try
{
conn.Open();
SqlDataReader reader = cmd1.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
houseKeepingRequest.HouseKeepingRequestID = reader.GetInt32(0);
houseKeepingRequest.BuildingNumber = reader.GetInt32(1);
houseKeepingRequest.RoomNumber = reader.GetInt32(2);
houseKeepingRequest.Description = reader.GetString(3);
if (reader.IsDBNull(4))
{
houseKeepingRequest.WorkingEmployeeID = null;
}
else
{
houseKeepingRequest.WorkingEmployeeID = reader.GetInt32(4);
}
houseKeepingRequest.Active = reader.GetBoolean(5);
break;
}
}
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
}
return(houseKeepingRequest);
}
public void TestRetrieveHouseKeepingRequestInValidInput()
{
//Arrange
HouseKeepingRequest newHouseKeepingRequest = new HouseKeepingRequest();
int invalidHouseKeepingRequestID = -1;
//Act
newHouseKeepingRequest = _houseKeepingRequestManager.RetrieveHouseKeepingRequest(invalidHouseKeepingRequestID);
//Assert
Assert.AreEqual(newHouseKeepingRequest.HouseKeepingRequestID, 0);
}
public void TestCreateHouseKeepingRequestInValidInputBuildingNumber()
{
//Arrange
HouseKeepingRequest newHouseKeepingRequest = new HouseKeepingRequest()
{
BuildingNumber = 10000, RoomNumber = 1, Description = "Created In Unit Test: TestCreateHouseKeepingRequestInValidInputBuildingNumber()", WorkingEmployeeID = 100000, Active = true
};
//Act
//Since BuildingNumber is invalid, this should throw an Exception
_houseKeepingRequestManager.AddHouseKeepingRequest(newHouseKeepingRequest);
}
/// <summary>
/// Author: Dalton Cleveland
/// Created : 3/27/2019
/// This will search for a request with a matching request ID from our mock data
/// </summary>
public HouseKeepingRequest RetrieveHouseKeepingRequest(int HouseKeepingRequestID)
{
HouseKeepingRequest h = new HouseKeepingRequest();
h = _houseKeepingRequests.Find(x => x.HouseKeepingRequestID == HouseKeepingRequestID);
if (h == null)
{
throw new ArgumentException("HouseKeepingRequestID did not match any HouseKeepingRequest in our System");
}
return(h);
}
public void TestUpdateHouseKeepingRequestInValidDescription()
{
//Arrange
HouseKeepingRequest newHouseKeepingRequest = new HouseKeepingRequest();
setHouseKeepingRequests(_houseKeepingRequests[0], newHouseKeepingRequest);
string newDescription = "This test is updating the description in TestUpdateHouseKeepingRequestValidDescription()" + createLongString(1001);
newHouseKeepingRequest.Description = newDescription;
//Act
_houseKeepingRequestManager.EditHouseKeepingRequest(_houseKeepingRequests[0], newHouseKeepingRequest);
}
/// <summary>
/// Author: Dalton Cleveland
/// Created : 3/27/2019
/// Retrieve All HouseKeepingRequests will attempt to select and return every single HouseKeepingRequest from our MSSQL database in the form of a List
/// </summary>
public List <HouseKeepingRequest> RetrieveAllHouseKeepingRequests()
{
List <HouseKeepingRequest> houseKeepingRequests = new List <HouseKeepingRequest>();
// get a connection
var conn = DBConnection.GetDbConnection();
// command text
string cmdText = @"sp_select_all_house_keeping_requests";
// command objects
var cmd = new SqlCommand(cmdText, conn);
// set the command type
cmd.CommandType = CommandType.StoredProcedure;
try
{
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
HouseKeepingRequest houseKeepingRequest = new HouseKeepingRequest();
houseKeepingRequest.HouseKeepingRequestID = reader.GetInt32(0);
houseKeepingRequest.BuildingNumber = reader.GetInt32(1);
houseKeepingRequest.RoomNumber = reader.GetInt32(2);
houseKeepingRequest.Description = reader.GetString(3);
if (reader.IsDBNull(4))
{
houseKeepingRequest.WorkingEmployeeID = null;
}
else
{
houseKeepingRequest.WorkingEmployeeID = reader.GetInt32(4);
}
houseKeepingRequest.Active = reader.GetBoolean(5);
houseKeepingRequests.Add(houseKeepingRequest);
}
}
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
}
return(houseKeepingRequests);
}
/// <summary>
/// Author: Dalton Cleveland
/// Created : 3/27/2019
/// This constructor is used for Creating a HouseKeepingRequest
/// Initializes connections to our HouseKeepingRequestManager
/// </summary>
public CreateHouseKeepingRequest(IHouseKeepingRequestManager houseKeepingRequestManager)
{
InitializeComponent();
_houseKeepingRequestManager = houseKeepingRequestManager;
chkActive.IsEnabled = false;
chkActive.IsChecked = true;
chkActive.Visibility = Visibility.Hidden;
txtWorkingEmployee.IsEnabled = false;
txtWorkingEmployee.Equals(null);
_existingHouseKeepingRequest = null;
}
private void btnUpdateFrontDesk_Click(object sender, RoutedEventArgs e)
{
if (tabBellHopService.IsSelected)
{
try
{
DataGridRow row = (DataGridRow)dgLuggage.ItemContainerGenerator.ContainerFromIndex(dgLuggage.SelectedIndex);
DataGridCell RowColumn = dgLuggage.Columns[0].GetCellContent(row).Parent as DataGridCell;
openView(luggageManager.RetrieveLuggageByID(int.Parse(((TextBlock)RowColumn.Content).Text)));
}
catch (ArgumentOutOfRangeException)
{
MessageBox.Show("You must select a guest before editing.");
}
catch (IndexOutOfRangeException)
{
MessageBox.Show("You must select a guest before editing.");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// Author: Dalton Cleveland
/// Created : 3/27/2019
/// The function which runs when the view HouseKeepingRequest button is clicked.
/// It will launch the CreateHouseKeepingRequest window in view mode with the option of updating
/// </summary>
else if (tabHousekeepingService.IsSelected)
{
if (dgHouseKeepingRequests.SelectedIndex != -1)
{
HouseKeepingRequest selectedHouseKeepingRequest = new HouseKeepingRequest();
try
{
selectedHouseKeepingRequest = _houseKeepingRequestManager.RetrieveHouseKeepingRequest(((HouseKeepingRequest)dgHouseKeepingRequests.SelectedItem).HouseKeepingRequestID);
var readUpdateHouseKeepingRequest = new CreateHouseKeepingRequest(selectedHouseKeepingRequest, _houseKeepingRequestManager);
readUpdateHouseKeepingRequest.ShowDialog();
refreshAllHouseKeepingRequests();
populateHouseKeepingRequests();
}
catch (Exception ex)
{
MessageBox.Show("Unable to find that HouseKeepingRequest\n" + ex.Message);
}
}
}
}
public void TestUpdateHouseKeepingRequestValidDescription()
{
//Arrange
HouseKeepingRequest newHouseKeepingRequest = new HouseKeepingRequest();
setHouseKeepingRequests(_houseKeepingRequests[0], newHouseKeepingRequest);
string newDescription = "This test is updating the description in TestUpdateHouseKeepingRequestValidDescription()";
newHouseKeepingRequest.Description = newDescription;
//Act
_houseKeepingRequestManager.EditHouseKeepingRequest(_houseKeepingRequests[0], newHouseKeepingRequest);
//Assert
_houseKeepingRequests = _houseKeepingRequestManager.RetrieveAllHouseKeepingRequests();
Assert.AreEqual(_houseKeepingRequestManager.RetrieveHouseKeepingRequest(_houseKeepingRequests[0].HouseKeepingRequestID).Description, newDescription);
}
/// <summary author="Dalton Cleveland" created="2019/03/27">
/// Sends Existing HouseKeepingRequest data along with the new HouseKeepingRequest data to HouseKeepingRequestAccessor. Returns an error if update fails
/// </summary>
public void EditHouseKeepingRequest(HouseKeepingRequest oldHouseKeepingRequest, HouseKeepingRequest newHouseKeepingRequest)
{
try
{
if (!newHouseKeepingRequest.IsValid())
{
throw new ArgumentException("Data for this new HouseKeepingRequest is not valid");
}
_houseKeepingRequestAccessor.UpdateHouseKeepingRequest(oldHouseKeepingRequest, newHouseKeepingRequest);
}
catch (Exception ex)
{
ExceptionLogManager.getInstance().LogException(ex);
throw ex;
}
}
public void TestRetrieveHouseKeepingRequestValidInput()
{
//Arrange
HouseKeepingRequest newHouseKeepingRequest = new HouseKeepingRequest();
//Act
newHouseKeepingRequest = _houseKeepingRequestManager.RetrieveHouseKeepingRequest(_houseKeepingRequests[0].HouseKeepingRequestID);
//Assert
Assert.AreEqual(newHouseKeepingRequest.HouseKeepingRequestID, _houseKeepingRequests[0].HouseKeepingRequestID);
Assert.AreEqual(newHouseKeepingRequest.BuildingNumber, _houseKeepingRequests[0].BuildingNumber);
Assert.AreEqual(newHouseKeepingRequest.RoomNumber, _houseKeepingRequests[0].RoomNumber);
Assert.AreEqual(newHouseKeepingRequest.Description, _houseKeepingRequests[0].Description);
Assert.AreEqual(newHouseKeepingRequest.WorkingEmployeeID, _houseKeepingRequests[0].WorkingEmployeeID);
Assert.AreEqual(newHouseKeepingRequest.Active, _houseKeepingRequests[0].Active);
}
/// <summary author="Dalton Cleveland" created="2019/03/27">
/// Returns a HouseKeepingRequest from a HouseKeepingRequestAccessor or throws an error if there was a problem
/// </summary>
public HouseKeepingRequest RetrieveHouseKeepingRequest(int HouseKeepingRequestID)
{
HouseKeepingRequest houseKeepingRequest = new HouseKeepingRequest();
try
{
houseKeepingRequest = _houseKeepingRequestAccessor.RetrieveHouseKeepingRequest(HouseKeepingRequestID);
}
catch (Exception ex)
{
ExceptionLogManager.getInstance().LogException(ex);
throw new ArgumentException("HouseKeepingRequestID did not match any HouseKeepingRequests in our System");
}
return(houseKeepingRequest);
}
/// <summary author="Dalton Cleveland" created="2019/03/27">
/// Passes along a HouseKeepingRequest object to our HouseKeepingRequestAccessorMSSQL to be stored in our database
public void AddHouseKeepingRequest(HouseKeepingRequest newHouseKeepingRequest)
{
try
{
//Double Check the HouseKeepingRequest is Valid
if (!newHouseKeepingRequest.IsValid())
{
throw new ArgumentException("Data for this HouseKeepingRequest is not valid");
}
_houseKeepingRequestAccessor.CreateHouseKeepingRequest(newHouseKeepingRequest);
}
catch (Exception ex)
{
ExceptionLogManager.getInstance().LogException(ex);
throw ex;
}
}
/// <summary>
/// Author: Dalton Cleveland
/// Created : 3/27/2019
/// Update HouseKeepingRequest will attempt to update the HouseKeepingRequest from our MSSQL database
/// </summary>
public void UpdateHouseKeepingRequest(HouseKeepingRequest oldHouseKeepingRequest, HouseKeepingRequest newHouseKeepingRequest)
{
// get a connection
var conn = DBConnection.GetDbConnection();
// command text
string cmdText1 = @"sp_update_house_keeping_request";
// command objects
var cmd1 = new SqlCommand(cmdText1, conn);
// set the command type
cmd1.CommandType = CommandType.StoredProcedure;
// parameters
cmd1.Parameters.AddWithValue("@HouseKeepingRequestID", oldHouseKeepingRequest.HouseKeepingRequestID);
cmd1.Parameters.AddWithValue("@oldBuildingNumber", oldHouseKeepingRequest.BuildingNumber);
cmd1.Parameters.AddWithValue("@oldRoomNumber", oldHouseKeepingRequest.RoomNumber);
cmd1.Parameters.AddWithValue("@oldDescription", oldHouseKeepingRequest.Description);
cmd1.Parameters.AddWithValue("@oldActive", oldHouseKeepingRequest.Active);
cmd1.Parameters.AddWithValue("@newBuildingNumber", newHouseKeepingRequest.BuildingNumber);
cmd1.Parameters.AddWithValue("@newRoomNumber", newHouseKeepingRequest.RoomNumber);
cmd1.Parameters.AddWithValue("@newDescription", newHouseKeepingRequest.Description);
cmd1.Parameters.AddWithValue("@newWorkingEmployeeID", newHouseKeepingRequest.WorkingEmployeeID);
cmd1.Parameters.AddWithValue("@newActive", newHouseKeepingRequest.Active);
try
{
// open the connection
conn.Open();
// execute the command
cmd1.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
}
}
/// <summary>
/// Author: Dalton Cleveland
/// Created : 3/27/2019
/// The function which runs when a HouseKeepingRequest is double clicked
/// </summary>
private void dgHouseKeepingRequests_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
if (dgHouseKeepingRequests.SelectedIndex != -1)
{
HouseKeepingRequest selectedHouseKeepingRequest = new HouseKeepingRequest();
try
{
selectedHouseKeepingRequest = _houseKeepingRequestManager.RetrieveHouseKeepingRequest(((HouseKeepingRequest)dgHouseKeepingRequests.SelectedItem).HouseKeepingRequestID);
var readUpdateHouseKeepingRequest = new CreateHouseKeepingRequest(selectedHouseKeepingRequest, _houseKeepingRequestManager);
readUpdateHouseKeepingRequest.ShowDialog();
refreshAllHouseKeepingRequests();
populateHouseKeepingRequests();
}
catch (Exception ex)
{
MessageBox.Show("Unable to find that HouseKeepingRequest\n" + ex.Message);
}
}
}
/// <summary>
/// Author: Dalton Cleveland
/// Created : 3/27/2019
/// This will update an existing housekeeping request or throw a new ArgumentException
/// </summary>
public void UpdateHouseKeepingRequest(HouseKeepingRequest oldHouseKeepingRequest, HouseKeepingRequest newHouseKeepingRequest)
{
bool updated = false;
foreach (var hr in _houseKeepingRequests)
{
if (hr.HouseKeepingRequestID == oldHouseKeepingRequest.HouseKeepingRequestID)
{
hr.BuildingNumber = newHouseKeepingRequest.BuildingNumber;
hr.RoomNumber = newHouseKeepingRequest.RoomNumber;
hr.WorkingEmployeeID = newHouseKeepingRequest.WorkingEmployeeID;
hr.Description = newHouseKeepingRequest.Description;
hr.Active = newHouseKeepingRequest.Active;
updated = true;
break;
}
}
if (!updated)
{
throw new ArgumentException("No House Keeping Request was found to update");
}
}
public void TestCreateHouseKeepingRequestValidInput()
{
//Arrange
HouseKeepingRequest newHouseKeepingRequest = new HouseKeepingRequest()
{
BuildingNumber = 1, RoomNumber = 1, Description = "Created In Unit Test: TestCreateHouseKeepingRequestValidInput()", WorkingEmployeeID = 100000, Active = true
};
//Act
_houseKeepingRequestManager.AddHouseKeepingRequest(newHouseKeepingRequest);
//Assert
//Updates the list of HouseKeepingRequests
_houseKeepingRequests = _houseKeepingRequestManager.RetrieveAllHouseKeepingRequests();
//Checks to see if the new HouseKeepingRequest is in the updated list of HouseKeepingRequests
Assert.IsNotNull(_houseKeepingRequests.Find(x => x.BuildingNumber == newHouseKeepingRequest.BuildingNumber &&
x.RoomNumber == newHouseKeepingRequest.RoomNumber &&
x.Description == newHouseKeepingRequest.Description &&
x.WorkingEmployeeID == newHouseKeepingRequest.WorkingEmployeeID &&
x.Active == newHouseKeepingRequest.Active));
}
/// <summary>
/// Author: Dalton Cleveland
/// Created : 3/27/2019
/// Creates a HouseKeepingRequest for the HouseKeepingRequest Table in our Microsoft SQL Server
/// </summary>
public void CreateHouseKeepingRequest(HouseKeepingRequest newHouseKeepingRequest)
{
// get a connection
var conn = DBConnection.GetDbConnection();
// command text
string cmdText1 = @"sp_create_house_keeping_request";
// command objects
var cmd1 = new SqlCommand(cmdText1, conn);
// set the command type
cmd1.CommandType = CommandType.StoredProcedure;
// parameters
//We do not have a HouseKeepingRequestID since we have not created the Request in our database yet
cmd1.Parameters.AddWithValue("@BuildingNumber", newHouseKeepingRequest.BuildingNumber);
cmd1.Parameters.AddWithValue("@RoomNumber", newHouseKeepingRequest.RoomNumber);
cmd1.Parameters.AddWithValue("@Description", newHouseKeepingRequest.Description);
cmd1.Parameters.AddWithValue("@Active", newHouseKeepingRequest.Active);
try
{
// open the connection
conn.Open();
// execute the command
cmd1.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
}
}
/// <summary>
/// Author: Dalton Cleveland
/// Created : 3/27/2019
/// This will create a request using the data provided in the newRequest
/// </summary>
public void CreateHouseKeepingRequest(HouseKeepingRequest newHouseKeepingRequest)
{
_houseKeepingRequests.Add(newHouseKeepingRequest);
}
