public int login(string Username, string Password)
{
int Perm = 3;
Transaction trans;
SqlCommand cmd;
trans = new Transaction();
trans.BegindTransactions();
String query = "Select UserName ,PassWord ,TypeOfUser from LogIn1 where UserName = '******'and PassWord = '******'";
cmd = new SqlCommand(query, trans.getcon(), trans.GetTransaction());
SqlDataReader dbr;
dbr = cmd.ExecuteReader();
while (dbr.Read() == true)
{
if (dbr.HasRows)
{
Perm = (int)dbr["TypeOfUser"];
}
}
dbr.Close();
trans.Commit();
trans.GetConnection().Close();
return Perm;
}
