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