public static User Get(string login) { var q = new Entities.User(); var u = q.All(where : "WHERE ACLU_LOGIN = @0 ", args: login).FirstOrDefault(); return(FromEntity(u)); }
public static User GetByEmail(string email) { var q = new Entities.User(); var u = q.All(where : "WHERE ACLU_EMAIL = @0", args: email).FirstOrDefault(); return(FromEntity(u)); }
public static User GetByEmail(string email, string password) { var q = new Entities.User(); var u = q.All(where : "WHERE ACLU_EMAIL = @0 AND ACLU_PASSWORD = @1", args: new object[] { email, password }).FirstOrDefault(); return(FromEntity(u)); }
public static User Get(string login, string password) { var q = new Entities.User(); var u = q.All(where : "WHERE ACLU_LOGIN = @0 AND ACLU_PASSWORD = @1", args: new object[] { login, password }).FirstOrDefault(); return(FromEntity(u)); }
public static User Get(int id) { var q = new Entities.User(); var u = q.All(where : "WHERE ACL_USER_ID = @0", args: id).FirstOrDefault(); return(FromEntity(u)); }
public static bool Update(User u) { var q = new Entities.User(); var usr = q.All(where : "WHERE ACL_USER_ID = @0", args: u.Id).FirstOrDefault(); if (usr == null) { return(false); } q.Update(new { ACLU_LOGIN = u.Login, ACLU_PASSWORD = u.Password, ACLU_EMAIL = u.Email }, u.Id); return(true); }