// Delete the data from the inventory
// check if id is avilable in the inventery data table
public void deletInventory(int id)
{
DataRow row = _inventory.Rows.Find(id);
if (row == null)
{
Console.WriteLine("-------------WARNING--------------\n" +
"This id is not in the inventory list\n" +
"-------------------------------------");
}
else
{
string cs = GetConnectionString("CarrepairMdf");
SqlConnection conn = new SqlConnection(cs);
conn.Open();
string query = "SELECT id FROM repair WHERE inventoryID = " + id + "";
SqlCommand cummand = new SqlCommand(query, conn);
var read = cummand.ExecuteReader();
if (read.Read())
{
int repairid = (int)read[0];
dataHelperRepair one = new dataHelperRepair();
one.deletRepair(repairid);
conn.Close();
}
row.Delete();
_sadapter.DeleteCommand = _scmdbuilder.GetDeleteCommand();
_sadapter.Update(_inventory);
FillDataSet();
}
}
// For the Update and insert for the repair collaction
// check if input is valid
public void opOnRepair(int cases)
{
string watToRepair;
int inventoryId = 0;
int id = 0;
dataHelperRepair one = new dataHelperRepair();
if (cases == 3 || cases == 4)
{
while (id == 0)
{
try
{
Console.WriteLine("Enter the id of the repairList");
id = Int32.Parse(Console.ReadLine());
}
catch
{
Console.WriteLine("Please Enter Valid input");
}
}
if (cases == 4)
{
one.deletRepair(id);
}
}
if (cases == 2 || cases == 3)
{
while (inventoryId == 0)
{
try
{
Console.WriteLine("Please Enter inventory id\n ");
inventoryId = Int32.Parse(Console.ReadLine());
}
catch
{
Console.WriteLine("Please Enter the Valid input");
}
}
do
{
Console.WriteLine("Please Enter what repair? \n");
watToRepair = Console.ReadLine();
if (isStringValid(watToRepair))
{
if (cases == 2)
{
one.insertRepar(inventoryId, watToRepair);
}
if (cases == 3)
{
one.updateRepair(id, watToRepair);
}
}
}while (!isStringValid(watToRepair));
}
}
