public LogEntry AddEntryToDb(string typeOfExcercise, string distance, int hours, int minutes, int seconds, int userId, string dateCreated, long kcal) { LogEntry demoLog = new LogEntry(); int result = -1; using (var db = new DataAccessContext()) { LogEntry log = new LogEntry { TypeOfExcercise = typeOfExcercise, Distance = distance, Hours = hours, Minutes = minutes, Seconds = seconds, UserId = userId, DateCreated = dateCreated, Kcal = kcal, }; demoLog = log; db.LogEntries.Add(log); result = db.SaveChanges(); } if (result != -1) { return demoLog; } else { return null; } }
public User AddUserToDb(string userName, string password, string name, int age, double weight, double height, long xp, int level, string privacyName, string privacyAge, string privacyWeight, string privacyHeight) { User newUser = new User(); //Check if username exist if it does, return null object int result = -1; using (var db = new DataAccessContext()) { User user = new User { UserName = userName, Password = password, Name = name, Age = age, Weight = weight, Height = height, Xp = xp, Level = level, PrivacyName = privacyName, PrivacyAge = privacyAge, PrivacyWeight = privacyWeight, PrivacyHeight = privacyHeight }; db.Users.Add(user); result = db.SaveChanges(); if (result != -1) newUser = user; } return newUser; }
public LogEntry GetEntryFromDB(int entryId, int userId) { LogEntry entry = new LogEntry(); using (var db = new DataAccessContext()) { LogEntry theEntry = (from log in db.LogEntries where log.LogEntryId == entryId & log.UserId == userId select log).Single(); entry = theEntry; } return entry; }
public Achievement GetLatestAchievement(int userId) { //By userID, find latest achievement and send to client Achievement latestAch = new Achievement(); using (var db = new DataAccessContext()) { var query = "select * from achievements as a where achievementid ="+ "(select achievement_achievementid from userachievements "+ "where user_userid = 57 and achievement_achievementid = a.achievementid)"; var data = db.Database.SqlQuery<Achievement>(query).First(); latestAch = data; } return latestAch; }
/// <summary> /// Tildeler de achievements til brugeren, som er fundet. /// </summary> /// <param name="list"></param> /// <param name="currentUser"></param> public void AssignAchievement(List<Achievement> list, User currentUser) { foreach (Achievement a in list) { using (var db = new DataAccessContext()) { int result = -1; int userId = currentUser.UserId; int achId = a.AchievementId; result = db.Database.ExecuteSqlCommand("INSERT INTO UserAchievements VALUES(" + userId + "," + achId + ")"); db.SaveChanges(); //User dbUser = (from user in db.Users // where user.UserId == currentUser.UserId // select user).FirstOrDefault(); //dbUser.Achievements = list; //db.SaveChanges(); } } }
public User GetUser(string username, string password) { User newUser = new User(); using (var db = new DataAccessContext()) { User theUser = (from user in db.Users .Include("Achievements") .Include("Titles") .Include("Logs") where user.UserName == username & user.Password == password select user).FirstOrDefault(); newUser = theUser; } return newUser; }
public List<LogEntry> GetFiveLatestLogs(int userId) { List<LogEntry> lastFiveLogs = new List<LogEntry>(); using (var db = new DataAccessContext()) { List<LogEntry> dbList = (from logs in db.LogEntries where logs.UserId == userId orderby logs.LogEntryId descending select logs).Take(5).ToList(); lastFiveLogs = dbList; } return lastFiveLogs; }
/// <summary> /// Baseret på brugerens xp, check om der er nogle achievement som kan tildeles. /// /// </summary> /// <param name="userXp"></param> /// <returns>liste over evt. achieves som brugeren skal have</returns> private List<Achievement> CheckForAchievement(long userXp) { List<Achievement> eligebleAchieves = new List<Achievement>(); List<Achievement> allTheAchieves = new List<Achievement>(); using (var db = new DataAccessContext()) { List<Achievement> dbList = (from achievements in db.Achievements select achievements).ToList(); allTheAchieves = dbList; } foreach (Achievement ach in allTheAchieves) { if (userXp > ach.XpToAchieve && ach.XpToAchieve != -1) { eligebleAchieves.Add(ach); } } return eligebleAchieves; }
public void UpdateUserXP(string userName, long earnedXp) { User newUser = new User(); long oldXp; using (var db = new DataAccessContext()) { User theUser = (from user in db.Users where user.UserName == userName select user).FirstOrDefault(); // Get the old xp for user before accumulating oldXp = theUser.Xp; // Accumulate new xp theUser.Xp += earnedXp; // Check for LevelUp long newXp = theUser.Xp; // Check if User should be levelled up if ((newXp) > (oldXp * 1.1)) { // Increment user level theUser.Level += 1; } newUser = theUser; db.SaveChanges(); } AssignAchievement(CheckForAchievement(newUser.Xp), newUser); }
public User UpdateUserProfile(string userName, string password, string name, int age, double weight, double height, long xp, int level) { User newUser = new User(); using (var db = new DataAccessContext()) { User theUser = (from user in db.Users where user.UserName == userName select user).FirstOrDefault(); // Update user theUser.UserName = userName; theUser.Password = password; theUser.Name = name; theUser.Age = age; theUser.Weight = weight; theUser.Height = height; theUser.Xp = xp; theUser.Level = level; theUser.PrivacyName = ""; theUser.PrivacyAge = ""; theUser.PrivacyWeight = ""; theUser.PrivacyHeight = ""; newUser = theUser; db.SaveChanges(); } return newUser; }
public FooterRepository() { this.context = new DataAccessContext(); }
public FeedbackRepository() { this.context = new DataAccessContext(); }
public ArticleCommentRepository() { this.dataAccessContext = new DataAccessContext(); }
public ImageRepository() { this.context = new DataAccessContext(); }
public SqlRepository(DataAccessContext db) { Db = db; }