public static User Create(string FirstName, string LastName, string Password, string Email,
string DisplayName, string Site, string Organization, string Comments, string City, string Region, string Country)
{
if (!IsEmailUnique(Email))
return new User();
var newUser = new User()
{
FirstName = FirstName, LastName = LastName,
DisplayName = DisplayName,
Email = Email, Site = Site,
Organization = Organization,
City = City, Region = Region, Country = Country,
Comments = Comments,
ValidationCode = Guid.NewGuid().ToString(),
IsValidated = false
};
if (newUser.DisplayName.Trim().Length < 1)
DisplayName = FirstName + " " + LastName;
SetPassword(newUser, Password);
var ctx = new ICCData();
ctx.Users.InsertOnSubmit(newUser);
ctx.SubmitChanges();
return newUser;
}
public static bool Add(CurrentAttendee attendee)
{
attendee.EventID = NextEventId;
var ctx = new ICCData();
ctx.CurrentAttendees.InsertOnSubmit(attendee);
ctx.SubmitChanges();
return true;
}
public static bool AddUserToRole(string UserName, string RoleName)
{
ICCData ctx = new ICCData();
var user = (from u in ctx.Users where string.Compare(u.Email, UserName, true) == 0 select u).FirstOrDefault();
var role = (from r in ctx.Roles where string.Compare(r.Name, RoleName, true) == 0 select r).FirstOrDefault();
if (user.Id > 0 && role.Id > 0)
{
var ur = new UserRole() { UserId = user.Id, RoleId = role.Id };
ctx.UserRoles.InsertOnSubmit(ur);
ctx.SubmitChanges();
return true;
}
return false;
}
public static void Propose(string Email, string SessionTitle, string SessionAbstract)
{
var ctx = new ICCData();
int eId = Event.GetNextEvent().Id;
var session = new Session()
{ Title = SessionTitle, Abstract = SessionAbstract, EventId = eId };
ctx.Sessions.InsertOnSubmit(session);
ctx.SubmitChanges();
var user = ctx.Users.Where(u => string.Compare(u.Email, Email, true) == 0).FirstOrDefault();
Speaker speak = new Speaker()
{ SessionId = session.Id, UserId = user.Id };
ctx.Speakers.InsertOnSubmit(speak);
ctx.SubmitChanges();
}
public static bool Update(int SessionId, string Title, string Abstract, bool IsApproved, int SpeakerID)
{
var ctx = new ICCData();
var session = (from s in ctx.Sessions
where s.Id == SessionId
select s).First();
session.Title = Title;
session.Abstract = Abstract;
session.IsApproved = IsApproved;
var speakers = (from s in ctx.Speakers
where s.SessionId == SessionId
select s).First();
ctx.SubmitChanges();
return true;
}
public static bool ValidateUserAccount(string code)
{
ICCData ctx = new ICCData();
var userMatch = (from u in ctx.Users
where u.ValidationCode == code
select u).FirstOrDefault();
if (userMatch.Id > 0)
{
userMatch.IsValidated = true;
ctx.SubmitChanges();
AddUserToRole(userMatch.Email, "attendees");
return true;
}
return false;
}
public static void Update(string email, string firstname, string lastname, string password,
string displayname, string site, string organization, string city,
string region, string country, string comments)
{
var ctx = new ICCData();
var user = ctx.Users.Where(u => string.Compare(u.Email, email, true) == 0).FirstOrDefault();
user.FirstName = firstname;
user.LastName = lastname;
if (password.Trim().Length > 0)
SetPassword(user, password);
user.DisplayName = displayname;
user.Site = site;
user.Organization = organization;
user.City = city;
user.Region = region;
user.Country = country;
user.Comments = comments;
ctx.SubmitChanges();
}