public OrderModel ToOrder(OrderDetails orderDetails) { OrderModel order = new OrderModel(); order.CustomerID = this.CustomerID; order.OrderDate = this.OrderDate; order.OrderStatus = orderDetails.OrderStatus; order.OrderType = orderDetails.OrderType; order.OrderValue = orderDetails.OrderValue; return order; }
OrderModel SelectDuplicateOrder(string orderValue) { OrderModel order = null; using (SqlConnection connection = new SqlConnection(connectionString)) { string commandText = "SELECT TOP 1 * FROM Orders WHERE OrderValue=@orderValue"; SqlCommand command = new SqlCommand(commandText); command.CommandType = CommandType.Text; command.Connection = connection; command.Parameters.AddWithValue("@orderValue", orderValue); connection.Open(); using (SqlDataReader dataReader = command.ExecuteReader()) { while (dataReader.Read()) { order = new OrderModel(); order.OrderID = Convert.ToInt64(dataReader["OrderID"]); order.CustomerID = Convert.ToInt32(dataReader["CustomerID"]); order.DateTimeAdded = Convert.ToDateTime(dataReader["DateTimeAdded"]); order.DateTimeUpdated = Convert.ToDateTime(dataReader["DateTimeUpdated"]); order.OrderDate = Convert.ToDateTime(dataReader["OrderDate"]); order.OrderStatus = Convert.ToInt32(dataReader["OrderStatus"]); order.OrderType = Convert.ToInt32(dataReader["OrderType"]); order.OrderValue = dataReader["OrderValue"].ToString(); } } } return order; }
void InsertOrderRecord(OrderModel order) { using (SqlConnection connection = new SqlConnection(connectionString)) { string commandText = "INSERT INTO Orders (CustomerID, OrderDate, OrderValue, OrderStatus, OrderType) VALUES (@CustomerID, @OrderDate, @OrderValue, @OrderStatus, @OrderType)"; SqlCommand command = new SqlCommand(commandText); command.CommandType = CommandType.Text; command.Connection = connection; command.Parameters.AddWithValue("@CustomerID", order.CustomerID); command.Parameters.AddWithValue("@OrderDate", order.OrderDate); command.Parameters.AddWithValue("@OrderValue", order.OrderValue); command.Parameters.AddWithValue("@OrderStatus", order.OrderStatus); command.Parameters.AddWithValue("@OrderType", order.OrderType); connection.Open(); command.ExecuteNonQuery(); } }
void LoadOrdersFromDB() { ordersFromDBRows.Clear(); LinkedList<OrderModel> loadedList = new LinkedList<OrderModel>(); if (CheckConnection()) { using (SqlConnection connection = new SqlConnection(connectionString)) { string commandText = "SELECT * FROM Orders"; SqlCommand command = new SqlCommand(commandText); command.CommandType = CommandType.Text; command.Connection = connection; connection.Open(); using (SqlDataReader dataReader = command.ExecuteReader()) { while (dataReader.Read()) { OrderModel order = new OrderModel(); order.OrderID = Convert.ToInt64(dataReader["OrderID"]); order.CustomerID = Convert.ToInt32(dataReader["CustomerID"]); order.DateTimeAdded = Convert.ToDateTime(dataReader["DateTimeAdded"]); order.DateTimeUpdated = Convert.ToDateTime(dataReader["DateTimeUpdated"]); order.OrderDate = Convert.ToDateTime(dataReader["OrderDate"]); order.OrderStatus = Convert.ToInt32(dataReader["OrderStatus"]); order.OrderType = Convert.ToInt32(dataReader["OrderType"]); order.OrderValue = dataReader["OrderValue"].ToString(); loadedList.AddLast(order); } } } ordersFromDBRows = loadedList; dgOrders.ItemsSource = loadedList; } }