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 User Get(string email)
{
email = email ?? "";
var ctx = new ICCData();
return((from u in ctx.Users where string.Compare(u.Email, email, true) == 0 select u).FirstOrDefault());
}
public override string[] GetRolesForUser(string email)
{
email = email ?? "";
var ctx = new ICCData();
//get userid
int MyUserID = ctx.Users.Where(u => u.Email == email).FirstOrDefault().Id;
//get user roles
IQueryable <UserRole> UserRoles = ctx.UserRoles.Where(ur => ur.UserId == MyUserID);
//load role ids into arraylist
var alUserRoles = new ArrayList(UserRoles.Count());
UserRoles.ToList().ForEach(ur => { alUserRoles.Add(ur.RoleId); });
//get roles for user based on id
IQueryable <Role> roles = (from r in ctx.Roles select r).AsQueryable();
var alRoles = new ArrayList();
roles.ToList().ForEach(r => { if (alUserRoles.Contains(r.Id))
{
alRoles.Add(r.Name);
}
});
//convert roles to string array
return(alRoles.ToArray(typeof(string)) as string[]);
}
public static List <CurrentAttendee> WaitList()
{
var ctx = new ICCData();
return(ctx.CurrentAttendees.Where(a => a.EventID == NextEventId)
.Skip(Config.MaxAttendees).ToList());
}
public static Event GetNextEvent()
{
var data = new ICCData();
var nextevent = data.Events.Where(e => e.StartOn.Date >= DateTime.Today)
.OrderBy(e => e.StartOn).FirstOrDefault();
return(nextevent);
}
public static List <User> GetCurrentEventAttendees()
{
var ctx = new ICCData();
//HACK clearly unfinished
return((from u in ctx.Users
where u.IsValidated == true
select u).ToList());
}
public static List <CurrentSession> List()
{
var ctx = new ICCData();
return(ctx.CurrentSessions
.OrderBy(currentSession => currentSession.Room)
.OrderBy(currentSession => currentSession.SessionTimeOrdinal)
.ToList());
}
public static List <User> GetAttendees()
{
var ctx = new ICCData();
var speakers = (from u in ctx.Users
where u.IsValidated == true
orderby u.LastName, u.FirstName
select u).ToList();
return(speakers);
}
public static bool Add(CurrentAttendee attendee)
{
attendee.EventID = NextEventId;
var ctx = new ICCData();
ctx.CurrentAttendees.InsertOnSubmit(attendee);
ctx.SubmitChanges();
return(true);
}
public void StringOperatorTestNotAscii()
{
// Arrange
var bytes = new byte[] { 12, 96, 14, 2 };
// Act
var target = new ICCData(bytes);
// Assert
var actual = Assert.ThrowsException <InvalidCastException>(() => (string)target);
}
public void ByteArrayOperatorTestNotBinary()
{
// Arrange
string s = "notbinarytest";
// Act
var target = new ICCData(s);
// Assert
var actual = Assert.ThrowsException <InvalidCastException>(() => (byte[])target);
}
public void ByteArrayOperatorTest()
{
// Arrange
var expected = new byte[] { 12, 96, 14, 2 };
// Act
var target = new ICCData(expected);
// Assert
var actual = (byte[])target;
Assert.AreEqual(expected, actual);
}
public void StringOperatorTest()
{
// Arrange
string expected = "stringoperatortest";
// Act
var target = new ICCData(expected);
// Assert
var actual = (string)target;
Assert.AreEqual(expected, actual);
}
public void Constructor1Test()
{
// Arrange
string expectedString = "constructor1test";
uint expectedFlag = ICCData.ASCII;
// Act
var target = new ICCData(expectedString);
// Assert
var actualString = (string)target;
var actualFlag = target.Flag;
Assert.AreEqual(expectedString, actualString);
Assert.AreEqual(expectedFlag, actualFlag);
}
public void Constructor2Test()
{
// Arrange
var expectedData = new byte[] { 12, 96, 14, 2 };
uint expectedFlag = ICCData.Binary;
// Act
var target = new ICCData(expectedData);
// Assert
var actualData = (byte[])target;
var actualFlag = target.Flag;
Assert.AreEqual(expectedData, actualData);
Assert.AreEqual(expectedFlag, actualFlag);
}
public static List <Session> GetAllSessions()
{
var ctx = new ICCData();
int eId = Event.GetNextEvent().Id;
var sessions = from s in ctx.Sessions
where s.EventId == eId && s.IsApproved
select s;
var sessions1 = ctx.Sessions.Where(sess => sess.EventId == eId);
return(sessions.ToList());
}
public static bool Validate(string email, string password)
{
email = email ?? "";
password = password ?? "";
ICCData ctx = new ICCData();
var matches = from u in ctx.Users
where u.Email == email && u.IsValidated
select u;
if (matches.Count() < 1)
{
return(false);
}
string passwordHash = CreatePasswordHash(password, matches.First().PasswordSalt);
return(passwordHash == matches.First().Password);
}
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 void FromHandleTestBinary2()
{
// Arrange
using (var profile = Profile.CreatePlaceholder(null))
{
var expected = new byte[] { 17, 99, 0, 253, 122, 19 };
var iccData = new ICCData(expected);
// do not use TagSignature.Data as this is not supported
profile.WriteTag(TagSignature.Ps2CRD3, iccData);
// Act
// implicit call to FromHandle
var actual = (byte[])profile.ReadTag <ICCData>(TagSignature.Ps2CRD3);
// Assert
CollectionAssert.AreEqual(expected, actual);
}
}
public void FromHandleTestAscii2()
{
// Arrange
using (var profile = Profile.CreatePlaceholder(null))
{
var expected = "fromhandletestascii2";
var iccData = new ICCData(expected);
// do not use TagSignature.Data as this is not supported
profile.WriteTag(TagSignature.Ps2CRD1, iccData);
// Act
// implicit call to FromHandle
var actual = (string)profile.ReadTag <ICCData>(TagSignature.Ps2CRD1);
// Assert
Assert.AreEqual(expected, actual);
}
}
public static List <Session> GetAcceptedSessions()
{
var ctx = new ICCData();
int eId = 0;
Event ev = Event.GetNextEvent();
if (ev != null)
{
eId = ev.Id;
}
var sessions = from s in ctx.Sessions
where s.IsApproved && s.EventId == eId
//let SpeakerName = s.Speakers.
select s;
return(sessions.ToList());
}
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 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 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();
}
public static int GetTotalCount()
{
var ctx = new ICCData();
return(ctx.CurrentAttendees.Where(a => a.EventID == NextEventId).Count());
}
public static List <CurrentSpeaker> List()
{
var ctx = new ICCData();
return(ctx.CurrentSpeakers.OrderBy(currentSpeaker => currentSpeaker.SpeakerName).ToList());
}
