/// <summary> /// Method to retrieve orders information /// </summary> /// <returns>All orders</returns> public List <OrderInfo> GetOrders() { List <OrderInfo> orders = new List <OrderInfo>(); try { //Execute a query to read the orders using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SqlText.SQL_SELECT_ORDER_GETORDERS, null)) { while (rdr.Read()) { OrderInfo order = new OrderInfo(); order.LscID = ComUtility.DBNullInt32Handler(rdr["LscID"]); order.TargetID = ComUtility.DBNullInt32Handler(rdr["TargetID"]); order.TargetType = ComUtility.DBNullNodeTypeHandler(rdr["TargetType"]); order.OrderType = ComUtility.DBNullActTypeHandler(rdr["OrderType"]); order.RelValue1 = ComUtility.DBNullStringHandler(rdr["RelValue1"]); order.RelValue2 = ComUtility.DBNullStringHandler(rdr["RelValue2"]); order.RelValue3 = ComUtility.DBNullStringHandler(rdr["RelValue3"]); order.RelValue4 = ComUtility.DBNullStringHandler(rdr["RelValue4"]); order.RelValue5 = ComUtility.DBNullStringHandler(rdr["RelValue5"]); order.UpdateTime = ComUtility.DBNullDateTimeHandler(rdr["UpdateTime"]); orders.Add(order); } } return(orders); } catch { throw; } }