public string DeleteABus(DeleteABus bus) { ABCTourDB_BasharJebryEntities context = new ABCTourDB_BasharJebryEntities(); string msg = string.Empty; try { var DeletedInfo = context.BusInfoes.Find(bus.BusId); context.BusInfoes.Remove(DeletedInfo); context.SaveChanges(); msg = "Data deletion sucess!"; SqlConnection conn; SqlCommand cmd; conn = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Resume\copy\copy\copy\copy\FinalExamProjectAndScreenShots-BasharJebry\FinalExam\FinalExam-BasharJebry\ABCTourDB_BasharJebry.mdf;Integrated Security=True"); conn.Open(); cmd = new SqlCommand("Delete from BusInfo where BusId=@Id", conn); cmd.Parameters.AddWithValue("@Id", bus.BusId); int result = cmd.ExecuteNonQuery(); conn.Close(); } catch (System.Data.Entity.Validation.DbEntityValidationException ex) { msg = ex.Message; msg = "Data deletion failed!"; } return(msg); }
public void delete(DeleteABus bus) { conn = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=E:\project of c# summer 2020\FinalExam\FinalExam-BasharJebry\ABCTourDB_BasharJebry.mdf;Integrated Security=True;MultipleActiveResultSets=True;Application Name=EntityFramework"); conn.Open(); cmd = new SqlCommand("Delete from BusInfo where BusId=@Id", conn); cmd.Parameters.AddWithValue("@Id", bus.BusId); int result = cmd.ExecuteNonQuery(); conn.Close(); }