public void getdatabysearch(DataGridView dg, String se)
{
Businesslogic bl = new Businesslogic();
string query = "select * from signup where Username like ('%" + se + "%')";
bl.filldataGrid(dg, query);
}
public void getdata(DataGridView dg)
{
Businesslogic bl = new Businesslogic();
string query = "select * from signup";
bl.filldataGrid(dg, query);
}
public void changepassword(User_db udb)
{
string query = String.Format("update [signup] set [Password]='{0}' where [Username]='{1}'", udb.Password, udb.Username);
Businesslogic BL = new Businesslogic();
BL.Nonquery(query);
}
public void DeleteUser(User_db udb)
{
string query = String.Format("Delete from signup where Username='******'", udb.Username);
Businesslogic BL = new Businesslogic();
BL.Nonquery(query);
}
public void Insertuser(User_db udb)
{
string query = String.Format("insert into signup values ('{0}','{1}','{2}','{3}')",
udb.Username, udb.Names, udb.Password, udb.Usertype);
Businesslogic BL = new Businesslogic();
BL.Nonquery(query);
}
public void Addcourse(User_db udb)
{
string query = String.Format("insert into courses values ('{0}','{1}','{2}')",
udb.Names, udb.Fees, udb.Course);
Businesslogic BL = new Businesslogic();
BL.Nonquery(query);
}
public void fillcombo(ComboBox cb)
{
string query = "select Username from signup";
Businesslogic BL = new Businesslogic();
OleDbDataReader rec = BL.SelectQuery(query);
while (rec.Read())
{
cb.Items.Add(rec[0].ToString());
}
}
public bool Authenticated(User_db udb)
{
string query = string.Format("select * from signup where Username='******' and Password='******' and Usertype='{2}'", udb.Username, udb.Password, udb.Usertype);
Businesslogic BL = new Businesslogic();
OleDbDataReader rec = BL.SelectQuery(query);
if (rec.Read())
{
return(true);
}
else
{
return(false);
}
}
