public static Checklist SetChecklist(DevCard card)
{
var checklist = _trello.Checklists.Add("Acceptance Criteria", _board);
checklist.CheckItems.Add(new CheckItem { Id = Guid.NewGuid().ToString(), Name = "Enter test 1 here...", Pos = 1 });
string text = "Add test criteria here...";
_trello.Checklists.AddCheckItem(checklist, !string.IsNullOrEmpty(card.AcceptanceCriteria) ? card.AcceptanceCriteria : text);
return checklist;
}
private static void SetTrelloLabel(DevCard ddd, Card bl)
{
foreach (var label in _lbls)
{
if (bl.Labels.Any(x => x.Name.ToLowerInvariant() == label.Name.ToLowerInvariant())) continue;
if (ddd.ToString().ToLowerInvariant().Contains(label.Name.ToLowerInvariant()))
{
bl.Labels.Add(label);
_trello.Cards.AddLabel(bl, label.Color.Value);
}
if (ddd.Priority.ToLowerInvariant().Contains(label.Name.ToLowerInvariant()))
{
bl.Labels.Add(label);
_trello.Cards.AddLabel(bl, label.Color.Value);
}
}
}
private static string GetCardName(DevCard devCard)
{
string cardname = null;
if (string.IsNullOrEmpty(devCard.IWantTo))
{
cardname = devCard.ToString();
}
else
{
cardname = devCard.Feature + ": " + devCard.IWantTo;
}
cardname = "(" + devCard.EstimatedHours + ") " + cardname;
return cardname;
}
private static void SetPriority(DevCard devCard, Card card, int count)
{
switch (devCard.Priority.ToLowerInvariant())
{
case "must":
card.Pos = 1 * count;
break;
case "should":
card.Pos = 2 * count;
break;
case "could":
card.Pos = 3 * count;
break;
default:
card.Pos = 4 * count;
break;
}
}
private static List<DevCard> ExtractDevCards()
{
var worksheet = _pck.Workbook.Worksheets.First(x => x.Name == "Backlog");
Console.WriteLine(worksheet.Name);
var list = new List<DevCard>();
var start = worksheet.Dimension.Start;
var end = worksheet.Dimension.End;
for (var row = start.Row; row <= end.Row; row++)
{
if (row <= 1) continue;
if (row > 50) break;
Rows.Add(row);
var dc = new DevCard();
for (var col = start.Column; col <= end.Column; col++)
{
// ... Cell by cell...
object cellValue = worksheet.Cells[row, col].Text; // This got me the actual value I needed.
Debug.WriteLine(cellValue);
if (col > 50) break;
switch (col)
{
case 1:
dc.Milestone = Convert.ToString(cellValue);
break;
case 3:
dc.Feature = Convert.ToString(cellValue);
break;
case 4:
dc.AsA = Convert.ToString(cellValue);
break;
case 5:
dc.IWantTo = Convert.ToString(cellValue);
break;
case 6:
dc.SoThat = Convert.ToString(cellValue);
break;
case 7:
dc.Priority = Convert.ToString(cellValue);
break;
case 8:
var ss = Convert.ToString(cellValue);
var no = string.IsNullOrEmpty(ss) ? "5" : ss;
dc.EstimatedHours = Convert.ToInt16(no);
break;
case 9:
dc.Notes = Convert.ToString(cellValue);
break;
default:
int icol;
if (_columnIndexes.TryGetValue("UAC", out icol))
if (icol == col)
{
dc.AcceptanceCriteria = Convert.ToString(cellValue);
}
break;
}
}
list.Add(dc);
}
return list;
}