//edit/put
internal FlowerBouquet Edit(FlowerBouquet updatedFlowerBouquet)
{
FlowerBouquet found = Get(updatedFlowerBouquet.Id);
found.FlowerId = updatedFlowerBouquet.FlowerId;
found.BouquetId = updatedFlowerBouquet.BouquetId;
return(_repo.Edit(found));
}
public ActionResult DeleteConfirmed(int id)
{
FlowerBouquet flowerBouquet = db.FlowerBouquets.Find(id);
db.FlowerBouquets.Remove(flowerBouquet);
db.SaveChanges();
return(RedirectToAction("Index"));
}
//Get by id
internal FlowerBouquet Get(int id)
{
FlowerBouquet found = _repo.Get(id);
if (found == null)
{
throw new Exception("Invalid Id");
}
return(found);
}
//create/post
internal FlowerBouquet Create(FlowerBouquet newFlowerBouquet)
{
FlowerBouquet created = _repo.Create(newFlowerBouquet);
if (created == null)
{
throw new Exception("Create Request Failed");
}
return(created);
}
//Post
internal FlowerBouquet Create(FlowerBouquet newFlowerBouquet)
{
string sql = @"
INSERT INTO flowerbouquets (flowerId, bouquetId)
VALUES (@FlowerId, @BouquetId);
SELECT LAST_INSERT_ID();
";
newFlowerBouquet.Id = _db.ExecuteScalar <int>(sql, newFlowerBouquet);
return(newFlowerBouquet);
}
public ActionResult <FlowerBouquet> Create([FromBody] FlowerBouquet newFlowerBouquet)
{
try
{
return(Ok(_fbs.Create(newFlowerBouquet)));
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
}
//Put
internal FlowerBouquet Edit(FlowerBouquet updateFlowerBouquet)
{
string sql = @"
UPDATE flowerbouquets SET
flowerId = @FlowerId,
bouquetId = @BouquetId
WHERE id = @Id
";
_db.Execute(sql, updateFlowerBouquet);
return(updateFlowerBouquet);
}
public ActionResult Edit([Bind(Include = "FlowerBouquetID,BouquetID,FlowerID,Quantity")] FlowerBouquet flowerBouquet)
{
if (ModelState.IsValid)
{
db.Entry(flowerBouquet).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.BouquetID = new SelectList(db.Bouquets, "BouquetID", "BouquetName", flowerBouquet.BouquetID);
ViewBag.FlowerID = new SelectList(db.Flowers, "FlowerID", "FlowerName", flowerBouquet.FlowerID);
return(View(flowerBouquet));
}
public ActionResult <FlowerBouquet> Edit(int id, [FromBody] FlowerBouquet updatedFlowerBouquet)
{
try
{
updatedFlowerBouquet.Id = id;
return(Ok(_fbs.Edit(updatedFlowerBouquet)));
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
}
public ActionResult <String> AddFlowerToBouquet(int id, [FromBody] FlowerBouquet flowerBouquet)
{
try
{
flowerBouquet.BouquetId = id;
return(Ok(_repo.AddFlowerToBouquet(flowerBouquet)));
}
catch (Exception e)
{
return(BadRequest(e));
}
}
public string AddFlowerToBouquet(FlowerBouquet fb)
{
string query = @"INSERT INTO flowerbouquets (bouquetId, flowerId)
VALUES (@BouquetId, @FlowerId);";
int changedRows = _db.Execute(query, fb);
if (changedRows < 1)
{
throw new Exception("Invalid Ids");
}
return("Successfully added Flower to Bouquet");
}
// GET: FlowerBouquets/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
FlowerBouquet flowerBouquet = db.FlowerBouquets.Find(id);
if (flowerBouquet == null)
{
return(HttpNotFound());
}
return(View(flowerBouquet));
}
public async Task <FlowerBouquet> Insert(string BouquetName, double Price, int AmountSold, string Description)
{
var bouquet = new FlowerBouquet
{
bouquetName = BouquetName,
price = Price,
amountSold = AmountSold,
description = Description
};
await _context.FlowerBouquet.AddAsync(bouquet);
await _context.SaveChangesAsync();
return(bouquet);
}
// GET: FlowerBouquets/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
FlowerBouquet flowerBouquet = db.FlowerBouquets.Find(id);
if (flowerBouquet == null)
{
return(HttpNotFound());
}
ViewBag.BouquetID = new SelectList(db.Bouquets, "BouquetID", "BouquetName", flowerBouquet.BouquetID);
ViewBag.FlowerID = new SelectList(db.Flowers, "FlowerID", "FlowerName", flowerBouquet.FlowerID);
return(View(flowerBouquet));
}
public async Task TestGetOnFlowerBouquetHappyPath()
{
var bouquet = new FlowerBouquet()
{
id = 1,
bouquetName = "test name 1",
price = 123,
amountSold = 1,
description = "test description 1"
};
_flowerBouquetRepoMock.Setup(x => x.GetOneBouquetById(1)).Returns(Task.FromResult(bouquet)).Verifiable();
var bouquetsResponse = await _flowerBouquetController.FlowerBouquetById(1);
bouquetsResponse.Should().BeOfType <OkObjectResult>();
Snapshot.Match(bouquetsResponse);
}
public async Task TestUpdateOneFlowerBouquetHappyPath()
{
var bouquet = new FlowerBouquet()
{
id = 1,
bouquetName = "test name 1",
price = 123,
amountSold = 1,
description = "test description 1"
};
_flowerBouquetRepoMock.Setup(x => x.Update(1, "test name", 456, 2, "test description 2")).Returns(Task.FromResult(bouquet)).Verifiable();
var bouquetResponse = await _flowerBouquetController.UpdateFlowerBouquet(1, new FlowerBouquetUpsertInput()
{
bouquetName = "test name",
price = 456,
amountSold = 2,
description = "test description 2"
});
bouquetResponse.Should().BeOfType <AcceptedResult>();
Snapshot.Match(bouquetResponse);
}
public static FlowerBouquetWebOutput Convert(this FlowerBouquet input)
{
return(new FlowerBouquetWebOutput(input.id, input.bouquetName, input.price, input.amountSold, input.description));
}
