public void InsertCupcake(Cupcake cupcake)
{
var connection = createConnection();
connection.Open();
SqlCommand command = new SqlCommand()
{
CommandText = "INSERT INTO Cupcake VALUES (@Name, @Price, @CreatedOn, @LastModified, @Ingredients, @ImageFileName, @Featured)",
Connection = connection
};
SqlParameter priceParemeter = new SqlParameter()
{
ParameterName = "Price",
DbType = System.Data.DbType.Decimal,
Value = cupcake.Price,
SqlDbType = System.Data.SqlDbType.Decimal,
SqlValue = cupcake.Price
};
command.Parameters.AddWithValue("Name", cupcake.Name);
command.Parameters.Add(priceParemeter);
command.Parameters.AddWithValue("CreatedOn", cupcake.CreatedOn);
command.Parameters.AddWithValue("LastModified", cupcake.LastModified);
command.Parameters.AddWithValue("Ingredients", cupcake.Ingredients);
command.Parameters.AddWithValue("ImageFileName", cupcake.ImageFileName == null ? "" : cupcake.ImageFileName);
command.Parameters.AddWithValue("Featured", cupcake.Featured);
command.ExecuteNonQuery();
connection.Close();
}
public void UpdateCupcake(Cupcake cupcake)
{
//create connection string and update cupcake
var connection = createConnection();
connection.Open();
SqlCommand command = new SqlCommand()
{
CommandText = "UPDATE Cupcake SET Name = @Name, Price = @Price, LastModified = @LastModified, Ingredients = @Ingredients, ImageFileName = @ImageFileName, Featured = @Featured WHERE Id = @Id",
Connection = connection
};
SqlParameter priceParemeter = new SqlParameter()
{
ParameterName = "Price",
DbType = System.Data.DbType.Decimal,
Value = cupcake.Price,
SqlDbType = System.Data.SqlDbType.Decimal,
SqlValue = cupcake.Price
};
command.Parameters.AddWithValue("Name", cupcake.Name);
command.Parameters.Add(priceParemeter);
command.Parameters.AddWithValue("LastModified", cupcake.LastModified);
command.Parameters.AddWithValue("Id", cupcake.Id);
command.Parameters.AddWithValue("Ingredients", cupcake.Ingredients);
command.Parameters.AddWithValue("ImageFileName", cupcake.ImageFileName);
command.Parameters.AddWithValue("Featured", cupcake.Featured);
command.ExecuteNonQuery();
connection.Close();
}
public IActionResult Create(string newName, string newDescription, int newPrice, string newCake, string newFrosting, string newTopping, int newInventory, string newImage)
{
Cupcake newCupcake = new Cupcake(newName, newDescription, newPrice, newCake, newFrosting, newTopping, newInventory, newImage);
cupcakeRepo.Save(newCupcake);
return(Json(newCupcake));
}
public IActionResult DeleteConfirmed(int id)
{
Cupcake thisCupcake = cupcakeRepo.Cupcakes.FirstOrDefault(x => x.Id == id);
cupcakeRepo.Remove(thisCupcake);
return(Json(thisCupcake));
}
/// <summary>
/// Fired when the game updates.
/// </summary>
/// <param name="args">The <see cref="EventArgs"/> instance containing the event data.</param>
private static void Game_OnUpdate(EventArgs args)
{
try
{
Game.PrintChat(Cupcake.Initialized.ToString());
if (!Cupcake.Initialized)
{
return;
}
}
catch (Exception)
{
// ignored
}
foreach (var spell in SpellList)
{
var target = TargetSelector.GetTarget(spell.Range, TargetSelector.DamageType.True);
if (target == null)
{
continue;
}
var prediction = Cupcake.GetPrediction(new CupcakeIngredients(target, spell)).CastPosition;
spell.Cast(prediction);
}
}
public ActionResult DeleteConfirmed(int id)
{
Cupcake cupcake = context.Cupcakes.Find(id);
context.Cupcakes.Remove(cupcake);
context.SaveChanges();
return(RedirectToAction("Index"));
}
public IGraphActionResult NewCupcakeCreated(Cupcake eventData, string nameLike = "*")
{
if (this.IsMatch(eventData, nameLike))
{
return(this.Ok(eventData));
}
return(this.Ok());
}
public void AddAsync_throws_if_model_is_null()
{
IInventoryRepository repository = new InventoryRepository(_context);
Cupcake cupcake = null;
Assert.ThrowsAsync <ArgumentException>(() => repository.AddAsync(cupcake));
}
public IActionResult CreatePost(Cupcake cupcake)
{
if (ModelState.IsValid)
{
_repository.CreateCupcake(cupcake);
return(RedirectToAction(nameof(Index)));
}
PopulateBakeriesDropDownList(cupcake.BakeryId);
return(View(cupcake));
}
public void Database_GetDetailsPage_SelectedCupcakeIsReturned()
{
CupcakeController controller = new CupcakeController(db);
var testCupcake = new Cupcake("Limoncello Meringue", "Vanilla cake with marshmallow frosting, browned to perfection.", 2, "Vanilla", "Marshmallow", "None", 24, "http://www.cupcakeroyale.com/wp-content/uploads/2016/04/Limoncello.jpg");
controller.Create(testCupcake);
var model = (controller.Details(testCupcake.Id) as ViewResult).ViewData.Model as Cupcake;
Assert.Equal(testCupcake, model);
}
public void Database_CreateNewCupcake_CupcakeIsReturned()
{
CupcakeController controller = new CupcakeController(db);
var testCupcake = new Cupcake("Limoncello Meringue", "Vanilla cake with marshmallow frosting, browned to perfection.", 2, "Vanilla", "Marshmallow", "None", 24, "http://www.cupcakeroyale.com/wp-content/uploads/2016/04/Limoncello.jpg");
controller.Create(testCupcake);
var collection = (controller.Index() as ViewResult).ViewData.Model as IEnumerable <Cupcake>;
Assert.Contains(testCupcake, collection);
}
public ActionResult Delete(int id)
{
Cupcake cupcake = context.Cupcakes.Find(id);
if (cupcake == null)
{
return(HttpNotFound());
}
return(View("Delete", cupcake));
}
public ActionResult Create(Cupcake cupcake)
{
if (!ModelState.IsValid)
{
return(View("Create", cupcake));
}
context.Cupcakes.Add(cupcake);
context.SaveChanges();
return(RedirectToAction("Index"));
}
public IActionResult Edit(int id)
{
Cupcake cupcake = _repository.GetCupcakeById(id);
if (cupcake == null)
{
return(NotFound());
}
PopulateBakeriesDropDownList(cupcake.BakeryId);
return(View(cupcake));
}
public async Task AddAsync(Cupcake cupcake)
{
if (cupcake == null)
{
throw new ArgumentException("Cupcake cannot be null", nameof(cupcake));
}
_context.Cupcakes.Add(cupcake);
await _context.SaveChangesAsync();
}
public void GetNameTest()
{
//Arrange
var cupcake = new Cupcake("Rhubarb Almond Buckle", "Our vanilla cupcake filled with a tangy rhubarb compote, topped with fresh strawberry buttercream and almond streusel. Available May only!", 3, "Almond", "Rhubarb", "Almonds", 36, "http://www.cupcakeroyale.com/wp-content/uploads/2016/03/Rhubarb-Crisp-084.jpg");
//Act
var result = cupcake.Name;
//Assert
Assert.Equal("Rhubarb Almond Buckle", result);
}
public async Task AddAsync_inserts_model_into_repository()
{
IInventoryRepository repository = new InventoryRepository(_context);
Cupcake cupcake = new Cupcake {
Name = "FooBar Sprinkles"
};
await repository.AddAsync(cupcake);
var savedCupcake = Assert.Single(_context.Cupcakes);
Assert.Equal(cupcake.Name, savedCupcake.Name);
}
public void CreateCupcake(Cupcake cupcake)
{
if (cupcake.PhotoAvatar != null && cupcake.PhotoAvatar.Length > 0)
{
cupcake.ImageMimeType = cupcake.PhotoAvatar.ContentType;
cupcake.ImageName = Path.GetFileName(cupcake.PhotoAvatar.FileName);
using (var ms = new MemoryStream())
{
cupcake.PhotoAvatar.CopyTo(ms);
cupcake.PhotoFile = ms.ToArray();
}
_context.Add(cupcake);
_context.SaveChanges();
}
}
public async Task <IActionResult> EditPost(int id, Cupcake cupcake)
{
if (_repository.GetCupcakeById(id) is Cupcake cupcakeToUpdate)
{
if (await TryUpdateModelAsync(cupcakeToUpdate, prefix: "",
c => c.BakeryId, c => c.CupcakeType, c => c.Description, c => c.GlutenFree, c => c.Price))
{
_repository.SaveChanges();
return(RedirectToAction(nameof(Index)));
}
PopulateBakeriesDropDownList(cupcakeToUpdate.BakeryId);
return(View(cupcakeToUpdate));
}
return(NotFound());
}
public void CreateCupcake(Cupcake cupcake)
{
if (cupcake.PhotoAvatar?.Length > 0)
{
cupcake.ImageMimeType = cupcake.PhotoAvatar.ContentType;
cupcake.ImageName = cupcake.PhotoAvatar.FileName;
using (var memoryStream = new MemoryStream())
{
cupcake.PhotoAvatar.CopyTo(memoryStream);
cupcake.PhotoFile = memoryStream.ToArray();
}
}
_context.Add(cupcake);
_context.SaveChanges();
}
public IActionResult Edit(string newName, string newDescription, int newPrice, string newCake, string newFrosting, string newTopping, int newInventory, string newImage, int id)
{
Cupcake thisCupcake = cupcakeRepo.Cupcakes.FirstOrDefault(x => x.Id == id);
thisCupcake.Name = newName;
thisCupcake.Description = newDescription;
thisCupcake.Price = newPrice;
thisCupcake.Cake = newCake;
thisCupcake.Frosting = newFrosting;
thisCupcake.Topping = newTopping;
thisCupcake.Inventory = newInventory;
thisCupcake.ImgUrl = newImage;
cupcakeRepo.Edit(thisCupcake);
return(Json(thisCupcake));
}
public void CreateCupcake(Cupcake cupcake)
{
if (cupcake.PhotoAvatar is not null)
{
if (cupcake.PhotoAvatar.Length > 0)
{
cupcake.ImageMimeType = cupcake.PhotoAvatar.ContentType;
cupcake.ImageName = Path.GetFileName(cupcake.PhotoAvatar.FileName);
using MemoryStream _ctxMemory = new();
cupcake.PhotoAvatar.CopyTo(_ctxMemory);
cupcake.PhotoFile = _ctxMemory.ToArray();
}
}
_ = _context.Add(cupcake);
_ = _context.SaveChanges();
}
public void DeleteCupcake(Cupcake cupcake)
{
//create connection string and delete cupcake
var connection = createConnection();
connection.Open();
SqlCommand command = new SqlCommand()
{
CommandText = "DELETE Cupcake WHERE Id = @Id",
Connection = connection
};
command.Parameters.AddWithValue("Id", cupcake.Id);
command.ExecuteNonQuery();
connection.Close();
}
public IGraphActionResult UpdateCupcake(Cupcake cupcake)
{
if (!this.ModelState.IsValid)
{
return(this.BadRequest(this.ModelState));
}
var updatedCake = _cupcakeService.UpdateCupcake(cupcake.Id ?? -1, cupcake.Name, cupcake.Flavor);
if (updatedCake == null)
{
return(this.BadRequest("Cupcake not found"));
}
this.PublishSubscriptionEvent(PastryConstants.CUPCAKE_UPDATED, updatedCake);
return(this.Ok(updatedCake));
}
public IGraphActionResult AddCupcake(Cupcake cupcake)
{
if (!this.ModelState.IsValid)
{
return(this.BadRequest(this.ModelState));
}
var updatedCake = _cupcakeService.CreateCupcake(cupcake.Name, cupcake.Flavor, cupcake.Quantity);
if (updatedCake == null)
{
return(this.BadRequest("Error creating the new cupcake"));
}
this.PublishSubscriptionEvent(PastryConstants.CUPCAKE_CREATED, updatedCake);
return(this.Ok(updatedCake));
}
private static void Main(string[] args)
{
Console.ForegroundColor = ConsoleColor.Cyan;
Console.WriteLine("Gang of Four Design Pattern - Decorator");
IDessert cookie = new Cookie {
BatterFlavor = "Vanilla", HasFrosting = true, FrostingFlavor = "Buttercream", UnitCost = .89m
};
cookie.UpdatePrice(1.99m);
IDessert cake = new Cake {
BatterFlavor = "Chocolate", HasFrosting = true, FrostingFlavor = "German Chocolate", UnitCost = 5.99m
};
cake.UpdatePrice(12.99m);
IDessert cupcake = new Cupcake()
{
BatterFlavor = "Red Velvet", HasFrosting = true, FrostingFlavor = "Cream cheese", UnitCost = 1.39m
};
cupcake.UpdatePrice(3.99m);
Console.ForegroundColor = ConsoleColor.Yellow;
Console.WriteLine(cookie.GetDetails());
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine(cake.GetDetails());
Console.ForegroundColor = ConsoleColor.Magenta;
Console.WriteLine(cupcake.GetDetails());
Console.ForegroundColor = ConsoleColor.White;
var offer = new DayOldDessertDecorator(cupcake)
{
DiscountPercentage = 25, Offer = "25% Day Old"
};
offer.ApplyDiscount();
Console.ForegroundColor = ConsoleColor.Magenta;
Console.WriteLine($"{offer.Offer} {offer.GetDetails()}");
}
public static CupcakeModel ToModel(this Cupcake cupcake)
{
//convert entity to model
var model = new CupcakeModel();
model.Id = cupcake.Id;
model.Name = cupcake.Name;
model.Price = cupcake.Price;
model.CreatedOn = (DateTime?)cupcake.CreatedOn;
model.LastModified = (DateTime?)cupcake.LastModified;
model.Ingredients = cupcake.Ingredients;
model.NumberOfIngredients = cupcake.Ingredients.Split(new string[] { Environment.NewLine }, StringSplitOptions.None)
.Select(x => !string.IsNullOrEmpty(x))
.ToList().Count;
model.ImageFileName = cupcake.ImageFileName;
model.Featured = cupcake.Featured;
return(model);
}
private static void AddTestData(GitTrioContext context)
{
context.Database.ExecuteSqlCommand("Delete From Cupcakes");
context.Database.ExecuteSqlCommand("Delete From Users");
var cupcake1 = new Cupcake("Limoncello Meringue", "Vanilla cake with marshmallow frosting, browned to perfection.", 2, "Vanilla", "Marshmallow", "None", 24, "http://www.cupcakeroyale.com/wp-content/uploads/2016/04/Limoncello.jpg");
context.Cupcakes.Add(cupcake1);
var cupcake2 = new Cupcake("Rhubarb Almond Buckle", "Our vanilla cupcake filled with a tangy rhubarb compote, topped with fresh strawberry buttercream and almond streusel. Available May only!", 3, "Almond", "Rhubarb", "Almonds", 36, "http://www.cupcakeroyale.com/wp-content/uploads/2016/03/Rhubarb-Crisp-084.jpg");
context.Cupcakes.Add(cupcake2);
var user1 = new User("user1", "password");
context.Users.Add(user1);
context.SaveChanges();
}
public void Database_DeleteDatabaseObject_SelectedCupcakeIsDeleted()
{
CupcakeController controller = new CupcakeController(db);
var testCupcake = new Cupcake("Limoncello Meringue", "Vanilla cake with marshmallow frosting, browned to perfection.", 2, "Vanilla", "Marshmallow", "None", 24, "http://www.cupcakeroyale.com/wp-content/uploads/2016/04/Limoncello.jpg");
controller.Create(testCupcake);
var testCupcake2 = new Cupcake("Red Velvet", "Vanilla cake with marshmallow frosting, browned to perfection.", 2, "Chocolate", "Marshmallow", "None", 24, "http://www.cupcakeroyale.com/wp-content/uploads/2016/04/Limoncello.jpg");
controller.Create(testCupcake2);
controller.DeleteConfirmed(testCupcake2.Id);
List <Cupcake> expected = new List <Cupcake> {
testCupcake
};
var collection = (controller.Index() as ViewResult).ViewData.Model as IEnumerable <Cupcake>;
Assert.Equal(expected, collection);
}
public static Cupcake ToEntity(this CupcakeModel model)
{
//convert model to entity
var cupcake = new Cupcake();
cupcake.Id = model.Id;
cupcake.Name = model.Name;
cupcake.Price = model.Price;
cupcake.Ingredients = model.Ingredients;
cupcake.LastModified = DateTime.Now;
if (cupcake.Id == 0)
{
cupcake.CreatedOn = DateTime.Now;
}
if (!string.IsNullOrEmpty(model.ImageFileName))
{
cupcake.ImageFileName = model.ImageFileName;
}
cupcake.Featured = model.Featured;
return(cupcake);
}
