public override void OnHelperCreation(TestBase test)
{
base.OnHelperCreation(test);
RandomData = test.Get <RandomData>();
SEMObjects = test.Get <SEMObjects>();
createdFacebookCampaignEntitiesForCleanup = test.Get <List <TblFacebookCampaign> >();
createdSequenceNumberEntitiesForCleanup = test.Get <List <TblSequenceNumber> >();
createdFacebookAdGroupEntitiesForCleanup = test.Get <List <TblFacebookAdGroup> >();
createdFacebookAccountEntitiesForCleanup = test.Get <List <TblFacebookAccount> >();
createdFacebookUserEntitiesFroCleanup = test.Get <List <TblFacebookUser> >();
test.AddTestCleanup("Cleanup SEMObjectDB", () => { onDBCleanup(); });
}
private void onDBCleanup()
{
//clean up facebook user
SqlParameter facebookUserSqlParameter = new SqlParameter("@LocalId", SqlDbType.BigInt);
foreach (var entity in createdFacebookUserEntitiesForCleanup)
{
facebookUserSqlParameter.Value = entity.LocalId;
SEMObjects.GetOpenSqlConnection().ExecuteNonQuery(
"delete from [SEMObjects].[dbo].[tblFacebookUser] where [LocalId] = @LocalId",
facebookUserSqlParameter);
}
//cleanup all other entries
SEMObjects.GetOpenSqlConnection().ExecuteNonQuery("delete from [SEMObjects].[dbo].[tblFacebookUser]");
}
public void InsertFacebookUserIntoDatabsase(TblFacebookUser facebookUserEntity)
{
SEMObjects.TblFacebookUser.InsertOnSubmit(facebookUserEntity);
SEMObjects.SubmitChanges();
}
