public void TestEditFacilityInspection()
{
// arrange
FacilityInspection oldFacilityInspection = new FacilityInspection()
{
FacilityInspectionID = 1000000,
UserID = 100000,
InspectorName = "Bob",
InspectionDate = new DateTime(2018, 7, 10, 7, 10, 24),
InspectionDescription = "Inspect cracked window",
InspectionCompleted = false
};
FacilityInspection newFacilityInspection = new FacilityInspection()
{
FacilityInspectionID = 1000000,
UserID = 100000,
InspectorName = "Jim",
InspectionDate = new DateTime(2018, 7, 10, 7, 10, 24),
InspectionDescription = "Inspect cracked window",
InspectionCompleted = false
};
bool result = false;
// act
result = _facilityInspectionManager.EditFacilityInspection(oldFacilityInspection, newFacilityInspection);
// assert
Assert.IsTrue(result);
}
/// <summary>
/// Creator: Carl Davis
/// Created: 2/28/2020
/// Approver: Ethan Murphy 3/6/2020
///
/// constructor for facility inspection controls
/// </summary>
/// <remarks>
/// Updater:
/// Updated:
/// Update:
/// </remarks>
public FacilityInspectionControls()
{
InitializeComponent();
_facilityInspectionManager = new FacilityInspectionManager();
selectedFacilityInspection = new FacilityInspection();
cmbFacilityInspectionFields.ItemsSource = inspectionItems;
}
/// <summary>
/// Creator: Carl Davis
/// Created: 3/4/2020
/// Approver: Ethan Murphy 3/6/2020
///
/// constructor for facility inspection controls
/// </summary>
/// <remarks>
/// Updater:
/// Updated:
/// Update:
/// </remarks>
public FacilityInspectionControls(PetUniverseUser user)
{
InitializeComponent();
_facilityInspectionManager = new FacilityInspectionManager();
selectedFacilityInspection = new FacilityInspection();
cmbFacilityInspectionFields.ItemsSource = inspectionItems;
_user = user;
}
/// <summary>
/// Creator: Carl Davis
/// Created: 3/18/2020
/// Approver: Chuck Baxter, 3/18/2020
///
/// Submits the updated information to the database
/// </summary>
/// <remarks>
/// Updater:
/// Updated:
/// Update:
/// </remarks>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnUpdateBuildingInspectionRecord_Click(object sender, RoutedEventArgs e)
{
if (string.IsNullOrEmpty(txtUserID.Text) || !long.TryParse(txtUserID.Text, out long num))
{
MessageBox.Show("Please enter a valid user id");
return;
}
if (string.IsNullOrEmpty(txtInspectorName.Text))
{
MessageBox.Show("Please enter the inspector name");
return;
}
if (string.IsNullOrEmpty(cndInspectionDate.SelectedDate.ToString()))
{
MessageBox.Show("Please enter the inspection date");
return;
}
if (string.IsNullOrEmpty(txtInspectionDescription.Text))
{
MessageBox.Show("Please enter the inspection description");
return;
}
try
{
FacilityInspection facilityInspection = new FacilityInspection
{
UserID = Int32.Parse(txtUserID.Text),
InspectorName = txtInspectorName.Text,
InspectionDate = (DateTime)cndInspectionDate.SelectedDate,
InspectionDescription = txtInspectionDescription.Text,
InspectionCompleted = (bool)chkInspectionCompleted.IsChecked
};
if (_facilityInspectionManager.EditFacilityInspection(selectedFacilityInspection, facilityInspection))
{
MessageBox.Show("Inspection record successfully updated.");
canAddFacilityInspection.Visibility = Visibility.Hidden;
canView.Visibility = Visibility.Visible;
BtnSubmitInspectionRecord.Visibility = Visibility.Visible;
btnUpdateBuildingInspectionRecord.Visibility = Visibility.Hidden;
lblInspectionCompleted.Visibility = Visibility.Hidden;
chkInspectionCompleted.Visibility = Visibility.Hidden;
RefreshViewAllList();
txtUserID.Text = "";
txtInspectorName.Text = "";
txtInspectionDescription.Text = "";
}
else
{
MessageBox.Show("Inspection record was not updated.");
}
}
catch (Exception ex)
{
WPFErrorHandler.ErrorMessage(ex.Message, "Save");
}
}
/// <summary>
/// Creator: Carl Davis
/// Created: 3/11/2020
/// Approver: Ethan Murphy 3/13/2020
/// Approver:
///
/// Method to select FacilityInspection Records by userID
/// </summary>
/// <remarks>
/// Updater:
/// Updated:
/// Update:
/// </remarks>
/// <param name="userID"></param>
/// <param name="inspectionComplete"></param>
/// <returns>List<FacilityMaintenance></returns>
public List <FacilityInspection> SelectFacilityInspectionByUserID(int userID, bool inspectionComplete)
{
List <FacilityInspection> facilityInspections = new List <FacilityInspection>();
// get a connection
var conn = DBConnection.GetConnection();
// create a sql command
var cmd = new SqlCommand("sp_select_facility_inspection_by_user_id", conn);
// set the command type
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserID", userID);
cmd.Parameters.AddWithValue("@InspectionCompleted", inspectionComplete);
try
{
// open the connection
conn.Open();
// create a variable to read the results
var reader = cmd.ExecuteReader();
// sees if results were found
if (reader.HasRows)
{
while (reader.Read())
{
var facilityInspection = new FacilityInspection();
facilityInspection.FacilityInspectionID = reader.GetInt32(0);
facilityInspection.UserID = reader.GetInt32(1);
facilityInspection.InspectorName = reader.GetString(2);
facilityInspection.InspectionDate = reader.GetDateTime(3);
facilityInspection.InspectionDescription = reader.GetString(4);
facilityInspection.InspectionCompleted = reader.GetBoolean(5);
facilityInspections.Add(facilityInspection);
}
}
// closes the reader
reader.Close();
}
catch (Exception ex)
{
throw ex;
}
finally
{
// close connection
conn.Close();
}
return(facilityInspections);
}
/// <summary>
/// Creator: Carl Davis
/// Created: 3/13/2020
/// Approver: Chuck Baxter, 3/18/2020
///
/// Method to update a facility inspection record
/// </summary>
/// <remarks>
/// Updater:
/// Updated:
/// Update:
/// </remarks>
/// <param name="oldFacilityInspection"></param>
/// <param name="newFacilityInspection"></param>
/// <returns>1 or 0 int depending if record was updated</returns>
public int UpdateFacilityInspection(FacilityInspection oldFacilityInspection, FacilityInspection newFacilityInspection)
{
int result = 0;
var conn = DBConnection.GetConnection();
var cmd = new SqlCommand("sp_update_facility_inspection", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@FacilityInspectionID", oldFacilityInspection.FacilityInspectionID);
cmd.Parameters.AddWithValue("@OldUserID", oldFacilityInspection.UserID);
cmd.Parameters.AddWithValue("@OldInspectorName", oldFacilityInspection.InspectorName);
cmd.Parameters.AddWithValue("@OldInspectionDate", oldFacilityInspection.InspectionDate);
cmd.Parameters.AddWithValue("@OldInspectionDescription", oldFacilityInspection.InspectionDescription);
cmd.Parameters.AddWithValue("@OldInspectionComplete", oldFacilityInspection.InspectionCompleted);
cmd.Parameters.AddWithValue("@NewUserID", newFacilityInspection.UserID);
cmd.Parameters.AddWithValue("@NewInspectorName", newFacilityInspection.InspectorName);
cmd.Parameters.AddWithValue("@NewInspectionDate", newFacilityInspection.InspectionDate);
cmd.Parameters.AddWithValue("@NewInspectionDescription", newFacilityInspection.InspectionDescription);
cmd.Parameters.AddWithValue("@NewInspectionComplete", newFacilityInspection.InspectionCompleted);
try
{
conn.Open();
result = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(result);
}
/// <summary>
/// Creator: Carl Davis
/// Created: 2/28/2020
/// Approver: Ethan Murphy 3/6/2020
/// Approver:
///
/// Method to add a FacilityInspectionRecord
/// </summary>
/// <remarks>
/// Updater:
/// Updated:
/// Update:
/// </remarks>
/// <param name="facilityInspection"></param>
/// <returns>true or false depending on if record was updated</returns>
public bool AddFacilityInspectionRecord(FacilityInspection facilityInspection)
{
bool result = true;
try
{
result = 1 == _facilityInspectionAccessor.InsertFacilityInspectionRecord(facilityInspection);
}
catch (Exception ex)
{
throw new ApplicationException("Failed to create record!", ex);
}
return(result);
}
/// <summary>
/// Creator: Carl Davis
/// Created: 3/13/2020
/// Approver: Chuck Baxter, 3/18/2020
///
/// Method to Edit a facility inspection record
/// </summary>
/// <remarks>
/// Updater:
/// Updated:
/// Update:
/// </remarks>
/// <param name="oldFacilityInspection"></param>
/// <param name="newFacilityInspection"></param>
/// <returns>bool depending if record was successfully updated</returns>
public bool EditFacilityInspection(FacilityInspection oldFacilityInspection, FacilityInspection newFacilityInspection)
{
bool result = false;
try
{
result = 1 == _facilityInspectionAccessor.UpdateFacilityInspection(oldFacilityInspection, newFacilityInspection);
}
catch (Exception ex)
{
throw new ApplicationException("Update Inspection Record Failed!", ex);
}
return(result);
}
/// <summary>
/// Creator: Carl Davis
/// Created: 3/13/2020
/// Approver: Chuck Baxter, 3/18/2020
///
/// Method to update a facility maintenance record
/// </summary>
/// <remarks>
/// Updater:
/// Updated:
/// Update:
/// </remarks>
/// <param name="oldFacilityInspection"></param>
/// <param name="newFacilityInspection"></param>
/// <returns>1 or 0 int if they are equal</returns>
public int UpdateFacilityInspection(FacilityInspection oldFacilityInspection, FacilityInspection newFacilityInspection)
{
int result;
oldFacilityInspection = newFacilityInspection;
if (oldFacilityInspection.Equals(newFacilityInspection))
{
result = 1;
}
else
{
result = 0;
}
return(result);
}
/// <summary>
/// Creator: Carl Davis
/// Created: 2/28/2020
/// Approver: Ethan Murphy, 3/6/2020
///
/// Method to insert a fake FacilityInspectioneRecord
/// </summary>
/// <remarks>
/// Updater:
/// Updated:
/// Update:
/// </remarks>
/// <param name="facilityInspection"></param>
/// <returns>1 or 0 depending if the record matches the data</returns>
public int InsertFacilityInspectionRecord(FacilityInspection facilityInspection)
{
int result = 0;
DateTime insepctionDate = new DateTime(2018, 7, 10, 7, 10, 24);
if (facilityInspection.FacilityInspectionID == 1000000 && facilityInspection.UserID == 100000 && facilityInspection.InspectorName == "Bob" &&
facilityInspection.InspectionDate == insepctionDate &&
facilityInspection.InspectionDescription == "Inspect cracked window" &&
facilityInspection.InspectionCompleted == false)
{
result = 1;
}
else
{
result = 0;
}
return(result);
}
/// <summary>
/// Creator: Carl Davis
/// Created: 3/18/2020
/// Approver: Chuck Baxter, 3/18/2020
///
/// brings up update window
/// </summary>
/// <remarks>
/// Updater:
/// Updated:
/// Update:
/// </remarks>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgFacilityInspection_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
txtUserID.Text = _user.PUUserID.ToString();
cndInspectionDate.DisplayDateStart = DateTime.Now;
selectedFacilityInspection = (FacilityInspection)dgFacilityInspection.SelectedItem;
if (selectedFacilityInspection != null)
{
canAddFacilityInspection.Visibility = Visibility.Visible;
canView.Visibility = Visibility.Hidden;
btnUpdateBuildingInspectionRecord.Visibility = Visibility.Visible;
BtnSubmitInspectionRecord.Visibility = Visibility.Hidden;
lblInspectionCompleted.Visibility = Visibility.Visible;
chkInspectionCompleted.Visibility = Visibility.Visible;
lblFacilityInspection.Content = "Update Facility Inspection Record";
txtUserID.Text = selectedFacilityInspection.UserID.ToString();
txtInspectorName.Text = selectedFacilityInspection.InspectorName;
txtInspectionDescription.Text = selectedFacilityInspection.InspectionDescription;
cndInspectionDate.SelectedDate = selectedFacilityInspection.InspectionDate;
chkInspectionCompleted.IsChecked = selectedFacilityInspection.InspectionCompleted;
}
}
/// <summary>
/// Creator: Carl Davis
/// Created: 2/28/2020
/// Approver: Ethan Murphy 3/6/2020
/// Approver:
///
/// Method to insert a FacilityInspection Record
/// </summary>
/// <remarks>
/// Updater:
/// Updated:
/// Update:
/// </remarks>
/// <param name="facilityInspection"></param>
/// <returns>1 or 0 int depending if record was added</returns>
public int InsertFacilityInspectionRecord(FacilityInspection facilityInspection)
{
int result = 0;
var conn = DBConnection.GetConnection();
var cmd = new SqlCommand("sp_insert_facility_inspection", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@UserID", SqlDbType.Int);
cmd.Parameters["@UserID"].Value = facilityInspection.UserID;
cmd.Parameters.Add("@InspectorName", SqlDbType.NVarChar);
cmd.Parameters["@InspectorName"].Value = facilityInspection.InspectorName;
cmd.Parameters.Add("@InspectionDate", SqlDbType.Date);
cmd.Parameters["@InspectionDate"].Value = facilityInspection.InspectionDate;
cmd.Parameters.Add("@InspectionDescription", SqlDbType.NVarChar);
cmd.Parameters["@InspectionDescription"].Value = facilityInspection.InspectionDescription;
try
{
conn.Open();
result = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(result);
}
