示例#1
0
        public ActionResult CheckAddNewOrder(Task11.NewOrderClass newOrder)
        {
            int checkID;

            checkID = _newDal.AddOrder(newOrder);
            return(View(checkID));
        }
示例#2
0
        public int AddOrder(NewOrderClass NewOrder)
        {
            using (var connection = new SqlConnection(ConnectionString))
            {
                int OrderID = 0;

                var command1 = new SqlCommand(
                    "INSERT INTO Northwind.Orders (Freight,OrderDate,ShippedDate) VALUES (@Freight,@OrderDate,@ShippedDate)", connection);

                var command2 = new SqlCommand("SELECT OrderID FROM Northwind.Orders WHERE OrderID = (SELECT MAX(OrderID) FROM Northwind.Orders)", connection);



                command1.Parameters.AddWithValue("@Freight", NewOrder.Freight);
                if (NewOrder.OrderDate == DateTime.MinValue)
                {
                    command1.Parameters.AddWithValue("@OrderDate", DBNull.Value);
                }
                else
                {
                    command1.Parameters.AddWithValue("@OrderDate", NewOrder.OrderDate);
                }
                if (NewOrder.ShippedDate == DateTime.MinValue)
                {
                    command1.Parameters.AddWithValue("@ShippedDate", DBNull.Value);
                }
                else
                {
                    command1.Parameters.AddWithValue("@ShippedDate", NewOrder.ShippedDate);
                }

                connection.Open();

                bool check = (command1.ExecuteNonQuery() == 1);

                if (check)
                {
                    using (var reader = command2.ExecuteReader())
                    {
                        while (reader.Read())
                        {
                            OrderID = reader.GetInt32(0);
                        }
                    }
                }

                return(OrderID);
            }
        }
示例#3
0
文件: DAL.cs 项目: Laetar/Epam
        public int AddOrder(NewOrderClass NewOrder)
        {
            using (var connection = new SqlConnection(ConnectionString))
            {
                int OrderID = 0;

                var command1 = new SqlCommand(
                    "INSERT INTO Northwind.Orders (Freight,OrderDate,ShippedDate) VALUES (@Freight,@OrderDate,@ShippedDate)", connection);

                var command2 = new SqlCommand("SELECT OrderID FROM Northwind.Orders WHERE OrderID = (SELECT MAX(OrderID) FROM Northwind.Orders)", connection);

                command1.Parameters.AddWithValue("@Freight", NewOrder.Freight);
                if (NewOrder.OrderDate == DateTime.MinValue)
                    command1.Parameters.AddWithValue("@OrderDate", DBNull.Value);
                else command1.Parameters.AddWithValue("@OrderDate", NewOrder.OrderDate);
                if (NewOrder.ShippedDate == DateTime.MinValue)
                    command1.Parameters.AddWithValue("@ShippedDate", DBNull.Value);
                else
                    command1.Parameters.AddWithValue("@ShippedDate", NewOrder.ShippedDate);

                connection.Open();

                bool check = (command1.ExecuteNonQuery() == 1);

                if (check)
                {
                    using (var reader = command2.ExecuteReader())
                    {
                        while (reader.Read())
                        {
                            OrderID = reader.GetInt32(0);
                        }
                    }
                }

                return OrderID;
            }
        }