// 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)); } }