private async void button1_Click(object sender, EventArgs e)
{
DataBank.AddressApartment = textBox1.Text;
DataBank.ValueApartment = textBox2.Text;
DataBank.AreaApartment = textBox3.Text;
DataBank.RoomsApartment = textBox4.Text;
DataBank.FloorApartment = textBox5.Text;
DataBank.SqaureApartment = textBox6.Text;
InsertTransactionsClients insertTransactions = new InsertTransactionsClients(sqlConnection);
insertTransactions.Show();
SqlCommand insertApartmentsCommand = new SqlCommand("INSERT INTO [Apartments] (Address, Value, Area, Rooms, Floor, Sqaure) VALUES(@Address, @Value, @Area, @Rooms, @Floor, @Sqaure)", sqlConnection);
insertApartmentsCommand.Parameters.AddWithValue("Address", Convert.ToString(textBox1.Text));
insertApartmentsCommand.Parameters.AddWithValue("Value", Convert.ToDecimal(textBox2.Text));
insertApartmentsCommand.Parameters.AddWithValue("Area", Convert.ToString(textBox3.Text));
insertApartmentsCommand.Parameters.AddWithValue("Rooms", Convert.ToInt32(textBox4.Text));
insertApartmentsCommand.Parameters.AddWithValue("Floor", Convert.ToInt32(textBox5.Text));
insertApartmentsCommand.Parameters.AddWithValue("Sqaure", Convert.ToDecimal(textBox6.Text));
try
{
await insertApartmentsCommand.ExecuteNonQueryAsync();//выполняет действие, при этом не возвращая никаких данных
Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private async void button1_Click(object sender, EventArgs e)
{
DataBank.SNMClients = textBox1.Text + " " + textBox2.Text + " " + textBox3.Text;
DataBank.BudgetClients = textBox4.Text;
DataBank.AreaClients = textBox5.Text;
DataBank.RoomsClients = textBox6.Text;
DataBank.FloorClients = textBox7.Text;
DataBank.SqaureClients = textBox8.Text;
DataBank.EmailClients = textBox9.Text;
InsertTransactionsClients insertTransactions = new InsertTransactionsClients(sqlConnection);
insertTransactions.Show();
SqlCommand insertClientsCommand = new SqlCommand("INSERT INTO [Clients] (Surname, Name, MiddleName, Budget, Area, Rooms, Floor, Sqaure, Email) VALUES(@Surname, @Name, @MiddleName, @Budget, @Area, @Rooms, @Floor, @Sqaure, @Email)", sqlConnection);
insertClientsCommand.Parameters.AddWithValue("Surname", Convert.ToString(textBox1.Text));
insertClientsCommand.Parameters.AddWithValue("Name", Convert.ToString(textBox2.Text));
insertClientsCommand.Parameters.AddWithValue("Middlename", Convert.ToString(textBox3.Text));
insertClientsCommand.Parameters.AddWithValue("Budget", Convert.ToDecimal(textBox4.Text));
insertClientsCommand.Parameters.AddWithValue("Area", Convert.ToString(textBox5.Text));
insertClientsCommand.Parameters.AddWithValue("Rooms", Convert.ToInt32(textBox6.Text));
insertClientsCommand.Parameters.AddWithValue("Floor", Convert.ToInt32(textBox7.Text));
insertClientsCommand.Parameters.AddWithValue("Sqaure", Convert.ToDecimal(textBox8.Text));
insertClientsCommand.Parameters.AddWithValue("Email", Convert.ToString(textBox9.Text));
try
{
await insertClientsCommand.ExecuteNonQueryAsync();//выполняет действие, при этом не возвращая никаких данных
Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
