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 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 int Update(Footer ft) { Footer footer = this.Get(); footer.copyright = ft.copyright; footer.fbUrl = ft.fbUrl; footer.gitUrl = ft.gitUrl; return(context.SaveChanges()); }
/// <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 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 int Insert(Feedback feed) { context.Feedbacks.Add(feed); return(context.SaveChanges()); }