private void Button_Click(object sender, RoutedEventArgs e)
{
InstitutionViewModel obj = new InstitutionViewModel();
string id = txtIdNumber.Text;
string pass = txtPassword.Text;
string conpass = txtConfirmPassword.Text;
var user = obj.getRegisteredUserLogin(id);
if(user != null)
{
if ( pass != "" && conpass != "")
{
if (pass == conpass)
{
obj.updateLogin(id,pass,conpass);
messageBox("Your password is been reset");
this.Frame.Navigate(typeof(LoginPage));
}
else
{
messageBox("Your password must match");
}
}
else {
messageBox("Enter the correct information");
}
}
}
public ObservableCollection <InstitutionViewModel> getAllInstitution()
{
institution = new ObservableCollection <InstitutionViewModel>();
using (var db = new SQLite.SQLiteConnection(app.dbPath))
{
var query = db.Table <Institution>();
foreach (var ins in query)
{
var ins1 = new InstitutionViewModel()
{
ID = ins.Id,
Name = ins.insitution
};
institution.Add(ins1);
}
}
return(institution);
}
private void btnPassword_Click(object sender, RoutedEventArgs e)
{
string id = txtIDnumber.Text;
string password, username;
var obj = new InstitutionViewModel();
var user = obj.getUser(id);
if(user != null)
{
username = user.email;
password = user.password;
messageBox("password is " + password + "username is " + username);
}else
{
messageBox("The user does not exist please make sure you enter a valid ID");
}
}
public ObservableCollection <InstitutionViewModel> getInstituionList(string name)
{
string nam = name + "%";
list = new ObservableCollection <InstitutionViewModel>();
using (var db = new SQLite.SQLiteConnection(app.dbPath))
{
//var query = db.Table<Courses>();
var query = db.Query <Institution>("select * from Institution where institution like '" + nam + "'");
foreach (var ins in query)
{
var ins1 = new InstitutionViewModel()
{
ID = ins.Id,
Insitution = ins.insitution,
};
list.Add(ins1);
}
}
return(list);
}
protected override void OnNavigatedTo(NavigationEventArgs e)
{
model = new InstitutionViewModel();
if (model.getInstitution() == null)
{
model.addInstitution("Tshwane University of Technology");
model.addInstitution("University of Johannesburg");
model.addInstitution("Jeppe College");
model.addInstitution("University of Limpopo");
model.addInstitution("Tshwane North College");
}
if (model.getCourse() == null)
{
model.addCourse("Information Technology",64);
model.addCourse("Policing", 64);
model.addCourse("mechanical Engineering", 64);
model.addCourse("Analytical chemistry", 65);
model.addCourse("mechanical Engineering", 65);
model.addCourse("Phamaceutical", 65);
model.addCourse("Local Government Management", 66);
model.addCourse("Policing", 66);
model.addCourse("Accounting", 66);
model.addCourse("Computer Sciences", 67);
model.addCourse("Education", 67);
model.addCourse("Phamaceutical", 67);
model.addCourse("Road and Traffic Management", 68);
model.addCourse("Local Government Management", 68);
model.addCourse("Information Technology", 68);
}
if (model.getCareer() == null)
{
model.addCareers("Software Developer \n Telecommunication \n Business Analyst", "Information Technology");
model.addCareers("Hire Resolve \n Construct Executive Research \n Maintanance", "mechanical Engineering");
model.addCareers("Detective Service \n Criminal Investigator", "Policing");
model.addCareers("Pharmacist \n Surgeon \n Medical Representative - Pharmaceutical Industry ", "Phamaceutical");
model.addCareers("Chartered Accountant \n Accounting technician\nBusiness Analyst", "Accounting");
model.addCareers("Pharmacist \n Laboratory Technician \nLab Analyst", "Analytical chemistry");
model.addCareers("Supply chain Management \n Finacial Management Support\nConsultant: Waste Management", "Local Government Management");
model.addCareers("Software Developer \n Data Analyst \n Software Engineer ", "Computer Sciences");
model.addCareers("Educator \n Lecturer \n Professor and Head of Department ", "Education");
model.addCareers("Traffic Accommodation Officer \n Specialist: Risk Management \n Traffic Cop ", "Road and Traffic Management");
}
if (model.getSubjectsOffered() == null)
{
model.addSubjectsOffered("Information Technology", "visual basics", "DSO17AT", "R1500");
model.addSubjectsOffered("Information Technology", "System software", "SSF30AT", "R1700");
}
if (model.getSubjectsDone()== null)
{
model.addSubjectsDone("Mathematics", "Information Technology");
}
if (model.getHowTheyWork() == null)
{
model.addHowTheyWork( "Information Technology","Assets/it.jpg");
model.addHowTheyWork("Policing", "Assets/download.jpg");
}
base.OnNavigatedTo(e);
}