//---
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();
}
}