try
{
Int32 InputedName = 1;
Int32 GetID = 0;
sqlConnection = new SqlConnection(myCon);
sqlConnection.Open();
SqlCommand Name = new SqlCommand("SELECT * FROM Users WHERE Name like '" + textBox5.Text + "'", sqlConnection);
SqlDataReader dr;
dr = Name.ExecuteReader();
while (dr.Read())
{
InputedName = dr.GetInt32(0);
}
dr.Close();
dr.Dispose();
SqlCommand cmd = new SqlCommand("Insert Into Request (id_user, Room, Phone, Comment) Values(@id_user, @Room, @Phone, @Comment)", sqlConnection);
cmd.Parameters.AddWithValue("@id_user", InputedName);
cmd.Parameters.AddWithValue("@Room", textBox6.Text);
cmd.Parameters.AddWithValue("@Phone", textBox4.Text);
cmd.Parameters.AddWithValue("@Comment", textBox3.Text);
//GetID = Convert.ToInt32(cmd.ExecuteScalar());
SqlCommand LID = new SqlCommand("SELECT MAX(id) FROM Request", sqlConnection);
SqlDataReader dr1;
dr1 = LID.ExecuteReader();
while (dr1.Read())
{
GetID = dr1.GetInt32(0);
}
dr1.Close();
dr1.Dispose();
SqlCommand cmd1 = new SqlCommand("Insert Into Req_mov (id, Mov_Comment, Time, id_spec, id_type, id_status, id_priority) Values(@id, @Mov_Comment, @Time, @id_spec, @id_type, @id_status, @id_priority)", sqlConnection);
cmd1.Parameters.AddWithValue("id", GetID);
cmd1.Parameters.AddWithValue("Mov_Comment", "Создание заявки");
cmd1.Parameters.AddWithValue("id_spec", 1);
cmd1.Parameters.AddWithValue("id_type", comboBox4.SelectedValue);
cmd1.Parameters.AddWithValue("id_status", 1);
cmd1.Parameters.AddWithValue("id_prirortiy", comboBox5.SelectedValue);
MessageBox.Show("Заявка отправлена, ваш номер заявки :"+GetID.ToString());
sqlConnection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error);
}