/// <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); } } } }