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