public List <ProjectDetails> GetProjectDetails() { List <ProjectDetails> objProjectDetails = new List <ProjectDetails>(); using (var context = new FSD_SBAEntities()) { var projectDetail = context.GetProjectDetails(); foreach (var project in projectDetail) { objProjectDetails.Add(new ProjectDetails { ProjectId = project.Project_ID, ProjectName = project.Project_Name, StartDate = project.Start_Date, EndDate = project.End_Date, Priority = project.Priority, NumberofTasks = project.CountOfTasks, Completed = project.Status, Manager = project.Manager }); } } return(objProjectDetails); }
public void EditTaskDetails(TaskDetails taskDetail) { using (var context = new FSD_SBAEntities()) { int i = context.UpdateTaskDetails(taskDetail.ProjectName, taskDetail.TaskId, taskDetail.TaskName, taskDetail.ParentTaskName, taskDetail.StartDate, taskDetail.EndDate, taskDetail.Priority, taskDetail.UserID, taskDetail.IsEnded); context.SaveChangesAsync(); } }
public void AddParentTaskDetails(string ParentTaskName) { using (var context = new FSD_SBAEntities()) { int i = context.AddParentTaskDetails(ParentTaskName); context.SaveChangesAsync(); } }
public void DeleteProject(int ProjectID) { using (var context = new FSD_SBAEntities()) { int i = context.DeleteProject(ProjectID); context.SaveChangesAsync(); } }
public void EditProjectDetail(ProjectDetails projectDetail) { using (var context = new FSD_SBAEntities()) { int i = context.UpdateProjectDetails(projectDetail.ProjectId, projectDetail.ProjectName, projectDetail.StartDate, projectDetail.EndDate, projectDetail.Priority, projectDetail.UserID); context.SaveChangesAsync(); } }
public void DeleteUser(int UserId) { using (var context = new FSD_SBAEntities()) { int i = context.DeleteUser(UserId); context.SaveChangesAsync(); } }
public void EditUserDetails(UserDetails userDetail) { using (var context = new FSD_SBAEntities()) { int i = context.UpdateUserDetails(userDetail.UserID, userDetail.FirstName, userDetail.LastName, userDetail.EmployeeID); context.SaveChangesAsync(); } }
public string EndTaskDetails(string TaskID) { using (var context = new FSD_SBAEntities()) { int i = context.EndTask(Int32.Parse(TaskID)); context.SaveChangesAsync(); } return(TaskID); }
public UserDetails GetUserDetailsByUserName(string UserName) { UserDetails objUserDetails = new UserDetails(); using (var context = new FSD_SBAEntities()) { var userDetails = context.GetUserDetailsByUserName(UserName); foreach (var user in userDetails) { objUserDetails.UserID = user.USER_ID; objUserDetails.EmployeeID = user.Employee_ID; objUserDetails.FirstName = user.First_Name; objUserDetails.LastName = user.Last_Name; } } return(objUserDetails); }
public TaskDetails GetTaskDetailsByProjectName(string projectName) { TaskDetails objTaskDetails = new TaskDetails(); using (var context = new FSD_SBAEntities()) { var taskDetails = context.GetTaskDetailsByProjectName(projectName); foreach (var task in taskDetails) { objTaskDetails.TaskId = task.TaskID; objTaskDetails.TaskName = task.TaskName; objTaskDetails.ParentTaskName = task.ParentTaskName; objTaskDetails.Priority = task.Priority; objTaskDetails.StartDate = task.StartDate; objTaskDetails.EndDate = task.EndDate; objTaskDetails.IsEnded = task.Status; } } return(objTaskDetails); }
public ProjectDetails GetProjectDetailsByProjectName(string projectName) { ProjectDetails objProjectDetails = new ProjectDetails(); using (var context = new FSD_SBAEntities()) { var projectDetail = context.GetProjectDetailsByProjectName(projectName); foreach (var project in projectDetail) { objProjectDetails.ProjectId = project.Project_ID; objProjectDetails.ProjectName = project.Project_Name; objProjectDetails.StartDate = project.Start_Date; objProjectDetails.EndDate = project.End_Date; objProjectDetails.Priority = project.Priority; objProjectDetails.Manager = project.Manager; objProjectDetails.NumberofTasks = project.CountOfTasks; objProjectDetails.Completed = project.Status; } } return(objProjectDetails); }
public List <UserDetails> GetUserDetails() { List <UserDetails> objUserDetails = new List <UserDetails>(); using (var context = new FSD_SBAEntities()) { var userDetails = context.GetUserDetails().ToList(); foreach (var user in userDetails) { objUserDetails.Add(new UserDetails { UserID = user.USER_ID, EmployeeID = user.Employee_ID, FirstName = user.First_Name, LastName = user.Last_Name }); } } return(objUserDetails); }
public List <TaskDetails> GetTaskDetails() { List <TaskDetails> objTaskDetails = new List <TaskDetails>(); using (var context = new FSD_SBAEntities()) { var taskDetails = context.GetTaskDetails().ToList(); foreach (var task in taskDetails) { objTaskDetails.Add(new TaskDetails { TaskId = task.TaskID, TaskName = task.TaskName, ParentTaskName = task.ParentTaskName, Priority = task.Priority, StartDate = task.StartDate, EndDate = task.EndDate, IsEnded = task.Status }); } } return(objTaskDetails); }