public static InventoryItem Find(int id) { SqlConnection conn = DB.Connection(); SqlDataReader rdr = null; conn.Open(); SqlCommand cmd = new SqlCommand("SELECT * FROM inventoryItems WHERE id= @InventoryItemID;", conn); SqlParameter inventoryItemIdParameter = new SqlParameter(); inventoryItemIdParameter.ParameterName = "@InventoryItemId"; inventoryItemIdParameter.Value = id.ToString(); cmd.Parameters.Add(inventoryItemIdParameter); rdr = cmd.ExecuteReader(); int foundInventoryItemId = 0; string foundInventoryItemName = null; string foundInventoryItemDescription = null; while(rdr.Read()) { foundInventoryItemId = rdr.GetInt32(0); foundInventoryItemName = rdr.GetString(1); } InventoryItem foundInventoryItem = new InventoryItem(foundInventoryItemName, foundInventoryItemDescription, foundInventoryItemId); if (rdr != null) rdr.Close(); if (conn != null) conn.Close(); return foundInventoryItem; }
public void Test_Save_AssignsIdToObject() { InventoryItem testInventoryItem = new InventoryItem("cat", "it's a cat"); testInventoryItem.Save(); InventoryItem foundInventoryItem = InventoryItem.Find(testInventoryItem.GetId()); Assert.Equal(testInventoryItem, foundInventoryItem); }
public void Test_Equal_ReturnsTrueIfNamesAreTheSame() { //Arrange, Act InventoryItem firstInventoryItem = new InventoryItem("cat", "it's a cat"); InventoryItem secondInventoryItem = new InventoryItem("cat", "it's a cat"); //Assert Assert.Equal(firstInventoryItem, secondInventoryItem); }
public void Test_DatabaseHasStuff() { //Arrange, Act InventoryItem newInventoryItem = new InventoryItem("cat", "it's a cat"); newInventoryItem.Save(); int result = InventoryItem.GetAll().Count; //Assert Assert.Equal(1, result); }
public void Test_DeleteOne_DeletesGivenOne() { InventoryItem firstInventoryItem = new InventoryItem("cat", "it's a cat"); firstInventoryItem.Save(); InventoryItem secondInventoryItem = new InventoryItem("dog", "it's a dog"); secondInventoryItem.Save(); InventoryItem thirdInventoryItem = new InventoryItem("fish", "it's a fish"); thirdInventoryItem.Save(); InventoryItem.DeleteOne("dog"); int newInventory=InventoryItem.GetAll().Count; Assert.Equal(2, newInventory); }
public void Test_Save_SavesToDatabase() { //Arrange InventoryItem newInventoryItem = new InventoryItem("cat", "it's a cat"); //Act newInventoryItem.Save(); List<InventoryItem> result = InventoryItem.GetAll(); List<InventoryItem> testList = new List<InventoryItem>{newInventoryItem}; //Assert Assert.Equal(testList, result); }
public void Test_Search_FindsIdByName() { InventoryItem testInventoryItem = new InventoryItem("cat", "it's a cat"); testInventoryItem.Save(); int result = InventoryItem.Search(testInventoryItem.GetName()); Assert.Equal(testInventoryItem.GetId(), result); }
public void Test_Search_DoesntFindIdForUnused() { InventoryItem testInventoryItem = new InventoryItem("cat", "it's a cat"); testInventoryItem.Save(); int result = InventoryItem.Search("dog"); Assert.Equal(-1, result); }
public static List<InventoryItem> GetAll() { List<InventoryItem> allInventoryItems = new List<InventoryItem>{}; SqlConnection conn = DB.Connection(); SqlDataReader rdr = null; conn.Open(); SqlCommand cmd = new SqlCommand("Select * FROM InventoryItems;", conn); rdr = cmd.ExecuteReader(); while(rdr.Read()) { int inventoryItemId = rdr.GetInt32(0); string inventoryItemName = rdr.GetString(1); string inventoryItemDescription = rdr.GetString(2); InventoryItem newInventoryItem = new InventoryItem(inventoryItemName, inventoryItemDescription, inventoryItemId); allInventoryItems.Add(newInventoryItem); } if (rdr != null) rdr.Close(); if (conn != null) conn.Close(); return allInventoryItems; }