public static StoriesDetails GetStoryDetails(int storyId, int projectId) { using (ManagementSystemEntities db = new ManagementSystemEntities()) { StoriesDetails model = new StoriesDetails(); var result = (from story in db.Stories.Where(story => story.Id == storyId && story.ProjectId == projectId && story.IsDeleted == false) select new StoriesDetails { Id = story.Id, Name = story.Name, ProjectId = story.ProjectId }); model = result.FirstOrDefault(); if (result != null) { model.Sprints = (from s in db.Stories where (s.ProjectId == projectId && s.IsDeleted == false && s.Id == storyId) join sprint_story in db.SprintStories on s.Id equals sprint_story.StoryId join sprint in db.Sprints on sprint_story.SprintId equals sprint.Id select sprint).ToList(); } return(model); } }
public ActionResult Create(StoryCreateModel storyModel, FormCollection collection) { if (ModelState.IsValid) { try { Story model = new Story() { ProjectId = storyModel.ProjectId, Exist = false, sprintId = StoriesFilterSession.sprintId }; if (storyModel.selectedType == 1) { model.Exist = true; model.Name = collection["search"].ToString(); } else { model.Name = collection["NewStory"].ToString(); } model.CreatorId = SessionData.UserId; model.CreateDate = DateTimeHelper.Today(); StoriesDetails newStory = StoriesLogic.InsertNewStory(model); if (newStory != null) { StoriesFilter story = StoriesFilterSession; story.AllStories.Add(newStory); StoriesFilterSession = story; } if (newStory == null && storyModel.selectedType == 2) { // return pop up to set option for create with the same name } } catch (Exception e) { LogsLogic.InsertLog(new Log() { Message = e.Message, StackTrace = e.StackTrace, StoryName = "ManagementProject/Stories/Create(Post)", Parameters = new JavaScriptSerializer().Serialize(storyModel) }); } } return(RedirectToAction("StoriesList", new { projectId = storyModel.ProjectId })); }
public void FinishCodeReview(int storyId, int projectId) { try { StoriesLogic.FinishCodeReview(storyId); StoriesDetails s = StoriesFilterSession.AllStories.FirstOrDefault(st => st.Id == storyId); // SetFilterStorySession(); } catch (Exception e) { LogsLogic.InsertLog(new Log() { Message = e.Message, StackTrace = e.StackTrace, StoryName = "ManagementProject/Stories/FinishCodeReview", Parameters = " storyId=" + storyId + "& projectId = " + projectId }); } }
public static StoriesDetails InsertNewStory(Story story) { StoriesDetails model = new StoriesDetails(); if (story.Exist) { var q = CheckOfExistingStory(story); if (CheckIfStoryLinkedToSprint(story) == null) { InsertSprintToStory(q.Id, story.sprintId); model = GetStoryDetails(q.Id, story.ProjectId); } } else { if (CheckOfExistingStory(story) != null) { return(model); } else { using (ManagementSystemEntities db = new ManagementSystemEntities()) { db.Stories.Add(story); db.SaveChanges(); int id = db.Stories.OrderByDescending(x => x.Id).First().Id; SprintStory sprint_story = new SprintStory() { SprintId = story.sprintId, StoryId = id }; db.SprintStories.Add(sprint_story); db.SaveChanges(); model = GetStoryDetails(id, story.ProjectId); } } } return(model); }