public bool Add(IngredientDTO ingredient, DishDTO dish)
{
int ingredientID = new IngredientDAL().FindByName(ingredient.Name).Id;
int dishID = new DishDAL().FindByName(dish.Name).Id;
DBConnection conn = new();
if (conn.Open())
{
string cmd =
"INSERT INTO ingredientdishrelation" +
"(ingredientID, dishID)" +
"VALUES" +
$"('{ingredientID}', '{dishID}'); ";
conn.RunCommand(cmd);
conn.Close();
return(true);
}
return(false);
}
internal void AddDishes(BillDTO bill, List <DishDTO> dishDTOs)
{
int billId = new BillDAL().FindByTableNumber(bill.TableNumber).ID;
DBConnection conn = new();
if (conn.Open())
{
foreach (DishDTO dish in dishDTOs)
{
int id = new DishDAL().FindByName(dish.Name).Id;
string cmd =
"INSERT INTO dishbillrelation" +
"(dishID, billID)" +
"VALUES" +
$"('{id}', '{billId}'); ";
conn.RunCommand(cmd);
}
conn.Close();
}
}
