public Enquiry Get(int id)
{
// Get Enquiry table's columns from the database.
using (CineplexDatabaseContext db = new CineplexDatabaseContext())
{
return(db.Enquiries.Where(
i => i.EnquiryID == id).SingleOrDefault());
}
}
public List <Enquiry> Get()
{
// Assign EnquiryID according to the number.
using (CineplexDatabaseContext db = new CineplexDatabaseContext())
{
return(db.Enquiries.OrderBy(
i => i.EnquiryID).ToList());
}
}
public string Put(int id, [FromBody] Enquiry obj)
{
// Update changes into database.
using (CineplexDatabaseContext db = new CineplexDatabaseContext())
{
db.Entry(obj).State = EntityState.Modified;
db.SaveChanges();
return("Enquiry updated successfully!");
}
}
public string Delete(int id)
{
// Delete selected row in the database.
using (CineplexDatabaseContext db = new CineplexDatabaseContext())
{
var obj = db.Enquiries.Where(
i => i.EnquiryID == id).SingleOrDefault();
db.Enquiries.Remove(obj);
db.SaveChanges();
return("Enquiry deleted successfully!");
}
}
public SessionsController(CineplexDatabaseContext context)
{
_context = context;
}
public CineplexesController(CineplexDatabaseContext context)
{
_context = context;
}
public BookingsController(CineplexDatabaseContext context)
{
_context = context;
}
public EnquiriesController(CineplexDatabaseContext context)
{
_context = context;
}
public MovieComingSoonController(CineplexDatabaseContext context)
{
_context = context;
}
