private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text.Trim() == "" ||
textBox2.Text.Trim() == "" ||
textBox3.Text.Trim() == "" ||
textBox4.Text.Trim() == "" ||
maskedTextBox1.Text.Trim() == "" ||
maskedTextBox2.Text.Trim() == "")
{
MessageBox.Show("Не все поля заплненны!");
}
else
{
SqlConnection conn = new SqlConnection(Program.st_connect);
conn.Open();
string s1 = "Select * from Service where ID_Service='" + textBox1.Text.Trim() + "'";
SqlCommand comm1 = new SqlCommand(s1, conn);
SqlDataReader read1 = comm1.ExecuteReader();
if (read1.HasRows)
{
MessageBox.Show("Логин занят!");
}
else
{
read1.Close();
string s = "insert into Service (ID_Uslugi,ID_Users,ID_Instructor,Price,Start_Time,End_Time) Values" +
"('" + textBox1.Text.Trim() + "'," +
"' " + textBox2.Text.Trim() + "'," +
"' " + textBox3.Text.Trim() + "'," +
"' " + textBox4.Text.Trim() + "'," +
"' " + maskedTextBox1.Text.Trim() + "'," +
"' " + maskedTextBox2.Text.Trim() + "')";
SqlCommand comm = new SqlCommand(s, conn);
comm.ExecuteScalar();
this.Close();
Form10 f = new Form10();
f.Show();
}
conn.Close();
}
}
private void button2_Click(object sender, EventArgs e)
{
int k = dataGridView1.CurrentRow.Index;
int ID_Service = Convert.ToInt32(dataGridView1[0, k].Value);
SqlConnection conn = new SqlConnection(Program.st_connect);
conn.Open();
string s = "DELETE FROM Service WHERE ID_Service=" + ID_Service.ToString();
SqlCommand comm = new SqlCommand(s, conn);
comm.ExecuteScalar();
conn.Close();
this.Close();
Form10 f = new Form10();
f.Show();
}
private void button9_Click(object sender, EventArgs e)
{
Form10 f = new Form10();
f.Show();
}