/// <summary>
/// Metode til at læse et objekt.
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
private static BoxCalRequest ReadRequest(IDataRecord reader)
{
string request = reader.GetString(0);
double volume = reader.GetDouble(1);
double length = reader.GetDouble(2);
double width = reader.GetDouble(3);
double height = reader.GetDouble(4);
BoxCalRequest req = new BoxCalRequest()
{
Request = request,
Volume = volume,
Length = length,
Width = width,
Height = height,
};
return(req);
}
/// <summary>
/// Metode som henter alle udregninger i azure tabel.
/// </summary>
/// <returns></returns>
public IList <BoxCalRequest> GetAllRequest()
{
const string selectAllRequests = "select * from boxcalrequest order by request";
using (SqlConnection databaseConnection = new SqlConnection(connectionString))
{
databaseConnection.Open();
using (SqlCommand selectCommand = new SqlCommand(selectAllRequests, databaseConnection))
{
using (SqlDataReader reader = selectCommand.ExecuteReader())
{
List <BoxCalRequest> requestList = new List <BoxCalRequest>();
while (reader.Read())
{
BoxCalRequest requests = ReadRequest(reader);
requestList.Add(requests);
}
return(requestList);
}
}
}
}
