public void CreateTasks(string title, string details, DateTime?expirationDate, bool?isCompleted, int?effort, int?remaininWork, int?statedId, int?activityId, int?priorityId, int?projectId) { DAL.Models.PCoreContext _context = new DAL.Models.PCoreContext(); _context.Tasks.Add(new DAL.Models.Tasks { Title = title, ActivityId = activityId, Details = details, Effort = effort, ExpirationDate = expirationDate, IsCompleted = isCompleted, PriorityId = priorityId, ProjectId = projectId, RemainingWork = remaininWork, StateId = statedId }); _context.SaveChanges(); }
public void DeleteProjects(int id) { DAL.Models.PCoreContext _context = new DAL.Models.PCoreContext(); if (_context.Artifacts.Any(x => x.ProjectId == id) || _context.UserProjects.Any(x => x.ProjectId == id)) { return; } var projectEF = _context.Projects.Where(x => x.Id == id).FirstOrDefault(); _context.Projects.Remove(projectEF); _context.SaveChanges(); }
public void UpdateProjects(int id, string title, string detail, DateTime?expectedCompletionDate) { DAL.Models.PCoreContext _context = new DAL.Models.PCoreContext(); var projectEF = _context.Projects.Where(x => x.Id == id).FirstOrDefault(); projectEF.Title = title; projectEF.Details = detail; projectEF.ExpectedCompletionDate = expectedCompletionDate; projectEF.UpdatedAt = DateTime.Now; _context.SaveChanges(); }
public List <Models.DB.Activities> GetActivities() { DAL.Models.PCoreContext _context = new DAL.Models.PCoreContext(); var listActivities = (from _activities in _context.Activities where _activities.Active == true select new Models.DB.Activities { Id = _activities.Id, Name = _activities.Name, Active = _activities.Active }).ToList(); return(listActivities); }
public void CreateProjects(string title, string details, DateTime?expectedCompletionDate, int?tenantId) { DAL.Models.PCoreContext _context = new DAL.Models.PCoreContext(); _context.Projects.Add(new DAL.Models.Projects { Title = title, Details = details, ExpectedCompletionDate = expectedCompletionDate, TenantId = tenantId, CreatedAt = DateTime.Now }); _context.SaveChanges(); }
public List <Models.DB.Tenants> GetTenants(string userId) { DAL.Models.PCoreContext _context = new DAL.Models.PCoreContext(); var listTenants = (from _tenants in _context.Tenants join _aspNetUsers in _context.AspNetUsers on _tenants.Id equals _aspNetUsers.TenantId where _aspNetUsers.Id.Equals(userId) select new Models.DB.Tenants { Id = _tenants.Id, Name = _tenants.Name, Plan = _tenants.Plan, CreatedAt = _tenants.CreatedAt, UpdatedAt = _tenants.UpdatedAt }).ToList(); return(listTenants); }
public List <Models.DB.Tasks> GetTasks(int?projectId, int?id) { DAL.Models.PCoreContext _context = new DAL.Models.PCoreContext(); var listTasks = (from _tasks in _context.Tasks join _states in _context.States on _tasks.StateId equals _states.Id join _activities in _context.Activities on _tasks.ActivityId equals _activities.Id join _priorities in _context.Priorities on _tasks.PriorityId equals _priorities.Id select new Models.DB.Tasks { Id = _tasks.Id, Details = _tasks.Details, Effort = _tasks.Effort, Title = _tasks.Title, ExpirationDate = _tasks.ExpirationDate, RemainingWork = _tasks.RemainingWork, IsCompleted = _tasks.IsCompleted, StateId = _tasks.StateId, State = new Models.DB.States { Name = _states.Name }, PriorityId = _tasks.PriorityId, Priority = new Models.DB.Priorities { Name = _priorities.Name }, ActivityId = _tasks.ActivityId, Activity = new Models.DB.Activities { Name = _activities.Name }, ProjectId = _tasks.ProjectId }).ToList(); if (projectId != null) { listTasks = listTasks.Where(x => x.ProjectId == projectId).ToList(); } if (id != null) { listTasks = listTasks.Where(x => x.Id == id).ToList(); } return(listTasks); }
public List <Models.DB.Projects> GetProjects(int?id, int?tenantId, string userId = null) { DAL.Models.PCoreContext _context = new DAL.Models.PCoreContext(); var listProjectsEF = (from _projects in _context.Projects select _projects).ToList(); if (id != null) { listProjectsEF = listProjectsEF.Where(x => x.Id == id).ToList(); } if (tenantId != null) { listProjectsEF = listProjectsEF.Where(x => x.TenantId == tenantId).ToList(); } if (!string.IsNullOrEmpty(userId)) { listProjectsEF = (from _projects in listProjectsEF join _userProjects in _context.UserProjects on _projects.Id equals _userProjects.ProjectId where _userProjects.UserId.Equals(userId) select _projects).ToList(); } var listProjects = (from _projects in listProjectsEF select new Models.DB.Projects { Id = _projects.Id, Title = _projects.Title, Details = _projects.Details, ExpectedCompletionDate = _projects.ExpectedCompletionDate, TenantId = _projects.TenantId, CreatedAt = _projects.CreatedAt, UpdatedAt = _projects.UpdatedAt }).ToList(); return(listProjects); }