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