private void Search_qpaper_Click(object sender, RoutedEventArgs e) { try { if (_mysql == null) { _mysql = new MysqlClass(constring); } string query = string.Empty; query = "Select * from qpaper where dept='" + search_class_dept.Text + "' and sem ='" + search_sem.Text + "'"; DataSet ds = _mysql.ExecuteQueryReturnDataset(query); if (ds != null && ds.Tables[0].Rows.Count > 0) { qpaper_grid.ItemsSource = ds.Tables[0].DefaultView; } else { MessageBox.Show("Question Paper details not found", "St. Anne's Admin DashBoard", MessageBoxButton.OK, MessageBoxImage.Exclamation); } _mysql.CloseConnection(); _mysql = null; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private bool IsAlreadyRegistered(string cls, string sem) { try { if (_mysql == null) { _mysql = new MysqlClass(constring); } string query = "Select * from timetable where course='" + cls + "' and sem ='" + sem + "'"; DataSet ds = _mysql.ExecuteQueryReturnDataset(query); if (ds != null && ds.Tables[0].Rows.Count > 0) { _mysql.CloseConnection(); _mysql = null; return(true); } _mysql.CloseConnection(); _mysql = null; } catch (Exception ex) { MessageBox.Show(ex.Message, "St. Anne's Admin DashBoard", MessageBoxButton.OK, MessageBoxImage.Error); } return(false); }
private void Search_std_Click(object sender, RoutedEventArgs e) { try { if (_mysql == null) { _mysql = new MysqlClass(constring); } string query = string.Empty; if (!string.IsNullOrWhiteSpace(search_std_name.Text)) { query = "Select * from login where admin_name='" + search_std_name.Text + "'"; } else { MessageBox.Show("Enter Admin Name", "St. Anne's Admin DashBoard", MessageBoxButton.OK, MessageBoxImage.Exclamation); return; } DataSet ds = _mysql.ExecuteQueryReturnDataset(query); if (ds != null && ds.Tables[0].Rows.Count > 0) { student_grid.ItemsSource = ds.Tables[0].DefaultView; } else { MessageBox.Show("Student details not found", "St. Anne's Admin DashBoard", MessageBoxButton.OK, MessageBoxImage.Exclamation); } _mysql.CloseConnection(); _mysql = null; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void loadgrid() { try { if (_mysql == null) { _mysql = new MysqlClass(constring); } string query = "Select * from std_register where designation='student' order by id desc"; DataSet ds = _mysql.ExecuteQueryReturnDataset(query); if (ds != null && ds.Tables.Count > 0) { student_grid.ItemsSource = ds.Tables[0].DefaultView; } _mysql.CloseConnection(); _mysql = null; } catch (Exception ex) { MessageBox.Show(ex.Message, "St. Anne's Admin DashBoard", MessageBoxButton.OK, MessageBoxImage.Exclamation); } }
private void Search_assignment_Click(object sender, RoutedEventArgs e) { try { if (_mysql == null) { _mysql = new MysqlClass(constring); } string query = string.Empty; if (from_date.Text != string.Empty && search_class_dept.SelectedIndex != 0 && search_sem.SelectedIndex != 0) { query = "Select * from assignments where dept='" + search_class_dept.Text + "' and sem ='" + search_sem.Text + "'and start_date ='" + from_date.Text + "'"; } else if (from_date.Text != string.Empty && search_class_dept.SelectedIndex == 0 && search_sem.SelectedIndex == 0) { query = "Select * from assignments where start_date='" + from_date.Text + "'"; } else { query = "Select * from assignments where dept='" + search_class_dept.Text + "' and sem ='" + search_sem.Text + "'"; } DataSet ds = _mysql.ExecuteQueryReturnDataset(query); if (ds != null && ds.Tables[0].Rows.Count > 0) { assign_grid.ItemsSource = ds.Tables[0].DefaultView; } else { MessageBox.Show("Assignments details not found", "St. Anne's Admin DashBoard", MessageBoxButton.OK, MessageBoxImage.Exclamation); } _mysql.CloseConnection(); _mysql = null; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void Btn_reset_Click(object sender, RoutedEventArgs e) { try { if (!validate()) { return; } if (_mysql == null) { _mysql = new MysqlClass(constring); } string user = ValidationFile._getusername; string password = curr_pass.Password; string query = "Select * from login where username='******' and password='******'"; DataSet dataSet = _mysql.ExecuteQueryReturnDataset(query); if (dataSet.Tables[0].Rows.Count > 0) { if (new_pass.Password != con_pass.Password) { MessageBox.Show("The new password and confirm password doesn't match.", "St. Anne's Admin DashBoard", MessageBoxButton.OK, MessageBoxImage.Error); } else { string updatequery = "update login set password = '******' where username='******'"; if (change_pass(updatequery)) { clear(); MessageBox.Show("The password has been changed.", "St. Anne's Admin DashBoard", MessageBoxButton.OK, MessageBoxImage.Information); } } } else { MessageBox.Show("The current password is invalid.", "St. Anne's Admin DashBoard", MessageBoxButton.OK, MessageBoxImage.Error); } _mysql.CloseConnection(); _mysql = null; } catch (Exception ex) { MessageBox.Show(ex.Message); } }