public IEnumerable<CardInfo> CreateCards(Grid grid, IListId list)
{
if(!grid.Cells.Any())
return Enumerable.Empty<CardInfo>();
var leftMostColumn = grid.Cells.Min(c => c.Column);
return grid.Cells.OrderBy(c => c.Row).ThenBy(c => c.Column)
.GroupBy(c => c.Row)
.Where(c => c.Any(x => x.Column == leftMostColumn))
.Select(c =>
{
var newCard = new CardInfo { Name = c.First().Value, ListId = list };
var skipFirstColumn = c.Skip(1);
var firstDateColumn = skipFirstColumn.FirstOrDefault(dc => dc.Type == typeof (DateTime));
if (firstDateColumn != null)
newCard.Due = DateTime.Parse(firstDateColumn.Value);
var firstStringColumn = skipFirstColumn.FirstOrDefault(sc => sc.Type == typeof (string));
if(firstStringColumn != null)
newCard.Desc = firstStringColumn.Value;
return newCard;
});
}
public IEnumerable<NewCard> CreateCards(IListId list)
{
var grid = new Grid();
foreach (Range cell in GetSelectedRange())
grid.AddCell(cell.Column, cell.Row, Convert.ToString(cell.Value));
return CreateCards(grid, list);
}
public IEnumerable<CardInfo> CreateCards(IListId list)
{
var grid = new Grid();
var selectedRange = GetSelectedRange();
if(selectedRange == null)
return Enumerable.Empty<CardInfo>();
foreach (Range cell in selectedRange)
grid.AddCell(cell.Column, cell.Row, Convert.ToString(cell.Value), cell.Value.GetType());
return CreateCards(grid, list);
}
public IEnumerable<NewCard> CreateCards(Grid grid, IListId list)
{
if(!grid.Cells.Any())
return Enumerable.Empty<NewCard>();
var leftMostColumn = grid.Cells.Min(c => c.Column);
return grid.Cells
.GroupBy(c => c.Row)
.Where(c => c.Any(x => x.Column == leftMostColumn))
.Select(c =>
{
var newCard = new NewCard(c.First().Value, list);
if (c.Count() > 1)
newCard.Desc = c.ElementAt(1).Value;
return newCard;
});
}