public bool UpdateProjectTime(string projID, int hours)
{
bool success;
try
{
using (var databaseContext = new TimeTrackerEntities1())
{
var value = (from each in databaseContext.Hours
where each.UserID == "JASSOW"
where each.ActivityID == projID
select each).FirstOrDefault();
value.Hours1 = value.Hours1 + hours;
databaseContext.SaveChanges();
}
success = true;
}
catch
{
success = false;
}
return(success);
}
public List <Users> GetAllUsers()
{
using (var databaseContext = new TimeTrackerEntities1())
{
var entities = from each in databaseContext.Users
select each;
return(entities.ToList());
}
}
public int GetTotalHoursByUser(string userId)
{
decimal?sumDecimal;
using (var databaseContext = new TimeTrackerEntities1())
{
sumDecimal = (from t in databaseContext.Hours
where t.UserID == userId.ToUpper()
select t.Hours1).Sum();
}
return(Convert.ToInt32(sumDecimal));
}
public int GetProjectTime()
{
decimal query;
using (var databaseContext = new TimeTrackerEntities1())
{
query = (decimal)(from each in databaseContext.Hours
where each.ActivityID == "8"
where each.UserID == "JASSOW"
select each.Hours1).FirstOrDefault();
}
return(Convert.ToInt32(query));
}
public List <string> GetActivitySummaryByUser(string userid)
{
List <string> activitySummaries = new List <string>();
using (var databaseContext = new TimeTrackerEntities1())
{
var activityQueryResults = (from hours in databaseContext.Hours
join activities in databaseContext.Activities on hours.ActivityID equals activities.ID
where hours.UserID == userid.ToUpper()
select new
{
ActivityName = activities.Name,
Hours = hours.Hours1
});
foreach (var item in activityQueryResults)
{
activitySummaries.Add(string.Format("{0} {1} hours", item.ActivityName, Convert.ToInt32(item.Hours)));
}
}
return(activitySummaries);
}