public CampaignSetupModel GetCategories(CampaignSetupModel model)
{
var scw = new ServiceClientWrapper();
// create AdCopy array
// get categories or classifications
var categories = scw.GetCategories(null, model.ProductGroup.ProductPromotionName,
model.ProductGroup.Words,
model.AdModelProp.Ads.Select(
pad => pad.AdTitle + " " + pad.AdTextLine1 + " " + pad.AdTextLine2).
ToArray(), model.AdModelProp.LandingUrl);
// create categories list that will be displayed in a multiselect list box
if (categories != null && categories.Count > 0)
{
for (var i = 0; i < categories.Count; i++)
{
var cm = new CampaignSetupModel.CategoriesModel {Id = i, Name = categories[i]};
model.AllCategories.Add(cm);
}
}
else
{
var logEnty = new LogEntry
{ActivityId = Guid.NewGuid(), Message = "Could not get Categories from web service"};
Logger.Write(logEnty);
}
return model;
// save this some how while getting the keywords this is becoming null
}
public ActionResult CampaignSetup(CampaignSetupModel model)
{
if (ModelState.IsValid)
{
SemplestDataService service = new SemplestDataService();
service.SaveAd(model);
}
return View(model);
}
public ActionResult CampaignSetup()
{
LogEntry logEnty = new LogEntry();
logEnty.ActivityId = Guid.NewGuid();
logEnty.Message = "Loading";
Logger.Write(logEnty);
LogService logService = new LogService();
logService.AddToLog(1, "Campaign Setup Accessed", "CampaignSetup//CampaignSetup//CampaignSetup", 1);
var campaignSetupModel = new CampaignSetupModel();
return View(campaignSetupModel);
}
public CampaignSetupModel GetKeyWords(CampaignSetupModel model, int promoId)
{
if (model.AllCategories.Count == 0)
{
//model.AllCategories = (List<CampaignSetupModel.CategoriesModel>)Session["AllCategories"];
}
var catList = new List<string>();
foreach (var cat in model.AllCategories)
{
catList.AddRange(from t in model.CategoryIds where cat.Id == t select cat.Name);
}
var scw = new ServiceClientWrapper();
// create AdCopy array
// get keywords from the web service
//List<string> keywords = scw.GetKeywords(catList, null, "coffee machine", null, null, "http://www.wholelattelove.com", null);
var keywords = scw.GetKeywords(catList, null, SerializeAdEnginesSelectedToStringArray(model).ToArray(),
model.ProductGroup.ProductPromotionName,
model.ProductGroup.Words,
model.AdModelProp.Ads.Select(
pad => pad.AdTitle + " " + pad.AdTextLine1 + " " + pad.AdTextLine2).
ToArray(), model.AdModelProp.LandingUrl,
SerializeToGeoTargetObjectArray(model).ToArray());
if (keywords != null && keywords.Length > 0)
{
model.AllKeywordProbabilityObjects.AddRange(keywords);
SaveKeywords(promoId, model.AllKeywordProbabilityObjects, model.AdModelProp.NegativeKeywords,
model.ProductGroup.ProductGroupName, model.ProductGroup.ProductPromotionName);
foreach (
var kwm in
model.AllKeywordProbabilityObjects.Where(key => key.isDeleted == false).Select(
key => new CampaignSetupModel.KeywordsModel {Name = key.keyword, Id = key.id}))
{
model.AllKeywords.Add(kwm);
}
}
else
{
var logEnty = new LogEntry
{ActivityId = Guid.NewGuid(), Message = "Could not get Keywords from web service"};
Logger.Write(logEnty);
}
return model;
}
public CampaignSetupModel GetKeyWords(CampaignSetupModel model)
{
if (model.AllCategories.Count == 0)
{
//model.AllCategories = (List<CampaignSetupModel.CategoriesModel>)Session["AllCategories"];
}
var catList = new List<string>();
foreach (var cat in model.AllCategories)
{
catList.AddRange(from t in model.CategoryIds where cat.Id == t select cat.Name);
}
var scw = new ServiceClientWrapper();
// create AdCopy array
List<string> adtitletextList = new List<string>();
foreach (SemplestModel.PromotionAd pad in model.AdModelProp.Ads)
{
adtitletextList.Add(pad.AdTitle + " " + pad.AdText);
}
// get keywords from the web service
//List<string> keywords = scw.GetKeywords(catList, null, "coffee machine", null, null, "http://www.wholelattelove.com", null);
var keywords = scw.GetKeywords(catList, null, model.ProductGroup.ProductPromotionName,
model.ProductGroup.Words, adtitletextList.ToArray(), model.AdModelProp.Url, null);
if (keywords != null && keywords.Count > 0)
{
foreach (var kwm in keywords.Select(key => new CampaignSetupModel.KeywordsModel { Name = key }))
{
model.AllKeywords.Add(kwm);
}
}
else
{
var logEnty = new LogEntry { ActivityId = Guid.NewGuid(), Message = "Could not get Keywords from web service" };
Logger.Write(logEnty);
}
return model;
}
public Promotion GetPromoitionFromCampaign(int customerFK, CampaignSetupModel model)
{
Promotion promo;
using (var dbContext =new SemplestModel.Semplest())
{
promo = GetPromoitionFromCampaign(dbContext, customerFK, model);
}
return promo;
}
public string SaveGeoTargetingAds(int customerFK, CampaignSetupModel model, CampaignSetupModel oldModel)
{
var rString = new System.Text.StringBuilder();
using (var dbcontext = new SemplestModel.Semplest())
{
var queryProd = (from c in dbcontext.ProductGroups
where
c.CustomerFK == customerFK &&
c.ProductGroupName == model.ProductGroup.ProductGroupName
select c).Single();
var promo = GetPromotionFromProductGroup(queryProd, model.ProductGroup.ProductPromotionName);
List<PromotionAd> addAds;
List<int> updateAds;
List<int> deleteAds;
GoogleViolation[] gv;
PromoAdTableType at;
var shouldscheduleAds = AddPromotionAdsToPromotion(promo, model, customerFK, oldModel,
out addAds, out updateAds, out deleteAds, out at);
if (shouldscheduleAds)
{
List<GoogleAddAdRequest> verifyAds =
model.AdModelProp.Ads.Where(t => !t.Delete).Select(pad => new GoogleAddAdRequest
{
promotionAdID = promo.PromotionPK,
headline = pad.AdTitle,
description1 =
pad.AdTextLine1,
description2 =
pad.AdTextLine2
}).ToList();
gv = ValidateAds(model.AdModelProp.LandingUrl,
model.AdModelProp.DisplayUrl, verifyAds);
if (gv.Length > 0)
throw new Exception(gv.First().shortFieldPath + ": " + gv.First().errorMessage);
}
GeoTargetTableType gt;
int addressCode =-1;
var st = dbcontext.AddressTypes.SingleOrDefault(pt => pt.AddressType1 == model.AdModelProp.PromotionAddressType);
if (st != null)
addressCode = st.AddressTypePK;
var shouldUpdateGeoTargeting = AddGeoTargetingToPromotion(promo, model, customerFK, oldModel, out gt);
if (shouldUpdateGeoTargeting)
{
var gtos = SerializeToGeoTargetObjectArray(model);
if (gtos.Any())
{
gv = ValidateGeotargeting(gtos);
if (gv.Length > 0)
throw new Exception(gv.First().shortFieldPath + ": " + gv.First().errorMessage);
}
}
var parameter = new SqlParameter("PromotionPK", promo.PromotionPK) { SqlDbType = SqlDbType.Int };
var parameter2 = new SqlParameter("LandingUrl", model.AdModelProp.LandingUrl.Trim()) { SqlDbType = SqlDbType.NVarChar };
var parameter3 = new SqlParameter("DisplayUrl", model.AdModelProp.DisplayUrl.Trim()) { SqlDbType = SqlDbType.NVarChar };
var parameter4 = new SqlParameter("AddressTypeFK", addressCode) { SqlDbType = SqlDbType.Int };
var parameter5 = new SqlParameter("GeoTVP", gt) { SqlDbType = SqlDbType.Structured, TypeName = "GeoTargetTableType" };
var parameter6 = new SqlParameter("AdTVP", at) { SqlDbType = SqlDbType.Structured, TypeName = "PromoAdTableType" };
var parameters = new object[] {parameter, parameter2, parameter3, parameter4, parameter5, parameter6};
var results = ((IObjectContextAdapter)dbcontext).ObjectContext.ExecuteStoreQuery<RVal>("exec UpdateGeoTargetingPromoAds @PromotionPK, @LandingUrl, @DisplayUrl, @AddressTypeFK, @GeoTVP, @AdTVP", parameters);
_savedCampaign = true;
foreach (var r in results)
{
rString.Append(r.UID);
rString.Append("=");
rString.Append(r.PKEY);
rString.Append(",");
}
if (promo.IsLaunched)
{
var sw = new ServiceClientWrapper();
var adEngines = new List<string>();
adEngines.AddRange(
promo.PromotionAdEngineSelecteds.Select(
pades => pades.AdvertisingEngine.AdvertisingEngine1));
if (shouldscheduleAds)
{
if (addAds.Any())
{
var addAdsIds =
addAds.Select(
promoAd =>
dbcontext.PromotionAds.Single(
row =>
row.AdTextLine1 == promoAd.AdTextLine1 && row.AdTextLine2 == promoAd.AdTextLine2 &&
row.AdTitle == promoAd.AdTitle && row.PromotionFK == promo.PromotionPK).
PromotionAdsPK).ToList();
sw.scheduleAds(promo.PromotionPK, addAdsIds, adEngines,
SEMplestConstants.PromotionAdAction.Add);
}
if (updateAds.Any())
sw.scheduleAds(promo.PromotionPK, updateAds, adEngines,
SEMplestConstants.PromotionAdAction.Update);
if (deleteAds.Any())
sw.scheduleAds(promo.PromotionPK, deleteAds, adEngines,
SEMplestConstants.PromotionAdAction.Delete);
}
if (shouldUpdateGeoTargeting)
sw.scheduleUpdateGeoTargeting(promo.PromotionPK, adEngines);
}
}
return string.IsNullOrEmpty(rString.ToString()) ? String.Empty : rString.ToString().Substring(0, rString.ToString().Length - 1);
}
public void SaveNegativeKeywords(Promotion promo, CampaignSetupModel model, SemplestModel.Semplest dbcontext)
{
IEnumerable<PromotionKeywordAssociation> qry = dbcontext.PromotionKeywordAssociations.Where(key => key.PromotionFK == promo.PromotionPK).ToList();
var kpos = new List<KeywordProbabilityObject>();
KeywordProbabilityObject kpo;
foreach (PromotionKeywordAssociation pka in qry)
{
kpo = new KeywordProbabilityObject
{
keyword = pka.Keyword.Keyword1,
semplestProbability = pka.SemplestProbability == null ? 0 : pka.SemplestProbability.Value,
isTargetMSN = pka.IsTargetMSN,
isTargetGoogle = pka.IsTargetGoogle
};
kpos.Add(kpo);
}
if (model.AdModelProp.NegativeKeywords != null)
foreach (string negativeKeyword in model.AdModelProp.NegativeKeywords)
{
if (!qry.Any(key => key.Keyword.Keyword1 == negativeKeyword))
{
kpo = new KeywordProbabilityObject { keyword = negativeKeyword };
kpos.Add(kpo);
}
}
SaveKeywords(promo.PromotionPK, kpos, model.AdModelProp.NegativeKeywords, model.ProductGroup.ProductGroupName, model.ProductGroup.ProductPromotionName);
}
public void SaveProductPromotion(int customerFk, CampaignSetupModel model, CampaignSetupModel oldModel)
{
using (var dbcontext = new SemplestModel.Semplest())
{
var queryProdGrp = from c in dbcontext.ProductGroups
where
c.CustomerFK == customerFk &&
c.ProductGroupName == model.ProductGroup.ProductGroupName
select c;
if (!queryProdGrp.Any())
{
//create new productgroup and promotion
var prodgroup = new ProductGroup
{
ProductGroupName = model.ProductGroup.ProductGroupName,
IsActive = true,
CustomerFK = customerFk,
StartDate =
Convert.ToDateTime(model.ProductGroup.StartDate,
new CultureInfo("en-Us")),
EndDate =
String.IsNullOrEmpty(model.ProductGroup.EndDate)
? (DateTime?)null
: Convert.ToDateTime(model.ProductGroup.EndDate)
};
var promo = CreatePromotionFromModel(model,
dbcontext.Configurations.First().
CustomerDefaultPerCampaignFlatFeeAmount);
dbcontext.ProductGroups.Add(prodgroup);
dbcontext.Promotions.Add(promo);
SavePromotionAdEngineSelected(promo,model, dbcontext);
dbcontext.SaveChanges();
_savedCampaign = true;
}
else
{//productgroupexists
var updateProdGrp = queryProdGrp.Single();
var updatePromotion = GetPromotionFromProductGroup(updateProdGrp,
model.ProductGroup.ProductPromotionName);
// if this is null means promotion name changed so create a new promotion
if (updatePromotion == null)
{
// create new promotion
updatePromotion = CreatePromotionFromModel(model,
dbcontext.Configurations.First().
CustomerDefaultPerCampaignFlatFeeAmount);
updatePromotion.ProductGroupFK = updateProdGrp.ProductGroupPK;
dbcontext.Promotions.Add(updatePromotion);
SavePromotionAdEngineSelected(updatePromotion, model, dbcontext);
}
else
{
// update promotion
UpdatePromotionFromModel(updatePromotion, model, dbcontext.Configurations.First().CustomerDefaultPerCampaignFlatFeeAmount);
if (updatePromotion.IsLaunched)
{
var sw = new ServiceClientWrapper();
var adEngines = new List<string>();
adEngines.AddRange(
updatePromotion.PromotionAdEngineSelecteds.Select(
pades => pades.AdvertisingEngine.AdvertisingEngine1));
if (model.ProductGroup.Budget != oldModel.ProductGroup.Budget)
sw.scheduleUpdateBudget(updatePromotion.PromotionPK, model.ProductGroup.Budget,
adEngines);
if (Convert.ToDateTime(model.ProductGroup.StartDate) != Convert.ToDateTime(oldModel.ProductGroup.StartDate))
sw.scheduleChangePromotionStartDate(updatePromotion.PromotionPK,
updatePromotion.PromotionStartDate, adEngines);
}
SavePromotionAdEngineSelected(updatePromotion, model, dbcontext);
}
}
dbcontext.SaveChanges();
// we need to set this because the _dbcontext is and campaign is updated so reflect changes we need to create new context
_savedCampaign = true;
}
}
public Promotion CreatePromotionFromModel(CampaignSetupModel model,
decimal customerDefaultPerCampaignFlatFeeAmount)
{
if (model.AdModelProp.LandingUrl != null && model.AdModelProp.DisplayUrl != null)
{
model.AdModelProp.LandingUrl = model.AdModelProp.LandingUrl.Trim();
model.AdModelProp.DisplayUrl = model.AdModelProp.DisplayUrl.Trim();
}
var promo = new Promotion
{
//no whitespace in database
PromotionName = model.ProductGroup.ProductPromotionName,
LandingPageURL = model.AdModelProp.LandingUrl,
DisplayURL = model.AdModelProp.DisplayUrl,
PromotionDescription = model.ProductGroup.Words,
PromotionBudgetAmount = model.ProductGroup.Budget,
BudgetCycleFK = GetBudgetCycleId("Monthly"),
PromotionEndDate =
string.IsNullOrEmpty(model.ProductGroup.EndDate)
? (DateTime?)null
: Convert.ToDateTime(model.ProductGroup.EndDate, new CultureInfo("en-Us")),
CycleEndDate = Convert.ToDateTime(model.ProductGroup.StartDate, new CultureInfo("en-Us")).AddMonths(1),
StartBudgetInCycle = model.ProductGroup.Budget - customerDefaultPerCampaignFlatFeeAmount,
RemainingBudgetInCycle =
model.ProductGroup.Budget - customerDefaultPerCampaignFlatFeeAmount,
PromotionStartDate =
Convert.ToDateTime(model.ProductGroup.StartDate, new CultureInfo("en-Us")),
CycleStartDate = Convert.ToDateTime(model.ProductGroup.StartDate, new CultureInfo("en-Us")),
IsPaused = false,
IsCompleted = false,
IsLaunched = false,
CreatedDate = DateTime.Now,
IsAutobid = model.ProductGroup.IsAutoBid,
AutoBidMaxCPC = model.ProductGroup.AutoBidMaxCPC
};
return promo;
}
public void SavePromotionAdEngineSelected(Promotion promo, CampaignSetupModel model,
SemplestModel.Semplest dbcontext)
{
var existingAdenginesSeleccted =
dbcontext.PromotionAdEngineSelecteds.Where(m => m.PromotionFK == promo.PromotionPK);
var templist = new List<int>();
model.ProductGroup.AdEnginesList.ForEach(t => templist.Add(Convert.ToInt32(t)));
var dn = existingAdenginesSeleccted.Where(t => !templist.Contains(t.AdvertisingEngineFK));
foreach (var adsel in dn)
dbcontext.PromotionAdEngineSelecteds.Remove(adsel);
foreach (int aes in model.ProductGroup.AdEnginesList)
{
int adengineid = Convert.ToInt32(aes);
var proAdEng = dbcontext.AdvertisingEngines.FirstOrDefault(m => m.AdvertisingEnginePK == adengineid);
if (proAdEng != null)
{
var adEngSelQuery =
existingAdenginesSeleccted.FirstOrDefault(
m => m.AdvertisingEngineFK == proAdEng.AdvertisingEnginePK);
if (adEngSelQuery == null)
{
var adEngineSel = new PromotionAdEngineSelected
{
AdvertisingEngineFK = proAdEng.AdvertisingEnginePK,
PromotionFK = promo.PromotionPK
};
dbcontext.PromotionAdEngineSelecteds.Add(adEngineSel);
}
//dbcontext.SaveChanges();
}
}
}
private static bool AddPromotionAdsToPromotion(Promotion promo, CampaignSetupModel model, int customerFk,
CampaignSetupModel oldModel, out List<PromotionAd> addAds, out List<int> updateAds, out List<int> deleteAds)
{
deleteAds = new List<int>();
updateAds = new List<int>();
addAds = new List<PromotionAd>();
bool shouldscheduleAds = false;
foreach (PromotionAd pad in model.AdModelProp.Ads)
{
if (pad.Delete && pad.PromotionAdsPK != 0 && !pad.HasBeenSaved)
{
var singlePromo = promo.PromotionAds.Single(id => id.PromotionAdsPK == pad.PromotionAdsPK);
if (singlePromo != null)
{
deleteAds.Add(pad.PromotionAdsPK);
shouldscheduleAds = true;
}
}
else if (!pad.Delete && pad.PromotionAdsPK == 0 && !pad.HasBeenSaved)
{
shouldscheduleAds = true;
addAds.Add(pad);
pad.AdTextLine1 = pad.AdTextLine1;
pad.AdTextLine2 = pad.AdTextLine2;
pad.AdTitle = pad.AdTitle;
var cad = new PromotionAd
{
AdTextLine1 = pad.AdTextLine1,
AdTextLine2 = pad.AdTextLine2,
AdTitle = pad.AdTitle,
PromotionAdsPK = pad.PromotionAdsPK,
CreatedDate = DateTime.Now
};
promo.PromotionAds.Add(cad);
}
else if (!pad.Delete && pad.PromotionAdsPK != 0)
{
var padOld = oldModel.AdModelProp.Ads.Single(x => x.PromotionAdsPK == pad.PromotionAdsPK);
if (padOld != null)
{
if (padOld.AdTextLine1 != pad.AdTextLine1 ||
padOld.AdTextLine2 != pad.AdTextLine2 ||
padOld.AdTitle != pad.AdTitle)
{
shouldscheduleAds = true;
updateAds.Add(pad.PromotionAdsPK);
var pa = promo.PromotionAds.Single(x => x.PromotionAdsPK == pad.PromotionAdsPK);
pa.AdTextLine1 = pad.AdTextLine1;
pa.AdTextLine2 = pad.AdTextLine2;
pa.AdTitle = pad.AdTitle;
}
}
}
}
return shouldscheduleAds;
}
private void RefreshKeywords(CampaignSetupModel model, Promotion promo)
{
using (var dbcontext = new SemplestModel.Semplest())
{
IEnumerable<PromotionKeywordAssociation> qry =
dbcontext.PromotionKeywordAssociations.Where(key => key.PromotionFK == promo.PromotionPK).ToList();
var kpos = new List<KeywordProbabilityObject>();
KeywordProbabilityObject kpo;
foreach (PromotionKeywordAssociation pka in qry)
{
kpo = new KeywordProbabilityObject
{
keyword = pka.Keyword.Keyword1,
semplestProbability =
pka.SemplestProbability == null ? 0 : pka.SemplestProbability.Value,
isTargetMSN = pka.IsTargetMSN,
isTargetGoogle = pka.IsTargetGoogle,
isDeleted = pka.IsDeleted,
id = pka.KeywordFK
};
kpos.Add(kpo);
}
SaveKeywords(promo.PromotionPK, kpos, model.AdModelProp.NegativeKeywords,
model.ProductGroup.ProductGroupName, model.ProductGroup.ProductPromotionName);
}
}
public void SaveSiteLinks(CampaignSetupModel model, int customerFk, CampaignSetupModel oldModel)
{
bool shouldRefreshSiteLinks = false;
using (var dbcontext = new SemplestModel.Semplest())
{
var queryProd = (from c in dbcontext.ProductGroups
where
c.CustomerFK == customerFk &&
c.ProductGroupName == model.ProductGroup.ProductGroupName
select c).Single();
var promo = GetPromotionFromProductGroup(queryProd, model.ProductGroup.ProductPromotionName);
List<GoogleSiteLink> sl =
model.SiteLinks.Where(t => !t.Delete).Select(row => new GoogleSiteLink
{
LinkText = row.LinkText,
LinkURL = row.LinkURL
}).ToList();
if (sl.Any())
{
GoogleViolation[] gv = ValidateSiteLinks(sl);
if (gv.Length > 0)
throw new Exception(gv.First().shortFieldPath + ": " + gv.First().errorMessage);
}
shouldRefreshSiteLinks = AddSiteLinksToPromotion(promo, model, customerFk, ((IObjectContextAdapter)dbcontext).ObjectContext, oldModel);
dbcontext.SaveChanges();
_savedCampaign = true;
try
{
var adEngines = new List<string>();
if (promo.IsLaunched && shouldRefreshSiteLinks)
{
adEngines.AddRange(
promo.PromotionAdEngineSelecteds.Select(pades => pades.AdvertisingEngine.AdvertisingEngine1));
var sw = new ServiceClientWrapper();
sw.scheduleRefreshSiteLinks(promo.PromotionPK, adEngines);
}
}
catch (Exception ex)
{
SharedResources.Helpers.ExceptionHelper.LogException(ex);
}
}
}
private bool AddSiteLinksToPromotion(Promotion promo, CampaignSetupModel model, int customerFk, System.Data.Objects.ObjectContext context, CampaignSetupModel oldModel)
{
bool shouldRefreshSiteLinks = false;
if (model.SiteLinks != null)
foreach (var sitelink in model.SiteLinks)
{
if (sitelink.Delete && !sitelink.SiteLinksSaved)
{
var sl = promo.SiteLinks.SingleOrDefault(x => x.SiteLInkPK == sitelink.SiteLInkPK);
if (sl != null)
{
context.DeleteObject(sl);
shouldRefreshSiteLinks = true;
}
}
//TODO remove when the validation is added
//if (!string.IsNullOrEmpty(sitelink.LinkText) && !string.IsNullOrEmpty((sitelink.LinkURL)))
else if (sitelink.SiteLInkPK == 0 && !sitelink.SiteLinksSaved)
{
shouldRefreshSiteLinks = true;
var slink = new SiteLink
{
LinkText = sitelink.LinkText,
LinkURL = sitelink.LinkURL,
PromotionFK = promo.PromotionPK
};
promo.SiteLinks.Add(slink);
}
else
{
var siteOld = oldModel.SiteLinks.Single(x => x.SiteLInkPK == sitelink.SiteLInkPK);
if (siteOld.LinkText != sitelink.LinkText ||
siteOld.LinkURL != sitelink.LinkURL)
{
shouldRefreshSiteLinks = true;
var sl = promo.SiteLinks.Single(x => x.SiteLInkPK== sitelink.SiteLInkPK);
sl.LinkText = sitelink.LinkText;
sl.LinkURL = sitelink.LinkURL;
}
}
}
return shouldRefreshSiteLinks;
}
public bool AddGeoTargetingToPromotion(Promotion promo, CampaignSetupModel model, int customerFk, CampaignSetupModel oldModel, System.Data.Objects.ObjectContext context)
{
bool shouldUpdateGeoTargeting = false;
if (model.AdModelProp.Addresses != null)
{
var modelIds = new List<int>();
foreach (GeoTargeting geo in model.AdModelProp.Addresses)
{
if (geo.Delete && !geo.HasBeenSaved)
{
var gt = promo.GeoTargetings.FirstOrDefault(x => x.GeoTargetingPK == geo.GeoTargetingPK);
if (gt != null)
{
context.DeleteObject(gt);
shouldUpdateGeoTargeting = true;
}
}
else if (geo.GeoTargetingPK == 0 && !geo.IsCountry && !geo.HasBeenSaved)
{
shouldUpdateGeoTargeting = true;
var geotarget = new GeoTargeting
{
Address = geo.Address,
City = geo.City,
StateCodeFK = geo.StateCodeFK,
Zip = geo.Zip,
ProximityRadius = geo.ProximityRadius,
Latitude = geo.Latitude,
Longitude = geo.Longitude
};
promo.GeoTargetings.Add(geotarget);
}
else
{
GeoTargeting geo1 = geo;
modelIds.Add(geo1.GeoTargetingPK);
var geoOld =
oldModel.AdModelProp.Addresses.FirstOrDefault(x => x.GeoTargetingPK == geo1.GeoTargetingPK);
if (geoOld != null)
{
if (geoOld.Address != geo1.Address ||
geoOld.City != geo1.City ||
geoOld.Latitude != geo1.Latitude ||
geoOld.Longitude != geo1.Longitude ||
geoOld.ProximityRadius != geo1.ProximityRadius ||
geoOld.Zip != geo1.Zip ||
geoOld.StateCode.StateAbbrPK != geo1.StateCodeFK ||
geoOld.Promotion.PromotionName != model.ProductGroup.ProductPromotionName)
{
shouldUpdateGeoTargeting = true;
var gt = promo.GeoTargetings.Single(x => x.GeoTargetingPK == geo1.GeoTargetingPK);
gt.Address = geo1.Address;
gt.City = geo1.City;
gt.Latitude = geo1.Latitude;
gt.Longitude = geo1.Longitude;
gt.ProximityRadius = geo1.ProximityRadius;
gt.Zip = geo1.Zip;
gt.StateCodeFK = geo1.StateCodeFK;
}
}
}
}
}
return shouldUpdateGeoTargeting;
}
public void SaveGeoTargetingAds(int customerFK, CampaignSetupModel model, CampaignSetupModel oldModel)
{
using (var dbcontext = new SemplestModel.Semplest())
{
var queryProd = (from c in dbcontext.ProductGroups
where
c.CustomerFK == customerFK &&
c.ProductGroupName == model.ProductGroup.ProductGroupName
select c).Single();
var promo = GetPromotionFromProductGroup(queryProd, model.ProductGroup.ProductPromotionName);
List<PromotionAd> addAds;
List<int> updateAds;
List<int> deleteAds;
GoogleViolation[] gv;
var shouldscheduleAds = AddPromotionAdsToPromotion(promo, model, customerFK, oldModel,
out addAds, out updateAds, out deleteAds);
if (shouldscheduleAds)
{
List<GoogleAddAdRequest> verifyAds =
model.AdModelProp.Ads.Where(t => !t.Delete).Select(pad => new GoogleAddAdRequest
{
promotionAdID = promo.PromotionPK,
headline = pad.AdTitle,
description1 =
pad.AdTextLine1,
description2 =
pad.AdTextLine2
}).ToList();
gv = ValidateAds(model.AdModelProp.LandingUrl,
model.AdModelProp.DisplayUrl, verifyAds);
if (gv.Length > 0)
throw new Exception(gv.First().shortFieldPath + ": " + gv.First().errorMessage);
}
var shouldUpdateGeoTargeting = AddGeoTargetingToPromotion(promo, model, customerFK, oldModel,
((IObjectContextAdapter)dbcontext).ObjectContext);
if (shouldUpdateGeoTargeting)
{
var gtos = SerializeToGeoTargetObjectArray(model);
if (gtos.Any())
{
gv = ValidateGeotargeting(gtos);
if (gv.Length > 0)
throw new Exception(gv.First().shortFieldPath + ": " + gv.First().errorMessage);
var op = new System.Data.Objects.ObjectParameter("totalSize", typeof(int));
string valueDelimiter = ",";
string listDelimiter = ";";
dbcontext.GetMSNGeoLocation(null, SerializeToCommaDlimitedString(model.AdModelProp.Addresses, valueDelimiter, listDelimiter), valueDelimiter, listDelimiter, op);
if ((int)op.Value > 250)
throw new Exception("geotarget limit");
}
}
promo.LandingPageURL = model.AdModelProp.LandingUrl.Trim();
promo.DisplayURL = model.AdModelProp.DisplayUrl.Trim();
dbcontext.SaveChanges();
_savedCampaign = true;
if (promo.IsLaunched)
{
var sw = new ServiceClientWrapper();
var adEngines = new List<string>();
adEngines.AddRange(
promo.PromotionAdEngineSelecteds.Select(
pades => pades.AdvertisingEngine.AdvertisingEngine1));
if (shouldscheduleAds)
{
if (addAds.Any())
{
var addAdsIds =
addAds.Select(
promoAd =>
dbcontext.PromotionAds.Single(
row =>
row.AdTextLine1 == promoAd.AdTextLine1 && row.AdTextLine2 == promoAd.AdTextLine2 &&
row.AdTitle == promoAd.AdTitle && row.PromotionFK == promo.PromotionPK).
PromotionAdsPK).ToList();
sw.scheduleAds(promo.PromotionPK, addAdsIds, adEngines,
SEMplestConstants.PromotionAdAction.Add);
}
if (updateAds.Any())
sw.scheduleAds(promo.PromotionPK, updateAds, adEngines,
SEMplestConstants.PromotionAdAction.Update);
if (deleteAds.Any())
sw.scheduleAds(promo.PromotionPK, deleteAds, adEngines,
SEMplestConstants.PromotionAdAction.Delete);
}
if (shouldUpdateGeoTargeting)
sw.scheduleUpdateGeoTargeting(promo.PromotionPK, adEngines);
}
}
}
private List<GeoTargetObject> SerializeToGeoTargetObjectArray(CampaignSetupModel model)
{
var geoList = new List<GeoTargetObject>();
foreach (var geo in model.AdModelProp.Addresses)
{
if (!geo.IsState)
{
var geoTObj = new GeoTargetObject();
geoTObj.address = geo.Address;
geoTObj.city = geo.City;
if (geo.StateCodeFK != null) geoTObj.state = GetStateNameFromDb((int)geo.StateCodeFK);
geoTObj.zip = geo.Zip;
geoTObj.radius = (double)(geo.ProximityRadius ?? 0);
geoTObj.latitude = (double)(geo.Latitude ?? 0);
geoTObj.longitude = (double)(geo.Longitude ?? 0);
geoList.Add(geoTObj);
}
}
return geoList;
}
private Promotion GetPromoitionFromCampaign(SemplestModel.Semplest dbcontext, int customerFK, CampaignSetupModel model)
{
var queryProd = (from c in dbcontext.ProductGroups
where
c.CustomerFK == customerFK &&
c.ProductGroupName == model.ProductGroup.ProductGroupName
select c).Single();
return GetPromotionFromProductGroup(queryProd, model.ProductGroup.ProductPromotionName);
}
public bool AddGeoTargetingToPromotion(Promotion promo, CampaignSetupModel model, int customerFk, CampaignSetupModel oldModel, out GeoTargetTableType gtt)
{
bool shouldUpdateGeoTargeting = false;
gtt = new GeoTargetTableType();
GeoTargetTableTypeRow gtr;
if (model.AdModelProp.Addresses != null)
{
foreach (GeoTargeting geo in model.AdModelProp.Addresses)
{
gtr = gtt.NewRow();
if (geo.Delete & !geo.HasBeenSaved)
{
var gt = promo.GeoTargetings.FirstOrDefault(x => x.GeoTargetingPK == geo.GeoTargetingPK);
if (gt != null)
{
gtr.PKEY = geo.GeoTargetingPK;
gtr.Operation = "D";
shouldUpdateGeoTargeting = true;
}
}
else if (geo.GeoTargetingPK == 0 && !geo.IsCountry & !geo.HasBeenSaved)
{
shouldUpdateGeoTargeting = true;
gtr.Address = geo.Address;
gtr.City = geo.City;
gtr.StateCodeFK = geo.StateCodeFK == int.MinValue ? null: geo.StateCodeFK;
gtr.Zip = geo.Zip;
gtr.ProximityRadius = geo.ProximityRadius;
gtr.Latitude = geo.Latitude;
gtr.Longitude = geo.Longitude;
gtr.UID = geo.UID;
gtr.Operation = "I";
}
else if (!geo.IsCountry)
{
GeoTargeting geoOld =
oldModel.AdModelProp.Addresses.SingleOrDefault(x => x.GeoTargetingPK == geo.GeoTargetingPK);
if (geoOld.Address != geo.Address ||
geoOld.City != geo.City ||
geoOld.Latitude != geo.Latitude ||
geoOld.Longitude != geo.Longitude ||
geoOld.ProximityRadius != geo.ProximityRadius ||
geoOld.Zip != geo.Zip ||
geoOld.StateCodeFK != geo.StateCodeFK)
{
shouldUpdateGeoTargeting = true;
gtr.Address = geo.Address;
gtr.City = geo.City;
gtr.Latitude = geo.Latitude;
gtr.Longitude = geo.Longitude;
gtr.ProximityRadius = geo.ProximityRadius;
gtr.Zip = geo.Zip;
gtr.StateCodeFK = geo.StateCodeFK == int.MinValue ? null : geo.StateCodeFK;
gtr.PKEY = geo.GeoTargetingPK;
gtr.Operation = "U";
}
}
if (!string.IsNullOrEmpty(gtr.Operation))
gtt.Add(gtr);
}
}
return shouldUpdateGeoTargeting;
}
public CampaignSetupModel GetCampaignSetupModelForPromotionId(int promoId, bool preview = false)
{
var model = new CampaignSetupModel();
var dbcontext = InitializeContext();
var promo = dbcontext.Promotions.FirstOrDefault(p => p.PromotionPK == promoId);
//only let the user see their promo
int customerFk =
((Credential)
(System.Web.HttpContext.Current.Session[Semplest.SharedResources.SEMplestConstants.SESSION_USERID])).
User.CustomerFK.Value;
if (promo != null && promo.ProductGroup.CustomerFK != customerFk)
promo = null;
// populate model from promotions
if (promo != null)
{
model.ProductGroup.IsAutoBid = promo.IsAutobid;
model.ProductGroup.AutoBidMaxCPC = promo.AutoBidMaxCPC;
model.ProductGroup.ProductGroupName = promo.ProductGroup.ProductGroupName;
model.ProductGroup.ProductPromotionName = promo.PromotionName;
model.ProductGroup.Budget = promo.PromotionBudgetAmount;
model.ProductGroup.StartDate = promo.PromotionStartDate.ToString("MM/dd/yyyy",
new CultureInfo("en-Us"));
model.ProductGroup.EndDate = promo.PromotionEndDate.HasValue
? promo.PromotionEndDate.Value.ToString("MM/dd/yyyy",
CultureInfo.
InvariantCulture)
: String.Empty;
// set words
model.ProductGroup.Words = promo.PromotionDescription;
}
// set advertising engines
model.ProductGroup.AdEnginesSelectedList = new List<AdEngineSelectModel>();
if (promo != null)
{
foreach (var paes in promo.PromotionAdEngineSelecteds)
{
var aesm = new AdEngineSelectModel
{
Id = paes.AdvertisingEngine.AdvertisingEnginePK,
Name = paes.AdvertisingEngine.AdvertisingEngine1
};
model.ProductGroup.AdEnginesSelectedList.Add(aesm);
model.ProductGroup.AdEnginesList.Add(paes.AdvertisingEngine.AdvertisingEnginePK);
}
// set URL
model.AdModelProp.LandingUrl = promo.LandingPageURL;
// set display url
model.AdModelProp.DisplayUrl = promo.DisplayURL;
// set geotargetings
model.AdModelProp.Addresses = promo.GeoTargetings.ToList();
var singleOrDefault = promo.GeoTargetings.FirstOrDefault();
if (singleOrDefault != null && singleOrDefault.AddressType != null)
model.AdModelProp.PromotionAddressType = singleOrDefault.AddressType.AddressType1;
else
model.AdModelProp.PromotionAddressType = "NATIONALLY";
// set promotionads
model.AdModelProp.Ads = promo.PromotionAds.Where(ads => !ads.IsDeleted).ToList();
if (!preview)
{
// set negative keywords
if (promo.PromotionKeywordAssociations != null)
model.AdModelProp.NegativeKeywords =
promo.PromotionKeywordAssociations.Where(m => m.IsNegative && !m.IsDeleted).Select(m => m.Keyword.Keyword1).
ToList();
}
// set islaunched
model.IsLaunched = promo.IsLaunched;
model.IsCompleted = promo.IsCompleted;
if (!preview)
{
model.AllKeywords.AddRange(
promo.PromotionKeywordAssociations.Where(key => !key.IsDeleted && !key.IsNegative).OrderByDescending(o => o.SemplestProbability).Select(
key =>
new CampaignSetupModel.KeywordsModel
{Name = key.Keyword.Keyword1, Id = key.Keyword.KeywordPK}));
}
model.SiteLinks = promo.SiteLinks.ToList();
}
if (!preview)
{
var cnt = model.AdModelProp.NegativeKeywords.Count();
for (var i = 0; i < cnt; i++)
{
model.AdModelProp.NegativeKeywordsText += model.AdModelProp.NegativeKeywords[i];
if (i < cnt - 1)
{
model.AdModelProp.NegativeKeywordsText += ", ";
}
}
}
//added by tudor
var userid =
((Credential) System.Web.HttpContext.Current.Session[SharedResources.SEMplestConstants.SESSION_USERID]).
UsersFK;
var queryCustFk = from u in dbcontext.Users where u.UserPK == userid select u.CustomerFK;
var custobj = from c in dbcontext.Customers
where c.CustomerPK == queryCustFk.FirstOrDefault()
select new {c.PercentOfMedia, c.PromotionFeeAmount, c.PromotionFeeOverride, c.AllowAutobid};
var firstOrDefault = custobj.FirstOrDefault();
if (firstOrDefault != null)
{
model.ProductGroup.AllowAutoBid = firstOrDefault.AllowAutobid;
model.PercentMedia = firstOrDefault.PercentOfMedia;
model.PromotionFeeOverRide = firstOrDefault.PromotionFeeOverride;
model.PromotionFeeOverRideAmount = firstOrDefault.PromotionFeeAmount;
}
model.BillType = dbcontext.Users.First(key => key.UserPK == userid).Customer.BillTypeFK;
return model;
}
private bool AddSiteLinksToPromotion(Promotion promo, CampaignSetupModel model, int customerFk, System.Data.Objects.ObjectContext context, CampaignSetupModel oldModel, out SiteLinksTableType st)
{
bool shouldRefreshSiteLinks = false;
st = new SiteLinksTableType();
if (model.SiteLinks != null)
foreach (var sitelink in model.SiteLinks)
{
SiteLinksTableTypeRow str = st.NewRow();
if (sitelink.Delete && !sitelink.SiteLinksSaved)
{
var sl = promo.SiteLinks.SingleOrDefault(x => x.SiteLInkPK == sitelink.SiteLInkPK);
if (sl != null)
{
str.Operation = "D";
str.PKEY = sl.SiteLInkPK;
context.DeleteObject(sl);
shouldRefreshSiteLinks = true;
}
}
//TODO remove when the validation is added
//if (!string.IsNullOrEmpty(sitelink.LinkText) && !string.IsNullOrEmpty((sitelink.LinkURL)))
else if (sitelink.SiteLInkPK == 0 && !sitelink.SiteLinksSaved)
{
shouldRefreshSiteLinks = true;
str.LinkText = sitelink.LinkText;
str.LinkUrl = sitelink.LinkURL;
str.UID = sitelink.UID;
str.Operation = "I";
}
else
{
var siteOld = oldModel.SiteLinks.Single(x => x.SiteLInkPK == sitelink.SiteLInkPK);
if (siteOld.LinkText != sitelink.LinkText ||
siteOld.LinkURL != sitelink.LinkURL)
{
shouldRefreshSiteLinks = true;
str.LinkText = sitelink.LinkText;
str.LinkUrl = sitelink.LinkURL;
str.PKEY = sitelink.SiteLInkPK;
str.Operation = "U";
}
}
if (!string.IsNullOrEmpty(str.Operation))
st.Add(str);
}
return shouldRefreshSiteLinks;
}
private void UpdatePromotionFromModel(Promotion updatePromotion, CampaignSetupModel model,
decimal customerDefaultPerCampaignFlatFeeAmount)
{
model.AdModelProp.LandingUrl = model.AdModelProp.LandingUrl.Trim();
model.AdModelProp.DisplayUrl = string.IsNullOrEmpty(model.AdModelProp.DisplayUrl) ? string.Empty : model.AdModelProp.DisplayUrl.Trim();
updatePromotion.LandingPageURL = model.AdModelProp.LandingUrl;
updatePromotion.DisplayURL = model.AdModelProp.DisplayUrl;
updatePromotion.PromotionDescription = model.ProductGroup.Words;
updatePromotion.PromotionBudgetAmount = model.ProductGroup.Budget;
updatePromotion.PromotionStartDate = Convert.ToDateTime(model.ProductGroup.StartDate,
new CultureInfo("en-Us"));
updatePromotion.CycleStartDate = Convert.ToDateTime(model.ProductGroup.StartDate,
new CultureInfo("en-Us"));
updatePromotion.PromotionEndDate = string.IsNullOrEmpty(model.ProductGroup.EndDate)
? (DateTime?) null
: Convert.ToDateTime(model.ProductGroup.EndDate,
new CultureInfo("en-Us"));
updatePromotion.CycleEndDate =
Convert.ToDateTime(model.ProductGroup.StartDate, new CultureInfo("en-Us")).AddMonths(1);
updatePromotion.StartBudgetInCycle = model.ProductGroup.Budget -
customerDefaultPerCampaignFlatFeeAmount;
updatePromotion.RemainingBudgetInCycle = model.ProductGroup.Budget -
customerDefaultPerCampaignFlatFeeAmount;
updatePromotion.IsAutobid = model.ProductGroup.IsAutoBid;
updatePromotion.AutoBidMaxCPC = model.ProductGroup.AutoBidMaxCPC;
}
public void AddSiteLinksToPromotion(Promotion promo, CampaignSetupModel model, int customerFk)
{
if (model.SiteLinks != null)
foreach (var sitelink in model.SiteLinks)
{
var slink = new SiteLink
{
LinkText = sitelink.LinkText,
LinkURL = sitelink.LinkURL,
PromotionFK = promo.PromotionPK
};
promo.SiteLinks.Add(slink);
try
{
var sw = new ServiceClientWrapper();
var adEngines = new List<string>();
if (promo.IsLaunched)
{
adEngines.AddRange(promo.PromotionAdEngineSelecteds.Select(pades => pades.AdvertisingEngine.AdvertisingEngine1));
sw.scheduleRefreshSiteLinksForAd(customerFk, promo.PromotionPK, adEngines);
}
}
catch (Exception ex) { SharedResources.Helpers.ExceptionHelper.LogException(ex.ToString()); }
}
}
public List<CampaignSetupModel.KeywordsModel> SaveNegativeKeywords(CampaignSetupModel model, int customerFk)
{
if (model.AdModelProp.NegativeKeywords.Any())
{
GoogleViolation[] gv = ValidateGoogleNegativeKeywords(model.AdModelProp.NegativeKeywords);
if (gv.Length > 0)
throw new Exception(gv.First().shortFieldPath + ": " + gv.First().errorMessage);
}
using (var dbcontext = new SemplestModel.Semplest())
{
var promo = GetPromoitionFromCampaign(dbcontext, customerFk, model);
if (!promo.IsLaunched)
{ RefreshKeywords(model, promo); }
else
{
var addKiops = new List<KeywordIdRemoveOppositePair>();
var addNewKiops = new List<string>();
var addDeletedKiops = new List<int>();
var qpka = promo.PromotionKeywordAssociations.ToList();
//check negative keywords that have been added to the gui
if (model.AdModelProp.NegativeKeywords != null)
{
foreach (string negativeKeyword in model.AdModelProp.NegativeKeywords)
{
var kiop = new KeywordIdRemoveOppositePair();
var pka = qpka.SingleOrDefault(key => key.Keyword.Keyword1 == negativeKeyword);
if (pka != null)
{
//means if the keyword existied and was positive it needs to be removed and added as a negative.
//if the keyword is already negative then do nothing because we've already added it
kiop.keywordId = pka.KeywordFK;
if (!pka.IsNegative)
{
kiop.removeOpposite = true;
addKiops.Add(kiop);
}
}
else
{
var kw = dbcontext.Keywords.SingleOrDefault(key => key.Keyword1 == negativeKeyword);
if (kw != null)
{
kiop.keywordId = kw.KeywordPK;
kiop.removeOpposite = false;
addKiops.Add(kiop);
}
else//this keyword doesn't exist in the database so when we call the stored proc get the id so it can be sent to the api
addNewKiops.Add(negativeKeyword);
}
}
}
//check for negative keywords that have been removed from the gui
foreach (PromotionKeywordAssociation k in qpka.Where(key => key.IsNegative == true).ToList())
{
if (!model.AdModelProp.NegativeKeywords.Contains(k.Keyword.Keyword1))
addDeletedKiops.Add(k.Keyword.KeywordPK);
}
List<int> deletedKeywords = new List<int>();
var op = new System.Data.Objects.ObjectParameter("NegativeKeywordID", typeof(int));
var op2 = new System.Data.Objects.ObjectParameter("Exists", typeof(int));
foreach (string kw in model.AdModelProp.NegativeKeywords)
{
//keywords that need to be deleted
var snr = dbcontext.SetNegativeKeyword(kw, promo.PromotionPK, op, op2).ToList();
if (snr.Any())
{
deletedKeywords.AddRange(snr.Select(ids => ids.KeywordPK));
}
if (!string.IsNullOrEmpty(op.Value.ToString()))
{
var kop = new KeywordIdRemoveOppositePair { keywordId = int.Parse(op.Value.ToString()), removeOpposite = bool.Parse(op2.Value.ToString()) };
addKiops.Add(kop);
}
}
foreach (int dk in addDeletedKiops)
promo.PromotionKeywordAssociations.Single(kw => kw.KeywordFK == dk).IsDeleted=true;
dbcontext.SaveChanges();
_savedCampaign = true;
var sw = new ServiceClientWrapper();
var adEngines = new List<string>();
adEngines.AddRange(
promo.PromotionAdEngineSelecteds.Select(pades => pades.AdvertisingEngine.AdvertisingEngine1));
if (addDeletedKiops.Any())
sw.DeleteNegativeKeywords(promo.PromotionPK, addDeletedKiops, adEngines);
if (addKiops.Any())
sw.AddNegativeKeywords(promo.PromotionPK, addKiops, adEngines);
if (deletedKeywords.Any())
sw.DeleteKeywords(promo.PromotionPK, deletedKeywords, adEngines);
}
model.AllKeywords.Clear();
model.AllKeywords.AddRange(
promo.PromotionKeywordAssociations.Where(key => !key.IsDeleted && !key.IsNegative).Select(
key =>
new CampaignSetupModel.KeywordsModel { Name = key.Keyword.Keyword1, Id = key.Keyword.KeywordPK }));
}
return model.AllKeywords;
}
public void AddPromotionAdsToPromotion(Promotion promo, CampaignSetupModel model, int customerFk)
{
foreach (PromotionAd pad in model.AdModelProp.Ads.Where(t => !t.Delete))
{
var cad = new PromotionAd { AdTextLine1 = pad.AdTextLine1, AdTextLine2 = pad.AdTextLine2, AdTitle = pad.AdTitle };
//if (pad.SiteLinks != null)
//{
// // add sitelinks
// foreach (SiteLink slink in pad.SiteLinks)
// {
// // this is check should be removed once we fix the logic in partialview and model
// if (!String.IsNullOrEmpty(slink.LinkText) && !String.IsNullOrEmpty(slink.LinkURL))
// {
// var slinkobj = new SiteLink { LinkText = slink.LinkText, LinkURL = slink.LinkURL };
// cad.SiteLinks.Add(slinkobj);
// }
// }
//}
promo.PromotionAds.Add(cad);
try
{
var sw = new ServiceClientWrapper();
var adEngines = new List<string>();
var promoAds = new List<int>();
if (promo.IsLaunched)
{
adEngines.AddRange(promo.PromotionAdEngineSelecteds.Select(pades => pades.AdvertisingEngine.AdvertisingEngine1));
promoAds.AddRange(promo.PromotionAds.Select(pa => pa.PromotionAdsPK));
sw.scheduleAds(customerFk, promo.PromotionPK, promoAds, adEngines, true);
}
}
catch (Exception ex) { SharedResources.Helpers.ExceptionHelper.LogException(ex.ToString()); }
}
}
public string SaveSiteLinks(CampaignSetupModel model, int customerFk, CampaignSetupModel oldModel)
{
bool shouldRefreshSiteLinks = false;
var rString = new System.Text.StringBuilder();
using (var dbcontext = new SemplestModel.Semplest())
{
var queryProd = (from c in dbcontext.ProductGroups
where
c.CustomerFK == customerFk &&
c.ProductGroupName == model.ProductGroup.ProductGroupName
select c).Single();
var promo = GetPromotionFromProductGroup(queryProd, model.ProductGroup.ProductPromotionName);
List<GoogleSiteLink> sl =
model.SiteLinks.Where(t => !t.Delete).Select(row => new GoogleSiteLink
{
LinkText = row.LinkText,
LinkURL = row.LinkURL
}).ToList();
if (sl.Any())
{
GoogleViolation[] gv = ValidateSiteLinks(sl);
if (gv.Length > 0)
throw new Exception(gv.First().shortFieldPath + ": " + gv.First().errorMessage);
}
SiteLinksTableType st;
shouldRefreshSiteLinks = AddSiteLinksToPromotion(promo, model, customerFk, ((IObjectContextAdapter)dbcontext).ObjectContext, oldModel, out st);
var parameter = new SqlParameter("PromotionPK", promo.PromotionPK) { SqlDbType = SqlDbType.Int };
var parameter2 = new SqlParameter("SlTVP", st) { SqlDbType = SqlDbType.Structured, TypeName = "SiteLinksTableType" };
var parameters = new object[] { parameter, parameter2 };
var results = ((IObjectContextAdapter)dbcontext).ObjectContext.ExecuteStoreQuery<RVal>("exec UpdateSiteLinks @PromotionPK, @SlTVP", parameters);
_savedCampaign = true;
foreach (var r in results)
{
rString.Append(r.UID);
rString.Append("=");
rString.Append(r.PKEY);
rString.Append(",");
}
_savedCampaign = true;
try
{
var adEngines = new List<string>();
if (promo.IsLaunched && shouldRefreshSiteLinks)
{
adEngines.AddRange(
promo.PromotionAdEngineSelecteds.Select(pades => pades.AdvertisingEngine.AdvertisingEngine1));
var sw = new ServiceClientWrapper();
sw.scheduleRefreshSiteLinks(promo.PromotionPK, adEngines);
}
}
catch (Exception ex)
{
SharedResources.Helpers.ExceptionHelper.LogException(ex);
}
}
return string.IsNullOrEmpty(rString.ToString()) ? String.Empty : rString.ToString().Substring(0, rString.ToString().Length - 1);
}
public List<string> SerializeAdEnginesSelectedToStringArray(CampaignSetupModel model)
{
return model.ProductGroup.AdEnginesList.Select(Convert.ToInt32).Select(id =>
{
var adEngineSelectModel =
model.ProductGroup.
AdvertisingEngines.
FirstOrDefault(
t => t.Id == id);
return adEngineSelectModel !=
null
? adEngineSelectModel
.Name
: null;
}).ToList();
}
private static bool AddPromotionAdsToPromotion(Promotion promo, CampaignSetupModel model, int customerFk,
CampaignSetupModel oldModel, out List<PromotionAd> addAds, out List<int> updateAds, out List<int> deleteAds, out PromoAdTableType att)
{
deleteAds = new List<int>();
updateAds = new List<int>();
addAds = new List<PromotionAd>();
bool shouldscheduleAds = false;
att = new PromoAdTableType();
PromoAdTableTypeRow atr;
foreach (PromotionAd pad in model.AdModelProp.Ads)
{
atr = att.NewRow();
if (pad.Delete && pad.PromotionAdsPK != 0)
{
var singlePromo = promo.PromotionAds.Single(id => id.PromotionAdsPK == pad.PromotionAdsPK);
if (singlePromo != null)
{
if (!promo.IsLaunched)
{
atr.PKEY = pad.PromotionAdsPK;
atr.Operation = "D";
}
deleteAds.Add(pad.PromotionAdsPK);
shouldscheduleAds = true;
}
}
else if (!pad.Delete && pad.PromotionAdsPK == 0)
{
shouldscheduleAds = true;
addAds.Add(pad);
atr.AdTextLine1 = pad.AdTextLine1;
atr.AdTextLine2 = pad.AdTextLine2;
atr.AdTitle = pad.AdTitle;
atr.UID = pad.UID;
atr.Operation = "I";
}
else if (!pad.Delete && pad.PromotionAdsPK != 0)
{
var oldAd = oldModel.AdModelProp.Ads.SingleOrDefault(x => x.PromotionAdsPK == pad.PromotionAdsPK);
if (oldAd.AdTextLine1 != pad.AdTextLine1 ||
oldAd.AdTextLine2 != pad.AdTextLine2 || oldAd.AdTitle != pad.AdTitle)
{
shouldscheduleAds = true;
updateAds.Add(pad.PromotionAdsPK);
atr.AdTextLine1 = pad.AdTextLine1;
atr.AdTextLine2 = pad.AdTextLine2;
atr.AdTitle = pad.AdTitle;
atr.PKEY = pad.PromotionAdsPK;
atr.Operation = "U";
}
}
if (!string.IsNullOrEmpty(atr.Operation))
att.Add(atr);
}
return shouldscheduleAds;
}
private List<GeoTargetObject> SerializeToGeoTargetObjectArray(CampaignSetupModel model)
{
var geoList = new List<GeoTargetObject>();
var sr = new StateRepository();
foreach (var geo in model.AdModelProp.Addresses)
{
if (!geo.IsState && !geo.Delete && !geo.IsCountry)
{
var geoTObj = new GeoTargetObject();
geoTObj.address = geo.Address;
geoTObj.city = geo.City;
if (geo.StateCodeFK != int.MinValue) geoTObj.state = sr.GetStateNameFromCode((int)geo.StateCodeFK);
geoTObj.zip = geo.Zip;
geoTObj.radius = (double?)(geo.ProximityRadius ?? null);
geoTObj.latitude = (double?)(geo.Latitude ?? null);
geoTObj.longitude = (double?)(geo.Longitude ?? null);
geoList.Add(geoTObj);
}
}
return geoList;
}
