public void ActivateAccount(string activationCode)
{
using (OasisEntities o = new OasisEntities())
{
Guid activationKey = Guid.Parse(activationCode);
User user = o.Users.Where(u => u.ActivationKey == activationKey).FirstOrDefault<User>();
user.UserStatusID = (int) UserStatuses.Active;
user.AccountValidated = true;
o.SaveChanges();
}
}
public int CreateGroup(string groupName, string description)
{
Group group = new Group();
using (OasisEntities o = new OasisEntities())
{
group.GroupName = groupName;
group.Description = description;
o.Groups.AddObject(group);
o.SaveChanges();
}
return group.GroupId;
}
public void AddUser(string emailAddress, string password, string firstName, string lastName, string address1, string address2, string city, string state, string zipCode, int userType, int userStatus, int rank, int[] userAccess, string phoneNumber, string mobilePhoneNumber)
{
Guid activationCode = Guid.NewGuid();
User user = new User();
using (OasisEntities o = new OasisEntities())
{
int access = 0;
foreach (int bit in userAccess)
{
access = access | bit;
}
user.EmailAddress = emailAddress;
user.Password = password;
user.FirstName = firstName;
user.LastName = lastName;
user.PhoneNumber = phoneNumber;
user.MobilePhoneNumber = mobilePhoneNumber;
user.Address1 = address1;
user.Address2 = address2;
user.City = city;
user.State = state;
user.ZipCode = zipCode;
user.ActivationKey = activationCode;
user.RegisterDate = DateTime.Now;
user.LastLoginDate = DateTime.Now;
user.AccountValidated = false;
user.RankId = rank;
user.UserStatusID = userStatus;
user.UserTypeId = userType;
user.UserAccessBitMask = access;
o.Users.AddObject(user);
o.SaveChanges();
}
this.SendActivationEmail(user.UserId);
}
public void UpdateGroupMembers(int groupId, string[] memberIds)
{
int memberId = 0;
using (OasisEntities o = new OasisEntities())
{
// Delete the current first
var currentMembers = o.UserGroups.Where(ug => ug.GroupId == groupId).ToList<UserGroup>();
foreach (UserGroup group in currentMembers)
{
o.DeleteObject(group);
}
// Now, re-add them
if (memberIds != null)
{
foreach (string id in memberIds)
{
if (!int.TryParse(id, out memberId)) continue;
UserGroup group = new UserGroup();
group.GroupId = groupId;
group.UserId = memberId;
o.UserGroups.AddObject(group);
}
}
o.SaveChanges();
}
}
public void UpdateGroup(int groupId, string groupName, string description)
{
Group group;
using (OasisEntities o = new OasisEntities())
{
group = o.Groups.Where(g => g.GroupId == groupId).FirstOrDefault<Group>();
if (group != null)
{
group.GroupName = groupName;
group.Description = description;
o.SaveChanges();
}
}
}
public void UpdateUser(string emailAddress, string password, string firstName, string lastName, string address1,
string address2, string city, string state, string zipCode, int userType, int userStatus, int rank, int[] userAccess, int userId, string phoneNumber, string mobilePhoneNumber)
{
User user;
using (OasisEntities o = new OasisEntities())
{
user = o.Users.Where(u => u.UserId == userId).FirstOrDefault<User>();
if (user != null)
{
int accessBitMask = 0;
foreach (int bit in userAccess)
{
accessBitMask = accessBitMask | bit;
}
user.EmailAddress = emailAddress;
user.Password = password;
user.FirstName = firstName;
user.LastName = lastName;
user.PhoneNumber = phoneNumber;
user.MobilePhoneNumber = mobilePhoneNumber;
user.Address1 = address1;
user.Address2 = address2;
user.City = city;
user.State = state;
user.ZipCode = zipCode;
user.UserTypeId = userType;
user.UserStatusID = userStatus;
user.RankId = rank;
user.UserAccessBitMask = accessBitMask;
o.SaveChanges();
}
}
}
public void RegisterUser(string emailAddress, string password, string firstName, string lastName, string address1, string address2, string city, string state, string zipCode, string phoneNumber, string mobilePhoneNumber)
{
using (OasisEntities o = new OasisEntities())
{
Guid activationCode = Guid.NewGuid();
User user = new User();
// Build and save the user
user.EmailAddress = emailAddress;
user.Password = password;
user.FirstName = firstName;
user.LastName = lastName;
user.PhoneNumber = phoneNumber;
user.MobilePhoneNumber = mobilePhoneNumber;
user.Address1 = address1;
user.Address2 = address2;
user.City = city;
user.State = state;
user.ZipCode = zipCode;
user.ActivationKey = activationCode;
user.RegisterDate = DateTime.Now;
user.LastLoginDate = DateTime.Now;
user.AccountValidated = false;
user.RankId = (int)Ranks.TWO_POINT_FIVE;
user.UserStatusID = (int) UserStatuses.Unvalidated;
user.UserTypeId = (int) UserTypes.WebUser;
user.UserAccessBitMask = (int) UserPriviledges.User;
o.Users.AddObject(user);
o.SaveChanges();
this.SendActivationEmail(user.UserId);
}
}
public void RecoverPassword(string emailAddress)
{
using (OasisEntities o = new OasisEntities())
{
User user = o.Users.Where(u => u.EmailAddress == emailAddress).FirstOrDefault<User>();
if (user != null)
{
string password = OasisUtility.GenerateTemporaryPassword();
StringBuilder email = new StringBuilder();
user.Password = password;
o.SaveChanges();
// Build the email
email.Append(user.FirstName + ",\n");
email.Append("\n");
email.Append("\n");
email.Append("You recently requested your password for OasisTennis.com.\n");
email.Append("\n");
email.Append("The following details is your membership information:\n");
email.Append("\n");
email.Append("Email address: " + user.EmailAddress + "\n");
email.Append("Password: "******"\n");
email.Append("\n");
email.Append("Let us know if you have any problems on the site!!\n");
email.Append("\n");
email.Append("\n");
email.Append("Thanks,\n");
email.Append("-The Oasis Team");
OasisUtility.SendEmail("*****@*****.**", new string[] { user.EmailAddress }, "OasisTennis.com Activation Email", email.ToString());
}
}
}
