public JsonSprintBurnDown(int sprintId) : base() { Data = new List<object>(); YAxisMin = 0; if (sprintId >= 0) { ScrumTimeEntities scrumTimeEntities = new ScrumTimeEntities(); SprintService sprintService = new SprintService(scrumTimeEntities); Sprint sprint = sprintService.GetSprintById(sprintId); if (sprint != null && sprint.Scrums.Count() > 0) { Data.Add(CreateIdealScrumTaskJsonList(sprint)); Data.Add(CreateScrumTaskJsonList(sprint)); XAxisMinDate = sprint.StartDate.ToString("MM/dd/yyyy"); XAxisMaxDate = sprint.FinishDate.ToString("MM/dd/yyyy"); YAxisMin = 0; ScrumService scrumService = new ScrumService(scrumTimeEntities); YAxisMax = scrumService.GetMaxTaskHourCountBySprintId(sprint.SprintId); } else HandleBadSprint(); } else HandleBadSprint(); }
public virtual ActionResult Index() { ScrumTimeEntities scrumTimeEntities = new ScrumTimeEntities(); string currentProductName = "None"; string currentSprintName = "None"; string nextReleaseName = "None"; ProductService productService = new ProductService(scrumTimeEntities); Product product = productService.GetProductById(SessionHelper.GetCurrentProductId(User.Identity.Name, Session)); if (product != null && product.ProductId > 0) { currentProductName = product.Name; SprintService sprintService = new SprintService(scrumTimeEntities); Sprint sprint = sprintService.GetSprintById(SessionHelper.GetCurrentSprintId(User.Identity.Name, Session)); if (sprint != null && sprint.SprintId > 0) { currentSprintName = sprint.Name; ReleaseService releaseService = new ReleaseService(scrumTimeEntities); Release nextRelease = releaseService.GetNextReleaseEqOrAfterDate(sprint.ProductId, sprint.FinishDate); if (nextRelease != null && nextRelease.ReleaseId > 0) nextReleaseName = nextRelease.Name; } } DashboardViewModel dashboardViewModel = new DashboardViewModel() { CurrentProductName = currentProductName, CurrentSprintName = currentSprintName, NextReleaseName = nextReleaseName }; return PartialView(dashboardViewModel); }
public Product SaveProduct(Product product) { if (product != null) { if (product.ProductId == 0) // this is new { _ScrumTimeEntities.AddToProducts(product); } else // the product exists { _ScrumTimeEntities.AttachTo("Products", product); ScrumTimeEntities freshScrumTimeEntities = new ScrumTimeEntities(_ScrumTimeEntities.Connection.ConnectionString); Product existingProduct = GetProductById(freshScrumTimeEntities, product.ProductId); if (existingProduct == null) { throw new Exception("The product no longer exists."); } _ScrumTimeEntities.ObjectStateManager.ChangeObjectState(product, System.Data.EntityState.Modified); } _ScrumTimeEntities.SaveChanges(); } return product; }
public static void CreateFirstTimeDefaults(string username) { ScrumTimeEntities scrumTimeEntities = new ScrumTimeEntities(); UserSetting userSetting = UserSettingService.GetUserSettingByUsername(scrumTimeEntities, username); if (userSetting == null) { // Load sample product id ProductService productService = new ProductService(scrumTimeEntities); int productIdOfSample = productService.GetProductIdOfSample(); if (productIdOfSample > -1) { SprintService sprintService = new SprintService(scrumTimeEntities); List<Sprint> mostRecentSprints = sprintService.GetMostRecentSprints(productIdOfSample, -1, 1); if (mostRecentSprints.Count > 0 && mostRecentSprints[0] != null) { userSetting = new UserSetting() { CurrentProduct = productIdOfSample, CurrentSprint = mostRecentSprints[0].SprintId, LastMainTabSelected = 1, Username = username }; scrumTimeEntities.AddToUserSettings(userSetting); scrumTimeEntities.SaveChanges(System.Data.Objects.SaveOptions.AcceptAllChangesAfterSave); } } } }
public Story SaveStory(Story story) { if (story != null) { if (story.StoryId == 0) // this is new { SetPriorityForSave(story, 0, story.Priority); _ScrumTimeEntities.AddToStories(story); } else // the story exists { _ScrumTimeEntities.AttachTo("Stories", story); ScrumTimeEntities freshScrumTimeEntities = new ScrumTimeEntities(_ScrumTimeEntities.Connection.ConnectionString); Story existingStory = GetStoryById(freshScrumTimeEntities, story.StoryId); if (existingStory != null && existingStory.StoryId > 0) { SetPriorityForSave(story, existingStory.Priority, story.Priority); } else { throw new Exception("The story no longer exists."); } _ScrumTimeEntities.ObjectStateManager.ChangeObjectState(story, System.Data.EntityState.Modified); } _ScrumTimeEntities.SaveChanges(); } return story; }
public UserSetting SaveUserSetting(UserSetting userSetting) { if (userSetting != null) { if (userSetting.UserSettingId == 0) // this is new { _ScrumTimeEntities.AddToUserSettings(userSetting); } else // the userSetting exists { _ScrumTimeEntities.AttachTo("UserSettings", userSetting); ScrumTimeEntities freshScrumTimeEntities = new ScrumTimeEntities(_ScrumTimeEntities.Connection.ConnectionString); UserSetting existingUserSetting = GetUserSettingByUsername(freshScrumTimeEntities, userSetting.Username); if (existingUserSetting == null) { throw new Exception("The user setting no longer exists."); } _ScrumTimeEntities.ObjectStateManager.ChangeObjectState(userSetting, System.Data.EntityState.Modified); } _ScrumTimeEntities.SaveChanges(); } return userSetting; }
public static List<Task> GetTasksByStoryIdOrderbyIdAsc(ScrumTimeEntities scrumTimeEntities, int storyId) { var results = from t in scrumTimeEntities.Tasks where t.StoryId == storyId orderby t.TaskId ascending select t; return results.ToList<Task>(); }
public void ChangePriorityOfExistingStory() { ScrumTimeEntities scrumTimeEntities = new ScrumTimeEntities(); StoryService storyService = new StoryService(scrumTimeEntities); Story story = storyService.GetStoryById(2); story.Priority = 0; storyService.SaveStory(story); }
public static List<Sprint> GetAllSprints(ScrumTimeEntities scrumTimeEntities, int productId) { var results = from t in scrumTimeEntities.Sprints where t.ProductId == productId orderby t.FinishDate descending select t; return results.ToList<Sprint>(); }
public void GetSprintsWithinDateRangeTest() { ScrumTimeEntities scrumTimeEntities = new ScrumTimeEntities(); SprintService sprintService = new SprintService(scrumTimeEntities); List<Sprint> sprints = sprintService.GetSprintsWithinDateRange(1, new DateTime(2010, 1, 1), new DateTime(2010, 6, 5)); Assert.AreEqual(5, sprints.Count()); }
public static Scrum GetScrumById(ScrumTimeEntities scrumTimeEntities, int id) { Scrum scrum = null; var results = from s in scrumTimeEntities.Scrums where s.ScrumId == id select s; if (results.Count() > 0) scrum = results.First<Scrum>(); return scrum; }
public static UserSetting GetUserSettingByUsername(ScrumTimeEntities scrumTimeEntities, string username) { UserSetting userSetting = null; var results = from u in scrumTimeEntities.UserSettings where u.Username == username select u; if (results.Count() > 0) userSetting = results.First<UserSetting>(); return userSetting; }
public static Scrum GetScrumByDateOfScrumAndSprintId(ScrumTimeEntities scrumTimeEntities, DateTime dateOfScrum, int sprintId) { Scrum scrum = null; var results = from s in scrumTimeEntities.Scrums where s.DateOfScrum == dateOfScrum && s.SprintId == sprintId select s; if (results.Count() > 0) scrum = results.First<Scrum>(); return scrum; }
public static Story GetStoryById(ScrumTimeEntities scrumTimeEntities, int id) { Story story = null; var results = from s in scrumTimeEntities.Stories where s.StoryId == id select s; if (results.Count() > 0) story = results.First<Story>(); else story = new Story(); return story; }
public static Task GetTaskById(ScrumTimeEntities scrumTimeEntities, int id) { Task task = null; var results = from t in scrumTimeEntities.Tasks where t.TaskId == id select t; if (results.Count() > 0) task = results.First<Task>(); else task = new Task(); return task; }
public static Release GetReleaseById(ScrumTimeEntities scrumTimeEntities, int id) { Release release = null; var results = from t in scrumTimeEntities.Releases where t.ReleaseId == id select t; if (results.Count() > 0) release = results.First<Release>(); else release = new Release(); return release; }
public static Product GetProductById(ScrumTimeEntities scrumTimeEntities, int id) { Product product = null; var results = from t in scrumTimeEntities.Products where t.ProductId == id select t; if (results.Count() > 0) product = results.First<Product>(); else product = new Product(); return product; }
public static Sprint GetSprintById(ScrumTimeEntities scrumTimeEntities, int id) { Sprint sprint = null; var results = from t in scrumTimeEntities.Sprints where t.SprintId == id select t; if (results.Count() > 0) sprint = results.First<Sprint>(); else sprint = new Sprint(); return sprint; }
public static StoryCollectionViewModel BuildByPriorityAsc(int productId) { ScrumTimeEntities scrumTimeEntities = new ScrumTimeEntities(); StoryCollectionViewModel storyCollectionViewModel = new StoryCollectionViewModel(); Product product = scrumTimeEntities.Products.First<Product>(p => p.ProductId == productId); var results = from s in product.Stories orderby s.Priority ascending select s; List<Story> stories = results.ToList<Story>(); storyCollectionViewModel.Stories = stories; return storyCollectionViewModel; }
public void AddNewStory() { ScrumTimeEntities scrumTimeEntities = new ScrumTimeEntities(); StoryService storyService = new StoryService(scrumTimeEntities); Story story = new Story() { Narrative = "Test story", Points = 8, Priority = 2, ProductId = 1, UserDefinedId = "not set" }; storyService.SaveStory(story); }
public static SprintCollectionViewModel BuildByStartDateDesc(int productId) { ScrumTimeEntities scrumTimeEntities = new ScrumTimeEntities(); SprintCollectionViewModel sprintCollectionViewModel = new SprintCollectionViewModel(); Product product = scrumTimeEntities.Products.First<Product>(p => p.ProductId == productId); var results = from s in product.Sprints orderby s.StartDate descending select s; List<Sprint> sprints = results.ToList<Sprint>(); sprintCollectionViewModel.Sprints = sprints; sprintCollectionViewModel.ProductId = productId; return sprintCollectionViewModel; }
public static ReleaseCollectionViewModel BuildByTargetDateDesc(int productId) { ScrumTimeEntities scrumTimeEntities = new ScrumTimeEntities(); ReleaseCollectionViewModel releaseCollectionViewModel = new ReleaseCollectionViewModel(); Product product = scrumTimeEntities.Products.First<Product>(p => p.ProductId == productId); var results = from s in product.Releases orderby s.Target descending select s; List<Release> releases = results.ToList<Release>(); releaseCollectionViewModel.Releases = releases; releaseCollectionViewModel.ProductId = productId; return releaseCollectionViewModel; }
public void DeleteStory() { ScrumTimeEntities scrumTimeEntities = new ScrumTimeEntities(); StoryService storyService = new StoryService(scrumTimeEntities); Story story = new Story() { Narrative = "Test story for deletion test.", Points = 8, Priority = 2, ProductId = 1, UserDefinedId = "not set" }; storyService.SaveStory(story); storyService.DeleteStory(story.StoryId); }
public static TaskCollectionViewModel BuildByIdAsc(int storyId) { ScrumTimeEntities scrumTimeEntities = new ScrumTimeEntities(); StoryService storyService = new StoryService(scrumTimeEntities); Story parentStory = storyService.GetStoryById(storyId); var results = from t in parentStory.Tasks orderby t.TaskId ascending select t; TaskCollectionViewModel taskCollectionViewModel = new TaskCollectionViewModel() { ParentStoryModel = parentStory, SortedTaskModels = results.ToList<Task>() }; return taskCollectionViewModel; }
public void DeleteScrum(ScrumTimeEntities scrumTimeEntities, int scrumId) { Scrum existingScrum = GetScrumById(scrumTimeEntities, scrumId); if (existingScrum != null && existingScrum.ScrumId > 0) { List<ScrumDetail> scrumDetails = existingScrum.ScrumDetails.ToList<ScrumDetail>(); foreach (ScrumDetail scrumDetail in scrumDetails) { scrumTimeEntities.DeleteObject(scrumDetail); } scrumTimeEntities.DeleteObject(existingScrum); scrumTimeEntities.SaveChanges(); } else throw new Exception("You have attempted to delete a scrum that does not exist."); }
public JsonTaskHoursPerSprint(int productId, int currentSprintId) : base() { Data = new List<object>(); Ticks = new List<string>(); YAxisMin = 0; if (productId >= 0) { ScrumTimeEntities scrumTimeEntities = new ScrumTimeEntities(); ProductService productService = new ProductService(scrumTimeEntities); Product product = productService.GetProductById(productId); Data.Add(CreateTaskHoursPerSprintJsonList(product, currentSprintId)); } else HandleBadProductId(); }
public static int GetCurrentSprintId(string username, HttpSessionStateBase session) { var value = session[CURRENTSPRINTID]; if (value == null) { // check the db ScrumTimeEntities scrumTimeEntities = new ScrumTimeEntities(); UserSetting userSetting = LoadUserSetting(scrumTimeEntities, username); if (userSetting != null && userSetting.CurrentSprint != null) { session[CURRENTSPRINTID] = userSetting.CurrentSprint; value = userSetting.CurrentSprint; } else value = -1; } return (int)value; }
// [['08/03/2010', 51, '08/03/2010'], ['08/05/2010', 0, '08/05/2010']] private List<object> CreateIdealScrumTaskJsonList(Sprint sprint) { ScrumTimeEntities scrumTimeEntities = new ScrumTimeEntities(); SprintService sprintService = new SprintService(scrumTimeEntities); List<object> idealScrumTaskJsonList = new List<object>(); List<object> scrumDetailList1 = new List<object>(); List<object> scrumDetailList2 = new List<object>(); if (sprint != null) { scrumDetailList1.Add(sprint.StartDate.ToString("MM/dd/yyyy")); scrumDetailList1.Add(sprintService.GetTotalHourCount(sprint.SprintId)); scrumDetailList1.Add(sprint.StartDate.ToString("MM/dd/yyyy")); idealScrumTaskJsonList.Add(scrumDetailList1); scrumDetailList2.Add(sprint.FinishDate.ToString("MM/dd/yyyy")); scrumDetailList2.Add(0); scrumDetailList2.Add(sprint.FinishDate.ToString("MM/dd/yyyy")); idealScrumTaskJsonList.Add(scrumDetailList2); } return idealScrumTaskJsonList; }
public static ScrumCollectionViewModel BuildByDateOfScrumDesc(int productId, int selectedSprintId) { ScrumTimeEntities scrumTimeEntities = new ScrumTimeEntities(); ScrumCollectionViewModel scrumCollectionViewModel = new ScrumCollectionViewModel(selectedSprintId); if (selectedSprintId > 0) { Sprint sprint = scrumTimeEntities.Sprints.First<Sprint>(s => s.SprintId == selectedSprintId); var results = from s in sprint.Scrums orderby s.DateOfScrum ascending select s; List<Scrum> scrums = results.ToList<Scrum>(); scrumCollectionViewModel.Scrums = scrums; } scrumCollectionViewModel.Usernames = new List<string>(); AccountMembershipService membershipService = new AccountMembershipService(); MembershipUserCollection membershipUserCollection = membershipService.GetAllUsers(); foreach (MembershipUser user in membershipUserCollection) { scrumCollectionViewModel.Usernames.Add(user.UserName); } return scrumCollectionViewModel; }
public static ProductCollectionViewModel BuildByNameAlphabetical(int currentProductId) { ScrumTimeEntities scrumTimeEntities = new ScrumTimeEntities(); ProductCollectionViewModel productCollectionViewModel = new ProductCollectionViewModel() { ProductViewModels = new List<ProductViewModel>() }; var results = from p in scrumTimeEntities.Products orderby p.Name ascending select p; foreach (Product product in results) { ProductViewModel productViewModel = new ProductViewModel() { IsCurrent = (product.ProductId == currentProductId) ? true : false, ProductModel = product }; productCollectionViewModel.ProductViewModels.Add(productViewModel); } return productCollectionViewModel; }