public IActionResult Add(CustomerFavoriteViewModel model)
{
var customerFavoriteId = dbConnection.ExecuteScalar <int>(@"
INSERT INTO `customer_favorite` (customer_id, item_id)
VALUES (@CustomerId, @ItemId);
SELECT LAST_INSERT_ID();
", new {
CustomerId = model.CustomerId,
ItemId = model.ItemId
});
return(RedirectToAction("Index"));
}
public IActionResult Add(int id)
{
var items = dbConnection.Query <ItemViewModel>(@"
SELECT Item_Id AS ItemId,
Name
FROM `Item`").ToList();
var customers = dbConnection.Query <CustomerViewModel>(@"
SELECT Customer_Id AS CustomerId,
CONCAT(First_Name, ' ', Last_Name) AS FullName
FROM `Customer`").ToList();
var model = new CustomerFavoriteViewModel()
{
AllCustomers = customers,
AllItems = items
};
return(View(model));
}
