public static List <LoginUnit> ClientLogin(string email, string password) { var f_password = Encrypt.MD5Hash(password); var query = (from u in context.users join kh in context.khachhangs on u.id equals kh.matk where u.email == email && u.password == f_password select new { idUser = u.id, idKH = kh.makh, tenKH = kh.hoten, email = kh.email }).FirstOrDefault(); LoginUnit loginUnit = new LoginUnit(); if (query != null) { loginUnit.idUser = (int)query.idUser; loginUnit.idKH = (int)query.idKH; loginUnit.tenKH = query.tenKH; loginUnit.email = query.email; } List <LoginUnit> li = new List <LoginUnit>(); li.Add(loginUnit); return(li); }
public static List <LoginUnit> ClientLogin(string email, string password) { using (var ctx = new CoffeeHouseDbContext()) { var f_password = Encrypt.MD5Hash(password); var query = (from u in ctx.users join kh in ctx.khachhangs on u.id equals kh.matk where u.email == email && u.password == f_password select new { idUser = u.id, idKH = kh.makh, tenKH = kh.hoten, email = kh.email }).FirstOrDefault(); LoginUnit loginUnit = new LoginUnit(); if (query != null) { loginUnit.idUser = (int)query.idUser; loginUnit.idKH = (int)query.idKH; loginUnit.tenKH = query.tenKH; loginUnit.email = query.email; } List <LoginUnit> li = new List <LoginUnit>(); li.Add(loginUnit); return(li); } // var f_password = Encrypt.MD5Hash(password); //var query = (from u in context.users // join kh in context.khachhangs // on u.id equals kh.matk // where u.email == email && u.password == f_password // select new // { // idUser = u.id, // idKH = kh.makh, // tenKH = kh.hoten, // email = kh.email // }).FirstOrDefault(); //LoginUnit loginUnit = new LoginUnit(); //if (query != null) //{ // loginUnit.idUser = (int)query.idUser; // loginUnit.idKH = (int)query.idKH; // loginUnit.tenKH = query.tenKH; // loginUnit.email = query.email; //} //List<LoginUnit> li = new List<LoginUnit>(); //li.Add(loginUnit); //return li; }