public static FORMLibrarian Instance()
{
if (sForm == null)
{
sForm = new FORMLibrarian();
}
return(sForm);
}
protected override void Dispose(bool disposing)
{
if (disposing)
{
if (components != null)
{
components.Dispose();
}
}
base.Dispose(disposing);
sForm = null;
}
private void FORMLibrarian_Load(object sender, System.EventArgs e)
{
//Set Images
setImages();
//Create Directory
sFunctions.CreateDirectory("\\@Pictures\\@Librarian");
//Set the Data Adapter
daLibrarianList = new OleDbDataAdapter("", clsConnections.CN);
//Load List of Librarian
loadLibrarians("SELECT tblLibrarian.LibrarianID, [LastName] & ', ' & [FirstName] & ' ' & [MiddleName] AS Fullname, tblLibrarian.StreetAddress, tblZipCodeList.CityTown, tblZipCodeList.Province, tblZipCodeList.ZipCode, tblLibrarian.ContactNo, tblLibrarian.EmailAddress, tblLibrarian.UserName FROM tblZipCodeList RIGHT JOIN tblLibrarian ON tblZipCodeList.ZipCode = tblLibrarian.ZipCode ORDER BY tblLibrarian.LibrarianID ASC");
publcLibrarianList = this;
}
