/// <summary>
/// Creator: Carl Davis
/// Created: 3/30/2020
/// Approver: Ethan Murphy 4/3/2020
///
/// Method to update a facility inspection item record
/// </summary>
/// <remarks>
/// Updater:
/// Updated:
/// Update:
/// </remarks>
/// <param name="oldFacilityInspectionItem"></param>
/// <param name="newFacilityInspectionItem"></param>
/// <returns>1 or 0 int depending if record was updated</returns>
public int UpdateFacilityInspectionItem(FacilityInspectionItem oldFacilityInspectionItem, FacilityInspectionItem newFacilityInspectionItem)
{
int result = 0;
var conn = DBConnection.GetConnection();
var cmd = new SqlCommand("sp_update_facility_inspection_item", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@FacilityInspectionItemID", oldFacilityInspectionItem.FacilityInspectionItemID);
cmd.Parameters.AddWithValue("@OldItemName", oldFacilityInspectionItem.ItemName);
cmd.Parameters.AddWithValue("@OldUserID", oldFacilityInspectionItem.UserID);
cmd.Parameters.AddWithValue("@OldFacilityInspectionID", oldFacilityInspectionItem.FacilityInpectionID);
cmd.Parameters.AddWithValue("@OldItemDescription", oldFacilityInspectionItem.ItemDescription);
cmd.Parameters.AddWithValue("@NewItemName", newFacilityInspectionItem.ItemName);
cmd.Parameters.AddWithValue("@NewUserID", newFacilityInspectionItem.UserID);
cmd.Parameters.AddWithValue("@NewFacilityInspectionID", newFacilityInspectionItem.FacilityInpectionID);
cmd.Parameters.AddWithValue("@NewItemDescription", newFacilityInspectionItem.ItemDescription);
try
{
conn.Open();
result = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(result);
}
public void TestAddFacilityInspectionItemRecord()
{
// arrange
FacilityInspectionItem facilityInspectionItem = new FacilityInspectionItem()
{
FacilityInspectionItemID = 1000000,
ItemName = "Pen",
UserID = 100000,
FacilityInpectionID = 1000000,
ItemDescription = "To fill out reports"
};
bool result = false;
// act
result = _facilityInspectionItemManager.AddFacilityInspectionItemRecord(facilityInspectionItem);
// assert
Assert.IsTrue(result);
}
/// <summary>
/// Creator: Carl Davis
/// Created: 3/30/2020
/// Approver: Ethan Murphy, 4/3/2020
///
/// Method to test update a facility inspection item record
/// </summary>
/// <remarks>
/// Updater:
/// Updated:
/// Update:
/// </remarks>
/// <param name="oldFacilityInspectionItem"></param>
/// <param name="newFacilityInspectionItem"></param>
/// <returns>1 or 0 int depending if record was updated</returns>
public int UpdateFacilityInspectionItem(FacilityInspectionItem oldFacilityInspectionItem, FacilityInspectionItem newFacilityInspectionItem)
{
int result;
oldFacilityInspectionItem = newFacilityInspectionItem;
if (oldFacilityInspectionItem.Equals(newFacilityInspectionItem))
{
result = 1;
}
else
{
result = 0;
}
return(result);
}
/// <summary>
/// Creator: Carl Davis
/// Created: 3/30/2020
/// Approver: Ethan Murphy 4/3/2020
///
/// Method to Edit a facility inspection item record
/// </summary>
/// <remarks>
/// Updater:
/// Updated:
/// Update:
/// </remarks>
/// <param name="oldFacilityInspectionItem"></param>
/// <param name="newFacilityInspectionItem"></param>
/// <returns>bool depending if record was successfully updated</returns>
public bool EditFacilityInspectionItem(FacilityInspectionItem oldFacilityInspectionItem, FacilityInspectionItem newFacilityInspectionItem)
{
bool result = false;
try
{
result = 1 == _facilityInspectionItemAccessor.UpdateFacilityInspectionItem(oldFacilityInspectionItem, newFacilityInspectionItem);
}
catch (Exception ex)
{
throw new ApplicationException("Update Inspection Item Record Failed!", ex);
}
return(result);
}
