public static void UpdateOrder()

in Source/Website/Data_Layer/OrdersData.cs [95:125]


        public static void UpdateOrder(Order order)
        {
            var query = @"UPDATE ORDERS
                                SET Code = @Code
                                ,Date = @Date
                                ,Type = @Type
                                ,ItemName = @ItemName
                                ,Status = @Status
                                ,Total = @Total
                            WHERE OrderId = @OrderId";
            
            var parameters = new SqlParameter[]
            {
                new SqlParameter("@Code", order.Code),
                new SqlParameter("@Date", order.Date),
                new SqlParameter("@Type", order.Type),
                new SqlParameter("@ItemName", order.ItemName),
                new SqlParameter("@Status", order.Status),
                new SqlParameter("@Total", order.Total),
                new SqlParameter("@OrderId", order.OrderId)
            };

            try
            {
                DataAccessHandler.ExecuteNonSelect(query, parameters);
            }
            catch (Exception e)
            {
                throw e;
            }
        }