public ActionResult CreateTaskUser(TaskUserModel vm) { var list = _context.tblUserRoleAssigns.Where(x => x.TaskId == vm.TaskId); if (list != null) { _context.tblUserRoleAssigns.RemoveRange(list); _context.SaveChanges(); } if (vm.UserSelected != null) { foreach (var user in vm.UserSelected) { int userId = Convert.ToInt16(user); var roleassign = new tblUserRoleAssign(); //roleassign.ClientId = 0; //roleassign.ProjectId = 0; roleassign.TaskId = vm.TaskId; roleassign.AssignUserId = userId; _context.tblUserRoleAssigns.Add(roleassign); _context.SaveChanges(); } } return(RedirectToAction("Index", new { area = "Task" })); }
public ActionResult CreateProject(ProjectModel vm) { tblProject Project = new tblProject(); if (vm.IsEdit) { Project = _context.tblProjects.SingleOrDefault(x => x.ProjectId == vm.ProjectId); } Project.ClientId = vm.ClientId; Project.ProjectName = vm.ProjectName; Project.Description = vm.Description; Project.Email = vm.Email; if (!vm.IsEdit) { _context.tblProjects.Add(Project); } _context.SaveChanges(); if (!User.IsInRole("1")) { int userId = Extension.GetUserId(); var user = _context.tblUserRoleAssigns.SingleOrDefault(x => x.ProjectId == vm.ProjectId && x.AssignUserId == userId && x.ClientId == 0 && x.TaskId == 0); if (user == null) { user = new tblUserRoleAssign(); //user.ClientId = 0; user.ProjectId = Project.ProjectId; //user.TaskId = 0; user.AssignUserId = Extension.GetUserId(); _context.tblUserRoleAssigns.Add(user); _context.SaveChanges(); } } return(RedirectToAction("Index", new { area = "Project" })); }
public ActionResult CreateTask(TaskModel vm) { int UserId = Convert.ToUInt16((this.User.Identity as System.Security.Claims.ClaimsIdentity).FindFirst("UserId").Value); tblTask task = new tblTask(); if (vm.IsEdit) { task = _context.tblTasks.SingleOrDefault(x => x.TaskId == vm.TaskId); } task.TaskName = vm.TaskName; task.TaskDescription = vm.TaskDescription; task.ProjectId = vm.ProjectId; task.ClientId = _context.tblProjects.SingleOrDefault(x => x.ProjectId == vm.ProjectId).ClientId; task.TaskDescription = vm.TaskDescription; if (!string.IsNullOrEmpty(vm.TaskStartDate.ToString())) { task.TaskStartDate = DateTime.ParseExact(vm.TaskStartDate.Replace("-", "/"), "dd/MM/yyyy", CultureInfo.InvariantCulture); } if (!string.IsNullOrEmpty(vm.TaskEndDate.ToString())) { task.TaskEndDate = DateTime.ParseExact(vm.TaskEndDate.Replace("-", "/"), "dd/MM/yyyy", CultureInfo.InvariantCulture); } task.TaskFrequency = vm.TaskFrequency; task.TaskName = vm.TaskName; task.TaskTick = vm.TaskTick; task.Email = vm.Email; if (!vm.IsEdit) { task.CreatedOn = DateTime.Now; task.CreatedBy = UserId; _context.tblTasks.Add(task); } else { var taskTick = _context.tblTaskTicks.Where(x => x.TaskId == vm.TaskId); _context.tblTaskTicks.RemoveRange(taskTick); task.UpdatedOn = DateTime.Now; task.UpdatedBy = UserId; } _context.SaveChanges(); if (vm.TaskTickselect != null) { vm.TaskTickselect.ToList().ForEach(t => _context.tblTaskTicks.Add(new tblTaskTick() { TaskId = task.TaskId, TaskTick = t.ToString() })); } _context.SaveChanges(); if (!User.IsInRole("1")) { int userId = Extension.GetUserId(); var user = _context.tblUserRoleAssigns.SingleOrDefault(x => x.ProjectId == 0 && x.AssignUserId == userId && x.ClientId == 0 && x.TaskId == vm.TaskId); if (user == null) { user = new tblUserRoleAssign(); //user.ClientId = 0; //user.ProjectId = 0; user.TaskId = vm.TaskId; user.AssignUserId = Extension.GetUserId(); _context.tblUserRoleAssigns.Add(user); _context.SaveChanges(); } } return(RedirectToAction("Index", new { area = "Task" })); }