public int Delete(MachineDetailsVm model)
{
using (var con = new MySqlConnection(connection))
{
return(con.Execute("DELETE FROM detailmachine WHERE machineId=@MachineId AND detailId=@DetailId", new { model.MachineId, model.DetailId }));
}
}
public void SetQuantity(MachineDetailsVm row)
{
using (var con = new MySqlConnection(connection))
{
con.Execute("UPDATE detailmachine SET Qty=@q WHERE MachineId=@m AND DetailId=@d",
new { q = row.Qty, m = row.MachineId, d = row.DetailId });
}
}
