public bool Authenticate(Users_DB user)
{
string query = String.Format("select * from users where username='******' and 'password={1}'", user.username, user.password);
BuisnessLogic bl = new BuisnessLogic();
OleDbDataReader reader = bl.SelectQuery(query);
if (reader.Read())
{
Users_DB ud = new Users_DB();
ud.id = reader[0].ToString();
ud.fname = reader[1].ToString();
ud.lname = reader[2].ToString();
ud.email = reader[3].ToString();
ud.phone = reader[4].ToString();
ud.aadhar = reader[5].ToString();
ud.username = reader[6].ToString();
ud.password = reader[7].ToString();
Session.CreateSession(ud);
return(true);
}
else
{
return(false);
}
}
public String getID(string email)
{
string query = String.Format("select id from users where email='{0}'", email);
BuisnessLogic bl = new BuisnessLogic();
OleDbDataReader reader = bl.SelectQuery(query);
if (reader.Read())
{
return(reader[0].ToString());
}
else
{
return("0");
}
}
public String getBalance(string id)
{
string query = String.Format("select balance from Account where userid={0}", @id);
Console.WriteLine(query);
BuisnessLogic bl = new BuisnessLogic();
OleDbDataReader reader = bl.SelectQuery(query);
if (reader.Read())
{
return(reader[0].ToString());
}
else
{
Console.WriteLine("Error");
return("0");
}
}