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