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