public BaseManager(DbContext dbContext = null)
{
if (dbContext == null)
{
// Use internal context
_usingInternalContext = true;
_dbContext = new CSPDatabaseModelEntities();
}
else
{
// Use received context (may contain transactions, etc)
_usingInternalContext = false;
_dbContext = (CSPDatabaseModelEntities)dbContext;
}
}
public List <PartnerSdkModels.Customers.Customer> GetAll()
{
List <PartnerSdkModels.Customers.Customer> customers = new List <PartnerSdkModels.Customers.Customer>();
using (var dbContext = new CSPDatabaseModelEntities())
{
using (var dataCampaignManager = new DataManagers.MarketingCampaignManager(dbContext))
{
List <Customer> customersDb = dataCampaignManager.GetAll <Customer>().ToList();
customers = customersDb != null
? customersDb.Select(x => CustomerMapper.MapFromSource(x)).ToList()
: null;
}
}
return(customers);
}
public List <Campaign> GetAll()
{
List <Campaign> campaigns = new List <Campaign>();
using (var dbContext = new CSPDatabaseModelEntities())
{
using (var dataCampaignManager = new DataManagers.MarketingCampaignManager(dbContext))
{
List <MarketingCampaign> campaignsDb = dataCampaignManager.GetAll <MarketingCampaign>(null, c => c.MarketingCampaignsCustomers).ToList();
campaigns = campaignsDb != null
? campaignsDb.Select(x => MarketingCampaignMapper.MapFromSource(x)).ToList()
: null;
}
}
return(campaigns);
}
public void DeleteCampaign(string campaignId)
{
ExceptionDispatchInfo capturedException = null;
DbContextTransaction dbContextTransaction = null;
Guid id;
MarketingCampaign marketingCampaign = new MarketingCampaign()
{
Id = !string.IsNullOrEmpty(campaignId) && Guid.TryParse(campaignId, out id) ? id : Guid.Empty
};
try
{
using (var dbContext = new CSPDatabaseModelEntities())
{
// Begin transaction
using (dbContextTransaction = dbContext.Database.BeginTransaction())
{
using (var dataCampaignsCustomerManager = new DataManagers.MarketingCampaignsCustomer(dbContext))
{
dataCampaignsCustomerManager.DeleteWhere <MarketingCampaignsCustomer>(c => c.MarketingCampaignId.ToString() == campaignId);
}
using (var dataCampaignManager = new DataManagers.MarketingCampaignManager(dbContext))
{
dataCampaignManager.DeleteWhere <MarketingCampaign>(c => c.Id.ToString() == campaignId);
}
dbContextTransaction.Commit();
}
}
}
catch (Exception ex)
{
capturedException = ExceptionDispatchInfo.Capture(ex);
if (dbContextTransaction != null)
{
// Rollback transaction
dbContextTransaction.Rollback();
}
}
}
public Campaign GetCampaign(string campaignId)
{
Campaign campaign = new Campaign();
using (var dbContext = new CSPDatabaseModelEntities())
{
using (var dataCampaignManager = new DataManagers.MarketingCampaignManager(dbContext))
{
MarketingCampaign campaignsDb = dataCampaignManager.FirstOrDefaultBy <MarketingCampaign>(c => c.Id != null &&
c.Id.ToString() == campaignId, c => c.MarketingCampaignsCustomers);
campaign = campaignsDb != null
? MarketingCampaignMapper.MapFromSource(campaignsDb)
: null;
}
}
return(campaign);
}
public Campaign Create(Campaign campaign)
{
Campaign campaignResult = null;
MarketingCampaign marketingCampaign = MarketingCampaignMapper.MapFromSource(campaign);
using (var dbContext = new CSPDatabaseModelEntities())
{
using (var dataCampaignManager = new DataManagers.MarketingCampaignManager(dbContext))
{
MarketingCampaign campaignDb = dataCampaignManager.AddOrUpdate <MarketingCampaign>(marketingCampaign, c => c.Id.ToString() == campaign.CampaignId);
MarketingCampaign campaignNew = dbContext.MarketingCampaigns.Include(c => c.MarketingCampaignsCustomers)
.Include(c => c.MarketingCampaignsCustomers.Select(x => x.Customer)).FirstOrDefault(c => c.Id == campaignDb.Id);
campaignResult = MarketingCampaignMapper.MapFromSource(campaignNew);
}
}
return(campaignResult);
}
