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));
}
