public static void TestClassSetup(TestContext context)
{
// Setup
var serviceCollection = new ServiceCollection();
serviceCollection.AddEntityFrameworkNpgsql()
.AddDbContext <RestaurantReviewsContext>()
.BuildServiceProvider();
var builder = new DbContextOptionsBuilder <RestaurantReviewsContext>();
// ToDo: factor this to somewhere less visible
builder.UseNpgsql("Server=127.0.0.1;Port=5432;Database=RestaurantReviews;User Id=postgres;Password=password;");
var dbContextOptions = builder.Options;
RestaurantReviewsContext = new RestaurantReviewsContext();
RestaurantReviewsContext.Database.Migrate();
// Test Assertions
Assert.IsTrue(RestaurantReviewsContext.Users.Count() >= DataSeeder.Users.Count()
, string.Format("Database has {0} Users and Seeder has {1}", RestaurantReviewsContext.Users.Count(), DataSeeder.Users.Count()));
Assert.IsTrue(RestaurantReviewsContext.Restaurants.Count() >= DataSeeder.Restaurants.Count()
, string.Format("Database has {0} Restaurants and Seeder has {1}", RestaurantReviewsContext.Restaurants.Count(), DataSeeder.Restaurants.Count()));
Assert.IsTrue(RestaurantReviewsContext.Reviews.Count() >= DataSeeder.Reviews.Count()
, string.Format("Database has {0} Reviews and Seeder has {1}", RestaurantReviewsContext.Reviews.Count(), DataSeeder.Reviews.Count()));
}
public bool CheckRestaurantExists(RestaurantModelDTO restaurant)
{
using (var db = new RestaurantReviewsContext())
{
var restaurantTable = db.TblRestaurant.Find(restaurant.Name, restaurant.City);
if (restaurant != null)
{
return(true);
}
}
return(false);
}
public void SetupTestData()
{
connection = new SqliteConnection("DataSource=:memory:");
connection.Open();
var options = new DbContextOptionsBuilder <RestaurantReviewsContext>()
.UseSqlite(connection)
.Options;
RestaurantReviewsContext context = new RestaurantReviewsContext(options);
repository = new SystemRepository(context);
validationRepository = new SystemRepository(context);
}
public bool CheckReviewerExists(ReviewerModelDTO reviewer)
{
using (var db = new RestaurantReviewsContext())
{
var reviewerRet = db.TblReviewer.Where(b => b.Name.CompareTo(reviewer.Name) == 0).FirstOrDefault();
if (reviewerRet != null)
{
return(true);
}
}
return(false);
}
public ReviewerModelDTO AddReviewer(ReviewerModelDTO newReviewer)
{
ReviewerModelDTO ret = null;
using (var db = new RestaurantReviewsContext())
{
TblReviewer reviewer = ModelFactory.Create(newReviewer);
db.TblReviewer.Add(reviewer);
db.SaveChanges();
ret = ModelFactory.Create(reviewer);
}
return(ret);
}
public ReviewerModelDTO GetReviewerById(int id)
{
ReviewerModelDTO ret = null;
using (var db = new RestaurantReviewsContext())
{
var reviewer = db.TblReviewer.Find(id);
if (reviewer != null)
{
ret = ModelFactory.Create(reviewer);
}
}
return(ret);
}
public ReviewModelDTO DeleteReview(int id)
{
ReviewModelDTO ret = null;
using (var db = new RestaurantReviewsContext())
{
TblReview review = db.TblReview.Find(id);
if (review != null)
{
db.TblReview.Remove(review);
db.SaveChanges();
ret = ModelFactory.Create(review);
}
}
return(ret);
}
public RestaurantModelList GetRestaurants(string city)
{
RestaurantModelList ret = new RestaurantModelList();
ret.RestaurantList = new List <RestaurantModelDTO>();
using (var db = new RestaurantReviewsContext())
{
var restaurants = from r in db.TblRestaurant
where r.City == city
select r;
foreach (TblRestaurant restaurant in restaurants)
{
ret.RestaurantList.Add(ModelFactory.Create(restaurant));
}
}
return(ret);
}
public ReviewModelList GetReviewsByReviewer(int reviewer_id)
{
ReviewModelList ret = new ReviewModelList();
ret.ReviewList = new List <ReviewModelDTO>();
using (var db = new RestaurantReviewsContext())
{
var reviews = from r in db.TblReview
where r.ReviewerId == reviewer_id
select r;
foreach (TblReview review in reviews)
{
ret.ReviewList.Add(ModelFactory.Create(review));
}
}
return(ret);
}
public Service()
{
db = new RestaurantReviewsContext();
restrepo = new RestaurantRepository(db);
revrepo = new ReviewRepository(db);
}
public ReviewRepo(RestaurantReviewsContext context)
{
_context = context;
}
public RepositoryWrapper(RestaurantReviewsContext repositoryContext)
{
_repoContext = repositoryContext;
}
public RestaurantRepository(RestaurantReviewsContext context)
{
this._context = context;
logger = NLog.LogManager.GetCurrentClassLogger();
}
public UserRepository(RestaurantReviewsContext dbContext)
: base(dbContext)
{
}
public UnitOfWork(RestaurantReviewsContext context)
{
_context = context;
}
public static void TestClassCleanup()
{
RestaurantReviewsContext = null;
}
public ReviewRepository(RestaurantReviewsContext context)
{
this._context = context;
}
public RepositoryBase(RestaurantReviewsContext repositoryContext)
{
this.RepositoryContext = repositoryContext;
}
