public void Ctor_Always_CreatesBacklog()
{
//Arrange
//Act
var backlog = new BacklogEntity(Title, _accountId);
//Assert
backlog.Id.ShouldNotBe(Guid.Empty);
backlog.Title.ShouldBe(Title);
backlog.AccountId.ShouldBe(_accountId);
}
public static void CreateBacklog(BacklogEntity backlog)
{
var con = new SQLiteConnection(ConnectionString);
con.Open();
int count = backlog.items.Count;
for (int i = 0; i <= count; i++)
{
var cmd = new SQLiteCommand(con);
cmd.CommandText = "INSERT INTO backlog (task, points, priority) VALUES ('" + backlog.items[i].task + "' ,'"
+ backlog.items[i].points + "' , '" + backlog.items[i].priority + "');";
cmd.ExecuteNonQuery();
}
con.Close();
}
public String Create(List <BacklogItemEntity> items)
{
BacklogEntity backlogEntity = new BacklogEntity();
BacklogRequest backlogRequest = new BacklogRequest();
JsonPackage package = new JsonPackage();
backlogEntity.items = items;
backlogRequest.backlogEntity = backlogEntity;
package.Type = "CreateRequest";
package.ForwardTo = "BacklogController";
package.Content = backlogRequest;
String jsonpackage = JsonConvert.SerializeObject(package);
return(jsonpackage);
}
public void HandleRequest(string json, Socket handler)
{
var request = JsonConvert.DeserializeObject <JsonPackage>(json);
switch (request.Type)
{
case ("CreateRequest"):
BacklogEntity backlogEntity = new BacklogEntity();
backlogEntity = request.Content.ToObject <BacklogRequest>().backlogEntity;
BacklogDatabaseController.CreateBacklog(backlogEntity);
break;
case ("RemoveRequest"):
//BacklogDatabaseController.RemoveSprint((request.Content.ToObject<RemoveSprintRequest>()).Sprint);
break;
}
}
public async Task CreateTeam(TeamRequest request, TeamResponse response)
{
response.Errors = Validator.CreateTeam(request.Team);
if (response.Errors.Count() > 0)
{
return;
}
var teamDb = _uow.Repository <TeamEntity>().GetOverview(t => t.TeamName == request.Team.TeamName).FirstOrDefault();
if (teamDb != null)
{
response.Errors.Add("teamname", $"Team with name {request.Team.TeamName} already exist.");
return;
}
var newTeam = _mapper.Map <TeamEntity>(request.Team);
_uow.Repository <TeamEntity>().Add(newTeam);
_uow.Save();
var newXrefTeamUser = new XRefTeamUserEntity {
TeamId = newTeam.TeamId, UserId = request.UserId, RoleId = (int)Enums.Role.SCRUM_MASTER
};
_uow.Repository <XRefTeamUserEntity>().Add(newXrefTeamUser);
_uow.Save();
var backlog = new BacklogEntity {
TeamId = newTeam.TeamId
};
_uow.Repository <BacklogEntity>().Add(backlog);
_uow.Save();
var user = _uow.Repository <UserEntity>().GetOverview(u => u.Id == request.UserId).FirstOrDefault();
var userTeams = _uow.Repository <XRefTeamUserEntity>().GetOverview(u => u.UserId == user.Id).Select(t => t.TeamId).ToArray();
response.Token = await user.GenerateJwtToken(_configuration, userTeams);
response.Team = _mapper.Map <TeamVM>(newTeam);
}
