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 string AuthenticateUser(UserInfo user) { ABCTourDB_BasharJebryEntities context = new ABCTourDB_BasharJebryEntities(); string msg = string.Empty; var checkedUser = context.Users.Find(user.UserName); try { if (checkedUser != null) { if (checkedUser.Password == user.Password) { msg = "Login Success"; } else { msg = "Login Failed"; } } else { msg = "Login Failed"; } } catch (System.Data.Entity.Validation.DbEntityValidationException ex) { MessageBox.Show(ex.Message); } return(msg); }
public RetrieveBusInfo RetrieveBusInfo() { ABCTourDB_BasharJebryEntities context = new ABCTourDB_BasharJebryEntities(); RetrieveBusInfo RetrieveInfo = new RetrieveBusInfo(); List <BusInfo> RetrieveInfoList = new List <BusInfo>(); RetrieveInfoList = context.BusInfoes.ToList(); RetrieveInfo.dataset = RetrieveInfoList; return(RetrieveInfo); }
public FoundRecord FindABus(FindABus bus) { ABCTourDB_BasharJebryEntities context = new ABCTourDB_BasharJebryEntities(); FoundRecord ChosenInfo = new FoundRecord(); try { var updatedInfo = context.BusInfoes.Find(bus.BusId); ChosenInfo.BusId = updatedInfo.BusId; ChosenInfo.Make = updatedInfo.Make; ChosenInfo.Model = updatedInfo.Model; ChosenInfo.NoOfSeats = updatedInfo.NoOfSeats; } catch (System.Data.Entity.Validation.DbEntityValidationException ex) { MessageBox.Show(ex.Message); } return(ChosenInfo); }
public string InsertABus(InsertABus bus) { ABCTourDB_BasharJebryEntities context = new ABCTourDB_BasharJebryEntities(); string msg = string.Empty; BusInfo newInfo = new BusInfo() { BusId = bus.BusId, Make = bus.Make, Model = bus.Model, NoOfSeats = bus.NoOfSeats }; try { context.BusInfoes.Add(newInfo); context.SaveChanges(); 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("Insert into BusInfo values(@BusId, @Make, @Model,@NoOfSeat)", conn); cmd.Parameters.AddWithValue("@BusId", bus.BusId); cmd.Parameters.AddWithValue("@Make", bus.Make); cmd.Parameters.AddWithValue("@Model", bus.Model); cmd.Parameters.AddWithValue("@NoOfSeat", bus.NoOfSeats); int result = cmd.ExecuteNonQuery(); conn.Close(); msg = "Record inserted"; } catch (System.Data.Entity.Validation.DbEntityValidationException ex) { msg = ex.Message; msg = "Record NOT inserted"; } return(msg); }
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); }