private void button8_Click(object sender, EventArgs e) { Form12 f12 = new Form12(); f12.Show(); }
private void button2_Click(object sender, EventArgs e) { // try // { if (!string.IsNullOrEmpty(this.comboBox1.Text)) { int ye = Convert.ToInt16(label2.Text); cmd = new SqlCommand("select write from contr where materialcode =(select MaterialCode from Materials where MaterialCourseTitle='" + comboBox1.Text + "') and year=" + ye + " and semester='" + label4.Text + "'", cn); cn.Open(); dr = cmd.ExecuteReader(); dr.Read(); string write = dr[0].ToString(); dr.Close(); cn.Close(); if (write == "0") { int yea = Convert.ToInt16(label2.Text); cmd = new SqlCommand(" exec inserte7 @idofstudent='" + nationalid + "' ,@course='" + comboBox1.SelectedItem.ToString() + "',@year=" + yea + " ,@semester='" + label4.Text + "' ", cn); cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); button1.Visible = true; textBox1.Clear(); textBox1.ReadOnly = false; comboBox1.Text = null; comboBox1.Items.Clear(); this.Size = new Size(904, 171); } else if (write == "1") { int yea = Convert.ToInt16(label2.Text); cmd = new SqlCommand(" update totalgpa set gpa=null where nationalid='" + nationalid + "' and year=" + yea + " and semester='" + label4.Text + "' ", cn); cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); cmd = new SqlCommand(" exec inserte7 @idofstudent='" + nationalid + "' ,@course='" + comboBox1.SelectedItem.ToString() + "',@year=" + yea + " ,@semester='" + label4.Text + "' ", cn); cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); DialogResult r = MessageBox.Show("الذهاب ورصد الدرجه الان ", "رسالة", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation); if (r == DialogResult.Yes) { Form12 FrmStudentGrades = new Form12(); cmd = new SqlCommand("select [year],semester from stateofregisteration where id=(select max(id) from stateofregisteration)", cn); cn.Open(); dr = cmd.ExecuteReader(); dr.Read(); FrmStudentGrades.label4.Text = dr[0].ToString(); FrmStudentGrades.label6.Text = dr[1].ToString(); string se = dr[1].ToString(); dr.Close(); cn.Close(); FrmStudentGrades.Show(); this.Close(); } this.Close(); } } else { MessageBox.Show("من فضللك المادة الدراسيه ", "رسالة", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } /* } * catch * { * MessageBox.Show("من فضللك التاكد من الاتصال بقاعده البيانات ", "رسالة", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); * }*/ }
private void button2_Click(object sender, EventArgs e) { Form12 form = new Form12(); form.Show(); }