/// <summary>
/// Creator: Carl Davis
/// Created: 4/9/2020
/// Approver: Ben Hanna, 4/10/20
///
/// constructor for facility Task controls
/// </summary>
/// <remarks>
/// Updater:
/// Updated:
/// Update:
/// </remarks>
public FacilityTaskControls()
{
InitializeComponent();
_facilityTaskManager = new FacilityTaskManager();
selectedFacilityTask = new FacilityTask();
cmbFacilityTaskFields.ItemsSource = searchItems;
}
public void TestEditFacilityTask()
{
// arrange
FacilityTask oldFacilityTask = new FacilityTask()
{
FacilityTaskID = 1000000,
FacilityTaskName = "Clean",
UserID = 100000,
StartDate = new DateTime(2018, 7, 10, 7, 10, 24),
CompletionDate = new DateTime(2018, 7, 10, 7, 10, 24),
TaskCompleted = false
};
FacilityTask newFacilityTask = new FacilityTask()
{
FacilityTaskID = 1000000,
FacilityTaskName = "Break",
UserID = 100001,
StartDate = new DateTime(2018, 7, 10, 7, 10, 24),
CompletionDate = new DateTime(2018, 7, 10, 7, 10, 24),
TaskCompleted = false
};
bool result = false;
// act
result = _facilityTaskManager.EditFacilityTask(oldFacilityTask, newFacilityTask);
// assert
Assert.IsTrue(result);
}
/// <summary>
/// Creator: Carl Davis
/// Created: 4/9/2020
/// Approver: Ben Hanna, 4/10/20
/// Approver:
///
/// Method to insert a FacilityTask Record
/// </summary>
/// <remarks>
/// Updater:
/// Updated:
/// Update:
/// </remarks>
/// <param name="facilityTask"></param>
/// <returns>1 or 0 int depending if record was added</returns>
public int InsertFacilityTaskRecord(FacilityTask facilityTask)
{
int result = 0;
var conn = DBConnection.GetConnection();
var cmd = new SqlCommand("sp_INSERT_facility_task", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@FacilityTaskName", facilityTask.FacilityTaskName);
cmd.Parameters.AddWithValue("@UserID", facilityTask.UserID);
cmd.Parameters.AddWithValue("@StartDate", facilityTask.StartDate);
cmd.Parameters.AddWithValue("@CompletionDate", facilityTask.CompletionDate);
cmd.Parameters.AddWithValue("@FacilityTaskNotes", facilityTask.FacilityTaskNotes);
try
{
conn.Open();
result = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(result);
}
/// <summary>
/// Creator: Carl Davis
/// Created: 4/9/2020
/// Approver: Ben Hanna, 4/10/20
///
/// constructor for facility Task controls with a user parameter
/// </summary>
/// <remarks>
/// Updater:
/// Updated:
/// Update:
/// </remarks>
public FacilityTaskControls(PetUniverseUser user)
{
InitializeComponent();
_facilityTaskManager = new FacilityTaskManager();
selectedFacilityTask = new FacilityTask();
_user = user;
cmbFacilityTaskFields.ItemsSource = searchItems;
}
/// <summary>
/// Creator: Carl Davis
/// Created: 4/9/2020
/// Approver: Ben Hanna, 4/10/20
///
/// creates a new facility task record the user has entered if validated
/// </summary>
/// <remarks>
/// Updater:
/// Updated:
/// Update:
/// </remarks>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BtnSubmitTaskRecord_Click(object sender, RoutedEventArgs e)
{
if (string.IsNullOrEmpty(txtTaskName.Text))
{
MessageBox.Show("Please enter the facility task name");
return;
}
if (string.IsNullOrEmpty(txtUserID.Text) || !long.TryParse(txtUserID.Text, out long num))
{
MessageBox.Show("Please enter a valid user id");
return;
}
if (string.IsNullOrEmpty(cndStartDate.SelectedDate.ToString()))
{
MessageBox.Show("Please enter the start date");
return;
}
if (string.IsNullOrEmpty(cndCompletionDate.SelectedDate.ToString()))
{
MessageBox.Show("Please enter the completion date");
return;
}
if (string.IsNullOrEmpty(txtTaskNotes.Text))
{
MessageBox.Show("Please enter the task notes");
return;
}
try
{
FacilityTask facilityTask = new FacilityTask
{
FacilityTaskName = txtTaskName.Text,
UserID = Int32.Parse(txtUserID.Text),
StartDate = (DateTime)cndStartDate.SelectedDate,
CompletionDate = (DateTime)cndStartDate.SelectedDate,
FacilityTaskNotes = txtTaskNotes.Text
};
if (_facilityTaskManager.AddFacilityTaskRecord(facilityTask))
{
MessageBox.Show("Facility Task record successfully added.");
canAddFacilityTask.Visibility = Visibility.Hidden;
canViewFacilityTask.Visibility = Visibility.Visible;
RefreshViewAllList();
txtUserID.Text = "";
txtTaskName.Text = "";
txtTaskNotes.Text = "";
}
else
{
MessageBox.Show("Facility Task record was not added.");
}
}
catch (Exception ex)
{
WPFErrorHandler.ErrorMessage(ex.Message, "Save");
}
}
/// <summary>
/// Creator: Carl Davis
/// Created: 4/9/2020
/// Approver: Ben Hanna, 4/10/20
/// Approver:
///
/// Method to select FacilityTask Records by userID
/// </summary>
/// <remarks>
/// Updater:
/// Updated:
/// Update:
/// </remarks>
/// <param name="userID"></param>
/// <param name="taskCompleted"></param>
/// <returns>List<FacilityTask></returns>
public List <FacilityTask> SelectFacilityTaskByUserID(int userID, bool taskCompleted = false)
{
List <FacilityTask> facilityTasks = new List <FacilityTask>();
// get a connection
var conn = DBConnection.GetConnection();
// create a sql command
var cmd = new SqlCommand("sp_select_facility_task_by_user_id", conn);
// set the command type
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserID", userID);
cmd.Parameters.AddWithValue("@TaskCompleted", taskCompleted);
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 facilityTask = new FacilityTask();
facilityTask.FacilityTaskID = reader.GetInt32(0);
facilityTask.FacilityTaskName = reader.GetString(1);
facilityTask.UserID = reader.GetInt32(2);
facilityTask.StartDate = reader.GetDateTime(3);
facilityTask.CompletionDate = reader.GetDateTime(4);
facilityTask.FacilityTaskNotes = reader.GetString(5);
facilityTask.TaskCompleted = reader.GetBoolean(6);
facilityTasks.Add(facilityTask);
}
}
// closes the reader
reader.Close();
}
catch (Exception ex)
{
throw ex;
}
finally
{
// close connection
conn.Close();
}
return(facilityTasks);
}
/// <summary>
/// Creator: Carl Davis
/// Created: 4/16/2020
/// Approver: Daulton Schiling, 4/16/2020
///
/// Method to update a facility task record
/// </summary>
/// <remarks>
/// Updater:
/// Updated:
/// Update:
/// </remarks>
/// <param name="oldFacilityTask"></param>
/// <param name="newFacilityTask"></param>
/// <returns>1 or 0 int depending if record was updated</returns>
public int UpdateFacilityTask(FacilityTask oldFacilityTask, FacilityTask newFacilityTask)
{
int result = 0;
var conn = DBConnection.GetConnection();
var cmd = new SqlCommand("sp_update_facility_task", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@FacilityTaskID", oldFacilityTask.FacilityTaskID);
cmd.Parameters.AddWithValue("@OldFacilityTaskName", oldFacilityTask.FacilityTaskName);
cmd.Parameters.AddWithValue("@OldUserID", oldFacilityTask.UserID);
cmd.Parameters.AddWithValue("@OldStartDate", oldFacilityTask.StartDate);
cmd.Parameters.AddWithValue("@OldCompletionDate", oldFacilityTask.CompletionDate);
cmd.Parameters.AddWithValue("@OldFacilityTaskNotes", oldFacilityTask.FacilityTaskNotes);
cmd.Parameters.AddWithValue("@OldTaskCompleted", oldFacilityTask.TaskCompleted);
cmd.Parameters.AddWithValue("@NewFacilityTaskName", newFacilityTask.FacilityTaskName);
cmd.Parameters.AddWithValue("@NewUserID", newFacilityTask.UserID);
cmd.Parameters.AddWithValue("@NewStartDate", newFacilityTask.StartDate);
cmd.Parameters.AddWithValue("@NewCompletionDate", newFacilityTask.CompletionDate);
cmd.Parameters.AddWithValue("@NewFacilityTaskNotes", newFacilityTask.FacilityTaskNotes);
cmd.Parameters.AddWithValue("@NewTaskCompleted", newFacilityTask.TaskCompleted);
try
{
conn.Open();
result = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(result);
}
/// <summary>
/// Creator: Carl Davis
/// Created: 4/16/2020
/// Approver: Daulton Schiling, 4/16/2020
///
/// Method to update a fake facility task record
/// </summary>
/// <remarks>
/// Updater:
/// Updated:
/// Update:
/// </remarks>
/// <param name="oldFacilityTask"></param>
/// <param name="newFacilityTask"></param>
/// <returns>1 or 0 int depending if record was updated</returns>
public int UpdateFacilityTask(FacilityTask oldFacilityTask, FacilityTask newFacilityTask)
{
oldFacilityTask = newFacilityTask;
if (oldFacilityTask.Equals(newFacilityTask))
{
return(1);
}
else
{
return(0);
}
}
/// <summary>
/// Creator: Carl Davis
/// Created: 4/9/2020
/// Approver: Ben Hanna, 4/10/20
/// Approver:
///
/// Method to insert a fake FacilityTask Record
/// </summary>
/// <remarks>
/// Updater:
/// Updated:
/// Update:
/// </remarks>
/// <param name="facilityTask"></param>
/// <returns>1 or 0 int depending if record was added</returns>
public int InsertFacilityTaskRecord(FacilityTask facilityTask)
{
DateTime dateTime = new DateTime(2018, 7, 10, 7, 10, 24);
if (facilityTask.FacilityTaskID == 1000000 && facilityTask.FacilityTaskName == "Clean" && facilityTask.UserID == 100000 && facilityTask.StartDate == dateTime &&
facilityTask.CompletionDate == dateTime &&
facilityTask.TaskCompleted == false)
{
return(1);
}
else
{
return(0);
}
}
/// <summary>
/// Creator: Carl Davis
/// Created: 4/16/2020
/// Approver: Daulton Schiling, 4/16/2020
/// Approver:
///
/// Method to delete a fake facility task record
/// </summary>
/// <remarks>
/// Updater:
/// Updated:
/// Update:
/// </remarks>
/// <param name="facilityTaskID"></param>
/// <returns>int 1 or 0 depending if record was deleted</returns>
public int DeleteFacilityTask(int facilityTaskID)
{
if (facilityTaskID == facilityTask.FacilityTaskID)
{
facilityTask = null;
}
if (facilityTask == null)
{
return(1);
}
else
{
return(0);
}
}
/// <summary>
/// Creator: Carl Davis
/// Created: 4/9/2020
/// Approver: Ben Hanna, 4/10/20
/// Approver:
///
/// Method to add a FacilityTaskRecord
/// </summary>
/// <remarks>
/// Updater:
/// Updated:
/// Update:
/// </remarks>
/// <param name="facilityTask"></param>
/// <returns>true or false depending on if record was updated</returns>
public bool AddFacilityTaskRecord(FacilityTask facilityTask)
{
bool result = true;
try
{
result = 1 == _facilityTaskAccessor.InsertFacilityTaskRecord(facilityTask);
}
catch (Exception ex)
{
throw new ApplicationException("Failed to create record!", ex);
}
return(result);
}
/// <summary>
/// Creator: Carl Davis
/// Created: 4/16/2020
/// Approver: Daulton Schiling, 4/16/2020
///
/// Method to Edit a facility task record
/// </summary>
/// <remarks>
/// Updater:
/// Updated:
/// Update:
/// </remarks>
/// <param name="oldFacilityTask"></param>
/// <param name="newFacilityTask"></param>
/// <returns>bool depending if record was successfully updated</returns>
public bool EditFacilityTask(FacilityTask oldFacilityTask, FacilityTask newFacilityTask)
{
bool result = false;
try
{
result = 1 == _facilityTaskAccessor.UpdateFacilityTask(oldFacilityTask, newFacilityTask);
}
catch (Exception ex)
{
throw new ApplicationException("Update Task Record Failed!", ex);
}
return(result);
}
/// <summary>
/// Creator: Carl Davis
/// Created: 4/19/2020
/// Approver: Daulton Schiling, 4/16/2020
///
/// Submits the updated information to the database
/// </summary>
/// <remarks>
/// Updater:
/// Updated:
/// Update:
/// </remarks>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnDeleteFacilityTask_Click(object sender, RoutedEventArgs e)
{
selectedFacilityTask = (FacilityTask)dgFacilityTask.SelectedItem;
string caption = "";
if (MessageBox.Show("Are you sure you want to delete this record?", caption, MessageBoxButton.YesNo, MessageBoxImage.Warning) == MessageBoxResult.Yes)
{
try
{
_facilityTaskManager.DeleteFacilityTask(selectedFacilityTask.FacilityTaskID);
RefreshViewAllList();
MessageBox.Show("Maintenance record successfully deleted.");
}
catch (Exception ex)
{
WPFErrorHandler.ErrorMessage(ex.Message, "Update");
}
}
}
public void TestAddFacilityTaskRecord()
{
// arrange
FacilityTask facilityTask = new FacilityTask()
{
FacilityTaskID = 1000000,
FacilityTaskName = "Clean",
UserID = 100000,
StartDate = new DateTime(2018, 7, 10, 7, 10, 24),
CompletionDate = new DateTime(2018, 7, 10, 7, 10, 24),
TaskCompleted = false
};
bool result = false;
// act
result = _facilityTaskManager.AddFacilityTaskRecord(facilityTask);
// assert
Assert.IsTrue(result);
}
public void TestDeleteFacilityTask()
{
// arrange
FacilityTask taskRecord = new FacilityTask()
{
FacilityTaskID = 1000003,
FacilityTaskName = "Break",
UserID = 100001,
StartDate = new DateTime(2018, 7, 10, 7, 10, 24),
CompletionDate = new DateTime(2018, 7, 10, 7, 10, 24),
TaskCompleted = false
};
bool result = false;
// act
result = _facilityTaskManager.DeleteFacilityTask(taskRecord.FacilityTaskID);
// assert
Assert.IsTrue(result);
}
/// <summary>
/// Creator: Carl Davis
/// Created: 4/16/2020
/// Approver: Daulton Schiling, 4/16/2020
///
/// brings up update window
/// </summary>
/// <remarks>
/// Updater:
/// Updated:
/// Update:
/// </remarks>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgFacilityTask_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
txtUserID.Text = _user.PUUserID.ToString();
selectedFacilityTask = (FacilityTask)dgFacilityTask.SelectedItem;
cndStartDate.DisplayDateStart = DateTime.Now;
cndCompletionDate.DisplayDateStart = DateTime.Now;
if (selectedFacilityTask != null)
{
BtnSubmitTaskRecord.Visibility = Visibility.Hidden;
canViewFacilityTask.Visibility = Visibility.Hidden;
canAddFacilityTask.Visibility = Visibility.Visible;
btnUpdateFacilityTaskRecord.Visibility = Visibility.Visible;
lblTaskFinished.Visibility = Visibility.Visible;
chkTaskFinished.Visibility = Visibility.Visible;
lblFacilityTask.Content = "Update Facility Task Record";
txtUserID.Text = selectedFacilityTask.UserID.ToString();
txtTaskName.Text = selectedFacilityTask.FacilityTaskName;
txtTaskNotes.Text = selectedFacilityTask.FacilityTaskNotes;
cndStartDate.SelectedDate = selectedFacilityTask.StartDate;
cndCompletionDate.SelectedDate = selectedFacilityTask.CompletionDate;
chkTaskFinished.IsChecked = selectedFacilityTask.TaskCompleted;
}
}