示例#1
0
        public List <UserDto> searchData(string criteria)
        {
            var data = new List <UserDto>();

            //if(string.IsNullOrWhiteSpace(criteria))
            //{
            //    return Users(0);
            //}

            using (var context = new FSEEntities())
            {
                var list = context.Users.Where(x => criteria == "0" || x.FirstName.Contains(criteria) || x.LastName.Contains(criteria)).ToList();

                if (list != null && list.Any())
                {
                    list.ForEach(x =>
                    {
                        data.Add(new UserDto
                        {
                            Id         = x.Id,
                            FirstName  = x.FirstName,
                            LastName   = x.LastName,
                            EmployeeId = x.EmployeeId
                        });
                    });
                }
            }

            return(data);
        }
示例#2
0
        public List <UserDto> Users(int id)
        {
            var users = new List <UserDto>();

            using (var context = new FSEEntities())
            {
                var userList = context.Users.Where(x => id == 0 || x.Id == id).ToList();

                if (userList != null && userList.Any())
                {
                    userList.ForEach(x =>
                    {
                        users.Add(new UserDto
                        {
                            Id         = x.Id,
                            FirstName  = x.FirstName,
                            LastName   = x.LastName,
                            EmployeeId = x.EmployeeId
                        });
                    });
                }
            }

            return(users);
        }
示例#3
0
        public bool delete([FromBody] int id)
        {
            try
            {
                using (var context = new FSEEntities())
                {
                    var data = context.Projects.FirstOrDefault(x => x.Id == id);
                    context.Projects.Remove(data);

                    var user = context.Users.FirstOrDefault(x => x.ProjectId == id);
                    if (user != null)
                    {
                        user.ProjectId = null;
                    }

                    context.SaveChanges();
                }
            }
            catch (Exception)
            {
                return(false);
            }

            return(true);
        }
示例#4
0
        public bool SaveUser(UserDto userdata)
        {
            if (userdata != null)
            {
                if (userdata.Id == 0)
                {
                    try
                    {
                        using (var context = new FSEEntities())
                        {
                            var newUser = new User()
                            {
                                FirstName  = userdata.FirstName,
                                LastName   = userdata.LastName,
                                EmployeeId = userdata.EmployeeId
                            };
                            context.Users.Add(newUser);

                            context.SaveChanges();
                        }
                    }
                    catch (Exception ex)
                    {
                        return(false);
                    }
                }
                else
                {
                    try
                    {
                        using (var context = new FSEEntities())
                        {
                            var userDetails = context.Users.FirstOrDefault(x => x.Id == userdata.Id);

                            if (userDetails != null)
                            {
                                userDetails.FirstName  = userdata.FirstName;
                                userDetails.LastName   = userdata.LastName;
                                userDetails.EmployeeId = userdata.EmployeeId;
                            }
                            else
                            {
                                return(false);
                            }

                            context.SaveChanges();
                        }
                    }
                    catch (Exception ex)
                    {
                        return(false);
                    }
                }
            }
            return(true);
        }
示例#5
0
        public List <ProjectDto> searchData(string criteria)
        {
            var projects = new List <ProjectDto>();

            using (var context = new FSEEntities())
            {
                var list = context.Projects.Where(x => criteria == null || x.Name.Contains(criteria)).ToList();

                if (list != null && list.Any())
                {
                    var newTasks = new List <TaskDto>();
                    list.ForEach(x =>
                    {
                        var selectedUser = x.Users?.FirstOrDefault() ?? new User();
                        var tasks        = x.Tasks;
                        if (tasks != null & tasks.Any())
                        {
                            tasks.ToList().ForEach(t =>
                            {
                                newTasks.Add(new TaskDto
                                {
                                    Id             = t.Id,
                                    Description    = t.Description,
                                    StartDate      = t.StartDate,
                                    EndDate        = t.EndDate,
                                    Priority       = t.Priority,
                                    Status         = t.Status,
                                    ParentId       = t.ParentId,
                                    ParentTaskName = t.ParentTask?.Description
                                });
                            });
                        }
                        projects.Add(new ProjectDto
                        {
                            Id             = x.Id,
                            Name           = x.Name,
                            StartDate      = x.StartDate,
                            EndDate        = x.EndDate,
                            Priority       = x.Priority,
                            TotalTasks     = x.Tasks?.Count() ?? 0,
                            CompletedTasks = x.Tasks?.Count(z => z.Status == "Completed") ?? 0,
                            SelectedUser   = new UserDto
                            {
                                Id         = selectedUser.Id,
                                FirstName  = selectedUser.FirstName,
                                LastName   = selectedUser.LastName,
                                EmployeeId = selectedUser.EmployeeId
                            },
                            Tasks = newTasks
                        });
                    });
                }
            }

            return(projects);
        }
示例#6
0
        public List <TaskDto> searchData(string criteria)
        {
            var tasks = new List <TaskDto>();

            using (var context = new FSEEntities())
            {
                var list = context.Tasks.Where(x => criteria == null || x.Description.Contains(criteria)).ToList();

                if (list != null && list.Any())
                {
                    list.ForEach(x =>
                    {
                        var user     = x.Users?.FirstOrDefault();
                        var taskUser = new UserDto();
                        if (user != null)
                        {
                            taskUser = new UserDto
                            {
                                Id         = user.Id,
                                FirstName  = user.FirstName,
                                LastName   = user.LastName,
                                EmployeeId = user.EmployeeId
                            };
                        }

                        tasks.Add(new TaskDto
                        {
                            Id          = x.Id,
                            Description = x.Description,
                            StartDate   = x.StartDate,
                            EndDate     = x.EndDate,
                            Priority    = x.Priority,
                            Status      = x.Status,
                            User        = taskUser,
                            Project     = new ProjectDto
                            {
                                Id   = x.Project?.Id ?? 0,
                                Name = x.Project?.Name,
                            },
                            ParentId       = x.ParentId,
                            ParentTaskName = x.ParentTask?.Description
                        });
                    });
                }
            }

            return(tasks);
        }
示例#7
0
        public bool delete(int id)
        {
            try
            {
                using (var context = new FSEEntities())
                {
                    var data = context.Tasks.FirstOrDefault(x => x.Id == id);
                    data.Status = "Completed";

                    context.SaveChanges();
                }
            }
            catch (Exception)
            {
                return(false);
            }

            return(true);
        }
示例#8
0
        public bool deleteUser([FromBody] int id)
        {
            try
            {
                using (var context = new FSEEntities())
                {
                    var user = context.Users.FirstOrDefault(x => x.Id == id);

                    if (user != null)
                    {
                        context.Users.Remove(user);
                        context.SaveChanges();
                        return(true);
                    }
                    return(false);
                }
            }
            catch (Exception ex)
            {
                return(false);
            }
        }
示例#9
0
        public List <ParentTaskDto> GetParentTask(int id)
        {
            var tasks = new List <ParentTaskDto>();

            using (var context = new FSEEntities())
            {
                var list = context.ParentTasks.Where(x => id == 0 || x.Id == id).ToList();

                if (list != null && list.Any())
                {
                    list.ForEach(x =>
                    {
                        tasks.Add(new ParentTaskDto
                        {
                            Id          = x.Id,
                            Description = x.Description
                        });
                    });
                }
            }

            return(tasks);
        }
示例#10
0
        public bool SaveTasks(TaskDto data)
        {
            if (data != null)
            {
                if (data.IsParentTask)
                {
                    using (var context = new FSEEntities())
                    {
                        var newParentTask = new ParentTask()
                        {
                            Description = data.Description,
                        };
                        context.ParentTasks.Add(newParentTask);

                        context.SaveChanges();
                    }
                }
                else
                {
                    if (data.Id == 0)
                    {
                        try
                        {
                            using (var context = new FSEEntities())
                            {
                                var newTask = new Task()
                                {
                                    Description = data.Description,
                                    StartDate   = data.StartDate,
                                    EndDate     = data.EndDate,
                                    Priority    = data.Priority,
                                    ProjectId   = data.ProjectId,
                                    ParentId    = data.ParentId,
                                    Status      = "New"
                                };
                                context.Tasks.Add(newTask);

                                var user = context.Users.FirstOrDefault(x => x.Id == data.UserId);
                                user.TaskId = newTask.Id;

                                context.SaveChanges();
                            }
                        }
                        catch (Exception ex)
                        {
                            return(false);
                        }
                    }
                    else
                    {
                        try
                        {
                            using (var context = new FSEEntities())
                            {
                                var task = context.Tasks.FirstOrDefault(x => x.Id == data.Id);

                                if (task != null)
                                {
                                    task.Description = data.Description;
                                    task.StartDate   = data.StartDate;
                                    task.EndDate     = data.EndDate;
                                    task.Priority    = data.Priority;
                                    task.ProjectId   = data.ProjectId;
                                    task.ParentId    = data.ParentId;
                                    task.Status      = "InProgress";

                                    var user = context.Users.FirstOrDefault(x => x.Id == data.UserId);
                                    user.TaskId = task.Id;
                                }
                                else
                                {
                                    return(false);
                                }

                                context.SaveChanges();
                            }
                        }
                        catch (Exception ex)
                        {
                            return(false);
                        }
                    }
                }
            }
            return(true);
        }
示例#11
0
        public bool SaveProjects(ProjectDto data)
        {
            if (data != null)
            {
                if (data.Id == 0)
                {
                    try
                    {
                        using (var context = new FSEEntities())
                        {
                            var newProject = new Project()
                            {
                                Name      = data.Name,
                                StartDate = data.StartDate,
                                EndDate   = data.EndDate,
                                Priority  = data.Priority
                            };
                            context.Projects.Add(newProject);

                            var user = context.Users.FirstOrDefault(x => x.Id == data.SelectedUser.Id);
                            user.ProjectId = newProject.Id;

                            context.SaveChanges();
                        }
                    }
                    catch (Exception ex)
                    {
                        return(false);
                    }
                }
                else
                {
                    try
                    {
                        using (var context = new FSEEntities())
                        {
                            var project = context.Projects.FirstOrDefault(x => x.Id == data.Id);

                            if (project != null)
                            {
                                project.Name      = data.Name;
                                project.StartDate = data.StartDate;
                                project.EndDate   = data.EndDate;
                                project.Priority  = data.Priority;
                            }
                            else
                            {
                                return(false);
                            }

                            var user = context.Users.FirstOrDefault(x => x.ProjectId == data.Id);
                            user.ProjectId = null;
                            var newuser = context.Users.FirstOrDefault(x => x.Id == data.SelectedUser.Id);
                            newuser.ProjectId = data.Id;

                            context.SaveChanges();
                        }
                    }
                    catch (Exception ex)
                    {
                        return(false);
                    }
                }
            }
            return(true);
        }