public static List <Adminler> getCredentials(string username, string password) { WebAutomationEntities db = new WebAutomationEntities(); using (db) { var sorgu = from p in db.Adminler where p.Email == username && p.Sifre == password select p; List <Adminler> infos = sorgu.ToList(); return(infos); } }
public bool UserLogin(string email, string password) { WebAutomationEntities db = new WebAutomationEntities(); using (db) { var sorgu = (from x in db.Adminler where x.Email == email && x.Sifre == password select x).FirstOrDefault(); if (sorgu != null) { return(true); } else { return(false); } } }
public static int getSessionRole(string username, string password) { WebAutomationEntities db = new WebAutomationEntities(); using (db) { try { var query = (from role in db.Adminler where role.Email == username && role.Sifre == password select role.Yetki).FirstOrDefault(); return(query ?? -1); } catch { return(00404); } } }
public void UserRegister(string name, string surname, string email, string password) { WebAutomationEntities db = new WebAutomationEntities(); Adminler a = new Adminler(); try { a.Ad = name; a.Soyad = surname; a.Email = email; a.Sifre = password; a.Yetki = 1; db.Adminler.Add(a); db.SaveChanges(); } catch (Exception e) { throw e; } }