/// <summary> /// We make a list of the orders avaiable and return the list /// </summary> /// <returns></returns> public List <OrderDO> ViewOrders() { List <OrderDO> orderList = new List <OrderDO>(); try { using (SqlConnection OrderConnection = new SqlConnection(_ConnectionString)) using (SqlCommand ViewOrders = new SqlCommand("VIEW_ORDER", OrderConnection)) { ViewOrders.CommandType = CommandType.StoredProcedure; OrderConnection.Open(); using (SqlDataReader sqlReader = ViewOrders.ExecuteReader()) { while (sqlReader.Read()) { OrderDO order = mapper.MapReadertoSingle(sqlReader); orderList.Add(order); } } } } catch (SqlException sqlex) { _Logger.ErrorLog(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, sqlex); } catch (Exception ex) { _Logger.ErrorLog(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, ex); } return(orderList); }