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