Exemplo n.º 1
0
        private void check_employees()
        {
            SqlConnection sqlConnection = new SqlConnection(@"Data Source=LIPGIPROMEZ\PROJECTMANAGER;Initial Catalog=InventAuto;Integrated Security=True");
            SqlCommand    cmd           = new SqlCommand();

            cmd.CommandType = CommandType.Text;
            cmd.CommandText = "SELECT COUNT(Emp_ID) FROM Employees WHERE Emp_ID = '" + txt_ID.Text + "'";
            cmd.Connection  = sqlConnection;
            sqlConnection.Open();
            //cmd.ExecuteNonQuery();
            SqlDataReader rd = cmd.ExecuteReader();

            while (rd.Read())
            {
                if (rd.GetInt32(0) == 0)
                {
                    emp.status = 0;
                }
                else
                {
                    button3.Visible = true;
                    label8.Visible  = false;
                    label9.Visible  = false;
                    MessageBox.Show("Предупреждение! \n Данное рабочее место уже заведено!");
                    emp.status   = 3;
                    this.TopMost = false;
                    Emp_desicion ed = new Emp_desicion();
                    ed.ShowDialog();
                }
            }
            rd.Close();
            sqlConnection.Close();
        }
Exemplo n.º 2
0
        private void Button3_Click(object sender, EventArgs e)
        {
            this.TopMost = false;
            Emp_desicion ed = new Emp_desicion();

            ed.ShowDialog();
        }