public static User CreateUser(string userName, string password, string emailAddress) { User user = null; using (CuplexLib.Linq.DataContext db = CuplexLib.Linq.DataContext.Create()) { if (db.Users.Any(u => u.UserName == userName)) { return(null); } CuplexLib.Linq.User dbUser = new CuplexLib.Linq.User(); dbUser.UserName = userName; dbUser.PasswordHash = Utils.GetMd5Hash(password); dbUser.EmailAddress = emailAddress; db.Users.InsertOnSubmit(dbUser); db.SubmitChanges(); user = new User(); user.EmailAddress = emailAddress; user.UserName = userName; user.UserRef = dbUser.UserRef; user.PasswordHash = dbUser.PasswordHash; } return(user); }
public void save() { if (UserRef > 0) { using (CuplexLib.Linq.DataContext db = CuplexLib.Linq.DataContext.Create()) { CuplexLib.Linq.User dbUser = db.Users.Where(u => u.UserRef == UserRef).SingleOrDefault(); if (dbUser == null) { return; } dbUser.LastLogin = LastLogin; dbUser.EmailAddress = EmailAddress; db.SubmitChanges(); } } }
public static User UpdateUser(int userRef, string password, string emailAddress) { using (CuplexLib.Linq.DataContext db = CuplexLib.Linq.DataContext.Create()) { CuplexLib.Linq.User user = db.Users.Where(u => u.UserRef == userRef).SingleOrDefault(); if (user == null) { return(null); } if (password != null) { user.PasswordHash = Utils.GetMd5Hash(password); } user.EmailAddress = emailAddress; db.SubmitChanges(); return(GetOne(userRef)); } }
public static User GetOneByUserName(string userName) { User usr = null; using (CuplexLib.Linq.DataContext db = CuplexLib.Linq.DataContext.Create()) { CuplexLib.Linq.User user = db.Users.Where(u => u.UserName == userName).SingleOrDefault(); if (user != null) { usr = new User(); usr.UserRef = user.UserRef; usr.UserName = user.UserName; usr.EmailAddress = user.EmailAddress; usr.IsAdmin = user.IsAdmin; usr.LastLogin = user.LastLogin; } } return(usr); }