private void loadStudentGridView()
{
int sem = int.Parse(select_sem_numericUpDown.Value.ToString());
string course = select_dept_comboBox.Text;
DataTable dt = Department_Methods.viewStudent(course, sem);
all_student_dataGridView.DataSource = dt;
if (dt.Rows.Count > 0)
{
total_textBox.Text = dt.Rows.Count.ToString();
int boy = 0, girl = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
string text = all_student_dataGridView.Rows[i].Cells["Gender"].Value.ToString();
if (text.Equals("male", StringComparison.OrdinalIgnoreCase))
{
boy += 1;
}
else
{
girl += 1;
}
}
boys_textBox.Text = boy.ToString();
girls_textBox.Text = girl.ToString();
}
else
{
boys_textBox.Text = "0";
girls_textBox.Text = "0";
total_textBox.Text = "0";
}
}
private void loadSubject_Teacher()
{
int sem = int.Parse(select_sem_numericUpDown.Value.ToString());
DataTable dt = Department_Methods.load_Set_Modify_DepartmentGridView(select_dept_comboBox.Text, sem);
all_sub_dataGridView.DataSource = dt;
}
//validate finding details & finds data
private void find_stud_button_Click(object sender, EventArgs e)
{
if (finding_details_validation())
{
dtToOld = Department_Methods.viewStudent(select_course_comboBox.Text, int.Parse(update_numericUpDown.Value.ToString()));
if (dtToOld.Rows.Count > 0)
{
search_dept_groupBox.Enabled = false;
if (update_sem_textBox.Text.Contains("-"))
{
new_sem_label.Text = "";
old_sem_label.Text = "";
}
else
{
new_sem_label.Text = "Sem - " + update_sem_textBox.Text;
old_sem_label.Text = "Sem - " + update_numericUpDown.Value;
}
OldToNew = dtToOld;
NewToOld = dtToOld.Clone();
old_stud_dataGridView.DataSource = OldToNew;
EnableForwardNavigation(true);
EnableReverseNavigation(false);
data_moving_option_panel.Enabled = true;
}
else
{
MessageBox.Show("No students r available");
}
}
}
private void loadDepartment()
{
DataTable dt = Department_Methods.GetCourse();
if (dt.Rows.Count > 0)
{
select_course_comboBox.DisplayMember = "C_Alias";
select_course_comboBox.ValueMember = "C_TotalSem";
select_course_comboBox.DataSource = dt;
find_stud_button.Enabled = true;
}
else
{
select_course_comboBox.DataSource = null;
select_course_comboBox.Items.Add("select");
select_course_comboBox.SelectedIndex = 0;
update_numericUpDown.Enabled = false;
find_stud_button.Enabled = false;
}
if (!select_course_comboBox.Text.Equals("select", StringComparison.OrdinalIgnoreCase))
{
decimal totalsem = decimal.Parse(select_course_comboBox.SelectedValue.ToString());
update_numericUpDown.Maximum = totalsem;
update_sem_textBox.Text = (update_numericUpDown.Value + 1).ToString();
}
}
private void loadDataGridiew()
{
int sem = int.Parse(select_sem_numericUpDown.Value.ToString());
DataTable department = Department_Methods.load_Set_Modify_DepartmentGridView(dept_name_comboBox.Text, sem);
department_dataGridView.DataSource = department;
if (department.Rows.Count > 0)
{
subject_nm_comboBox.DisplayMember = "SubjectName";
subject_nm_comboBox.DataSource = department;
subject_nm_comboBox.SelectedIndex = 0;
int rowid = department_dataGridView.Rows.GetFirstRow(DataGridViewElementStates.Selected);
string empnm = department_dataGridView.Rows[rowid].Cells[1].Value.ToString();
if (empnm.Equals("not set", StringComparison.OrdinalIgnoreCase))
{
select_teacher_comboBox.Text = empnm;
}
else
{
select_teacher_comboBox.SelectedIndex = 0;
}
}
}
//validate & save data and insert it into database
private void save_button_Click(object sender, EventArgs e)
{
if (save_details_validation())
{
int affected = Department_Methods.setSubjectTeacher(select_teacher_comboBox.Text, subject_nm_comboBox.Text);
if (affected > 0)
{
AlertBox.ShowDialog("Data saved successfully", AlertBox.AlertType.success, true);
loadDataGridiew();
}
}
}
private void promote_button_Click(object sender, EventArgs e)
{
int successCounter = 0;
foreach (DataGridViewRow row in new_stud_dataGridView.SelectedRows)
{
int grno = int.Parse(row.Cells["Grno"].Value.ToString());
int affected = Department_Methods.PromoteStudent(grno, int.Parse(update_sem_textBox.Text));
if (affected > 0)
{
successCounter++;
}
DataRow[] temp = NewToOld.Select("Grno=" + grno);
NewToOld.Rows.Remove(temp[0]);
}
MessageBox.Show(successCounter + " student(s) r promoted");
}
private void loadDepartment()
{
DataTable dt = Department_Methods.GetCourse();
if (dt.Rows.Count > 0)
{
select_dept_comboBox.DisplayMember = "C_Alias";
select_dept_comboBox.ValueMember = "C_TotalSem";
select_dept_comboBox.DataSource = dt;
find_button.Enabled = true;
}
else
{
select_dept_comboBox.DataSource = null;
select_dept_comboBox.Items.Add("select");
select_dept_comboBox.SelectedIndex = 0;
select_sem_numericUpDown.Enabled = false;
find_button.Enabled = false;
}
}
private void loadEmployee()
{
List <string> nm = Department_Methods.loadEmployeeName();
if (nm.Count > 0)
{
string[] temp = new string[nm.Count];
for (int i = 0; i < temp.Length; i++)
{
temp[i] = nm[i].ToString();
}
select_teacher_comboBox.Items.Clear();
select_teacher_comboBox.Items.AddRange(temp);
}
else
{
select_teacher_comboBox.Items.Add("select");
}
select_teacher_comboBox.SelectedIndex = 0;
}
