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