public void TestBlankLAList()
{
LAList testList3 = new LAList() { ID = 50, Name = "Blank List" };
LAListItem testInsertItem = new LAListItem() { ID = 10, Description = "Test Insert", Done = false };
Assert.IsNotNull(testInsertItem, "Test insert item is null.");
testList3.LAListItems.Add(testInsertItem);
Assert.AreEqual<int>(1, testList3.LAListItems.Count, "List item not added.");
testList3.LAListItems.Remove(testInsertItem);
Assert.AreEqual<int>(0, testList3.LAListItems.Count, "List item not removed.");
}
public void TestInitialize()
{
Database.SetInitializer(new DbInitializer());
this.db = new ListAssistContext(new DbConStringBuilder("WebAPITests").getConnectionString());
db.Database.Initialize(true);
Assert.IsNotNull(this.db, "List assist context is null.");
AutoMapperConfiguration.Configure();
listQueries = new ListQueries(new DbConStringBuilder("WebAPITests").getConnectionString());
LAList testList1 = new LAList() { Name = "Test List 1" };
LAList testList2 = new LAList() { Name = "Test List 2" };
LAListItem testInsertItem1 = new LAListItem() { Description = "Test Insert 1", Done = false };
LAListItem testInsertItem2 = new LAListItem() { Description = "Test Insert 2", Done = false };
LAListItem testInsertItem3 = new LAListItem() { Description = "Test Insert 3", Done = false };
Assert.IsNotNull(testList1, "Test list 1 is null.");
Assert.IsNotNull(testList2, "Test list 2 is null.");
Assert.IsNotNull(testInsertItem1, "Test insert item 1 is null.");
testList1.LAListItems.Add(testInsertItem1);
Assert.IsNotNull(testInsertItem2, "Test insert item 2 is null.");
testList1.LAListItems.Add(testInsertItem2);
Assert.IsNotNull(testInsertItem3, "Test insert item 3 is null,");
testList2.LAListItems.Add(testInsertItem3);
var lists = new List<LAList>
{
testList1,
testList2,
};
foreach (LAList newList in lists)
{
this.db.LALists.Add(newList);
foreach (LAListItem newListItem in newList.LAListItems)
{
this.db.LAListItems.Add(newListItem);
}
}
this.db.SaveChanges();
Assert.IsNotNull(this.db.LALists.Where(e => e.Name.Equals("Test List 1")).FirstOrDefault(), "Test List 1 not found.");
Assert.IsNotNull(this.db.LALists.Where(e => e.Name.Equals("Test List 2")).FirstOrDefault(), "Test List 2 not found.");
Assert.IsNull(this.db.LALists.Where(e => e.Name.Equals("Test List 3")).FirstOrDefault(), "Test List 3 found.");
}
public void TestLAListItem()
{
LAListItem testListItem = new LAListItem() { ID = 1, Description = "Test List Item", Done = true };
int id = testListItem.ID;
Assert.AreEqual<int>(1, id);
string description = testListItem.Description;
Assert.IsNotNull(description);
Assert.AreEqual<string>("Test List Item", description);
Boolean done = testListItem.Done;
Assert.IsTrue(done);
}
public void TestAddListItem()
{
LAList testList = new LAList { Name = "Test List 1" };
Assert.IsNotNull(testList);
LAListItem testListItem = new LAListItem { Description = "Test Item 1", Done = true };
Assert.IsNotNull(testListItem);
Assert.AreEqual<int>(0, testList.LAListItems.Count);
testList.LAListItems.Add(testListItem);
Assert.AreEqual<int>(1, testList.LAListItems.Count);
testList = null;
testListItem = null;
}
public void TestInitialize()
{
LAList testList1 = new LAList() { ID = 30, Name = "Test List 1" };
LAList testList2 = new LAList() { ID = 40, Name = "Test List 2" };
LAListItem testInsertItem1 = new LAListItem() { ID = 12, Description = "Test Insert 1", Done = false };
LAListItem testInsertItem2 = new LAListItem() { ID = 13, Description = "Test Insert 2", Done = false };
LAListItem testInsertItem3 = new LAListItem() { ID = 14, Description = "Test Insert 3", Done = false };
Assert.IsNotNull(testList1, "Test list 1 is null.");
Assert.IsNotNull(testList2, "Test list 2 is null.");
Assert.IsNotNull(testInsertItem1, "Test insert item 1 is null.");
testList1.LAListItems.Add(testInsertItem1);
Assert.IsNotNull(testInsertItem2, "Test insert item 2 is null.");
testList1.LAListItems.Add(testInsertItem2);
Assert.IsNotNull(testInsertItem3, "Test insert item 3 is null,");
testList2.LAListItems.Add(testInsertItem3);
Database.SetInitializer(new DbInitializer());
this.db = new ListAssistContext();
this.db.Database.Initialize(false);
Assert.IsNotNull(this.db, "List assist context is null.");
var lists = new List<LAList>
{
testList1,
testList2,
};
foreach (LAList newList in lists)
{
this.db.LALists.Add(newList);
foreach (LAListItem newListItem in newList.LAListItems)
{
this.db.LAListItems.Add(newListItem);
}
}
this.db.SaveChanges();
Assert.IsNotNull(this.db.LALists.Find(30), "List with ID = 30 not found.");
}
public void TestRemoveListItem()
{
LAList testList = new LAList { Name = "Test List 2" };
Assert.IsNotNull(testList);
LAListItem testListItem = new LAListItem { Description = "Test Item 2", Done = false };
Assert.IsNotNull(testListItem);
Assert.AreEqual<int>(0, testList.LAListItems.Count);
testList.LAListItems.Add(testListItem);
Assert.AreEqual<int>(1, testList.LAListItems.Count);
testList.LAListItems.Remove(testListItem);
Assert.AreEqual<int>(0, testList.LAListItems.Count);
testList = null;
testListItem = null;
}
public void TestEditListItem()
{
LAList testList = new LAList { Name = "Test List 3" };
Assert.IsNotNull(testList);
LAListItem testListItem = new LAListItem { Description = "Test Item 3", Done = false };
Assert.IsNotNull(testListItem);
Assert.AreEqual<int>(0, testList.LAListItems.Count);
testList.LAListItems.Add(testListItem);
Assert.AreEqual<int>(1, testList.LAListItems.Count);
LAListItem updateListItem = testList.LAListItems.Find(x => x.ID == 0);
Assert.IsNotNull(updateListItem);
updateListItem.Done = true;
updateListItem = null;
LAListItem foundListItem = testList.LAListItems.Find(x => x.ID == 0);
Assert.IsNotNull(foundListItem);
Assert.IsTrue(foundListItem.Done);
foundListItem = null;
testList = null;
testListItem = null;
}
// GET: LALists/Details/5
public ActionResult Details(int? id)
{
HttpResponseMessage responseMsg = null;
JObject jsonObj = null;
// JObject jsonItemObj = null;
LAList lAList = null;
List<LAListItem> listItems = null;
List<LASuggestion> listSuggestions = null;
if (id == null)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
responseMsg = this.newClient.GetAsync("api/Lists/" + id).Result;
if (responseMsg.StatusCode == HttpStatusCode.OK)
{
jsonObj = JObject.Parse(responseMsg.Content.ReadAsStringAsync().Result);
lAList = jsonObj.ToObject<LAList>();
if (lAList == null)
{
return HttpNotFound();
}
foreach (JObject jsonItemObj in jsonObj["ShoppingListItems"])
{
var item = new LAListItem();
item.ID = (int)jsonItemObj["Id"];
item.ListID = (int)jsonItemObj["ListId"];
item.Done = (bool)jsonItemObj["Checked"];
item.Description = (string)jsonItemObj["Description"];
lAList.LAListItems.Add(item);
}
listSuggestions = jsonObj["ShoppingListSuggestions"].ToObject<List<LASuggestion>>();
foreach (LASuggestion item in listSuggestions)
{
lAList.LASuggestions.Add(item);
}
return View("Details", lAList);
}
return View(lAList);
}
public ActionResult AddListItem(int? id)
{
LAListItem lAListItem = null;
if (id == null)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
lAListItem = new LAListItem() { ListID = (int)id };
return View("AddListItem", lAListItem);
}
public void TestAddItemToNoList()
{
var newItem = new LAListItem() { Description = "Test Insert 0", Done = false };
var result = ListQueries.AddItemToList(newItem);
Assert.AreEqual(false, result);
}
public void TestAddDuplicateItem()
{
var newItem = new LAListItem()
{
Description = "Milk",
ListID = 1
};
var result = ListQueries.AddItemToList(newItem);
Assert.AreEqual(false, result);
Assert.AreEqual(4, ListQueries.GetList(1).LAListItems.Count);
}
public void TestAddListItem()
{
LAList testList = new LAList() { Name = "List to Remove" };
ListQueries.AddList(testList);
Assert.IsNotNull(ListQueries.GetList(testList.ID));
Assert.AreEqual(0, ListQueries.GetList(testList.ID).LAListItems.Count);
var newItem = new LAListItem()
{
Description = "Test Item",
Done = true,
ListID = testList.ID
};
var result = ListQueries.AddItemToList(newItem);
var foundList = ListQueries.GetList(testList.ID);
Assert.AreEqual(true, result);
Assert.IsNotNull(foundList);
Assert.AreEqual(1, foundList.LAListItems.Count);
ListQueries.RemoveList(foundList.ID);
Assert.AreEqual(2, ListQueries.GetLists().Count);
}
public static bool AddItemToList(LAListItem item)
{
var success = false;
if (item != null)
{
var list = db.LALists.Find(item.ListID);
if (list != null)
{
var duplicate = db.LAListItems.Where(e => (e.ListID == item.ListID) && (e.Description.Equals(item.Description))).FirstOrDefault();
if (duplicate == null)
{
db.LAListItems.Add(item);
db.SaveChanges();
success = true;
}
//else if (duplicate.Done)
//{
// duplicate.Done = false;
// db.Entry(duplicate).State = EntityState.Modified;
//}
}
}
return success;
}
