public ActionResult Create(string startDate, string endDate, int itemId) { DateTime?startDateTime = ParseDateString.GetDateForString(startDate); DateTime?endDateTime = ParseDateString.GetDateForString(endDate); if (startDateTime == null || endDateTime == null || endDateTime < startDateTime) { return(JsonError("Make sure Start Date and End Date are valid dates")); } //If selection range is bigger than 3 years set the last date to max 3 years if (((endDateTime.Value - DateTime.Today).TotalDays / 365) > 3) { endDateTime = DateTime.Today.AddYears(3); if (startDateTime > endDateTime) { startDateTime = endDateTime; } } var closedStatuses = MetaManager.StatusGetClosed(); List <IssueLinkType> linkTypes = IssueManager.GeminiContext.Meta.LinkTypeGet(); IssueLinkType repeatedLinkType = linkTypes.Find(t => string.Compare(t.Label, "Repeated", true) == 0); if (repeatedLinkType == null && linkTypes.Count > 0) { repeatedLinkType = linkTypes[0]; } var issue = IssueManager.Get(itemId); RepeatParser repeat = new RepeatParser(issue.Repeated); List <IssueDto> repeatedIssues = IssueManager.GetItemsForOriginator(IssueOriginatorType.Repeat, issue.Id.ToString()); if (repeatedIssues.Count > 0) { var previousItemsToDelete = repeatedIssues.FindAll(c => c.Created.Date() >= startDateTime.Value && c.Created.Date() <= endDateTime.Value && !closedStatuses.Contains(c.Entity.StatusId)); foreach (var item in previousItemsToDelete) { IssueManager.Delete(item.Entity.Id); } } for (DateTime date = startDateTime.Value; date <= endDateTime.Value; date = date.AddDays(1)) { repeat.CurrentDateTime = date.Date(); IssueDto lastRepeated = IssueManager.GetLastCreatedIssueForOriginator(IssueOriginatorType.Repeat, issue.Id.ToString()); DateTime lastRepeatedDate = issue.Created; if (lastRepeated != null && lastRepeated.Entity.IsExisting) { lastRepeatedDate = lastRepeated.Created; } if (repeat.MaximumRepeats > 0) { repeatedIssues = IssueManager.GetItemsForOriginator(IssueOriginatorType.Repeat, issue.Id.ToString()); if (repeatedIssues != null && repeatedIssues.Count >= repeat.MaximumRepeats) { continue; } } //If last item was created into the future do this if (lastRepeatedDate > date.Date()) { List <IssueDto> tmpRepeatedIssues = IssueManager.GetItemsForOriginator(IssueOriginatorType.Repeat, issue.Id.ToString()); List <IssueDto> ItemsBeforeStartDate = tmpRepeatedIssues.FindAll(i => i.Created < date.Date()); if (ItemsBeforeStartDate.Count == 0) { lastRepeatedDate = issue.Created; } else { lastRepeatedDate = ItemsBeforeStartDate.OrderBy("Created").Last().Created; } } if (repeat.NeedsToRepeat(lastRepeatedDate)) { var customFields = issue.CustomFields; issue.Attachments = new List <IssueAttachmentDto>(); issue.Entity.Repeated = string.Empty; issue.Entity.OriginatorData = issue.Entity.Id.ToString(); issue.Entity.OriginatorType = IssueOriginatorType.Repeat; issue.Entity.ParentIssueId = null; issue.Entity.IsParent = false; issue.Entity.StatusId = 0; issue.Entity.ResolutionId = 0; if (issue.Entity.StartDate.HasValue && issue.Entity.DueDate.HasValue && issue.Entity.StartDate != new DateTime() && issue.Entity.DueDate != new DateTime()) { TimeSpan tsDates = issue.Entity.DueDate.Value - issue.Entity.StartDate.Value; issue.Entity.DueDate = date.AddDays(tsDates.TotalDays); issue.Entity.StartDate = date.Date(); } else { issue.Entity.StartDate = null; issue.Entity.DueDate = null; } int issueId = issue.Id; issue.Entity.Created = date; IssueDto repeated = IssueManager.Create(issue.Entity); if (repeated.Entity.Id > 0) { string statment = "update gemini_issues set created = @created where issueid = @issueid"; SQLService.Instance.ExecuteQuery(statment, new { created = new DateTime(date.Year, date.Month, date.Day, 8, 0, 0).ToUtc(UserContext.User.TimeZone), issueid = repeated.Entity.Id }); } if (customFields != null && customFields.Count > 0) { foreach (var field in customFields) { try { //Find the existing ID to 'replace', if exists. var existingCF = repeated.CustomFields .SingleOrDefault(s => s.Entity.CustomFieldId == field.Entity.CustomFieldId); field.Entity.Id = existingCF == null ? 0 : existingCF.Entity.Id; field.Entity.IssueId = repeated.Entity.Id; field.Entity.ProjectId = repeated.Entity.ProjectId; CustomFieldManager.Update(new CustomFieldData(field.Entity)); } catch (Exception ex) { LogException(ex); } } } if (repeatedLinkType != null) { IssueManager.IssueLinkCreate(repeated.Entity.Id, issueId, repeatedLinkType.Id); } } } return(JsonSuccess()); }