private void button_schedual_exams_classes_Click(object sender, EventArgs e) { this.Hide(); A_ScaduilngClassForExam_Secretary schadex = new A_ScaduilngClassForExam_Secretary(); schadex.ShowDialog(); }
private void A_ScaduilngClassForExam_Secretary_Load(object sender, EventArgs e) { CURRENTA_ScaduilngClassForExam_Secretary = this; comboBox1_examName.Items.Clear(); comboBox2_ClassNum.Items.Clear(); cn.Open(); SqlCommand cmd = cn.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "select ExamName from HeadDepartmentExamList"; cmd.ExecuteNonQuery(); DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); foreach (DataRow dr in dt.Rows) { comboBox1_examName.Items.Add(dr["ExamName"].ToString()); } cn.Close(); cn.Open(); SqlCommand cmd1 = cn.CreateCommand(); cmd1.CommandType = CommandType.Text; cmd1.CommandText = "select *from [Classes]"; cmd1.ExecuteNonQuery(); DataTable dt1 = new DataTable(); SqlDataAdapter da1 = new SqlDataAdapter(cmd1); da1.Fill(dt1); foreach (DataRow dr in dt1.Rows) { period = Convert.ToString(dr["examsPeriod"].ToString()); if (period != "") { comboBox2_ClassNum.Items.Add(dr["NumClass"].ToString()); } else { continue; } } cn.Close(); }
private void button_SUBMIT_Click(object sender, EventArgs e) { SqlCommand cmd; SqlDataReader dr; //check that fields are not empty if (String.IsNullOrEmpty(comboBox2_ClassNum.Text) || String.IsNullOrEmpty(comboBox1_examName.Text) || String.IsNullOrEmpty(comboBox3_examHour.Text)) { MessageBox.Show("All fields REQIRED! please try again"); this.Hide(); A_ScaduilngClassForExam_Secretary.CURRENTA_ScaduilngClassForExam_Secretary.Show(); } if (String.IsNullOrEmpty(comboBox2_ClassNum.Text)) { cn.Open(); SqlCommand cmd1 = cn.CreateCommand(); cmd1.CommandType = CommandType.Text; cmd1.CommandText = cmd1.CommandText = "select ExamDate, hour from HeadDepartmentExamList where ExamName='" + comboBox1_examName.SelectedItem.ToString() + "'"; cmd1.Connection = cn; dr = cmd1.ExecuteReader(); if ((dr["ExamDate"].ToString() != "") && (dr["hour"].ToString() != "")) { ExD = dr["ExamDate"].ToString(); hour = dr["hour"].ToString(); ExamN = dr["ExamNum"].ToString(); } cn.Close(); dr.Close(); } cn.Open(); SqlCommand cmd2 = cn.CreateCommand(); cmd2.CommandType = CommandType.Text; cmd2.CommandText = cmd2.CommandText = "select * from [HeadDepartmentExamList]"; cmd2.ExecuteNonQuery(); DataTable dt1 = new DataTable(); SqlDataAdapter da1 = new SqlDataAdapter(cmd2); da1.Fill(dt1); foreach (DataRow dr1 in dt1.Rows) { if (ExamN == dr1["ExamNum"].ToString()) { // if (dr1["ExamName"].ToString() == comboBox1_examName.SelectedItem.ToString()) // { index = tempindex + 1; // } } tempindex++; } for (j = 0; j < dt1.Rows.Count; j++) { if (j != index) { if (dt1.Rows[j]["ExamDate"].ToString() == ExD) { if (dt1.Rows[j]["hour"].ToString() == hour) { if (dt1.Rows[j]["ExamName"].ToString() == ExamN) { count++; } } } } } cn.Close(); if ((count == 0)) { cn.Open(); SqlDataAdapter da = new SqlDataAdapter("UPDATE HeadDepartmentExamList SET hour='" + comboBox3_examHour.SelectedItem.ToString() + "',class='" + comboBox2_ClassNum.SelectedItem.ToString() + "'WHERE ExamName='" + comboBox1_examName.SelectedItem.ToString() + "'", cn); da.SelectCommand.ExecuteNonQuery(); SqlDataAdapter da2 = new SqlDataAdapter("UPDATE Classes SET examsPeriod='" + "V" + "'WHERE NumClass='" + comboBox2_ClassNum.SelectedItem.ToString() + "'", cn); da2.SelectCommand.ExecuteNonQuery(); cn.Close(); MessageBox.Show(" The Exam has been signed in Class successfully!!"); this.Hide(); comboBox2_ClassNum.Items.Clear(); comboBox1_examName.Items.Clear(); comboBox3_examHour.Items.Clear(); A_ScaduilngClassForExam_Secretary sec = new A_ScaduilngClassForExam_Secretary();/*.CURRENTA_ScaduilngClassForExam_Secretary.Show()*/ sec.ShowDialog(); } else { MessageBox.Show(" Exam collisin , Schedual Class for Exam has FAILED!"); A_ScaduilngClassForExam_Secretary.CURRENTA_ScaduilngClassForExam_Secretary.Show(); } }