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