public static void ProcessCards() { var ndl = new NaggerDataLinker(); List <Card> cards = ndl.GetCardCollection(); int currentColumn = 0; foreach (var card in cards) { currentColumn = card.ColumnID; card.ColumnID = (int)card.AssignColumn(); if (card.ColumnID != currentColumn) { ndl.UpdateCard(card); } } Console.WriteLine("Could Do: {0}", cards.Count(c => c.AssignColumn() == ColumnType.colCould)); Console.WriteLine("Should Do: {0}", cards.Count(c => c.AssignColumn() == ColumnType.colShould)); Console.WriteLine("Must Do: {0}", cards.Count(c => c.AssignColumn() == ColumnType.colMust)); Console.WriteLine("Done: {0}", cards.Count(c => c.AssignColumn() == ColumnType.colDone)); Console.WriteLine("Skipped: {0}", cards.Count(c => c.AssignColumn() == ColumnType.colSkip)); }
// GET: Nags public ActionResult Index() { var model = new List <CardViewModel>(); NaggerDataLinker ndl = new NaggerDataLinker(); List <Card> cards = ndl.GetCardCollection(); var viewModel = from c in cards join m in db.Columns on c.ColumnID equals m.ID join l in db.Locations on c.LocationID equals l.ID join b in db.Boards on c.BoardID equals b.ID join f in db.Frequencies on c.FrequencyID equals f.DayCount select new CardViewModel { ColumnDescription = m.Description, BoardDescription = b.Description, LocationDescription = l.Description, FrequencyDescription = f.Description, Mandated = c.Mandated, BoardID = c.BoardID, FrequencyID = c.FrequencyID, LocationID = c.LocationID, Title = c.Title, Description = c.Description }; return(View(viewModel)); }
public void GetAllNags() { ArrayList objs = new ArrayList(); try { var ndl = new NaggerDataLinker(); List <Card> cards = ndl.GetCardCollection(); foreach (var card in cards) { objs.Add(new { id = card.ID, title = card.Title, columnID = card.ColumnID, description = card.Description, board = card.BoardID, frequencyID = card.FrequencyID, dueDate = card.DueDate, lastDone = card.LastDone, skipCount = card.SkipCount }); } } catch (Exception ex) { if (log.IsDebugEnabled) { log.DebugFormat("Error getting Nags: {0}", ex.Message); } } Context.Response.Clear(); Context.Response.ContentType = "application/json"; Context.Response.Write(JsonConvert.SerializeObject(objs)); }