public IEnumerable<hunt> GetTreasureHunts() { using (var context = new TreasureHuntEntities()) { var returnedHunts = context.hunts.ToList(); returnedHunts.ForEach(e => context.ObjectStateManager.ChangeObjectState(e,System.Data.EntityState.Detached)); return returnedHunts; } }
public question GetQuestion(long questionId) { using (var context = new TreasureHuntEntities()) { var returnedQuestions = context.questions.Where(c => c.QuestionId == questionId).Single(); context.ObjectStateManager.ChangeObjectState(returnedQuestions, System.Data.EntityState.Detached); return returnedQuestions; } }
public void SaveNewHuntQuestion(huntquestion huntQuestion) { using (var context = new TreasureHuntEntities()) { context.huntquestions.AddObject(huntQuestion); context.SaveChanges(); context.ObjectStateManager.ChangeObjectState(huntQuestion, System.Data.EntityState.Added); } }
/// <summary> /// Method that returns all of the companys found in the 'companydetails' table. /// </summary> /// <returns></returns> public List<companydetail> getExistingCompanies() { using (var context = new TreasureHuntEntities()) { var returnedCompanies = context.companydetails.ToList(); returnedCompanies.ForEach(e => context.ObjectStateManager.ChangeObjectState(e, System.Data.EntityState.Detached)); return returnedCompanies; } }
/// <summary> /// Method that returns all existing users that are found in the 'users' table. /// </summary> /// <returns></returns> public List<user> GetExistingUsers() { using (var context = new TreasureHuntEntities()) { var returnedUsers = context.users.ToList(); returnedUsers.ForEach(e => context.ObjectStateManager.ChangeObjectState(e, System.Data.EntityState.Detached)); return returnedUsers; } }
public long SaveQuestion(question newQuestion) { using (var context = new TreasureHuntEntities()) { context.questions.AddObject(newQuestion); context.SaveChanges(); context.ObjectStateManager.ChangeObjectState(newQuestion, System.Data.EntityState.Added); return newQuestion.QuestionId; } }
public List<long> GetHuntQuestions(hunt hunt) { using (var context = new TreasureHuntEntities()) { if (hunt == null) return null; var returnedquestionIds = context.huntquestions.Where(c => c.HuntId == hunt.HuntId).Select(s => s.QuestionId).ToList(); returnedquestionIds.ForEach(e => context.ObjectStateManager.ChangeObjectState(e, System.Data.EntityState.Detached)); return returnedquestionIds; } }
public IEnumerable<hunt> GetTreasureHuntsForParticularUser(user user) { using (var context = new TreasureHuntEntities()) { if (user == null) return null; var returnedHuntIds = context.userhunts.Where(c => c.UserId == user.UserId).Select(s => s.HuntId).ToList(); returnedHuntIds.ForEach(e => context.ObjectStateManager.ChangeObjectState(e, System.Data.EntityState.Detached)); List<hunt> returnedListOfHunts = new List<hunt>(); foreach (var huntId in returnedHuntIds) { var hunt = context.hunts.Where(c => c.HuntId == huntId).Single(); context.ObjectStateManager.ChangeObjectState(hunt, System.Data.EntityState.Detached); returnedListOfHunts.Add(hunt); } return returnedListOfHunts; } }
/// <summary> /// Method that returns a hunt if one exists for a given name for a given user. /// </summary> /// <param name="name"></param> /// <param name="userId"></param> /// <returns></returns> public hunt GetHuntBasedOnName(String name, long userId) { using (var context = new TreasureHuntEntities()) { //Get all of this usershunts ids for the given user. var returnedUserHunts = context.userhunts.Where(c => c.UserId == userId).ToList(); context.ObjectStateManager.ChangeObjectState(returnedUserHunts, System.Data.EntityState.Detached); //For each of these hunt ids, foreach (var userHunts in returnedUserHunts) { //Grab that hunt, var hunt = context.hunts.Where(c => c.HuntId == userHunts.HuntId).Single(); context.ObjectStateManager.ChangeObjectState(hunt, System.Data.EntityState.Detached); //If that hunt name is the same as expected, return that hunt. if (hunt.HuntName == name) { return hunt; } } return null; } }
/// <summary> /// Method that returns the securityquestion answer associated with a given user. /// </summary> /// <param name="currentUser"></param> /// <returns></returns> public usersecurityquestion getUserSecurityAnswer(user currentUser) { using (var context = new TreasureHuntEntities()) { if (currentUser == null) return null; var returnedUserSecurityQuestionDetails = context.usersecurityquestions.Where(c => c.UserId == currentUser.UserId).Single(); context.ObjectStateManager.ChangeObjectState(returnedUserSecurityQuestionDetails, System.Data.EntityState.Detached); return returnedUserSecurityQuestionDetails; } }
/// <summary> /// Method that saves new usersecurityquestion data into the 'usersecurityquestions' table. /// </summary> /// <param name="userSecurityQuestion"></param> public void SaveUserSecurityQuestion(usersecurityquestion userSecurityQuestion) { using (var context = new TreasureHuntEntities()) { context.usersecurityquestions.AddObject(userSecurityQuestion); context.SaveChanges(); context.ObjectStateManager.ChangeObjectState(userSecurityQuestion, System.Data.EntityState.Added); } }
/// <summary> /// Method that saves new UserRole data into the 'userroles' table. /// </summary> /// <param name="newUserRole"></param> public void SaveUserRole(userrole newUserRole) { using (var context = new TreasureHuntEntities()) { context.userroles.AddObject(newUserRole); context.SaveChanges(); context.ObjectStateManager.ChangeObjectState(newUserRole, System.Data.EntityState.Added); } }
/// <summary> /// Method that saves a new user into the 'users' table. /// </summary> /// <param name="newUser"></param> /// <returns></returns> public long SaveUser(user newUser) { using (var context = new TreasureHuntEntities()) { context.users.AddObject(newUser); context.SaveChanges(); context.ObjectStateManager.ChangeObjectState(newUser, System.Data.EntityState.Added); return newUser.UserId; } }
/// <summary> /// Method that saves company data into the 'companydetails' table. /// </summary> /// <param name="companyDetails"></param> public void saveCompany(companydetail companyDetails) { using(var context = new TreasureHuntEntities()) { context.companydetails.AddObject(companyDetails); context.SaveChanges(); context.ObjectStateManager.ChangeObjectState(companyDetails, System.Data.EntityState.Added); } }
public void UpdateQuestion(question updatedQuestion) { using (var context = new TreasureHuntEntities()) { context.questions.AddObject(updatedQuestion); context.SaveChanges(); context.ObjectStateManager.ChangeObjectState(updatedQuestion, System.Data.EntityState.Modified); } }
/// <summary> /// Method that returns all of the securityquestion data associated with a given user. /// </summary> /// <param name="user"></param> /// <returns></returns> public securityquestion getUserSecurityQuestion(user user) { using (var context = new TreasureHuntEntities()) { if (user == null) return null; //Grab the user's securityquestionId var returnedUserSecurityQuestionId = context.usersecurityquestions.Where(c => c.UserId == user.UserId).Select(s => s.SecurityQuestionId).Single(); context.ObjectStateManager.ChangeObjectState(returnedUserSecurityQuestionId, System.Data.EntityState.Detached); //Grab the security question associated with this id. var returnedQuestion = context.securityquestions.Where(c => c.SecurityQuestionId == returnedUserSecurityQuestionId).Single(); context.ObjectStateManager.ChangeObjectState(returnedQuestion, System.Data.EntityState.Detached); return returnedQuestion; } }
/// <summary> /// Method that returns a list of questions for a given hunt. /// </summary> /// <param name="hunt"></param> /// <returns></returns> public IEnumerable<question> GetHuntQuestions(hunt hunt) { using (var context = new TreasureHuntEntities()) { if (hunt == null) return null; //Grab all of the question ids associated with a given hunt. var returnedquestionIds = context.huntquestions.Where(c => c.HuntId == hunt.HuntId).Select(s => s.QuestionId).ToList(); returnedquestionIds.ForEach(e => context.ObjectStateManager.ChangeObjectState(e, System.Data.EntityState.Detached)); List<question> returnedListOfQuestions = new List<question>(); //For each one of these ids foreach (var questionId in returnedquestionIds) { //Add to the list the question associated with this id. var question = context.questions.Where(c => c.QuestionId == questionId).Single(); context.ObjectStateManager.ChangeObjectState(question, System.Data.EntityState.Detached); returnedListOfQuestions.Add(question); } return returnedListOfQuestions; } }
/// <summary> /// Method that saves new hunt data into the 'hunts' table. /// </summary> /// <param name="newHunt"></param> /// <returns></returns> public long SaveNewHunt(hunt newHunt) { using (var context = new TreasureHuntEntities()) { context.hunts.AddObject(newHunt); context.SaveChanges(); context.ObjectStateManager.ChangeObjectState(newHunt, System.Data.EntityState.Added); return newHunt.HuntId; } }
/// <summary> /// Method that returns all of the security questions available in the 'securityquestions' table. /// </summary> /// <returns></returns> public IEnumerable<securityquestion> getListOfSecurityQuestions() { using (var context = new TreasureHuntEntities()) { var returnedQuestions = context.securityquestions.ToList(); returnedQuestions.ForEach(e => context.ObjectStateManager.ChangeObjectState(e, System.Data.EntityState.Detached)); return returnedQuestions; } }
/// <summary> /// Method that saves userhunt data in the 'userhunts' table. /// </summary> /// <param name="userHunt"></param> public void SaveUserHunt(userhunt userHunt) { using (var context = new TreasureHuntEntities()) { context.userhunts.AddObject(userHunt); context.SaveChanges(); context.ObjectStateManager.ChangeObjectState(userHunt, System.Data.EntityState.Added); } }
/// <summary> /// Method that returns the name of the participant associated with a given id. /// </summary> /// <param name="userId"></param> /// <returns></returns> public user GetParticipant(long userId) { using (var context = new TreasureHuntEntities()) { var returnedHuntParticipant = context.users.Where(c => c.UserId == userId).Single(); context.ObjectStateManager.ChangeObjectState(returnedHuntParticipant, System.Data.EntityState.Detached); return returnedHuntParticipant; } }
/// <summary> /// Method that returns a list of treasure hunts for a given user. /// </summary> /// <param name="user"></param> /// <returns></returns> public IEnumerable<hunt> GetTreasureHuntsForParticularUser(user user) { using (var context = new TreasureHuntEntities()) { if (user == null) return null; //Grab of all HuntIds associated with the given user. var returnedHuntIds = context.userhunts.Where(c => c.UserId == user.UserId).Select(s => s.HuntId).ToList(); returnedHuntIds.ForEach(e => context.ObjectStateManager.ChangeObjectState(e, System.Data.EntityState.Detached)); List<hunt> returnedListOfHunts = new List<hunt>(); //For each of these ids foreach (var huntId in returnedHuntIds) { //Add to a list the hunt associated with this id. var hunt = context.hunts.Where(c => c.HuntId == huntId).Single(); context.ObjectStateManager.ChangeObjectState(hunt, System.Data.EntityState.Detached); returnedListOfHunts.Add(hunt); } //Return this list. return returnedListOfHunts; } }
/// <summary> /// Method that returns a user associated with the given email address. /// </summary> /// <param name="emailAddress"></param> /// <returns></returns> public user GetUser(string emailAddress) { using (var context = new TreasureHuntEntities()) { if (context.users.Any(c => c.Email == emailAddress)) { var returnedUser = context.users.Where(c => c.Email == emailAddress).Single(); context.ObjectStateManager.ChangeObjectState(returnedUser, System.Data.EntityState.Detached); return returnedUser; } return null; } }
/// <summary> /// Method that updates the login password associated with a given user. /// </summary> /// <param name="currentUser"></param> /// <param name="newPassword"></param> public void updateUserPassword(user currentUser, String newPassword) { using (var context = new TreasureHuntEntities()) { var userToChange = context.users.Where(c => c.UserId == currentUser.UserId).Single(); userToChange.Password = newPassword; context.SaveChanges(); context.ObjectStateManager.ChangeObjectState(userToChange, System.Data.EntityState.Modified); } }
/// <summary> /// Method that returns the userrole data associated with the given user. /// </summary> /// <param name="user"></param> /// <returns></returns> public userrole GetUserRole(user user) { using (var context = new TreasureHuntEntities()) { var returnedUserRole = context.userroles.Where(c => c.UserId == user.UserId).Single(); context.ObjectStateManager.ChangeObjectState(returnedUserRole, System.Data.EntityState.Detached); return returnedUserRole; } }
//-http://stackoverflow.com/questions/15576282/sorting-a-c-sharp-list-by-multiple-columns //-http://stackoverflow.com/questions/18525253/wpf-listt-sort /// <summary> /// Method that returns all the huntparticipant data for a given treasure hunt. /// </summary> /// <param name="currentTreasureHunt"></param> /// <returns></returns> public List<huntparticipant> GetHuntParticipants(hunt currentTreasureHunt) { using (var context = new TreasureHuntEntities()) { if (currentTreasureHunt == null) return null; var returnedHuntParticipants = context.huntparticipants.Where(c => c.HuntId == currentTreasureHunt.HuntId).OrderByDescending(s => s.Tally).ThenBy(s => s.ElapsedTime).ToList(); returnedHuntParticipants.ForEach(e => context.ObjectStateManager.ChangeObjectState(e, System.Data.EntityState.Detached)); return returnedHuntParticipants; } }
public hunt GetHuntBasedOnName(String name) { using (var context = new TreasureHuntEntities()) { var returnedHunt = context.hunts.Where(c => c.HuntName == name).Single(); context.ObjectStateManager.ChangeObjectState(returnedHunt, System.Data.EntityState.Detached); return returnedHunt; } }