public int GetLoginInfo(Teacher_tblDTO teacher_tbldto)
{
string query = "SELECT Count(*) FROM teacher_tbl WHERE email='" + teacher_tbldto.TEACHER_EMAIL + "' AND password='******'";
int count = -1;
if (dbconnect.OpenConnection() == true)
{
MySqlCommand cmd = new MySqlCommand(query, dbconnect.connection);
count = int.Parse(cmd.ExecuteScalar() + "");
dbconnect.CloseConnection();
return(count);
}
else
{
return(count);
}
}
public DataSet getSingleTeacher(Teacher_tblDTO teacher_tbldto)
{
string query = "SELECT * FROM teacher_tbl WHERE email='" + teacher_tbldto.TEACHER_EMAIL + "'";
if (dbconnect.OpenConnection() == true)
{
MySqlCommand cmd = new MySqlCommand(query, dbconnect.connection);
mysqlAdapter = new MySqlDataAdapter(cmd);
dataSet = new DataSet();
mysqlAdapter.Fill(dataSet);
dbconnect.CloseConnection();
return(dataSet);
}
else
{
return(dataSet);
}
}
