public static void AddOrder()

in Source/Website/Data_Layer/OrdersData.cs [57:93]


        public static void AddOrder(Order order)
        {
            var query = @"INSERT INTO ORDERS
                                ([Code]
                                ,[Date]
                                ,[Type]
                                ,[ItemName]
                                ,[Status]
                                ,[Total])
                            VALUES
                                (@Code
                                ,@Date
                                ,@Type
                                ,@ItemName
                                ,@Status
                                ,@Total)";
                            

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

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