Пример #1
0
        private void حفظToolStripMenuItem_Click_1(object sender, EventArgs e)
        {
            if (textBox2.Text.Length == 0)
            {
                MessageBox.Show("قم بادخال كود الموظف");
            }
            try {
                string[]    s  = new string[] { "@x", "@y" };
                string[]    s2 = new string[] { textBox1.Text, textBox2.Text };
                SqlDbType[] s3 = new SqlDbType[] { SqlDbType.VarChar, SqlDbType.Int };
                con.ExecuteInsertOrUpdateOrDeleteUsingStoredProc("register_leaving_in", s, s2, s3);

                //  cmd = new SqlCommand("register_leaving_in ", con);
                //  cmd.CommandType = CommandType.StoredProcedure;
                //cmd.Parameters.AddWithValue("@x", textBox1.Text);
                //cmd.Parameters.AddWithValue("@y", textBox2.Text);
                //  cmd.ExecuteNonQuery();
                if (textBox2.Text.Length != 0)
                {
                    موافق f = new موافق();
                    f.Show();
                }
            }
            catch (Exception ee) {
                MessageBox.Show(ee.Message);
            }
        }
Пример #2
0
        //private void button1_Click(object sender, EventArgs e)
        //{
        //    cmd = new SqlCommand("select name as 'الاسم'from employee where emp_id=@x", con);
        //    cmd.Parameters.AddWithValue("@x", textBox1.Text);
        //    SqlDataReader dataReader = cmd.ExecuteReader();
        //    dataReader.Read();
        //    textBox2.Text = dataReader[0].ToString();
        //    dataReader.Close();
        //}

        private void button4_Click(object sender, EventArgs e)
        {
            try
            {
                if (textBox1.Text.Length == 0)
                {
                    MessageBox.Show("قم بادخال كود الموظف");
                }
                if (textBox1.Text.Length != 0 & comboBox2.Text.Length == 0)
                {
                    MessageBox.Show("قم باختيار نوع الاذن");
                }
                string[]    s  = new string[] { "@x", "@y" };
                string[]    s2 = new string[] { textBox1.Text, comboBox2.Text };
                SqlDbType[] s3 = new SqlDbType[] { SqlDbType.Int, SqlDbType.VarChar };
                con.ExecuteInsertOrUpdateOrDeleteUsingStoredProc("reg_permits_in", s, s2, s3);


                //cmd = new SqlCommand("reg_permits_in", con);
                //cmd.CommandType = CommandType.StoredProcedure;
                //cmd.Parameters.AddWithValue("@x", textBox1.Text);
                //cmd.Parameters.AddWithValue("@y", comboBox2.SelectedItem);
                //cmd.ExecuteNonQuery();

                if (textBox1.Text.Length != 0 & comboBox2.Text.Length != 0)
                {
                    موافق f = new موافق();
                    f.Show();
                }
            }
            catch (Exception ee)
            {
                MessageBox.Show(ee.Message);
            }
        }
        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                if (textBox2.Text.Length == 0 && textBox3.Text.Length == 0)
                {
                    MessageBox.Show("قم بادخال البيانات");
                }
                string[]    s  = new string[] { "@x", "@y" };
                string[]    s2 = new string[] { textBox3.Text, textBox2.Text };
                SqlDbType[] s3 = new SqlDbType[] { SqlDbType.VarChar, SqlDbType.VarChar };
                con.ExecuteInsertOrUpdateOrDeleteUsingStoredProc("reg_method_attending_leaving1", s, s2, s3);
                //cmd = new MySqlCommand("insert into methods_attending_leaving set attending_method=@x,short_name=@y,attend_method=@z", con);
                //cmd.Parameters.AddWithValue("@x", textBox3.Text);
                //cmd.Parameters.AddWithValue("@y", textBox2.Text);
                //cmd.Parameters.AddWithValue("@z", comboBox1.SelectedItem);

                //cmd.ExecuteNonQuery();
                if (textBox2.Text.Length != 0 && textBox3.Text.Length != 0)
                {
                    موافق f = new موافق();
                    f.Show();
                }
            }
            catch (Exception ee)
            {
                MessageBox.Show(ee.Message);
            }
        }
        private void حفظToolStripMenuItem_Click(object sender, EventArgs e)
        {
            try
            {
                if (textBox2.Text.Length == 0 & comboBox1.Text.Length == 0 & comboBox2.Text.Length == 0 & comboBox3.Text.Length == 0)
                {
                    MessageBox.Show("قم بادخال البيانات");
                }
                if (textBox2.Text.Length != 0 & comboBox1.Text.Length == 0 & comboBox2.Text.Length == 0 & comboBox3.Text.Length == 0)
                {
                    MessageBox.Show("قم بادخال وقت الوردية ونوع الوردية وعدد الورديات");
                }
                string[]    s  = new string[] { "@x", "@y", "@z", "@m" };
                string[]    s2 = new string[] { comboBox2.Text, comboBox1.Text, comboBox3.Text, textBox2.Text };
                SqlDbType[] s3 = new SqlDbType[] { SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.Int };

                con.ExecuteInsertOrUpdateOrDeleteUsingStoredProc("reg_roceasa_in", s, s2, s3);
                //{
                //    MessageBox.Show("تم تسجيل وردية لهذا الموظف من قبل");
                //}
                //else
                //{
                //    موافق f = new موافق();
                //    f.Show();
                //}
                //cmd = new SqlCommand("reg_roceasa_in", con);
                //cmd.CommandType = CommandType.StoredProcedure;
                //cmd.Parameters.AddWithValue("@x",comboBox2.SelectedItem);
                //cmd.Parameters.AddWithValue("@y",comboBox1.SelectedItem);
                //cmd.Parameters.AddWithValue("@z",comboBox3.SelectedItem);
                //cmd.Parameters.AddWithValue("@m",textBox2.Text);
                //cmd.ExecuteNonQuery();
                if (textBox2.Text.Length != 0 & comboBox1.Text.Length != 0 & comboBox2.Text.Length != 0 & comboBox3.Text.Length != 0)
                {
                    موافق f = new موافق();
                    f.Show();
                }
            }
            catch (Exception ee)
            {
                MessageBox.Show(ee.Message);
            }
        }