public static void RemoveRecord(AutoLotDataSet.InventoryDataTable table, InventoryTableAdapter adapter)
{
try
{
AutoLotDataSet.InventoryRow rowToDelete = table.FindByCarId(1);
adapter.Delete(rowToDelete.CarId, rowToDelete.Make, rowToDelete.Color, rowToDelete.PetName);
rowToDelete = table.FindByCarId(2);
adapter.Delete(rowToDelete.CarId, rowToDelete.Make, rowToDelete.Color, rowToDelete.PetName);
}
catch (Exception ex)
{
WriteLine(ex.Message);
}
}
private static void RemoveRecords(AutoLotDataSet.InventoryDataTable table, InventoryTableAdapter adapter)
{
try
{
AutoLotDataSet.InventoryRow rowToDelete = table.FindByCarId(table.Last().CarId);
adapter.Delete(rowToDelete.CarId, rowToDelete.Make, rowToDelete.Color, rowToDelete.Name);
rowToDelete = table.FindByCarId(table.Last().CarId - 1);
adapter.Delete(rowToDelete.CarId, rowToDelete.Make, rowToDelete.Color, rowToDelete.Name);
adapter.Update(table);
}
catch (Exception ex)
{
WriteLine(ex.Message);
}
}
private static void RemoveRow(AutoLotDataSet.InventoryDataTable table, InventoryTableAdapter adapter, int n)
{
var rows = table.Rows;
if ((n = ((AutoLotDataSet.InventoryRow)rows[rows.Count - n]).CarId) > 12)
{
WriteLine($"- remove row with CarId {n}");
AutoLotDataSet.InventoryRow row = table.FindByCarId(n);
adapter.Delete(row.CarId, row.Make, row.Color, row.PetName);
}
}
private static void RemoveRecords(AutoLotDataSet.InventoryDataTable table, InventoryTableAdapter adapter)
{
try
{
Write("Enter ID of car to delete: ");
string carID = ReadLine() ?? "0";
AutoLotDataSet.InventoryRow rowToDelete = table.FindByCarId(int.Parse(carID));
adapter.Delete(rowToDelete.CarId, rowToDelete.Make, rowToDelete.Color, rowToDelete.PetName);
}
catch (Exception ex)
{
WriteLine(ex.Message);
}
}
private static void RemoveRecords(AutoLotDataSet.InventoryDataTable tb, InventoryTableAdapter adapter)
{
try
{
Console.WriteLine("Enter carId what you want delete: ");
int carIdToDelete = int.Parse(Console.ReadLine().ToString());
AutoLotDataSet.InventoryRow rowToDelete = tb.FindByCarId(carIdToDelete);
adapter.Delete(rowToDelete.CarId, rowToDelete.Make, rowToDelete.Color, rowToDelete.PetName);
adapter.Update(tb);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
