public static void NewList(string listname)
{
using (var db = new KanbanEntities())
{
var newrow = db.Set<List>();
newrow.Add(new List { Name = listname, CreatedDate = DateTime.Now });
db.SaveChanges();
Console.WriteLine(listname + " added!");
}
}
public static void GetListing()
{
using (var db = new KanbanEntities())
{
foreach (var list in db.Lists)
{
Console.WriteLine(list.Name);
var subcards = db.Cards.Where(u => u.ListID == list.ListID);
foreach (var card in subcards)
{
Console.WriteLine("\t" + card.Text);
}
}
}
}
static void Main(string[] args)
{
using (var db = new KanbanEntities())
{
foreach (var list in db.Lists)
{
Console.WriteLine(list.Name);
foreach (var card in db.Cards)
{
if (card.ListID == list.ListID)
{
Console.WriteLine("\t" + card.Text);
}
}
}
try
{
while (true) {
Console.WriteLine("Do you want to create a New List, a New Card, Delete a Card, or Delete a List?");
string choice = Console.ReadLine();
if (choice.ToLower() == "new list")
{
Console.WriteLine("Please enter the name of the new list.");
string listname = Console.ReadLine();
var newie = db.Set<List>();
newie.Add(new List { Name = listname, CreatedDate = DateTime.Now });
db.SaveChanges();
Console.WriteLine(listname + " added!");
break;
}
else if (choice.ToLower() == "new card")
{
int listIDadd = 0;
Console.WriteLine("Please enter the name of the List you would like to add your card to.");
string listnameadd = Console.ReadLine();
var listAdd = db.Lists.Where(u => u.Name == listnameadd);
foreach (var u in listAdd)
{
listIDadd = u.ListID;
}
Console.WriteLine("Please enter the card information to be added to this list.");
string cardinfo = Console.ReadLine();
var newie = db.Set<Card>();
newie.Add(new Card { ListID = listIDadd, CreatedDate = DateTime.Now, Text = cardinfo });
db.SaveChanges();
Console.WriteLine(cardinfo + " added to " + listnameadd);
break;
}
else if (choice.ToLower() == "delete a card")
{
Console.WriteLine("Please enter the name of the Card you would like to delete.");
string cardDeleteInfo = Console.ReadLine();
var cardDelete = db.Cards.Where(u => u.Text == cardDeleteInfo);
foreach (var u in cardDelete)
{
db.Cards.Remove(u);
}
db.SaveChanges();
break;
}
else if (choice.ToLower() == "delete a list")
{
Console.WriteLine("Please enter the name of the List you would like to delete.");
string listDeleteInfo = Console.ReadLine();
var listDelete = db.Lists.Where(u => u.Name == listDeleteInfo);
foreach (var u in listDelete)
{
db.Lists.Remove(u);
}
db.SaveChanges();
break;
}
else
{
Console.WriteLine("Entry not understood.");
}
}
Console.ReadLine();
}
catch
{
Console.WriteLine("Please enter the correct name of the list or card.");
Console.ReadLine();
}
}
}
public static void NewCard(string listname, string cardname)
{
using (var db = new KanbanEntities())
{
var selList = db.Lists.Where(u => u.Name == listname).FirstOrDefault();
var newrow = db.Set<Card>();
newrow.Add(new Card { ListID = selList.ListID, CreatedDate = DateTime.Now, Text = cardname });
db.SaveChanges();
Console.WriteLine(cardname + " added to " + listname);
}
}
public static void DelCard(string text)
{
using (var db = new KanbanEntities())
{
var delCard = db.Cards.Where(u => u.Text == text).FirstOrDefault();
db.Cards.Remove(delCard);
db.SaveChanges();
}
}
public static void DelCard(int id)
{
using (var db = new KanbanEntities())
{
var cardsDelete = db.Cards.Where(u => u.ListID == id);
foreach (var x in cardsDelete)
{
db.Cards.Remove(x);
}
db.SaveChanges();
}
}
public static void DelList(string list)
{
using (var db = new KanbanEntities())
{
var listDelete = db.Lists.Where(u => u.Name == list).FirstOrDefault();
DelCard(listDelete.ListID);
db.Lists.Remove(listDelete);
db.SaveChanges();
}
}