static public Order EnterDataSupplier(OrderToTheSupplier order) { Console.WriteLine("Введите ИНН поставщика."); order.INN = int.Parse(Console.ReadLine()); Console.WriteLine("Физический адрес"); order.PhysicalAdress = Console.ReadLine(); Console.WriteLine("Юридический адрес"); order.LegalAdress = Console.ReadLine(); return(order); }
private Order ReturnTypeOrder(bool b) { Order ord = null; if (b) { ord = new OrderFromBuyer(); } else { ord = new OrderToTheSupplier(); } return(ord); }
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); }
/// <summary> /// Выгружает из БД заказ с номером заказа, если такой есть /// </summary> public static Order LoadOrder(int ID) { Order order = null; using (SqlConnection sqlConnection = new SqlConnection(connectionString)) { sqlConnection.Open(); SqlParameter sqlParameter = new SqlParameter("@idOrder", System.Data.SqlDbType.Int); sqlParameter.Value = ID; string sqlQuery = String.Format("Select IDOrder,DocNumber,TotalAmountOrder,IDClient,Status,IDSupplier From dbo.OrderTable Where IDOrder = @idOrder"); SqlCommand sqlCommand = new SqlCommand(sqlQuery, sqlConnection); sqlCommand.Parameters.Add(sqlParameter); SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(); while (sqlDataReader.Read()) { if (sqlDataReader.IsDBNull(5) && sqlDataReader.IsDBNull(3)) { throw new Exception("Столбцы IDSupplier и IDClient одновременно не могут быть null"); } else if (sqlDataReader.IsDBNull(5)) { order = new OrderFromBuyer(); } else if (sqlDataReader.IsDBNull(3)) { order = new OrderToTheSupplier(); } order.IDOrder = sqlDataReader.GetInt32(0); order.DocNumber = sqlDataReader.GetInt32(1); order.TotalAmountOrder = sqlDataReader.GetSqlMoney(2); order.IDClient = sqlDataReader.GetInt32(3); order.Status = sqlDataReader.GetString(4); order.IDSupplier = sqlDataReader.GetSqlInt32(5); } } return(order); }