public List<Desk> GetAllDesks()
{
List<Desk> deskList = new List<Desk>();
SqlConnection connection = new SqlConnection(_connectionString);
string commandString = "EXEC dbo.spDesk_GetAllDesks";
SqlCommand command = new SqlCommand(commandString);
try
{
command.Connection = connection;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
SqlToDeskModelFactory DeskFactory = new SqlToDeskModelFactory(reader);
deskList = DeskFactory.GetAllDesks();
connection.Close();
return deskList;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
/// <summary>
/// Function to query the database for
/// desks on a particular floor
/// </summary>
public List<Desk> GetDesksFromFloor(int floor)
{
List<Desk> deskList = new List<Desk>();
SqlConnection connection = new SqlConnection(_connectionString);
string commandString = "EXEC dbo.spDesk_GetDesksByFloor @FloorNumber = @floor";
SqlCommand command = new SqlCommand(commandString);
try
{
command.Parameters.AddWithValue("@floor", floor);
command.Connection = connection;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
SqlToDeskModelFactory DeskFactory = new SqlToDeskModelFactory(reader);
deskList = DeskFactory.GetAllDesks(floor);
connection.Close();
return deskList;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}