Exemple #1
0
        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();
            }
        }
Exemple #2
0
 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();
             }
         }
     }
 }
Exemple #3
0
 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);
                     }
                 }
             }
         }
     }
 }
Exemple #4
0
 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();
                     }
                 }
             }
         }
     }
 }
Exemple #5
0
 public static void Save(RefUserProViewModel model)
 {
     using (var db = new ShlekenEntities3())
     {
         if (model.Id > 0)
         {
             var item = db.Users.Single(i => i.RefUserPro.Any(u => u.Id == model.Id));
             int id   = item.Id;
             item    = model.Map <UsersViewModel, Users>(item);
             item.Id = id;
             db.SaveChanges();
         }
         else
         {
             db.TasksRoles.Add(new TasksRoles {
                 RoleId = model.Task.RoleId, TaskId = Taskservice.GetTemp(model.ProjectId)
             });
             db.SaveChanges();
             if (model.UserId == 0)
             {
                 db.Users.Add(new Users {
                     Email = model.Email, Password = model.Password, Name = model.Name, AccountId = db.Accounts.FirstOrDefault().Id
                 });
                 db.SaveChanges();
                 model.UserId = db.Users.ToList().LastOrDefault().Id;
             }
             int roleId = db.TasksRoles.ToList().LastOrDefault().RoleId;
             db.RefUserPro.Add(new RefUserPro {
                 ProjecrId = model.ProjectId, RoleId = roleId, UserId = model.UserId
             });
             var y = db.TasksRoles.ToList().LastOrDefault();
             db.SaveChanges();
             List <TasksRoles> tasks = new List <TasksRoles>();
             foreach (var item in db.Projects.Single(p => p.Id == model.ProjectId).Tasks)
             {
                 if (db.TasksRoles.Any(t => t.TaskId == item.Id && t.RoleId == roleId) == false)
                 {
                     tasks.Add(new TasksRoles {
                         TaskId = item.Id, RoleId = roleId, Value = 0
                     });
                 }
             }
             db.TasksRoles.AddRange(tasks);
             db.SaveChanges();
         }
     }
 }
Exemple #6
0
 public static void Save(OutcomesViewModel model)
 {
     using (var db = new ShlekenEntities3())
     {
         if (model.Id > 0)
         {
             var item = db.Outcomes.Single(i => i.Projects.AccountId == Userservice.AccountId && i.Id == model.Id);
             item = model.Map <OutcomesViewModel, Outcomes>(item);
             db.SaveChanges();
         }
         else
         {
             var item = model.Map <OutcomesViewModel, Outcomes>();
             db.Outcomes.Add(item);
             db.SaveChanges();
         }
     }
 }
Exemple #7
0
 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();
     }
 }
Exemple #8
0
 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();
     }
 }
Exemple #9
0
 public static int Add(RolesResourcesViewModel model)
 {
     using (var db = new ShlekenEntities3())
     {
         var item = model.Map <RolesResourcesViewModel, Roles>();
         db.Roles.Add(item);
         db.SaveChanges();
         return(item.Id);
     }
 }
Exemple #10
0
 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();
     }
 }
Exemple #11
0
 public static void Save(UsersViewModel model)
 {
     using (var db = new ShlekenEntities3())
     {
         if (model.Id > 0)
         {
             var item = db.Users.Single(i => i.Id == model.Id);
             item = model.Map <UsersViewModel, Users>(item);
             db.SaveChanges();
         }
         else
         {
             var item = model.Map <UsersViewModel, Users>();
             item.AccountId = Userservice.AccountId;
             db.Users.Add(item);
             db.SaveChanges();
         }
     }
 }
Exemple #12
0
 public static void New(int pro, string name)
 {
     using (var db = new ShlekenEntities3())
     {
         db.Roles.Add(new Roles {
             Name = name, ProjectId = pro
         });
         db.SaveChanges();
     }
 }
Exemple #13
0
        public static bool IsProjectManager(int projects, int userId)
        {
            ShlekenEntities3 db   = new ShlekenEntities3();
            RefUserPro       user = db.RefUserPro.ToList().FirstOrDefault(u => u.ProjecrId == projects && u.UserId == userId);

            bool isM = db.Projects.ToList().FirstOrDefault(j => j.Id == projects).RefUserPro.Min(o => o.Id) == user.Id;

            db.RefUserPro.ToList().FirstOrDefault(u => u.ProjecrId == projects && u.UserId == userId).IsOwner = isM;
            db.SaveChanges();
            return(isM);
        }
Exemple #14
0
 public static void Save(ToDoListsViewModel model)
 {
     using (var db = new ShlekenEntities3())
     {
         if (model.Id > 0)
         {
             var item = db.ToDoLists.Single(i => i.Projects.AccountId == Userservice.AccountId && i.Id == model.Id);
             item = model.Map <ToDoListsViewModel, ToDoLists>(item);
             db.SaveChanges();
         }
         else
         {
             var item = model.Map <ToDoListsViewModel, ToDoLists>();
             item.CreatedDate = DateTime.Now;
             item.Userid      = Userservice.UserId;
             db.ToDoLists.Add(item);
             db.SaveChanges();
         }
     }
 }
Exemple #15
0
 public static int Add(ActivitiesViewModel model)
 {
     using (var db = new ShlekenEntities3())
     {
         var item = model.Map <ActivitiesViewModel, Activities>();
         item.Date      = DateTime.Now;
         item.ProjectId = 1;
         db.Activities.Add(item);
         db.SaveChanges();
         return(item.Id);
     }
 }
Exemple #16
0
 public static int Add(FilesViewModel model)
 {
     using (var db = new ShlekenEntities3())
     {
         var item = model.Map <FilesViewModel, Files>();
         item.CreatedDate = DateTime.Now;
         item.UserId      = 7;
         db.Files.Add(item);
         db.SaveChanges();
         return(item.Id);
     }
 }
Exemple #17
0
 public static void Delete(int Projects, int RoleId, int UserId)
 {
     using (var db = new ShlekenEntities3())
     {
         var items = db.Teams.Where(i => i.Projects.AccountId == Userservice.AccountId && i.RoleId == RoleId && i.UserId == UserId && i.ProjectId == Projects).ToList();
         foreach (var item in items)
         {
             db.Teams.Remove(item);
             db.SaveChanges();
         }
     }
 }
Exemple #18
0
 public static void Delete(int id, int projectId)
 {
     using (var db = new ShlekenEntities3())
     {
         var item  = db.Users.Single(i => i.RefUserPro.Any(r => r.Id == id));
         var tasks = db.RefUserPro.Where(t => t.UserId == item.Id).SelectMany(y => y.Roles.TasksRoles);
         db.TasksRoles.RemoveRange(tasks);
         db.RefUserPro.RemoveRange(db.RefUserPro.Where(r => r.ProjecrId == projectId && r.UserId == item.Id));
         db.Teams.RemoveRange(db.Teams.Where(r => r.ProjectId == projectId && r.UserId == item.Id));
         db.SaveChanges();
     }
 }
Exemple #19
0
 public static void Save(ProjectsViewModel model)
 {
     using (var db = new ShlekenEntities3())
     {
         if (model.Id > 0)
         {
             var item = db.Projects.Single(i => i.AccountId == Userservice.AccountId && i.Id == model.Id);
             item = model.Map <ProjectsViewModel, Projects>(item);
             db.SaveChanges();
         }
         else
         {
             var item = model.Map <ProjectsViewModel, Projects>();
             db.Projects.Add(item);
             db.SaveChanges();
             db.Tasks.Add(new Tasks {
                 Name = "no task", ProjectId = db.Projects.ToList().LastOrDefault().Id, Description = "h", Status = "done", ShowClient = false
             });
             db.SaveChanges();
         }
     }
 }
Exemple #20
0
        public static int GetTemp(int pro)
        {
            ShlekenEntities3 db = new ShlekenEntities3();
            var oo = db.Tasks.ToList().FirstOrDefault(t => t.Name == "no task" && t.ProjectId == pro);

            if (oo == null)
            {
                db.Tasks.Add(new Tasks {
                    Name = "no task", ProjectId = pro, Description = "h", Status = "done", ShowClient = false
                });
                db.SaveChanges();
                GetTemp(pro);
            }
            return(oo.Id);
        }
Exemple #21
0
        public static void Delete(int id)
        {
            using (var db = new ShlekenEntities3())
            {
                var item = db.Tasks.Single(i => i.Projects.AccountId == Userservice.AccountId && i.Id == id);

                var TasksRoles = db.TasksRoles.Where(i => i.TaskId == item.Id && i.Tasks.ProjectId == item.ProjectId && i.Tasks.Projects.AccountId == item.Projects.AccountId).ToList();
                foreach (var taskrols in TasksRoles)
                {
                    db.TasksRoles.Remove(taskrols);
                }

                db.Tasks.Remove(item);
                db.SaveChanges();
            }
        }
Exemple #22
0
        public void SetViewModel()
        {
            ShlekenEntities3 db = new ShlekenEntities3();

            ProjectId = ProjecrId;

            Tasks = db.TasksRoles.Where(t => t.RoleId == RoleId).ToList();
            db.TasksRoles.Where(t => t.RoleId == RoleId).ToList().ForEach(t => t.Value = Value);
            var user = db.RefUserPro.FirstOrDefault(r => r.Id == Id).Users;

            Password = user.Password;
            Email    = user.Email;
            Name     = user.Name;
            Roles    = db.Roles.FirstOrDefault(t => t.Id == RoleId);
            RoleName = Roles.Name;

            db.SaveChanges();
        }
Exemple #23
0
        public static void Delete(int id)
        {
            using (var db = new ShlekenEntities3())
            {
                var item = db.Projects.Single(i => i.AccountId == Userservice.AccountId && i.Id == id);
                var list = db.Contacts.ToList();
                foreach (var i in list)
                {
                    if (i.ProjectId == item.Id && i.Projects.AccountId == item.AccountId)
                    {
                        db.Contacts.Remove(i);
                        db.SaveChanges();
                    }
                }

                var m = db.Meetings.ToList();
                foreach (var i in m)
                {
                    if (i.ProjectId == item.Id && i.Projects.AccountId == item.AccountId)
                    {
                        db.Meetings.Remove(i);
                        db.SaveChanges();
                    }
                }

                var tr = db.TasksRoles.ToList();
                foreach (var i in tr)
                {
                    if (i.Tasks.ProjectId == item.Id && i.Roles.ProjectId == item.Id && i.Tasks.Projects.AccountId == item.AccountId && i.Roles.Projects.AccountId == item.AccountId)
                    {
                        db.TasksRoles.Remove(i);
                        db.SaveChanges();
                    }
                }


                var r = db.Tasks.ToList();
                foreach (var i in r)
                {
                    if (i.ProjectId == item.Id && i.Projects.AccountId == item.AccountId)
                    {
                        db.Tasks.Remove(i);
                        db.SaveChanges();
                    }
                }

                var g = db.Globals.ToList();
                foreach (var i in g)
                {
                    if (i.ProjectId == item.Id && i.Projects.AccountId == item.AccountId)
                    {
                        db.Globals.Remove(i);
                        db.SaveChanges();
                    }
                }

                var Teams = db.Teams.ToList();
                foreach (var i in Teams)
                {
                    if (i.ProjectId == item.Id && i.Projects.AccountId == item.AccountId)
                    {
                        db.Teams.Remove(i);
                        db.SaveChanges();
                    }
                }

                var res = db.Roles.ToList();
                foreach (var i in res)
                {
                    if (i.ProjectId == item.Id && i.Projects.AccountId == item.AccountId)
                    {
                        db.Roles.Remove(i);
                        db.SaveChanges();
                    }
                }

                var Fixes = db.Fixes.ToList();
                foreach (var i in Fixes)
                {
                    if (i.ProjectId == item.Id && i.Projects.AccountId == item.AccountId)
                    {
                        db.Fixes.Remove(i);
                        db.SaveChanges();
                    }
                }


                var a = db.Activities.ToList();
                foreach (var i in a)
                {
                    if (i.ProjectId == item.Id && i.Projects.AccountId == item.AccountId)
                    {
                        db.Activities.Remove(i);
                        db.SaveChanges();
                    }
                }


                var o = db.Outcomes.ToList();
                foreach (var i in o)
                {
                    if (i.ProjectId == item.Id && i.Projects.AccountId == item.AccountId)
                    {
                        db.Outcomes.Remove(i);
                        db.SaveChanges();
                    }
                }


                var n = db.Incomes.ToList();
                foreach (var i in n)
                {
                    if (i.ProjectId == item.Id && i.Projects.AccountId == item.AccountId)
                    {
                        db.Incomes.Remove(i);
                        db.SaveChanges();
                    }
                }

                var f = db.Files.ToList();
                foreach (var i in f)
                {
                    if (i.ProjectId == item.Id && i.Projects.AccountId == item.AccountId)
                    {
                        db.Files.Remove(i);
                        db.SaveChanges();
                    }
                }

                var Risks = db.Risks.ToList();
                foreach (var i in Risks)
                {
                    if (i.ProjectId == item.Id && i.Projects.AccountId == item.AccountId)
                    {
                        db.Risks.Remove(i);
                        db.SaveChanges();
                    }
                }

                var t = db.ToDoLists.ToList();
                foreach (var i in t)
                {
                    if (i.ProjectId == item.Id && i.Projects.AccountId == item.AccountId)
                    {
                        db.ToDoLists.Remove(i);
                        db.SaveChanges();
                    }
                }

                var re = db.RefUserPro.ToList();
                foreach (var i in re)
                {
                    if (i.ProjecrId == item.Id && i.Projects.AccountId == item.AccountId)
                    {
                        db.RefUserPro.Remove(i);
                        db.SaveChanges();
                    }
                }
                db.Projects.Remove(item);
                db.SaveChanges();
            }
        }
Exemple #24
0
        public static List <TeamsViewModel> GetHoursUsers(int ProjectId)
        {
            using (var db = new ShlekenEntities3())
            {
                var newTeams = new List <Teams>();
                db.Projects.Where(p => p.Id == ProjectId).SelectMany(p => p.RefUserPro).ToList().Where(p => !db.Teams.Any(pp => pp.RoleId == p.RoleId && pp.UserId == p.UserId)).ToList().ForEach(i => newTeams.Add(new Teams {
                    ProjectId = i.ProjecrId, RoleId = i.RoleId.Value, UserId = i.UserId, Date = DateTime.Today, Hours = 0, Roles = i.Roles, Users = i.Users
                }));
                db.Teams.AddRange(newTeams);
                db.SaveChanges();
                var UsersRoles    = new List <TeamsViewModel>();
                var datesProjects = DatesProjects(ProjectId);
                var ListTeams     = new List <TeamsViewModel>();

                var listTeams = db.Teams
                                .Where(i => i.Projects.AccountId == Userservice.AccountId && i.ProjectId == ProjectId)
                                .OrderBy(i => i.RoleId)
                                .ToList()
                                .Select(i =>
                {
                    var item       = i.Map <Teams, TeamsViewModel>();
                    item.RolesName = i.Roles.Name;
                    item.Name      = i.Users.Name;
                    return(item);
                }).ToList()
                                .GroupBy(i => new { i.UserId, i.RoleId })
                                .ToList();
                foreach (var Teams in listTeams)
                {
                    var item = new TeamsViewModel();
                    item.UsersHours = new List <HourDate>();
                    foreach (var t in Teams)
                    {
                        item.Id        = t.Id;
                        item.Date      = t.Date;
                        item.UserId    = t.UserId;
                        item.Name      = t.Name;
                        item.RolesName = t.RolesName;
                        item.RoleId    = t.RoleId;
                        item.UsersHours.Add(new HourDate {
                            Hour = t.Hours, Date = t.Date, Id = t.Id
                        });
                    }
                    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
                                });
                            }
                            else
                            {
                                if (count == item.UsersHours.Count)
                                {
                                    item.AllHours.Add(new HourDate {
                                        Hour = 0, Date = date.Date
                                    });
                                }
                                count++;
                            }
                        }
                    }
                    ListTeams.Add(item);
                }
                var tt = new List <Teams>();

                return(ListTeams.OrderBy(i => i.RoleId).ToList());
            }
        }