public static LoginResult LogIn(string userName, string userPassword)
{
using (var db = new MySqlProvider())
{
var queryResult = (from p in db.User
where p.UserName == userName &&
p.UserIsValid
select p).FirstOrDefault();
LoginResult result = new LoginResult();
if (queryResult == null)
{
result.Response = LoginResponse.NotFound;
}
else
{
result.Response = LoginResponse.Success;
result.User = new Business.Classes.User.User()
{
UserID = queryResult.UserID,
UserName = queryResult.UserName
};
}
return(result);
}
}
public static List <Business.Classes.User.User> All()
{
using (var db = new MySqlProvider())
{
var query = from p in db.User
select p;
return(query.ToList().Select(userDB => new Business.Classes.User.User()
{
UserID = userDB.UserID, UserName = userDB.UserName
}).ToList());
}
}