public void CanUpdateUserRating()
{
DbContextOptions <SwitchbackAPIDbContext> options = new DbContextOptionsBuilder <SwitchbackAPIDbContext>().UseInMemoryDatabase("CanCreateCourse").Options;
using (SwitchbackAPIDbContext context = new SwitchbackAPIDbContext(options))
{
// Arrange
UserRatings rating11 = new UserRatings();
rating11.ID = 11;
rating11.TrailInfoID = 1;
rating11.Rating = 4;
context.Add(rating11);
context.SaveChanges();
rating11.Rating = 5;
context.Update(rating11);
context.SaveChanges();
// Act
var result = context.UserRatings.FirstOrDefault(m => m.ID == rating11.ID);
// Assert
Assert.Equal(result, rating11);
};
}
public void CanGetOneUserRatingFromThree_End()
{
DbContextOptions <SwitchbackAPIDbContext> options = new DbContextOptionsBuilder <SwitchbackAPIDbContext>().UseInMemoryDatabase("CanCreateCourse").Options;
using (SwitchbackAPIDbContext context = new SwitchbackAPIDbContext(options))
{
// Arrange
UserRatings rating8 = new UserRatings();
rating8.ID = 8;
rating8.TrailInfoID = 3;
rating8.Rating = 4;
UserRatings rating9 = new UserRatings();
rating9.ID = 9;
rating9.TrailInfoID = 3;
rating9.Rating = 3;
UserRatings rating10 = new UserRatings();
rating10.ID = 10;
rating10.TrailInfoID = 3;
rating10.Rating = 2;
context.Add(rating8);
context.Add(rating9);
context.Add(rating10);
context.SaveChanges();
// Act
var result = context.UserRatings.FirstOrDefault(m => m.ID == rating10.ID);
// Assert
Assert.Equal(result, rating10);
};
}
public void CanGetOneUserRatingFromThree_Middle()
{
DbContextOptions <SwitchbackAPIDbContext> options = new DbContextOptionsBuilder <SwitchbackAPIDbContext>().UseInMemoryDatabase("CanCreateCourse").Options;
using (SwitchbackAPIDbContext context = new SwitchbackAPIDbContext(options))
{
// Arrange
UserRatings rating5 = new UserRatings();
rating5.ID = 5;
rating5.TrailInfoID = 1;
rating5.Rating = 4;
UserRatings rating6 = new UserRatings();
rating6.ID = 6;
rating6.TrailInfoID = 1;
rating6.Rating = 3;
UserRatings rating7 = new UserRatings();
rating7.ID = 7;
rating7.TrailInfoID = 1;
rating7.Rating = 2;
context.Add(rating5);
context.Add(rating6);
context.Add(rating7);
context.SaveChanges();
// Act
var result = context.UserRatings.FirstOrDefault(m => m.ID == rating6.ID);
// Assert
Assert.Equal(result, rating6);
};
}
public void CanGetOneUserRatingFromThree_Begining()
{
DbContextOptions <SwitchbackAPIDbContext> options = new DbContextOptionsBuilder <SwitchbackAPIDbContext>().UseInMemoryDatabase("CanCreateCourse").Options;
using (SwitchbackAPIDbContext context = new SwitchbackAPIDbContext(options))
{
// Arrange
UserRatings rating2 = new UserRatings();
rating2.ID = 2;
rating2.TrailInfoID = 2;
rating2.Rating = 4;
UserRatings rating3 = new UserRatings();
rating3.ID = 3;
rating3.TrailInfoID = 2;
rating3.Rating = 3;
UserRatings rating4 = new UserRatings();
rating4.ID = 4;
rating4.TrailInfoID = 2;
rating4.Rating = 2;
context.Add(rating2);
context.Add(rating3);
context.Add(rating4);
context.SaveChanges();
// Act
var result = context.UserRatings.FirstOrDefault(m => m.ID == rating2.ID);
// Assert
Assert.Equal(result, rating2);
};
}
public void CanGetUpdateTrail()
{
DbContextOptions <SwitchbackAPIDbContext> options = new DbContextOptionsBuilder <SwitchbackAPIDbContext>().UseInMemoryDatabase("CanCreateCourse").Options;
using (SwitchbackAPIDbContext context = new SwitchbackAPIDbContext(options))
{
// Arrange
Trail trail1 = new Trail();
trail1.Name = "Clown Lake Trail";
trail1.Type = "Featured Hike";
trail1.Summary = "A great place for a picnic and watching paragliders!";
trail1.Difficulty = "blue";
trail1.Stars = 4.3;
trail1.StarVotes = 50;
trail1.Location = "Issaquah, Washington";
trail1.Url = "https://www.hikingproject.com/trail/7005406/poo-poo-point-via-chirico-trail";
trail1.ImgSqSmall = "https://cdn-files.apstatic.com/hike/7004771_sqsmall_1554310760.jpg";
trail1.ImgSmall = "https://cdn-files.apstatic.com/hike/7004771_small_1554310760.jpg";
trail1.ImgSmallMed = "https://cdn-files.apstatic.com/hike/7004771_smallMed_1554310760.jpg";
trail1.ImgMedium = "https://cdn-files.apstatic.com/hike/7004771_medium_1554310760.jpg";
trail1.Length = 3.9;
trail1.Ascent = 1619;
trail1.Descent = -1618;
trail1.High = 1807;
trail1.Low = 188;
trail1.Longitude = -122.0211;
trail1.Latitude = 47.4999;
trail1.ConditionStatus = "All Clear";
trail1.ConditionDetails = "Dry";
trail1.ConditionDate = "2019-04-19 11:05:03";
context.Add(trail1);
context.SaveChanges();
trail1.ConditionStatus = "Raining Cats and Dogs";
context.Update(trail1);
context.SaveChanges();
// Act
var result = context.Trail.FirstOrDefault(m => m.TrailID == trail1.TrailID);
// Assert
Assert.Equal(result, trail1);
};
}
/// <summary>
/// Connects Service to Database
/// </summary>
/// <param name="context">Database</param>
public TrailServices(SwitchbackAPIDbContext context)
{
_context = context;
}
/// <summary>
/// pass in database and configuration settings
/// </summary>
/// <param name="context">data</param>
/// <param name="configuration">connection strings, api, ect...</param>
public GetTrailsDataController(SwitchbackAPIDbContext context, IConfiguration configuration)
{
_context = context;
Configuration = configuration;
}
/// <summary>
/// Connects Service to Database
/// </summary>
/// <param name="context">Database</param>
public UserRatingsService(SwitchbackAPIDbContext context)
{
_context = context;
}
public void CanGetOneTrailFromThree_One()
{
DbContextOptions <SwitchbackAPIDbContext> options = new DbContextOptionsBuilder <SwitchbackAPIDbContext>().UseInMemoryDatabase("CanCreateCourse").Options;
using (SwitchbackAPIDbContext context = new SwitchbackAPIDbContext(options))
{
// Arrange
Trail trail1 = new Trail();
trail1.Name = "Clown Lake Trail";
trail1.Type = "Featured Hike";
trail1.Summary = "A great place for a picnic and watching paragliders!";
trail1.Difficulty = "blue";
trail1.Stars = 4.3;
trail1.StarVotes = 50;
trail1.Location = "Issaquah, Washington";
trail1.Url = "https://www.hikingproject.com/trail/7005406/poo-poo-point-via-chirico-trail";
trail1.ImgSqSmall = "https://cdn-files.apstatic.com/hike/7004771_sqsmall_1554310760.jpg";
trail1.ImgSmall = "https://cdn-files.apstatic.com/hike/7004771_small_1554310760.jpg";
trail1.ImgSmallMed = "https://cdn-files.apstatic.com/hike/7004771_smallMed_1554310760.jpg";
trail1.ImgMedium = "https://cdn-files.apstatic.com/hike/7004771_medium_1554310760.jpg";
trail1.Length = 3.9;
trail1.Ascent = 1619;
trail1.Descent = -1618;
trail1.High = 1807;
trail1.Low = 188;
trail1.Longitude = -122.0211;
trail1.Latitude = 47.4999;
trail1.ConditionStatus = "All Clear";
trail1.ConditionDetails = "Dry";
trail1.ConditionDate = "2019-04-19 11:05:03";
Trail trail2 = new Trail();
trail2.Name = "Pie in the Face Trail";
trail2.Type = "Featured Hike";
trail2.Summary = "Watchout for Clowns throwing Pies";
trail2.Difficulty = "Azure";
trail2.Stars = 2.3;
trail2.StarVotes = 20;
trail2.Location = "Clown, Washington";
trail2.Url = "https://www.hikingproject.com/trail/7005406/pie-face";
trail2.ImgSqSmall = "https://cdn-files.apstatic.com/hike/7005771_sqsmall_1554310760.jpg";
trail2.ImgSmall = "https://cdn-files.apstatic.com/hike/7005771_small_1554310760.jpg";
trail2.ImgSmallMed = "https://cdn-files.apstatic.com/hike/7005771_smallMed_1554310760.jpg";
trail2.ImgMedium = "https://cdn-files.apstatic.com/hike/7005771_medium_1554310760.jpg";
trail2.Length = 2.9;
trail2.Ascent = 1719;
trail2.Descent = -1218;
trail2.High = 107;
trail2.Low = 18;
trail2.Longitude = -132.0211;
trail2.Latitude = 47.7999;
trail2.ConditionStatus = "Pies Everywhere";
trail2.ConditionDetails = "Slippery";
trail2.ConditionDate = "2019-04-19 10:05:03";
Trail trail3 = new Trail();
trail3.Name = "The Slippery Bannana Trail";
trail3.Type = "Featured Hike";
trail3.Summary = "Watch your step, there is bannana peals every where";
trail3.Difficulty = "Red";
trail3.Stars = 1.3;
trail3.StarVotes = 25;
trail3.Location = "Bananna, Washington";
trail3.Url = "https://www.hikingproject.com/trail/7005306/slippery-bananna";
trail3.ImgSqSmall = "https://cdn-files.apstatic.com/hike/7005571_sqsmall_1554311760.jpg";
trail3.ImgSmall = "https://cdn-files.apstatic.com/hike/7005571_small_1554311760.jpg";
trail3.ImgSmallMed = "https://cdn-files.apstatic.com/hike/7005571_smallMed_1554311760.jpg";
trail3.ImgMedium = "https://cdn-files.apstatic.com/hike/7005571_medium_1554311760.jpg";
trail3.Length = 6.9;
trail3.Ascent = 2219;
trail3.Descent = -3218;
trail3.High = 607;
trail3.Low = 218;
trail3.Longitude = -132.9211;
trail3.Latitude = 46.7999;
trail3.ConditionStatus = "Bananna peals Everywhere";
trail3.ConditionDetails = "Slippery";
trail3.ConditionDate = "2019-04-17 10:05:03";
context.Add(trail1);
context.SaveChanges();
context.Add(trail2);
context.SaveChanges();
context.Add(trail3);
context.SaveChanges();
// Act
var result = context.Trail.FirstOrDefault(m => m.TrailID == trail1.TrailID);
// Assert
Assert.Equal(result, trail1);
};
}
