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