public List <T> FindByTop(int index) { using (var db = new CinemaBookingDBEntities()) { return(db.Set <T>().Take <T>(index).ToList()); } }
public List <T> GetAll() { using (var db = new CinemaBookingDBEntities()) { return(db.Set <T>().ToList()); } }
public T FindByID <E>(E id) { using (var db = new CinemaBookingDBEntities()) { return(db.Set <T>().Find(id)); } }
public List <T> FindBy(System.Linq.Expressions.Expression <Func <T, bool> > predicate) { using (var db = new CinemaBookingDBEntities()) { return(db.Set <T>().Where(predicate).ToList()); } }
public void Update(T entity) { using (var db = new CinemaBookingDBEntities()) { db.Entry(entity).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } }
public void Create(T entity) { using (var db = new CinemaBookingDBEntities()) { db.Set <T>().Add(entity); db.SaveChanges(); } }
public int createCustomer(Customer cus) { using (var db = new CinemaBookingDBEntities()) { db.Set <Customer>().Add(cus); db.SaveChanges(); return(cus.customerId); } }
public static SqlConnection GetConnection1() { using (var db = new CinemaBookingDBEntities()) { var ec = db.Database.Connection; var adoConnStr = ec.ConnectionString; return(new SqlConnection(adoConnStr)); } }
public int CreateOrder(BookingTicket entity) { using (var db = new CinemaBookingDBEntities()) { db.Set <BookingTicket>().Add(entity); db.SaveChanges(); return(entity.bookingId); } }
public List <MovieSchedule> FindMovieSchedule(int filmId, int timeId, int cinemaId, DateTime scheduleDate) { using (var db = new CinemaBookingDBEntities()) { List <MovieSchedule> list = db.MovieSchedules.Include("Room") .Where(s => s.filmId == filmId && s.timeId == timeId && s.scheduleDate == scheduleDate && s.Room.cinemaId == cinemaId).ToList(); return(list); } }
public void Delete <E>(E id) { using (var db = new CinemaBookingDBEntities()) { var entity = db.Set <T>().Find(id); if (entity != null) { db.Set <T>().Remove(entity); } db.SaveChanges(); } }