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);
}
