private void Load_Course_Course()
{
dt_course = FinanceDepartment_Methods.Load_CourseDetails();
course_comboBox.DataSource = dt_course;
course_comboBox.ValueMember = "Id";
course_comboBox.DisplayMember = "Alias";
}
private void find_button_Click(object sender, EventArgs e)
{
if (valid())
{
DataTable dt = FinanceDepartment_Methods.Load_DataGridView(selectcourse_comboBox.Text, int.Parse(selectsem_numericUpDown.Value.ToString()));
DataView filter = dt.DefaultView;
if (all_radioButton.Checked)
{
stud_payment_dataGridView.DataSource = dt;
}
else if (due_radioButton.Checked)
{
int duefee = 0;
if (due_textbox.Text != "")
{
duefee = int.Parse(due_textbox.Text);
}
filter.RowFilter = "Due >" + duefee;
stud_payment_dataGridView.DataSource = filter;
}
else if (paid_radioButton.Checked)
{
filter.RowFilter = "[Total Paid] =[Payable Fees]";
stud_payment_dataGridView.DataSource = filter;
}
}
}
private void Search_button_Click(object sender, EventArgs e)
{
if (valid_filter())
{
dt_dataGridView = FinanceDepartment_Methods.Load_DataGridView(course_comboBox.Text, int.Parse(select_sem_numericUpDown.Value.ToString()));
all_student_nm_dataGridView.DataSource = dt_dataGridView;
}
}
private void collect_button_Click(object sender, EventArgs e)
{
if (valid_collect())
{
loadFinanceEntity();
if (FinanceDepartment_Methods.insertFees(fe) > 0)
{
AlertBox.ShowDialog("Fees collected successfully", AlertBox.AlertType.success, true);
dt_dataGridView = FinanceDepartment_Methods.Load_DataGridView(course_comboBox.Text, int.Parse(select_sem_numericUpDown.Value.ToString()));
all_student_nm_dataGridView.DataSource = dt_dataGridView;
}
}
}
private void loadCourse()
{
dt_course = FinanceDepartment_Methods.Load_CourseDetails();
if (dt_course.Rows.Count > 0)
{
selectcourse_comboBox.DisplayMember = "Alias";
selectcourse_comboBox.ValueMember = "TotalSem";
selectcourse_comboBox.DataSource = dt_course;
}
else
{
selectcourse_comboBox.DataSource = null;
selectcourse_comboBox.Items.Add("select");
selectcourse_comboBox.SelectedIndex = 0;
}
}
private void Load_fee_collection_panel(DataGridViewCellEventArgs e)
{
fee_collection_panel.Enabled = true;
int Grno = int.Parse(all_student_nm_dataGridView.Rows[e.RowIndex].Cells[0].Value.ToString());
DataTable dt_cellClick = FinanceDepartment_Methods.FeeCollection_CellClick(Grno);
grno_textBox.Text = dt_cellClick.Rows[0]["Grno"].ToString();
studentnm_textBox.Text = dt_cellClick.Rows[0][1].ToString();
int admission_Year = ((DateTime)dt_cellClick.Rows[0][2]).Year;
int leaving_Year = int.Parse(dt_cellClick.Rows[0][3].ToString());
for (int i = admission_Year; i < leaving_Year; i++)
{
paymentyear_comboBox.Items.Add(i + "-" + (i + 1));
}
paymentyear_comboBox.SelectedIndex = 0;
}
