public void update(UpdateABus bus) { SqlConnection conn; SqlCommand cmd; 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("Update BusInfo set Model=@Model, Make=@Make ,NoOfSeats=@NoOfSeats where BusId=@BusId", conn); cmd.Parameters.AddWithValue("@BusId", bus.BusId); cmd.Parameters.AddWithValue("@Make", bus.Make); cmd.Parameters.AddWithValue("@Model", bus.Model); cmd.Parameters.AddWithValue("@NoOfSeats", bus.NoOfSeats); int result = cmd.ExecuteNonQuery(); conn.Close(); }
public string UpdateABus(UpdateABus bus) { ABCTourDB_BasharJebryEntities context = new ABCTourDB_BasharJebryEntities(); string msg = string.Empty; BusInfo newInfo = new BusInfo(); try { var updatedInfo = context.BusInfoes.Find(bus.BusId); updatedInfo.Make = bus.Make; updatedInfo.Model = bus.Model; updatedInfo.NoOfSeats = bus.NoOfSeats; context.SaveChanges(); msg = "Record Updated!!"; 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("Update BusInfo set Model=@Model, Make=@Make ,NoOfSeats=@NoOfSeats where BusId=@BusId", conn); cmd.Parameters.AddWithValue("@BusId", bus.BusId); cmd.Parameters.AddWithValue("@Make", bus.Make); cmd.Parameters.AddWithValue("@Model", bus.Model); cmd.Parameters.AddWithValue("@NoOfSeats", bus.NoOfSeats); int result = cmd.ExecuteNonQuery(); conn.Close(); } catch (System.Data.Entity.Validation.DbEntityValidationException ex) { msg = ex.Message; msg = "Data updating failed!!"; return(msg); } return(msg); }