public void LoadOrder() { int ID = EnterData.IDOrder(); order = DBWork.LoadOrder(ID); Show.ShowOrder(order); }
public void CreateOrder() { int who = EnterData.ChoiceCustomer(); order = ReturnTypeOrder(who == 1); GoMethod(); EnterData.EnterDataOrder(order); //Изменяем общую сумму заказа order.Process(); DBWork.InsertOrderInDB(order); Show.ShowOrder(order); }
public void UpdateOrder() { int ID = EnterData.IDOrder(); order = DBWork.LoadOrder(ID); if (order != null) { Console.WriteLine("Новые данные заказа\n"); order = ReturnTypeOrder(!order.IDSupplier.IsNull); GoMethod(); EnterData.EnterDataOrder(order); //Изменяем общую сумму заказа order.Process(); order.IDOrder = ID; DBWork.UpdateOrder(order); } Show.ShowOrder(order); }
public static Order CreateOrderFromBuyer(OrderFromBuyer order) { using (SqlConnection sqlConnection = new SqlConnection(connectionString)) { sqlConnection.Open(); SqlCommand sqlCommand = null; SqlDataReader sqlDataReader = null; Console.WriteLine("Выберите ID Клиента, на которого следует оформить заказ"); order.IDClient = (SqlInt32)(int.Parse(Console.ReadLine())); string sqlQuery = String.Format("Select * From dbo.Client Where IDClient =" + order.IDClient); sqlCommand = new SqlCommand(sqlQuery, sqlConnection); sqlDataReader = sqlCommand.ExecuteReader(); if (!sqlDataReader.HasRows) { Console.WriteLine("Такого клиента нет в базе данных. Добавим.\n"); EnterData.EnterDataClient(order); sqlDataReader.Close(); sqlCommand = new SqlCommand(); sqlCommand.Connection = sqlConnection; sqlCommand.CommandText = @"INSERT INTO Client (Name, Adress) VALUES ('" + order.NameClient + "','" + order.AdressClient + "');"; sqlCommand.ExecuteNonQuery(); sqlQuery = String.Format("SELECT Top 1 * FROM OrderDB.dbo.Client ORDER BY IDClient DESC;"); sqlCommand = new SqlCommand(sqlQuery, sqlConnection); sqlDataReader = sqlCommand.ExecuteReader(); while (sqlDataReader.Read()) { order.IDClient = sqlDataReader.GetInt32(0); } } sqlDataReader.Close(); } return(order); }
public static Order CreateOrderToTheSupplier(OrderToTheSupplier order) { using (SqlConnection sqlConnection = new SqlConnection(connectionString)) { sqlConnection.Open(); SqlCommand sqlCommand = null; SqlDataReader sqlDataReader = null; Console.WriteLine("ID Поставщика"); order.IDSupplier = (SqlInt32)(int.Parse(Console.ReadLine())); string sqlQuery = String.Format("Select * From dbo.Supplier Where IDSupplier =" + order.IDSupplier); sqlCommand = new SqlCommand(sqlQuery, sqlConnection); sqlDataReader = sqlCommand.ExecuteReader(); if (!sqlDataReader.HasRows) { Console.WriteLine("Такого поставщика нет в Базе Данных. Добавим.\n"); EnterData.EnterDataSupplier(order); sqlDataReader.Close(); sqlCommand = new SqlCommand(); sqlCommand.Connection = sqlConnection; sqlCommand.CommandText = @"INSERT INTO Supplier (INN, PhysicalAddress, LegalAddress) VALUES (" + order.INN + ",'" + order.PhysicalAdress + "','" + order.LegalAdress + "');"; sqlCommand.ExecuteNonQuery(); sqlQuery = String.Format("SELECT Top 1 * FROM OrderDB.dbo.Supplier ORDER BY IDSupplier DESC;"); sqlCommand = new SqlCommand(sqlQuery, sqlConnection); sqlDataReader = sqlCommand.ExecuteReader(); while (sqlDataReader.Read()) { order.IDSupplier = sqlDataReader.GetInt32(0); } } sqlDataReader.Close(); } return(order); }