private void tijiao_Click(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(projectPlanId))
{
// TODO 报错
}
else
{
SprintDTO sprintDTO = new SprintDTO(
this.projectPlanId
, this.textBox3.Text
, this.kaishishijian.Text
, this.jieshushijian.Text
, this.comboBoxEdit1.Text
);
PlanService.createSprint(sprintDTO);
PlanService.insertTaskPlanAfterSprint(
new TaskPlanDTO(
sprintDTO.Id
, this.kaishishijian.Text
, this.jieshushijian.Text
)
);
this.form2.refreshDeclare();
this.Close();
}
}
/// <summary>
/// 修改迭代
/// </summary>
/// <param name="sprint"></param>
public static void updateSprint(SprintDTO sprint)
{
DBUtil.ExecuteSQL("UPDATE sprint SET " +
" sprint_code = '" + sprint.Sprint_code + "'" +
", create_date = '" + sprint.Create_date + "'" +
", start_time = '" + sprint.Start_time + "'" +
", end_time = '" + sprint.End_time + "'" +
", status = '" + sprint.Status + "' " +
" WHERE id = '" + sprint.Id + "'");
}
public void Delete(SprintDTO sprint)
{
SprintDAL sprintDAL = new SprintDAL()
{
Sprint_id = sprint.Sprint_id
};
_unitOfWork.SprintRepository.Delete(sprintDAL);
_unitOfWork.Save();
}
public IActionResult Create([FromBody] SprintDTO sprint)
{
try
{
_sprintService.Create(sprint);
return(Ok());
}
catch
{
return(BadRequest());
}
}
public void Update(SprintDTO sprintDTO)
{
var sprintDAL = _unitOfWork.SprintRepository.GetByID(sprintDTO.Sprint_id);
sprintDAL.Name = sprintDTO.Name;
sprintDAL.Description = sprintDTO.Description;
sprintDAL.StartDate = sprintDTO.StartDate;
sprintDAL.EndDate = sprintDTO.EndDate;
sprintDAL.SprintStatus_id = _unitOfWork.SprintStatusRepository.GetByCondition(sprintStatus => sprintStatus.StatusName == sprintDTO.SprintStatus).SprintStatus_id;
_unitOfWork.Save();
}
public void CreateTest()
{
var mock = new Mock <IUnitOfWork>()
{
DefaultValue = DefaultValue.Mock
};
var newSprint = new SprintDTO();
SprintService service = new SprintService(mock.Object);
service.Create(newSprint);
mock.Verify(i => i.Save());
}
/// <summary>
/// 创建迭代
/// </summary>
/// <param name="sprint"></param>
public static void createSprint(SprintDTO sprint)
{
DBUtil.ExecuteSQL("INSERT INTO sprint(id,project_plan_id,sprint_code,create_date,start_time,end_time,status)"
+ " values"
+ " ('" + sprint.Id + "'"
+ ", '" + sprint.Project_plan_id + "'"
+ ", '" + sprint.Sprint_code + "'"
+ ", now()"
+ ", '" + sprint.Start_time + "'"
+ ", '" + sprint.End_time + "'"
+ ", '" + sprint.Status
+ "');"
);
}
public SprintDTO GetByID(int id)
{
SprintDAL sprintDAL = _unitOfWork.SprintRepository.GetByID(id);
SprintDTO sprint = new SprintDTO()
{
Sprint_id = sprintDAL.Sprint_id,
Name = sprintDAL.Name,
Description = sprintDAL.Description,
StartDate = sprintDAL.StartDate,
EndDate = sprintDAL.EndDate,
SprintStatus = sprintDAL.Status.StatusName
};
return(sprint);
}
public void Create(SprintDTO sprint)
{
int sprintStatus_id = _unitOfWork.SprintStatusRepository.GetByCondition(status => status.StatusName == sprint.SprintStatus).SprintStatus_id;
SprintDAL sprintDAL = new SprintDAL
{
Name = sprint.Name,
Description = sprint.Description,
StartDate = sprint.StartDate,
EndDate = sprint.EndDate,
SprintStatus_id = sprintStatus_id
};
_unitOfWork.SprintRepository.Create(sprintDAL);
_unitOfWork.Save();
}
public void AddSprintTest()
{
//Arrange
var mock = new Mock <ISprintService>();
SprintDTO sprintDTO = new SprintDTO {
Name = "Sprint", Description = "Description"
};
mock.Setup(a => a.Create(sprintDTO));
SprintController controller = new SprintController(mock.Object);
//Act
var result = controller.Create(sprintDTO);
//Assert
Assert.IsType <OkResult>(result);
}
public void GetStories()
{
var mock = new Mock <IStoryService>();
var mockSprint = new Mock <ISprintService>();
SprintDTO sprintDTO = new SprintDTO();
mockSprint.Setup(a => a.Create(sprintDTO));
mock.Setup(i => i.GetStories()).Returns(new List <StoryDTO>().AsQueryable());
StoryController controller = new StoryController(mock.Object, mockSprint.Object);
//Act
var result = controller.GetStories();
//Assert
mock.Verify(i => i.GetStories(), Times.Once);
}
public void DeletesprintTest()
{
var mock = new Mock <ISprintService>();
SprintDTO sprintDTO = new SprintDTO {
Name = "Test", Description = "Test"
};
mock.Setup(a => a.Create(sprintDTO));
SprintController controller = new SprintController(mock.Object);
mock.Setup(a => a.Delete(sprintDTO));
//Act
var result = controller.Delete(sprintDTO.Sprint_id);
//Assert
Assert.IsType <OkResult>(result);
}
public void CreateTest()
{
//Arrange
var mockStory = new Mock <IStoryService>();
var mockSprint = new Mock <ISprintService>();
StoryDTO storyDTO = new StoryDTO();
SprintDTO sprintDTO = new SprintDTO();
mockStory.Setup(a => a.CreateStory(storyDTO));
mockSprint.Setup(a => a.Create(sprintDTO));
StoryController controller = new StoryController(mockStory.Object, mockSprint.Object);
//Act
var result = controller.CreateStory(storyDTO);
//Assert
Assert.IsType <CreatedResult>(result);
}
public void UpdateSprintTest()
{
var mock = new Mock <ISprintService>();
SprintDTO sprintDTO = new SprintDTO {
Name = "Test", Description = "Test"
};
mock.Setup(a => a.Create(sprintDTO));
string exp = "111";
sprintDTO.Name = exp;
sprintDTO.Description = exp;
mock.Setup(a => a.Update(sprintDTO));
SprintController controller = new SprintController(mock.Object);
var result = controller.Edit(sprintDTO);
Assert.IsType <OkResult>(result);
Assert.Equal(exp, sprintDTO.Name);
Assert.Equal(exp, sprintDTO.Description);
}
public void GetSprintTest()
{
var mock = new Mock <IUnitOfWork>()
{
DefaultValue = DefaultValue.Mock
};
var newSprint = new SprintDTO()
{
Name = "Name",
Description = "Description",
};
SprintService service = new SprintService(mock.Object);
service.Create(newSprint);
var result = service.GetByID(newSprint.Sprint_id);
Assert.Equal(newSprint.Sprint_id, result.Sprint_id);
Assert.NotStrictEqual(result.Name, newSprint.Name);
Assert.NotStrictEqual(result.Description, newSprint.Description);
}
public void DeleteStoryTest()
{
//Arrange
var mock = new Mock <IStoryService>();
var mockSprint = new Mock <ISprintService>();
SprintDTO sprintDTO = new SprintDTO();
mockSprint.Setup(a => a.Create(sprintDTO));
StoryDTO storyDTO = new StoryDTO {
Name = "Test", Description = "Description"
};
mock.Setup(a => a.CreateStory(storyDTO));
StoryController controller = new StoryController(mock.Object, mockSprint.Object);
var temp = controller.CreateStory(storyDTO);
//Act
var result = controller.DeleteStory(storyDTO.Story_id);
//Assert
Assert.IsType <OkResult>(result);
}
public void GetStoryTest()
{
//Arrange
var mock = new Mock <IStoryService>();
var mockSprint = new Mock <ISprintService>();
SprintDTO sprintDTO = new SprintDTO();
StoryDTO storyDTO = new StoryDTO
{
Story_id = 1,
Name = "name",
Description = "description"
};
mock.Setup(i => i.GetStory(storyDTO.Story_id));
mockSprint.Setup(a => a.Create(sprintDTO));
StoryController controller = new StoryController(mock.Object, mockSprint.Object);
//Act
var result = controller.GetStory(storyDTO.Story_id);
//Assert
Assert.IsType <OkObjectResult>(result);
}
public void UpdateTest()
{
var mock = new Mock <IUnitOfWork>()
{
DefaultValue = DefaultValue.Mock
};
var newSprint = new SprintDTO()
{
Name = "Name",
Description = "Description"
};
SprintService service = new SprintService(mock.Object);
service.Create(newSprint);
newSprint.Name = "NameName";
newSprint.Description = "description";
service.Update(newSprint);
var result = service.GetByID(newSprint.Sprint_id);
Assert.Equal(result.Sprint_id, newSprint.Sprint_id);
Assert.Equal("NameName", result.Name);
Assert.Equal("description", result.Description);
}
public async Task BeginSprint(CommandContext ctx, [Description("Name the sprint")][RemainingText]
string sprintName)
{
var currSprint = await _sprintRepository.Current(ctx.Guild.Id);
if (currSprint != null)
{
await ctx.Channel.SendMessageAsync(
$"There is already a sprint active named {currSprint.SprintName}, please end it with the `?{nameof(EndSprint).ToLower()}` command");
return;
}
if (sprintName == null)
{
await ctx.Channel.SendMessageAsync(
$"Please specify a name of the sprint like so: `?{nameof(BeginSprint).ToLower()} <{nameof(sprintName).ToLower()}>`");
return;
}
var sprint = new SprintDTO
{
SprintName = sprintName,
StartDate = DateTime.Now,
GuildId = ctx.Guild.Id
};
await _sprintRepository.Create(sprint);
var embedBuilder = new DiscordEmbedBuilder
{
Title = "New Sprint Started",
Description = $"{sprintName} has begun!",
Timestamp = sprint.StartDate
};
await ctx.Channel.SendMessageAsync(embedBuilder);
}
public SprintDTO GetSprint(int id)
{
SprintDTO sprint = _sprintService.GetByID(id);
return(sprint);
}
