/// <summary>
/// Author: Dalton Cleveland
/// Created : 3/5/2019
/// RetrieveAllMaintenanceStatusTypes will select all of the MaintenanceStatusTypes from our Database
/// </summary>
public List <MaintenanceStatusType> RetrieveAllMaintenanceStatusTypes()
{
List <MaintenanceStatusType> maintenanceStatusTypes = new List <MaintenanceStatusType>();
var conn = DBConnection.GetDbConnection();
// command text
string cmdText2 = @"sp_retrieve_maintenance_status_types";
// command objects
var cmd2 = new SqlCommand(cmdText2, conn);
// set the command type
cmd2.CommandType = CommandType.StoredProcedure;
try
{
conn.Open();
SqlDataReader reader2 = cmd2.ExecuteReader();
if (reader2.HasRows)
{
while (reader2.Read())
{
MaintenanceStatusType maintenanceStatusType = new MaintenanceStatusType();
maintenanceStatusType.MaintenanceStatusID = reader2.GetString(0);
maintenanceStatusType.Description = reader2.GetString(1);
maintenanceStatusTypes.Add(maintenanceStatusType);
}
}
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
}
return(maintenanceStatusTypes);
}
public void DeleteMaintenanceStatusType(MaintenanceStatusType deletedMaintenanceStatusType)
{
throw new NotImplementedException();
}
public void CreateMaintenanceStatusType(MaintenanceStatusType newMaintenanceStatusType)
{
throw new NotImplementedException();
}
