public static List <users> getCredentials(string username, string password)
{
MyPayEntities db = new MyPayEntities();
using (db)
{
var sorgu = from i in db.users
where i.email == username && i.password == password
select i;
List <users> infos = sorgu.ToList();
return(infos);
}
}
public static int getSessionRole(string username, string password)
{
MyPayEntities db = new MyPayEntities();
using (db)
{
try
{
var query = (from user in db.users
where user.email == username && user.password == password
select user.admin).FirstOrDefault();
return query ?? -1;
}
catch
{
return 00404;
}
}
}
public bool UserLogin(string email, string password)
{
MyPayEntities db = new MyPayEntities();
using (db)
{
var sorgu = (from x in db.users
where x.email == email && x.password == password
select x).FirstOrDefault();
if (sorgu != null)
{
return(true);
}
else
{
return(false);
}
}
}
public void UserRegister(string first_name, string last_name, string email, string password, int admin, string phone_number)
{
MyPayEntities db = new MyPayEntities();
users user = new users();
try
{
user.first_name = first_name;
user.last_name = last_name;
user.email = email;
user.password = password;
user.phone_number = phone_number;
user.admin = 1;
db.users.Add(user);
db.SaveChanges();
}
catch (Exception e)
{
throw e;
}
}
