public ActionResult detailTask(int id) { var task = pocoDb.Fetch <tblTask>("where TaskID=@0", id).FirstOrDefault(); var taskStatus = pocoDb.Fetch <tblTaskStatus>("Where taskStatusID=@0", task.taskStatusID).FirstOrDefault(); var notes = pocoDb.Fetch <tblNote>("where objectID=@0", id); var pids = notes.Select(x => x.createdByID).ToList(); var person = pocoDb.Fetch <tblPerson>("where PersonID=@0", task.createdByID).FirstOrDefault(); var company = pocoDb.Fetch <tblCompany>("Where CompanyID=@0", task.CompanyID).FirstOrDefault(); var client = pocoDb.Fetch <tblPerson>("Where PersonID=@0", company.ContactID).FirstOrDefault(); var estimate = pocoDb.FirstOrDefault <tblEstimate>("Where EstimateID IS NOT NULL and estimateID=@0", task.estimateID); List <tblPerson> personlist = null; if (pids.Any() == true) { personlist = pocoDb.Fetch <tblPerson>("Where PersonID IN (@0)", pids).ToList(); } var VM = new ClientPortal.ViewModels.TasksViewModel { Task = task, Notes = notes, People = personlist, Status = taskStatus, Person = person, Company = company, Client = client, Estimate = estimate }; return(View(VM)); }
// GET: Task public ActionResult displayTasks() { string userid = ""; if (Session["userId"] != null) { userid = Session["userId"].ToString(); } int userID = int.Parse(userid); var user = pocoDb.Fetch <tblUser>("where userID=@0", userID).FirstOrDefault(); var personID = user.PersonID; var person = pocoDb.Fetch <tblPerson>("where PersonID=@0", personID).FirstOrDefault(); var companyID = person.CompanyID; List <int> activeStatusID = new List <int>() { 1, 2, 3, 6, 17, 19, 20, 21 }; var tasksActive = pocoDb.Fetch <tblTask>("Where taskStatusID IN(@0) and CompanyID=@1 and isnull(parentID,0)=0", activeStatusID, companyID).OrderByDescending(m => m.CreatedDate); List <int> closedStatusID = new List <int>() { 7, 16 }; var closedTasks = pocoDb.Fetch <tblTask>("Where closedDate IS NOT NULL and taskStatusID IN(@0) and isnull(parentID,0)=0", closedStatusID); var topTenTasks = closedTasks.OrderByDescending(m => m.ClosedDate).Take(10); var VM = new ClientPortal.ViewModels.TasksViewModel { Tasks = tasksActive, closedTasks = topTenTasks }; return(View(VM)); }
public ActionResult noteList(int taskID) { var notes = pocoDb.Fetch <tblNote>("where objectID=@0", taskID); var VM = new ClientPortal.ViewModels.TasksViewModel { Notes = notes }; return(View(VM)); }