public RefUserProViewModel() : base() { ShlekenEntities3 db = new ShlekenEntities3(); ProjectId = ProjecrId; Tasks = db.TasksRoles.Where(t => t.RoleId == RoleId).ToList(); }
public static List <MeetingsViewModel> GetAll(int ProjectId, MeetingsearchViewModel search) { if (search.ToDate != null) { search.ToDate = search.ToDate.Value.AddDays(1); } if (search.FromDate != null) { search.FromDate = search.FromDate.Value.AddDays(-1); } using (var db = new ShlekenEntities3()) { return(db.Meetings .Where(i => i.Projects.AccountId == Userservice.AccountId && i.ProjectId == ProjectId && (string.IsNullOrEmpty(search.Subject) == true || i.Subject.ToLower().Contains(search.Subject.ToLower())) && (string.IsNullOrEmpty(search.Location) == true || i.Location.ToLower().Contains(search.Location.ToLower())) && (search.ToDate == null || i.Date < search.ToDate) && (search.FromDate == null || i.Date > search.FromDate) ) .ToList() .Select(i => { var item = i.Map <Meetings, MeetingsViewModel>(); return item; }) .ToList()); } }
public static List <OutcomesViewModel> Get(BudgetSearchViewModel search) { if (search.ToDate != null) { search.ToDate = search.ToDate.Value.AddDays(1); } if (search.FromDate != null) { search.FromDate = search.FromDate.Value.AddDays(-1); } using (var db = new ShlekenEntities3()) { return(db.Outcomes .Where(i => i.Projects.AccountId == Userservice.AccountId && (search.ProjectId == 0 || i.ProjectId == search.ProjectId) && (search.ToDate == null || i.Date < search.ToDate) && (search.FromDate == null || i.Date > search.FromDate) ) .ToList() .Select(i => { var item = i.Map <Outcomes, OutcomesViewModel>(); item.ApproverName = i.Users.Name; return item; }) .ToList()); } }
public static List <TeamsViewModel> GetAllMore180(int ProjectId) { using (var db = new ShlekenEntities3()) { var datesProjects = DatesProjects(ProjectId); var Teams = db.Teams .Where(i => i.Projects.AccountId == Userservice.AccountId) .ToList() .GroupBy(i => new { i.Users }) .ToList(); var listTeams = new List <TeamsViewModel>(); foreach (var team in Teams) { var item = new TeamsViewModel(); item.Name = team.Key.Users.Name; item.UserId = team.Key.Users.Id; item.UsersHours = new List <HourDate>(); var TeamsDate = team.GroupBy(i => i.Date); foreach (var td in TeamsDate) { var sum = 0; foreach (var t in td) { sum += t.Hours; } var UsersHours = new HourDate { Date = td.Key.Date, Hour = sum, Usersname = item.Name }; item.UsersHours.Add(UsersHours); } item.AllHours = new List <HourDate>(); foreach (var date in datesProjects) { var count = 1; foreach (var hour in item.UsersHours) { if (hour.Date.Month == date.Date.Month && hour.Date.Year == date.Date.Year) { item.AllHours.Add(new HourDate { Hour = hour.Hour, Date = hour.Date, Id = hour.Id, Usersname = hour.Usersname }); } else { if (count == item.UsersHours.Count) { item.AllHours.Add(new HourDate { Hour = 0, Date = date.Date, Id = 0, Usersname = hour.Usersname }); } count++; } } } listTeams.Add(item); } return(listTeams); } }
public static void Delete(int id) { using (var db = new ShlekenEntities3()) { var user = db.RefUserPro.Where(u => u.Id == id).FirstOrDefault(); var item = db.Roles.Single(i => i.Id == user.RoleId); var list = db.Teams.ToList(); foreach (var i in list) { if (i.ProjectId == item.ProjectId && i.RoleId == item.Id) { db.Teams.Remove(i); db.SaveChanges(); } } var TasksRoles = db.TasksRoles.ToList(); foreach (var t in TasksRoles) { if (t.Roles.ProjectId == item.ProjectId && t.RoleId == item.Id) { db.TasksRoles.Remove(t); db.SaveChanges(); } } db.Roles.Remove(item); db.RefUserPro.Remove(user); db.SaveChanges(); } }
public static List <RefUserProViewModel> Get(int projectId, UsersSearchViewModel search) { using (var db = new ShlekenEntities3()) { var users = db.Projects.ToList().FirstOrDefault(i => i.Id == projectId).RefUserPro.ToList(); if (!string.IsNullOrEmpty(search.Name)) { users = users.Where(n => n.Users.Name.Contains(search.Name)).ToList(); } if (!string.IsNullOrEmpty(search.Role)) { users = users.Where(r => r.ProjecrId == projectId && r.Roles.Name == search.Role).ToList(); } var u = users.ToList().Map <RefUserPro, RefUserProViewModel>(); for (int i = 0; i < users.Count; i++) { u[i].ProjectId = users[i].ProjecrId; u[i].ProjectName = users[i].Projects.Name; u[i].Email = users[i].Users.Email; u[i].Name = users[i].Users.Name; u[i].IsOwner = db.Projects.ToList().FirstOrDefault(j => j.Id == projectId).RefUserPro.Min(o => o.Id) == users[i].Users.Id; u[i].Password = users[i].Users.Password; u[i].Task = db.TasksRoles.ToList().FirstOrDefault(g => g.RoleId == users[i].RoleId); } return(u); } }
public static void Save(List <GlobalsViewModel> models) { using (var db = new ShlekenEntities3()) { if (models != null) { foreach (var model in models) { if (model.Id > 0) { var item = db.Globals.Single(i => i.Projects.AccountId == Userservice.AccountId && i.Id == model.Id); item = model.Map <GlobalsViewModel, Globals>(item); db.SaveChanges(); } else { if (model.Name != null) { var item = model.Map <GlobalsViewModel, Globals>(); db.Globals.Add(item); db.SaveChanges(); } } } } } }
public static void Save(List <TasksViewModel> models) { using (var db = new ShlekenEntities3()) { foreach (var model in models) { if (model.Id > 0) { var tr = model.TasksRoles; model.TasksRoles = null; var item = db.Tasks.SingleOrDefault(i => i.Projects.AccountId == Userservice.AccountId && i.Id == model.Id); item = model.Map <TasksViewModel, Entities.Tasks>(item); db.SaveChanges(); if (tr != null) { SaveRolestaks(tr, item.Id); } } else { if (model.Name != null) { var item = model.Map <TasksViewModel, Entities.Tasks>(); db.Tasks.Add(item); db.SaveChanges(); var TasksAfterSave = db.Tasks.ToList().Last(); if (model.TasksRoles != null) { SaveRolestaks(model.TasksRoles, TasksAfterSave.Id); } } } } } }
public static List <RisksViewModel> Get(int ProjectId, RisksearchViewModel search) { using (var db = new ShlekenEntities3()) { return(db.Risks .Where(i => i.Projects.AccountId == Userservice.AccountId && i.ProjectId == ProjectId && (string.IsNullOrEmpty(search.Name) == true || i.Name.ToLower().Contains(search.Name.ToLower())) && (search.Status == 0 || i.Status == search.Status) && (search.Priority == 0 || i.Priority == search.Priority) && (search.Probabilty == 0 || i.Probabilty == search.Probabilty) && (search.UserId == 0 || i.UserId == search.UserId) ) .ToList() .Select(i => { var item = i.Map <Risks, RisksViewModel>(); item.ProbabiltyName = i.RiskProbabilities.Name; item.PriorityName = i.RiskPriorities.Name; item.StatusName = i.RiskStatuses.Name; item.UsersName = i.Users.Name; return item; }) .ToList().OrderBy(i => i.Date).ToList()); } }
public static void SaveRolestaks(ICollection <TasksRoles> TasksRoles, int TaskId) { using (var db = new ShlekenEntities3()) { foreach (var model in TasksRoles) { model.TaskId = TaskId; var item = db.TasksRoles.SingleOrDefault(i => i.RoleId == model.RoleId && i.TaskId == TaskId); if (item != null) { item.TaskId = model.TaskId; item.RoleId = model.RoleId; item.Value = model.Value; db.SaveChanges(); } else { TasksRoles newItem = new TasksRoles { TaskId = model.TaskId, RoleId = model.RoleId, Value = model.Value }; db.TasksRoles.Add(newItem); db.SaveChanges(); } } } }
public static List <ToDoListsViewModel> GetAll(int ProjectId, ToDoListsearchViewModel search) { if (search.ToDate != null) { search.ToDate = search.ToDate.Value.AddDays(1); } if (search.FromDate != null) { search.FromDate = search.FromDate.Value.AddDays(-1); } using (var db = new ShlekenEntities3()) { return(db.ToDoLists .Where(i => i.Projects.AccountId == Userservice.AccountId && i.ProjectId == ProjectId && (search.ToDate == null || i.Date < search.ToDate) && (search.FromDate == null || i.Date > search.FromDate) && (search.IsDone == 0 || i.IsDone == search.IsDone) && (string.IsNullOrEmpty(search.Description) == true || i.Description.ToLower().Contains(search.Description.ToLower())) ) .ToList() .Select(i => { var item = i.Map <ToDoLists, ToDoListsViewModel>(); item.Status = i.ToDoListStatuses.Name; return item; }) .ToList()); } }
public static List <ProjectsViewModel> Get(ProjectsSearchViewModel search, int userId) { using (var db = new ShlekenEntities3()) { return(db.Projects.ToList().Where(p => p.RefUserPro.Any(r => r.UserId == userId)) .Where(i => i.AccountId == Userservice.AccountId && (string.IsNullOrEmpty(search.Name) == true || i.Name.ToLower().Contains(search.Name.ToLower())) && //(search.OwnerId == 0 || i.OwnerId == search.OwnerId) && (search.Status == 0 || i.Status == search.Status)) .ToList() .Select(i => { var item = i.Map <Projects, ProjectsViewModel>(); if (i.RefUserPro.Where(o => o.IsOwner == true).FirstOrDefault() == null && i.RefUserPro.ToList().FirstOrDefault() != null) { i.RefUserPro.ToList().FirstOrDefault().IsOwner = true; } if (i.RefUserPro.Where(o => o.IsOwner == true).FirstOrDefault() != null) { item.OwnerName = i.RefUserPro.Where(o => o.IsOwner == true).FirstOrDefault().Users.Name; } item.StatusName = i.ProjectStatuses.Name; return item; }) .ToList()); } }
public static List <ProjectStatusesViewModel> Get() { using (var db = new ShlekenEntities3()) { return(db.ProjectStatuses .Map <ProjectStatuses, ProjectStatusesViewModel>()); } }
public static List <RiskPrioritiesViewModel> Get() { using (var db = new ShlekenEntities3()) { return(db.RiskPriorities .Map <RiskPriorities, RiskPrioritiesViewModel>()); } }
public static List <ToDoListStatusesViewModel> Get() { using (var db = new ShlekenEntities3()) { return(db.ToDoListStatuses .Map <ToDoListStatuses, ToDoListStatusesViewModel>()); } }
public static List <MeetingsViewModel> GetMeetingsForUser(int id) { var db = new ShlekenEntities3(); var lm = new List <MeetingsViewModel>(); lm = db.Projects.Where(p => p.RefUserPro.Any(i => i.UserId == id)).ToList().SelectMany(pr => pr.Meetings.Map <Meetings, MeetingsViewModel>()).ToList(); return(lm); }
public static List <ProjectsViewModel> GetProjectsForUsers(int id) { var t = new ShlekenEntities3().Projects.Where(p => p.RefUserPro.Any(i => i.UserId == id)).ToList().Map <Projects, ProjectsViewModel>(); var s = new ShlekenEntities3().RefUserPro.ToList(); //var s = new ShlekenEntities3().Users.Where(i => i.Id == id).FirstOrDefault().RefUserPro.ToList().Select(p => p.Projects).Map<Projects, ProjectsViewModel>(); return(new ShlekenEntities3().Projects.Where(p => p.RefUserPro.Any(i => i.UserId == id)).ToList().Map <Projects, ProjectsViewModel>()); }
public static void Delete(int id) { using (var db = new ShlekenEntities3()) { var item = db.Outcomes.Single(i => i.Projects.AccountId == Userservice.AccountId && i.Id == id); db.Outcomes.Remove(item); db.SaveChanges(); } }
public static void Delete(int id) { using (var db = new ShlekenEntities3()) { var item = db.Users.Single(i => i.Id == id); db.Users.Remove(item); db.SaveChanges(); } }
public static List <RolesResourcesViewModel> Get(int ProjectId) { using (var db = new ShlekenEntities3()) { return(db.Roles .Where(i => i.Projects.AccountId == Userservice.AccountId && i.ProjectId == ProjectId) .Map <Roles, RolesResourcesViewModel>()); } }
public static List <UsersViewModel> Get(int projectId) { using (var db = new ShlekenEntities3()) { var t = db.Projects.ToList().FirstOrDefault(i => i.Id == projectId).RefUserPro.Select(i => i.Users).ToList(); var s = t.Map <Users, UsersViewModel>(); return(t.Map <Users, UsersViewModel>()); } }
public static int countRoles(int ProjectId) { using (var db = new ShlekenEntities3()) { return(db.Roles .Where(i => i.Projects.AccountId == Userservice.AccountId && i.ProjectId == ProjectId) .Count()); } }
public static object Single(int id) { using (var db = new ShlekenEntities3()) { return(db.Users. Single(i => i.Id == id) .Map <Users, UsersViewModel>()); } }
public static object Single(int id) { using (var db = new ShlekenEntities3()) { return(db.Activities .Single(i => i.Projects.AccountId == Userservice.AccountId && i.Id == id) .Map <Activities, ActivitiesViewModel>()); } }
public static List <UsersViewModel> Get() { using (var db = new ShlekenEntities3()) { return(db.Users .Map <Users, UsersViewModel>()); } }
public static List <GlobalsViewModel> Get(int ProjectId) { using (var db = new ShlekenEntities3()) { return(db.Globals .Where(i => i.Projects.AccountId == Userservice.AccountId && i.ProjectId == ProjectId) .Map <Globals, GlobalsViewModel>()); } }
public static ProjectsViewModel Single(int id) { using (var db = new ShlekenEntities3()) { return(db.Projects .Single(i => i.AccountId == Userservice.AccountId && i.Id == id) .Map <Projects, ProjectsViewModel>()); } }
public static List <ProjectsViewModel> Get() { using (var db = new ShlekenEntities3()) { return(db.Projects .Where(i => i.AccountId == Userservice.AccountId && i.Status == 1) .Map <Projects, ProjectsViewModel>()); } }
public static ProjectsViewModel Get(int Projects) { using (var db = new ShlekenEntities3()) { var getProjects = db.Projects .SingleOrDefault(i => i.AccountId == Userservice.AccountId && i.Id == Projects); var item = getProjects.Map <Projects, ProjectsViewModel>(); return(item); } }
public static void SaveTeamsHoursCost(int TeamsHours, int TeamsCost, int ProjectId) { using (var db = new ShlekenEntities3()) { var item = db.Projects.Single(i => i.AccountId == Userservice.AccountId && i.Id == ProjectId); item.TeamTotalCost = TeamsCost; item.TeamTotalHours = TeamsHours; db.SaveChanges(); } }