public void LoadBill()
{
loadBillData.LoadBillFromDb();
foreach (var popBill in loadBillData.pubBillCollect)
{
lblTotalTuitionContainer.Text = popBill.Bill_TotalAmount.ToString();
lblDiscountContainer.Text = $"{popBill.Bill_Discount.ToString()}%";
lblTotalBalanceContainer.Text = popBill.Bill_Balance.ToString();
lblTotalPaymentMadeContainer.Text = popBill.Bill_PaymentMade.ToString();
lblTuitionDueDateContainer.Text = popBill.Bill_DueDate.ToString();
}
}
private void LoadStudents()
{
loadStudentData.LoadStudentsFromDb();
loadBillData.LoadBillFromDb();
foreach (var popStudents in loadStudentData.pubStudentCollect)
{
lblStudentNumberContainer.Text = popStudents.Std_Id.ToString();
char middleName = popStudents.Std_MName.ToString().FirstOrDefault();
lblStudentNameContainer.Text = $"{popStudents.Std_FName.ToString()} {middleName}. {popStudents.Std_LName}";
lblCourseCodeContainer.Text = popStudents.Std_CourseCode.ToString();
lblYearContainer.Text = popStudents.Std_Year.ToString();
lblSectionContainer.Text = popStudents.Std_Section.ToString();
}
foreach (var popBill in loadBillData.pubBillCollect)
{
lblSemesterContainer.Text = popBill.Bill_Semester.ToString();
lblSchoolYearContainer.Text = popBill.Bill_SchoolYear.ToString();
}
}