public static void Add(User user)
{
using (JsonStoreDataContext context = new JsonStoreDataContext())
{
context.tbl_Users.InsertOnSubmit(Map(user));
context.SubmitChanges();
}
}
public static User GetUser(string email = null, long id = 0L)
{
using (JsonStoreDataContext db = new JsonStoreDataContext())
{
return((new User()).Map((from pp in db.tbl_Users
where (String.IsNullOrEmpty(email) || pp.Email.Equals(email)) &&
(id.Equals(0) || pp.ID.Equals(id))
select pp).FirstOrDefault()));
}
}
public static bool Validate(string email, string password)
{
using (JsonStoreDataContext db = new JsonStoreDataContext())
{
var query = (from pp in db.tbl_Users
where pp.Email.ToLower().Equals(email.ToLower()) && pp.Password != null &&
pp.Password.Equals(password.Encrypt("password")) && pp.Active
select pp).FirstOrDefault();
Site.Context().Session.AddSafe("json-site-user", GetUser(email));
return(query != null);
}
}
public static string CreateForgotPasswordToken(string email)
{
string resetToken = null;
using (JsonStoreDataContext db = new JsonStoreDataContext())
{
var query = (from pp in db.tbl_Users where pp.Email.ToLower().Equals(email.ToLower()) && pp.Active select pp).FirstOrDefault();
if (query != null)
{
resetToken = "abcdefghijklmnopqrstuvwxyz".Shuffle().First(16);
query.ResetToken = resetToken;
db.SubmitChanges();
}
}
return(resetToken);
}
public static bool resetPassword(string email)
{
using (JsonStoreDataContext db = new JsonStoreDataContext())
{
var query = (from pp in db.tbl_Users where pp.Email.ToLower().Equals(email.ToLower()) && pp.Active select pp).FirstOrDefault();
if (query != null)
{
query.IsReset = true;
query.ResetToken = "";
query.LastResetTime = DateTime.Now;
db.SubmitChanges();
return(true);
}
}
return(false);
}
public static List <Role> GetRoles()
{
if (Roles != null && Roles.Count > 0)
{
return(Roles);
}
else
{
Roles = new List <Role>();
using (JsonStoreDataContext db = new JsonStoreDataContext())
{
foreach (tbl_UserRole role in db.tbl_UserRoles.ToList())
{
Roles.Add(Map(role));
}
return(Roles);
}
}
}
public static bool changePassword(string email, string newPassword, string newPasswordHint = "")
{
using (JsonStoreDataContext db = new JsonStoreDataContext())
{
var query = (from pp in db.tbl_Users where pp.Email.ToLower().Equals(email.ToLower()) && pp.Active select pp).FirstOrDefault();
if (query != null)
{
query.IsReset = false;
query.ResetToken = "";
query.Password = newPassword.Encrypt();
if (!String.IsNullOrEmpty(newPasswordHint))
{
query.PasswordHint = newPasswordHint;
}
db.SubmitChanges();
return(true);
}
}
return(false);
}
