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);
}
}
