//--- private void Insert_Or_Update_ReviewPage_Review_Interaction(ReviewPage reviewPage, List <Review> reviews) { try { using (DataDbContext context = new DataDbContext()) { //var reviewPage_ = context.ReviewPages.Find().ReviewPageId } var sourceName = "FaceBook"; var callMethod = "Api"; var accountId = "105294769132327896230"; var locationId = "14880430448251263796"; var externalId = "2366450684051732373"; var reviewPageComp = string.Concat(sourceName, callMethod); reviewPageComp = string.Concat(reviewPageComp, accountId); reviewPageComp = string.Concat(reviewPageComp, locationId); reviewPageComp = string.Concat(reviewPageComp, externalId); // Insert seed data into the database using one instance of the context using (DataDbContext context = new DataDbContext()) { DAC.LPM.SQLServer.ReviewPage _reviewPage = new DAC.LPM.SQLServer.ReviewPage { SourceName = sourceName, CallMethod = callMethod, AccountId = accountId, LocationId = locationId, ExternalId = externalId, AverageRating = 0.0M, //Created = DateTime.Today, Updated = DateTime.Today, LastUpdated = DateTime.Today, Reviews = new List <DAC.LPM.SQLServer.Review> { new DAC.LPM.SQLServer.Review { ParsedId = "ParsedId", AuthorName = "AuthorName", AuthorProfileUrl = "AuthorProfileUrl", AuthorIconUrl = "AuthorIconUrl", AuthorExternalId = "AuthorExternalId", ReviewPageId_FK = reviewPageComp, Content = "Content for review", //ContentLength = 20, Rating = 1, Created = DateTime.Today.ToString(), Updated = DateTime.Today.ToString(), LastUpdated = DateTime.Today, Interactions = new List <Interaction> { new Interaction { InteractionType = "InteractionType", ParentType = "ParentType", AuthorName = "AuthorName", AuthorProfileUrl = "AuthorProfileUrl", AuthorIconUrl = "AuthorIconUrl", AuthorExternalId = "AuthorExternalId", Content = DateTime.Today.ToString(), //ContentLength = 20, Created = DateTime.Today.ToString(), CreatedTime = DateTime.Today, LastUpdated = DateTime.Today } } } } }; context.ReviewPages.Add(_reviewPage); context.SaveChanges(); } using (DataDbContext context = new DataDbContext()) { var service = new SQLServerServices(context); var result = service.Find("FaceBook"); //Assert.AreEqual("ReviewPage SourceName Test", context.ReviewPages.Find().SourceName); //Assert.Equals("ReviewPage SourceName Test", context.ReviewPages.First().SourceName); //Assert.AreEqual("Review AuthorName", context.Reviews.First().AuthorName); //Assert.AreEqual("SQLServerTests ReviewPage SourceName Test", result.First().SourceName); //--- Assert.AreEqual(2, result.Count()); logger.Debug($"Total # of Reviews ({result.Count()}) "); } } catch (Exception ex) { logger.Error( $"Exception Error: {ex.Message} Details: {ex.StackTrace} InnerException: {ex.InnerException}"); throw ex; } finally { // context.Database.CloseConnection(); } }
public void Insert_to_SQL_Tables_Use_BusinessLogic() { try { var sourceName = "FaceBook"; var callMethod = "Api"; var accountId = "105294769132327896230"; var locationId = "14880430448251263796"; var externalId = "2366450684051732373"; var reviewPageComp = string.Concat(sourceName, callMethod); reviewPageComp = string.Concat(reviewPageComp, accountId); reviewPageComp = string.Concat(reviewPageComp, locationId); reviewPageComp = string.Concat(reviewPageComp, externalId); // Insert seed data into the database using one instance of the context using (DataDbContext context = new DataDbContext()) { var reviewPage = new DAC.LPM.SQLServer.ReviewPage { SourceName = sourceName, CallMethod = callMethod, AccountId = accountId, LocationId = locationId, ExternalId = externalId, AverageRating = 0.0M, //Created = DateTime.Today, Updated = DateTime.Today, LastUpdated = DateTime.Today, Reviews = new List <DAC.LPM.SQLServer.Review> { new DAC.LPM.SQLServer.Review { ParsedId = "ParsedId", AuthorName = "AuthorName", AuthorProfileUrl = "AuthorProfileUrl", AuthorIconUrl = "AuthorIconUrl", AuthorExternalId = "AuthorExternalId", ReviewPageId_FK = reviewPageComp, Content = "Content for review", //ContentLength = 20, Rating = 1, Created = DateTime.Today.ToString(), Updated = "Review Created 2", LastUpdated = DateTime.Today, Interactions = new List <Interaction> { new Interaction { InteractionType = "Response", ParentType = "Comment", AuthorName = "AuthorName", AuthorProfileUrl = "AuthorProfileUrl", AuthorIconUrl = "AuthorIconUrl", AuthorExternalId = "AuthorExternalId", Content = "Content for Interaction", //ContentLength = 20, Created = DateTime.Today.ToString(), CreatedTime = DateTime.Today, LastUpdated = DateTime.Today } } } } }; context.ReviewPages.Add(reviewPage); context.SaveChanges(); } using (DataDbContext context = new DataDbContext()) { var service = new SQLServerServices(context); var result = service.Find("FaceBook"); logger.Debug($"Total # of Reviews ({result.Count()}) "); //---Assert.AreEqual("FaceBook", context.ReviewPages.Find().SourceName); //Assert.AreEqual("FaceBook", context.ReviewPages.Find().SourceName); //---Assert.AreEqual("FaceBookApi105294769132327896230148804304482512637962366450684051732373", context.Reviews.Single().ReviewPageComp); Assert.AreEqual("FaceBook", result.First().SourceName); } } finally { // context.Database.CloseConnection(); } }