public int UpdateFoodData(DogFood dogFood) { try { SqlCommand sqlCommand = new SqlCommand("DogFoodCrud", sqlConnection); sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.Parameters.AddWithValue("@DogFood", "Update"); sqlCommand.Parameters.AddWithValue("@FoodId", dogFood.FoodId); sqlCommand.Parameters.AddWithValue("@FoodName", dogFood.FoodName); sqlCommand.Parameters.AddWithValue("@Quantity", dogFood.Quantity); sqlCommand.Parameters.AddWithValue("@BrandName", dogFood.BrandName); sqlCommand.Parameters.AddWithValue("@Stock", dogFood.Stock); sqlCommand.Parameters.AddWithValue("@Cost", dogFood.Cost); sqlCommand.Parameters.AddWithValue("@ProductImage", dogFood.FoodImage); sqlCommand.Parameters.AddWithValue("@UpdateDate", dogFood.UpdateDate.ToLongDateString()); sqlConnection.Open(); int dataUpdated = sqlCommand.ExecuteNonQuery(); CloseAndDisposeCon(); return(dataUpdated); } catch (Exception ex) { throw ex; } finally { CloseAndDisposeCon(); } }
private void feedDogs(DogFood theDogFood) { int currLeftPos = Console.CursorLeft; Console.SetCursorPosition(currLeftPos - 1, Console.CursorTop); if (theDogFood.level <= 0) { string msg = "Sorry. Out of Dog Food. Press any key to continue"; int currxPos = Console.CursorLeft; int curryPOs = Console.CursorTop; Console.Write(msg ); Console.ReadKey(true); Console.SetCursorPosition(currxPos-1, Console.CursorTop); // move the cursor up Nine lines to paint next menu on top. Console.Write(" "); // to erase the last message //throw new System.NotImplementedException("Dog Food is empty"); return; } if (Dogs == null) { Console.Write("Sorry. No Dogs to Feed. Press any key to continue"); Console.ReadKey(true); //throw new System.NotImplementedException("No Dogs to Feed"); return; } foreach (var dog in Dogs) { dog.feedIt(dog.FeedingAmount); theDogFood.level -= dog.FeedingAmount; } return; }
public void CanWriteAndReadDogFoodIngredients() { int foodId; var ingredientsList = new System.Collections.Generic.List <string> { "Chicken", "Bacon", "Peas", "Water", "Preservative" }; using (var dbc = PawtionContext.GetSQLiteContext(sqlFilename)) { var food = new DogFood() { BagSize = 12, Name = "Magi's pet mince" }; food.Ingredients = ingredientsList; dbc.Foods.Add(food); dbc.SaveChanges(); foodId = food.Id; } using (var dbc = PawtionContext.GetSQLiteContext(sqlFilename)) { var dogfood = dbc.Foods.Find(foodId); Assert.NotNull(dogfood); Assert.NotEmpty(dogfood.Ingredients); Assert.Equal(ingredientsList.Count, dogfood.Ingredients.Count); } }
public Supplies() { catFood = new CatFood(); dogFood = new DogFood(); birdFood = new BirdFood(); reptileFood = new ReptileFood(); }
public void CanInsertAPawtionEntityWithShopDetails() { int pawtionId; var myShop = new Shop("PetMax Kyalami Corner", new Point(new Coordinate(28.074818, -25.985173))); using (var dbc = PawtionContext.GetSQLiteContext(sqlFilename)) { var food = new DogFood() { BagSize = 12, Name = "Hills Active Adult" }; var pawtion = new Pawtion(food, 851, 32); pawtion.PetShop = new Shop(myShop.Name, myShop.Location); dbc.Pawtions.Add(pawtion); dbc.SaveChanges(); pawtionId = pawtion.Id; } using (var dbc = PawtionContext.GetSQLiteContext(sqlFilename)) { var pawtion = dbc.Pawtions.Find(pawtionId); Assert.Equal(myShop.Name, pawtion.PetShop.Name); Assert.Equal(myShop.Location, pawtion.PetShop.Location); } }
public void CanEditDogFoodIngredients() { int foodId; var ingredientsList = new System.Collections.Generic.List <string> { "Chicken", "Bacon", "Peas", "Water", "Preservative" }; var ingredientsList2 = new System.Collections.Generic.List <string> { "Bacon", "Chicken", "Desicated coconut", "Peas", "Preservative", "Water", "ZeroMSG" }; using (var dbc = PawtionContext.GetSQLiteContext(sqlFilename)) { var food = new DogFood() { BagSize = 12, Name = "Magi's pet mince 2" }; food.Ingredients = ingredientsList; dbc.Foods.Add(food); dbc.SaveChanges(); foodId = food.Id; } using (var dbc = PawtionContext.GetSQLiteContext(sqlFilename)) { var dogfood = dbc.Foods.Find(foodId); Assert.NotNull(dogfood); Assert.NotEmpty(dogfood.Ingredients); dogfood.Ingredients.Add("Desicated coconut"); dogfood.Ingredients.Add("ZeroMSG"); dogfood.Ingredients.Sort(); dbc.SaveChanges(); } }
public void Eat_SuppliedDogFood_ShouldNotBeHungry() { // Arrange var dog = new Dog("dawg"); var dogFood = new DogFood(); // Act dog.Feed(dogFood); // Assert Assert.IsFalse(dog.IsHungry); }
public void Eat_SuppliedDogFood_ShouldthrowArgumentException() { // Arrange var cat = new Cat("Mr Meow"); var dogFood = new DogFood(); // Act var exception = Assert.Throws<ArgumentException>(() => cat.Feed(dogFood)); // Assert StringAssert.Contains("Cats can only eat CatFood", exception.Message); }
public void Eat_DogFoodShouldIncreaseEnegy() { //Arrange var dog = new Dog("Doggy"); //Act var currentEnergy = dog.Energy; var dogFood = new DogFood(); dog.Eat(dogFood); //Assert Assert.Greater(dog.Energy, currentEnergy); }
public void CanInsertAPawtionEntity() { using (var dbc = PawtionContext.GetSQLiteContext(sqlFilename)) { var food = new DogFood() { BagSize = 12, Name = "Hills Healthy Adult" }; var pawtion = new Pawtion(food, 765, 32); dbc.Pawtions.Add(pawtion); dbc.SaveChanges(); Assert.NotEqual(0, pawtion.Id); Assert.Equal(DateTime.Today, pawtion.AddedDate().Date); } }
public void WillNotAddDuplicateDogFoodBasedOnAlternateKey() { using (var dbc = PawtionContext.GetSQLiteContext(sqlFilename)) { var dogfood1 = new DogFood() { Name = "DogFood 1", BagSize = 12 }; var dogfood2 = new DogFood() { Name = "DogFood 1", BagSize = 12 }; dbc.Foods.Add(dogfood1); Assert.ThrowsAny <System.InvalidOperationException>(() => dbc.Foods.Add(dogfood2)); //()=>dbc.SaveChanges()); } }
public int DeleteFoodData(DogFood dogFood) { try { SqlCommand sqlCommand = new SqlCommand("DogFoodCrud", sqlConnection); sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.Parameters.AddWithValue("@DogFood", "Delete"); sqlCommand.Parameters.AddWithValue("@FoodId", dogFood.FoodId); sqlConnection.Open(); int dataDeleted = sqlCommand.ExecuteNonQuery(); CloseAndDisposeCon(); return(dataDeleted); } catch (Exception ex) { throw ex; } finally { CloseAndDisposeCon(); } }
public DataTable FilterFoodByQuantity(DogFood dogFood) { try { SqlCommand sqlCommand = new SqlCommand("FilterDogFood", sqlConnection); sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.Parameters.AddWithValue("@Filter", "Quantity"); sqlCommand.Parameters.AddWithValue("@Quantity", dogFood.Quantity); sqlConnection.Open(); SqlDataReader dataReader = sqlCommand.ExecuteReader(); DataTable dataTable = new DataTable(); dataTable.Load(dataReader); CloseAndDisposeCon(); return(dataTable); } catch (Exception ex) { throw ex; } finally { CloseAndDisposeCon(); } }
public int UpdateFood(DogFood dogFood) { return(dogFoodDL.UpdateFoodData(dogFood)); }
public DataTable FoodByQuantity(DogFood dogFood) { return(dogFoodDL.FilterFoodByQuantity(dogFood)); }
public DataTable FoodByCost(DogFood dogFood) { return(dogFoodDL.FilterFoodByCost(dogFood)); }
public DataTable FoodByBrand(DogFood dogFood) { return(dogFoodDL.FilterFoodByBrand(dogFood)); }
public int DeleteFood(DogFood dogFood) { return(dogFoodDL.DeleteFoodData(dogFood)); }
public void eat(DogFood food) { }
public int InsertFood(DogFood dogFood) { return(dogFoodDL.InsertFoodData(dogFood)); }