public async Task <ActionResult> Update(string?id, string?date, [FromQuery] string[] itemnames, [FromQuery] string[] removeid)
{
foreach (var name in itemnames)
{
if (id != null)
{
var labID = Int16.Parse(id ?? "0");
var type = Int16.Parse(name.Split(' ').Last());
int itemIDs = ItemDB.Add(new Item(name.Split(' ')[0], (ItemTypes)type));
LabItemDB.AddItem(labID, itemIDs);
}
}
if (id != null)
{
foreach (var removeID in removeid)
{
var labID = Int16.Parse(id ?? "0");
var itemID = Int16.Parse(removeID ?? "0");
var itemDB = await ItemDB.GetByIDAsync(itemID);
var labItemDB = await LabItemDB.GetAllByLabIDAsync(labID);
var db = new SoftwareStudioContext();
string queryString = $"DELETE FROM laboratory_items WHERE item_id = {itemID}; DELETE FROM items WHERE uuid = {itemID}; ";
// var items = await db.itemDetails.FromSqlRaw(queryString).ToListAsync();
await db.Database.ExecuteSqlRawAsync(queryString);
}
}
return(RedirectToAction("Detail", new { id = id, date = date }));
}
public async Task <ActionResult <List <Laboratory_item> > > Gets(int labID)
{
return(await LabItemDB.GetAllByLabIDAsync(labID));
}
