public IEnumerable <ReviewEntry> GetRecentNReviewEntries(int n, int hospitalId)
{
using (MyWebApplicationContext db = new MyWebApplicationContext())
{
return(db.ReviewEntries.OrderByDescending(x => x.DateTime).Where(x => x.hospitalId == hospitalId).Take(n));
}
}
public IEnumerable <ReviewEntry> GetAllValidReviewEntries()
{
using (MyWebApplicationContext db = new MyWebApplicationContext())
{
return(db.ReviewEntries.Where(x => x.isValid == true).ToList());
}
}
public List <HospitalDetails> GetEntriesMatchedByName(string searchText)
{
using (MyWebApplicationContext db = new MyWebApplicationContext())
{
return(db.HospitalDetails.Where(x => x.Name.Contains(searchText)).ToList());
}
}
public IEnumerable <HospitalDetails> GetEntriesMatchedByCity(string searchText)
{
using (MyWebApplicationContext db = new MyWebApplicationContext())
{
return(db.HospitalDetails.Where(x => x.City.Contains(searchText)).ToList());
}
}
public List <HospitalDetails> GetAllHospitalDetailsEntries()
{
using (MyWebApplicationContext db = new MyWebApplicationContext())
{
return(db.HospitalDetails.ToList());
}
}
public HospitalDetails GetHospitalDetail(int id)
{
using (MyWebApplicationContext db = new MyWebApplicationContext())
{
return(db.HospitalDetails.Find(id));
}
}
public IEnumerable <ReviewEntry> GetAllReviewEntries()
{
using (MyWebApplicationContext db = new MyWebApplicationContext())
{
return(db.ReviewEntries.ToList());
}
}
protected bool HospitalDetailsExists(int id)
{
using (MyWebApplicationContext db = new MyWebApplicationContext())
{
return(db.HospitalDetails.Count(e => e.id == id) > 0);
}
}
public IEnumerable <ReviewEntry> GetRatingSpecificReviewEntries(int lowestRating, int hospitalId)
{
using (MyWebApplicationContext db = new MyWebApplicationContext())
{
return(db.ReviewEntries.Where(x => x.userRating > lowestRating && x.hospitalId == hospitalId).ToList());
}
}
public IEnumerable <ReviewEntry> GetAllReviewEntriesByHospitalId(int id)
{
using (MyWebApplicationContext db = new MyWebApplicationContext())
{
return(db.ReviewEntries.Where(x => x.hospitalId == id).ToList());
}
}
public void AddReviewEntry(ReviewEntry reviewEntry)
{
using (MyWebApplicationContext db = new MyWebApplicationContext())
{
db.ReviewEntries.Add(reviewEntry);
db.SaveChanges();
}
}
public void AddHospitalDetail(HospitalDetails hospitalDetails)
{
using (MyWebApplicationContext db = new MyWebApplicationContext())
{
db.HospitalDetails.Add(hospitalDetails);
db.SaveChanges();
}
}
public int GetMostRatedHospitalId()
{
using (MyWebApplicationContext db = new MyWebApplicationContext())
{
//see group by cluase and update this, else do by foreach
return(0);
}
}
public IEnumerable <ReviewEntry> GetReviewEntriesSinceDate(DateTime dateTime)
{
using (MyWebApplicationContext db = new MyWebApplicationContext())
{
//update database to have date time as type DateTime, and then compare
return(db.ReviewEntries.Where(x => x.DateTime.CompareTo(dateTime) >= 0).ToList());
}
}
public void Dispose(bool disposing)
{
using (MyWebApplicationContext db = new MyWebApplicationContext())
{
if (disposing)
{
db.Dispose();
}
}
}
public bool DeleteHospitalDetail(int id)
{
using (MyWebApplicationContext db = new MyWebApplicationContext())
{
HospitalDetails hospitalDetails = db.HospitalDetails.Find(id);
if (hospitalDetails == null)
{
return(false);
}
db.HospitalDetails.Remove(hospitalDetails);
db.SaveChanges();
return(true);
}
}
public bool ModifyHospitalDetail(int id, HospitalDetails hospitalDetails)
{
using (MyWebApplicationContext db = new MyWebApplicationContext())
{
db.Entry(hospitalDetails).State = EntityState.Modified;
try
{
db.SaveChanges();
return(true);
}
catch (DbUpdateConcurrencyException)
{
if (!HospitalDetailsExists(id))
{
return(false);
}
else
{
throw;
}
}
}
}
