private void getstudentInfo()
{
List <string> sinfo = xdl.selectItems("students_table", "user_id, contact_number", new string[] { "user_id", "contact_number" },
"student_number = " + this.student_n)[0];
user_id = sinfo.ElementAt(0);
contactnum = sinfo.ElementAt(1);
List <string> stdinfo = xdl.selectItems("users_table", "first_name, last_name, middle_name, extension",
new string[] { "first_name", "last_name", "middle_name", "extension" }, "user_id = " + user_id)[0];
List <string> allInfo = new List <string>();
allInfo.AddRange(sinfo);
allInfo.AddRange(stdinfo);
for (int i = 0; i < allInfo.Count; i++)
{
string key = i == 0 ? "user_id" : i == 1 ? "contact_number" : i == 2 ? "first_name" :
i == 3 ? "last_name" : i == 4 ? "middle_name" : i == 5 ? "extension" : "";
this.student_info.Add(key, allInfo.ElementAt(i));
}
}
private void student_select(object sender, SelectionChangedEventArgs e)
{
ListView lv = new ListView();
lv = sender as ListView;
var item = lv.SelectedItem as Student;
if (item != null)
{
Student.stud_num = item.Student_Number;
Student.rfid_num = xdl.selectItems("students_table", "rfid_number", new string[] { "rfid_number" }, "student_number = " + item.Student_Number)[0].ElementAt(0);
}
}
private async void login(object sender, RoutedEventArgs e)
{
string pass = password.Password;
string un = username.Text;
responseString = await client.GetStringAsync("http://localhost/rtams-portal/lib/decrypt-pass.php?pw=" + pass);
List <string>[] credentials = xdl.selectItems("users_table", "username", new string[] { "username" }, "username = \"" +
un + "\" and password = \"" + responseString + "\" and account_type = 'admin'");
try
{
if (credentials[0].ElementAt(0) == un)
{
MainWindow mw = new MainWindow();
mw.Show();
this.Close();
}
}
catch (Exception)
{
MessageBox.Show("Wrong Username or Password!", "Login Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
