public ActionResult DeleteConfirmed(int id) { WorkTeam workTeam = db.WorkTeams.Find(id); db.WorkTeams.Remove(workTeam); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Id,ContractName,CreateTime,FullName,MobilePhone,Name,TelPhone,UpdateTime")] WorkTeam workTeam) { if (ModelState.IsValid) { db.Entry(workTeam).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(workTeam)); }
public TeamContext(WorkTeam workTeam) { this.workTeam = workTeam; this.count = workTeam.Count; using (var db = new SmetaApplication.DbContexts.SmetaDbAppContext()) { Post = db.Posts.Where(x => x.Id == workTeam.PostId).FirstOrDefault(); } PaybyHour = Post.Pay / 168; }
public ActionResult Create([Bind(Include = "Id,ContractName,CreateTime,FullName,MobilePhone,Name,TelPhone,UpdateTime")] WorkTeam workTeam) { if (ModelState.IsValid) { db.WorkTeams.Add(workTeam); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(workTeam)); }
// GET: WorkTeams/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } WorkTeam workTeam = db.WorkTeams.Find(id); if (workTeam == null) { return(HttpNotFound()); } return(View(workTeam)); }
private Exception ProcessFile(string file) { Exception ex = null; try { string content = System.IO.File.ReadAllText(file); VSTSComms.Ouput.OutPutObject jsonContent = JsonConvert.DeserializeObject <VSTSComms.Ouput.OutPutObject>(content); WorkTeam workTeam = _dataContext.WorkTeam.Where(x => x.WorkTeamId == jsonContent.TeamID).FirstOrDefault(); AgileSystem agileSystem = _dataContext.AgileSystem.Where(x => x.WorkTeamId == jsonContent.TeamID).FirstOrDefault(); if (agileSystem == null) { agileSystem = new AgileSystem() { AgileSystemId = Guid.NewGuid().ToString(), AgileSystemType = jsonContent.SystemType, AgileSystemName = workTeam.WorkTeamName, WorkTeamId = workTeam.WorkTeamId }; _dataContext.AgileSystem.Add(agileSystem); } AddAnyMissingUsers(agileSystem, jsonContent); //WorkTeam workTeam = _dataContext.WorkTeam.Where(x => x.TeamId == jsonContent.TeamID).FirstOrDefault(); foreach (var sprint in jsonContent.Sprints) { //TODO: fix issue here with finding previous sprint. It's not deleting it. //find sprint //AgileSprint agileSprint = FindSprint(workTeam.TeamId, sprint.ID); AgileSprint agileSprint = FindSprint(agileSystem.AgileSystemId, sprint.ID); if (agileSprint != null) { RemoveStories(agileSprint); } if (agileSprint == null) { agileSprint = new AgileSprint(); _dataContext.AgileSprint.Add(agileSprint); agileSprint.AgileSprintId = Guid.NewGuid().ToString(); } //set properties agileSprint.AgileSprintName = sprint.ID; agileSprint.AgileSystemId = agileSystem.AgileSystemId; agileSprint.SprintDescription = sprint.Name; agileSprint.EndDate = Convert.ToDateTime(sprint.EndDate); agileSprint.StartDate = Convert.ToDateTime(sprint.StartDate); foreach (var story in sprint.Stories) { AgileStory agileStory = new AgileStory() { AgileStoryId = Guid.NewGuid().ToString() }; _dataContext.AgileStory.Add(agileStory); agileStory.AgileStoryName = story.ID; agileStory.AgileSprintId = agileSprint.AgileSprintId; agileStory.StoryDescription = story.ID; agileStory.StoryType = story.Type; agileStory.StoryStatus = story.State; agileStory.StoryPoints = Convert.ToString(story.Points); foreach (var assignee in story.Assignees) { if (assignee.ID != null) { AgileStoryAgileSystemUser agileStoryAgileSystemUser = new AgileStoryAgileSystemUser(); _dataContext.AgileStoryAgileSystemUser.Add(agileStoryAgileSystemUser); agileStoryAgileSystemUser.AgileStoryAgileSystemUserId = Guid.NewGuid().ToString(); agileStoryAgileSystemUser.AgileStoryId = agileStory.AgileStoryId; //TODO get team member AgileSystemUser systemUser = FindAgileSystemUser(assignee, agileSystem.AgileSystemId); agileStoryAgileSystemUser.AgileSystemUserId = systemUser.AgileSystemUserId; agileStoryAgileSystemUser.AgileSystemUserStoryPoints = assignee.Points.ToString(); } } } } } catch (Exception ex1) { ex = ex1; } return(ex); }