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