Ejemplo n.º 1
0
        private void button3_Click(object sender, EventArgs e)
        {
            DBActions.AddAccident(frmdescription.Text, repairCheck.Checked, Convert.ToDateTime(repairTime.Text));


            SqlConnection baglanti = new SqlConnection(connectionString);

            baglanti.Open();
            string arama = "SELECT  ID FROM  tblIncident WHERE  Description = @description";

            SqlCommand komut = new SqlCommand(arama, baglanti);

            komut.Parameters.AddWithValue("@description", frmdescription.Text);
            // komut.ExecuteNonQuery();

            SqlDataReader dr = komut.ExecuteReader();


            if (dr.Read())
            {
                textBox3.Text = dr["ID"].ToString();
            }
            else
            {
                MessageBox.Show("Arama TAMAMLANAMADI...");
            }

            // ResetScreen();
            baglanti.Close();
        }
Ejemplo n.º 2
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                DBActions.AddAccident(frmdescription.Text, repairCheck.Checked, Convert.ToDateTime(repairTime.Text));

                resetScreen();
                MessageBox.Show("GEÇMİŞ OLSUN");
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }