public IEnumerable <Story> GetStoriesByBacklogId(uint backlogId)
{
List <Story> stories = new List <Story>();
try
{
using (MySqlConnection connection = OpenNewConnection())
{
MySqlCommand selectCommand = CreateSelectAllCommand(_STORIES_TABLE_NAME, "BacklogId", "=", backlogId);
selectCommand.Connection = connection;
MySqlDataReader reader = selectCommand.ExecuteReader();
try
{
while (reader.Read())
{
uint id = SafeValueReader.GetUIntSafe(reader, "Id");
string name = SafeValueReader.GetStringSafe(reader, "Name");
uint importance = SafeValueReader.GetUIntSafe(reader, "Importance");
uint initialEstimate = SafeValueReader.GetUIntSafe(reader, "InitialEstimate");
string howToDemo = SafeValueReader.GetStringSafe(reader, "HowToDemo");
string notes = SafeValueReader.GetStringSafe(reader, "Notes");
string status = _storyStatusesDataModel.GetStatus(Convert.ToUInt32(reader["Status"]));
uint executorId = SafeValueReader.GetUIntSafe(reader, "ExecutorId");
stories.Add(new Story(id, name, importance, initialEstimate, howToDemo, notes, status, executorId, backlogId));
}
}
catch (Exception ex)
{
_logger?.Error(ex);
throw;
}
}
}
catch
{
throw;
}
return(stories);
}
public Sprint GetSprintByProjectId(uint projectId)
{
Sprint sprint = null;
try
{
using (MySqlConnection connection = OpenNewConnection())
{
MySqlCommand command = new MySqlCommand();
command.CommandText = $"SELECT * FROM `{_SPRINT_TABLE_NAME}` WHERE NOW() >= StartDate AND NOW() <= FinishDate AND ProjectId = {projectId} AND FinishedBeforeTheApointedDate = FALSE;";
command.Connection = connection;
MySqlDataReader reader = command.ExecuteReader();
try
{
if (reader.Read())
{
uint id = SafeValueReader.GetUIntSafe(reader, "Id");
string mainGoal = SafeValueReader.GetStringSafe(reader, "MainGoal");
DateTime startDate = reader.GetDateTime("StartDate");
DateTime finishDate = reader.GetDateTime("FinishDate");
uint backlogId = SafeValueReader.GetUIntSafe(reader, "BacklogId");
bool finishedBeforeTheApointedDate = Convert.ToBoolean(reader["FinishedBeforeTheApointedDate"]);
sprint = new Sprint(id, mainGoal, startDate, finishDate, projectId, backlogId, finishedBeforeTheApointedDate);
}
}
catch (Exception ex)
{
_logger?.Error(ex);
}
}
}
catch (Exception ex)
{
_logger?.Fatal($"{GetType().Name}.GetTeamById(uint id) error.");
_logger?.Fatal(ex);
}
return(sprint);
}
public IEnumerable <Sprint> GetAllProjectSprints(uint projectId)
{
List <Sprint> sprints = new List <Sprint>();
try
{
using (MySqlConnection connection = OpenNewConnection())
{
MySqlCommand command = CreateSelectAllCommand(_SPRINT_TABLE_NAME, "ProjectId", "=", projectId);
command.Connection = connection;
MySqlDataReader reader = command.ExecuteReader();
try
{
while (reader.Read())
{
uint id = SafeValueReader.GetUIntSafe(reader, "Id");
string mainGoal = SafeValueReader.GetStringSafe(reader, "MainGoal");
DateTime startDate = reader.GetDateTime("StartDate");
DateTime finishDate = reader.GetDateTime("FinishDate");
uint backlogId = SafeValueReader.GetUIntSafe(reader, "BacklogId");
bool finishedBeforeTheApointedDate = Convert.ToBoolean(reader["FinishedBeforeTheApointedDate"]);
sprints.Add(new Sprint(id, mainGoal, startDate, finishDate, projectId, backlogId, finishedBeforeTheApointedDate));
}
}
catch (Exception ex)
{
_logger?.Error(ex);
}
}
}
catch (Exception ex)
{
_logger?.Fatal($"{GetType().Name}.GetAllProjectSprints(uint projectId) error.");
_logger?.Fatal(ex);
}
return(sprints);
}
private void InitializeStatuses()
{
_statuses = new List <Status>();
try
{
using (MySqlConnection connection = OpenNewConnection())
{
MySqlCommand selectCommand = CreateSelectAllCommand(_STORY_STATUSES_TABLE_NAME);
selectCommand.Connection = connection;
MySqlDataReader reader = selectCommand.ExecuteReader();
try
{
while (reader.Read())
{
uint id = SafeValueReader.GetUIntSafe(reader, "Id");
string name = SafeValueReader.GetStringSafe(reader, "Name");
StoryStatus enumValue = GetStatusEnumValue(name);
_statuses.Add(new Status
{
Id = id,
Name = name,
EnumValue = enumValue
});
}
}
catch (Exception ex)
{
_logger?.Error(ex);
throw;
}
}
}
catch
{
throw;
}
}