public IQueryable<Task> GetTasksByUser(UserProfile user)
{
IQueryable<Task> query = context.Tasks.Where(t => t.ParentTaskId == null && t.Users.Any(U => U.UserId == user.UserId));
foreach (Task task in query.ToList())
{
task.ChildTask = context.Tasks.Where(t => t.ParentTaskId == task.TaskID).ToList();
task.CreatedByUser = context.UserProfiles.Where(t => t.UserId == task.CreatedBy).FirstOrDefault();
task.ProjectStatus = context.ProjectStatuses.Where(t => t.ProjectStatusID==null||t.ProjectStatusID == task.ProjectStatusID).FirstOrDefault();
task.LoggedTime = context.TimeLogs.Where(t => t.TaskID == task.TaskID).ToList(); //List of time log against task Added by Mahedee @18-03-14
task.ActualTaskHour = task.LoggedTime.Sum(x => x.TaskHour); //Sum of entry hour as actual hour. Added by Mahedee @18-03-14
}
return query;
}
private string GenerateMailBody(UserProfile user)
{
string overdueTask = string.Empty;
string todaysTask = string.Empty;
string dueTommorrowTask = string.Empty;
string futureTask = string.Empty;
string messageBody = string.Empty;
IQueryable<Task> taskList = unitofWork.TaskRepository.GetTasksByUser(user);
messageBody = "<b>Dear " + user.FirstName + "</b>,<br>" + "<b>You have the following tasks:</b><br>";
foreach (Task task in taskList)
{
if (task.EndDate < DateTime.Today) // overdue task
{
overdueTask += "<li>" + task.Title + "</li>";
}
else if (task.StartDate == DateTime.Today) // todays task
{
todaysTask += "<li>" + task.Title + "</li>";
}
else if (task.EndDate == DateTime.Today.AddDays(1)) //due tomorrow task
{
dueTommorrowTask += "<li>" + task.Title + "</li>";
}
else if (task.StartDate > DateTime.Today) //Future task
{
futureTask += "<li>" + task.Title + "</li>";
}
}
if (overdueTask != string.Empty)
{
messageBody += "<b>Overdue tasks:</b> <br>" + overdueTask;
}
if (todaysTask != string.Empty)
{
messageBody += "<b>Today's tasks:</b> <br>" + todaysTask;
}
if (dueTommorrowTask != string.Empty)
{
messageBody += "<b>Due Tommorrow's tasks:</b> <br>" + dueTommorrowTask;
}
if (futureTask != string.Empty)
{
messageBody += "<b>Future tasks:</b> <br>" + futureTask;
}
return messageBody;
}
public void Update(UserProfile user)
{
context.Entry(user).State = System.Data.Entity.EntityState.Modified;
}
public void Insert(UserProfile user)
{
context.UserProfiles.Add(user);
}
public IQueryable<Task> ByProjectIncluding(long projectID, UserProfile user, params Expression<Func<Task, object>>[] includeProperties)
{
IQueryable<Task> query = context.Tasks.Where(t => t.ProjectID == projectID && t.ParentTaskId == null && t.Users.Any(U=>U.UserId==user.UserId));
foreach (var includeProperty in includeProperties)
{
query = query.Include(includeProperty);
}
foreach (Task task in query.ToList())
{
task.ChildTask = context.Tasks.Where(t => t.ParentTaskId == task.TaskID).ToList();
}
return query;
}
public List<Notification> UserUnreadNotification(UserProfile user)
{
return context.Notifications.Where(n=>n.UserID==user.UserId && n.IsNoticed==false).ToList();
}
public void LoadAssignedProjects(UserProfile user)
{
List<Project> projectList= unitOfWork.ProjectRepository.GetAssignedProjectByUser(user);
ViewBag.AssignedProjects = projectList;
}
public void LoadUnreadNotifications(UserProfile user)
{
}
public ActionResult EditProfile(UserProfileViewModel model)
{
UserProfile user = new UserProfile();
user = unitOfWork.UserRepository.GetUserByUserID((int)Membership.GetUser(WebSecurity.CurrentUserName).ProviderUserKey);
user.FirstName = model.FirstName;
user.LastName = model.LastName;
unitOfWork.UserRepository.Update(user);
unitOfWork.Save();
ViewBag.Flag = "1";
// MembershipUser user2= Membership.GetUser(user.UserName);
return View(model);
}
public ActionResult EditProfile()
{
// UserProfileViewModel userModel = new UserProfileViewModel();
UserProfile user = new UserProfile();
UserProfileViewModel userModel = new UserProfileViewModel();
user = unitOfWork.UserRepository.GetUserByUserID((int)Membership.GetUser(WebSecurity.CurrentUserName).ProviderUserKey);
userModel.Email = user.Email;
userModel.FirstName = user.FirstName;
userModel.LastName = user.LastName;
return View(userModel);
}