private void bttnBarrowed_Click(object sender, System.EventArgs e)
{
FORMBarrowedBooks_Barrowers.sBookNumber = txtBookNO.Text;
FORMBarrowedBooks_Barrowers sForm = new FORMBarrowedBooks_Barrowers();
sForm.ShowDialog();
}
private void FORMBarrowedBooks_Barrowers_Load(object sender, System.EventArgs e)
{
//Set the Icon on Listview.
lvBooks.SmallImageList = MDIFORM.i16x16;
//Set the Data Adapter
daHistory = new OleDbDataAdapter("", clsConnections.CN);
//Set the Combo Box
sFunctions.FillCombo(cbYear, "SELECT tblSchoolYear.IndexSY, [YearStart] & ' - ' & [YearEnd] AS SY FROM tblSchoolYear ORDER BY [YearStart] & ' - ' & [YearEnd] ASC", "tblSchoolYear", 1);
sFunctions.FillCombo(cbLevel, "SELECT * FROM tblLevel ORDER BY LevelName ASC", "tblLevel", 1);
//Set to Load Books History
loadBooks("SELECT tblBarrowed.BookNo, tblBarrowers.BarrowerID, [LastName] & ', ' & [FirstName] & ' ' & [MiddleName] AS Fullname, tblCourse.CourseName, tblBarrowed.DateBarrowed, tblBarrowed.DateRetured, [YearStart] & ' - ' & [YearEnd] AS SY, tblLevel.LevelName FROM tblSchoolYear RIGHT JOIN (tblLevel RIGHT JOIN (tblCourse RIGHT JOIN (tblBarrowers RIGHT JOIN tblBarrowed ON tblBarrowers.BarrowerID = tblBarrowed.BarrowerID) ON tblCourse.IndexCourse = tblBarrowers.Course) ON tblLevel.IndexLevel = tblBarrowers.LevelIndex) ON tblSchoolYear.IndexSY = tblBarrowers.SchoolYear WHERE [YearStart] & ' - ' & [YearEnd] LIKE '" + cbYear.Text + "' AND tblLevel.LevelName LIKE '" + cbLevel.Text + "' AND tblBarrowed.BookNo LIKE '" + sBookNumber + "' ORDER BY tblBarrowers.BarrowerID ASC");
publicHistory = this;
}