public List<ACM.Model.Campaign> CampaignInfo(ACM.Model.Campaign request)
{
List<ACM.Model.Campaign> response = new List<ACM.Model.Campaign>();
try
{
using (ACM_Redesign2014Context ctx = new ACM_Redesign2014Context())
{
ctx.Configuration.ProxyCreationEnabled = false;
if (request != null && request.RequestorId != null && request.RequestorId != 0)
{
response = (from campaign in ctx.Campaigns
where campaign.RequestorId == request.RequestorId
select campaign).ToList();
}
else
response = (from campaign in ctx.Campaigns
select campaign).ToList();
ctx.Configuration.ProxyCreationEnabled = true;
}
}
catch (Exception ex)
{
Error.WriteException(TraceEventType.Error, ex.Message.ToString(), "CampaignInfo");
throw;
}
return response;
}
public List<CampaignFollowUp> CampaignFollowUpInfo(CampaignFollowUp request)
{
List<CampaignFollowUp> response = new List<CampaignFollowUp>();
try
{
using (ACM_Redesign2014Context ctx = new ACM_Redesign2014Context())
{
if (request != null && request.CampaignId != 0)
{
response = (from campaignFollowUp in ctx.CampaignFollowUps
where campaignFollowUp.CampaignId == request.CampaignId
select campaignFollowUp).ToList();
}
else
response = (from campaign in ctx.CampaignFollowUps
select campaign).ToList();
}
}
catch (Exception ex)
{
Error.WriteException(TraceEventType.Error, ex.Message.ToString(), "CampaignFollowUpInfo");
throw;
}
return response;
}
public string AdAdRestrictionFlagAdd(int adid, int campaignId, List<int> flags, bool applyAll = false)
{
string retVal = string.Empty;
try
{
if (flags.Count > 0)
{
var splitFlag = string.Join(",", flags);
int applyToAllAd = 0;
if (applyAll)
applyToAllAd = 1;
using (ACM_Redesign2014Context ctx = new ACM_Redesign2014Context())
{
ctx.Database.ExecuteSqlCommand("SP_Adrestrictions @AdRestrictionId, @AdId, @CampaignId, @applyAll",
new SqlParameter("AdRestrictionId", splitFlag),
new SqlParameter("AdId", adid),
new SqlParameter("CampaignId", campaignId),
new SqlParameter("applyAll", applyToAllAd)
);
}
}
}
catch (Exception ex)
{
Error.WriteException(TraceEventType.Error, ex.Message.ToString(), "AdAdd");
throw;
}
return retVal;
}
public List<ACM.Model.DeploymentPeriod> DeploymentPeriodInformation(ACM.Model.DeploymentPeriod request)
{
List<ACM.Model.DeploymentPeriod> response = new List<ACM.Model.DeploymentPeriod>();
try
{
using (ACM_Redesign2014Context ctx = new ACM_Redesign2014Context())
{
ctx.Configuration.ProxyCreationEnabled = false;
if (request != null)
{
response = (from deploymentperiod in ctx.DeploymentPeriods
select deploymentperiod).ToList();
}
ctx.Configuration.ProxyCreationEnabled = true;
}
}
catch (Exception ex)
{
Error.WriteException(TraceEventType.Error, ex.Message.ToString(), "DeploymentPeriodInformation");
throw;
}
return response;
}
public ACM.Model.DeploymentPeriod DeploymentPeriodAdd(ACM.Model.DeploymentPeriod request)
{
ACM.Model.DeploymentPeriod response = new ACM.Model.DeploymentPeriod();
try
{
using (ACM_Redesign2014Context ctx = new ACM_Redesign2014Context())
{
request.CreatedDate = DateTime.Now;
ctx.DeploymentPeriods.Add(request);
ctx.SaveChanges();
ctx.Configuration.ProxyCreationEnabled = false;
// IQueryable<ACM.Model.Campaign> response1 = ctx.Campaigns.Last();
response = (from deploymentperiod in ctx.DeploymentPeriods
orderby deploymentperiod.DeploymentPeriodId descending
select deploymentperiod).First();
ctx.Configuration.ProxyCreationEnabled = true;
}
}
catch (Exception ex)
{
Error.WriteException(TraceEventType.Error, ex.Message.ToString(), "DeploymentPeriodAdd");
throw;
}
return response;
}
public ACM.Model.Campaign CampaignAdd(ACM.Model.Campaign request)
{
ACM.Model.Campaign response = new ACM.Model.Campaign();
try
{
using (ACM_Redesign2014Context ctx = new ACM_Redesign2014Context())
{
request.CreatedDate = DateTime.Now;
ctx.Campaigns.Add(request);
ctx.SaveChanges();
ctx.Configuration.ProxyCreationEnabled = false;
response = (from campaign in ctx.Campaigns
where campaign.CampaignGuid == request.CampaignGuid
orderby campaign.CampaignId descending
select campaign).First();
ctx.Configuration.ProxyCreationEnabled = true;
}
}
catch (Exception ex)
{
Error.WriteException(TraceEventType.Error, ex.Message.ToString(), "CampaignAdd");
throw;
}
return response;
}
public static IEnumerable<GetDropDownListByValue> GetDropDownListByValue(string MasterTableID, string MasterTableDescription, string MasterTableName)
{
List<GetDropDownListByValue> listItems = new List<GetDropDownListByValue>();
using (ACM_Redesign2014Context ctx = new ACM_Redesign2014Context())
{
listItems = (ctx.Database.SqlQuery<GetDropDownListByValue>("exec GetListforDropDown @Param1,@Param2,@Param3",
new SqlParameter("Param1", MasterTableID),
new SqlParameter("Param2", MasterTableDescription),
new SqlParameter("Param3", MasterTableName)
)).ToList();
}
return listItems;
}
public string CampaignMainFrameAdd(CampaignMainFrame request)
{
try
{
using (ACM_Redesign2014Context ctx = new ACM_Redesign2014Context())
{
ctx.CampaignMainFrames.Add(request);
ctx.SaveChanges();
}
}
catch (Exception ex)
{
Error.WriteException(TraceEventType.Error, ex.Message.ToString(), "CampaignMainFrameAdd");
throw;
}
return "Successfully added";
}
public string DeploymentModification(ACM.Model.DeploymentPeriod request)
{
try
{
using (ACM_Redesign2014Context ctx = new ACM_Redesign2014Context())
{
request.ModifiedDate = DateTime.Now;
ctx.Entry(request).State = EntityState.Modified;
ctx.SaveChanges();
}
}
catch (Exception ex)
{
Error.WriteException(TraceEventType.Error, ex.Message.ToString(), "DeploymentModification");
throw;
}
return "Successfully updated";
}
public static IEnumerable<GetDataForDropDownList> GetMasterDropDownDataforMasterTables(string MasterTableID, string MasterTableDescription, string MasterTableName)
{
ACM_Redesign2014Context ctx = new ACM_Redesign2014Context();
try
{
var listItems = (ctx.Database.SqlQuery<GetDataForDropDownList>("exec GetListforDropDown @Param1,@Param2,@Param3",
new SqlParameter("Param1", MasterTableID),
new SqlParameter("Param2", MasterTableDescription),
new SqlParameter("Param3", MasterTableName)
)).ToList();
return listItems;
}
catch (Exception ex)
{
Error.WriteException(TraceEventType.Error, ex.Message.ToString(), "GetMasterDropDownDataforMasterTables");
throw;
}
}
public string CampaignDel(ACM.Model.Campaign request)
{
try
{
using (ACM_Redesign2014Context ctx = new ACM_Redesign2014Context())
{
ACM.Model.Campaign campaign = ctx.Campaigns.Find(request.CampaignId);
ctx.Campaigns.Remove(request);
ctx.SaveChanges();
}
}
catch (Exception ex)
{
Error.WriteException(TraceEventType.Error, ex.Message.ToString(), "CampaignDel");
throw;
}
return "Successfully deleted";
}
public List<CampaignTargetFileProvider> CampaigTargetFileInfo(CampaignTargetFileProvider request)
{
List<CampaignTargetFileProvider> response = new List<CampaignTargetFileProvider>();
try
{
using (ACM_Redesign2014Context ctx = new ACM_Redesign2014Context())
{
if (request != null && request.CampaignId != 0)
{
response = (from campaignTargetFileProvider in ctx.CampaignTargetFileProviders
where campaignTargetFileProvider.CampaignId == request.CampaignId
select campaignTargetFileProvider).ToList();
}
}
}
catch (Exception ex)
{
Error.WriteException(TraceEventType.Error, ex.Message.ToString(), "CampaigTargetFileInfo");
throw;
}
return response;
}
public CampaignTargetFileProvider CampaigTargetFileInq(CampaignTargetFileProvider request)
{
CampaignTargetFileProvider response = new CampaignTargetFileProvider();
try
{
using (ACM_Redesign2014Context ctx = new ACM_Redesign2014Context())
{
ctx.Configuration.ProxyCreationEnabled = false;
if (request != null)
{
response = ctx.CampaignTargetFileProviders.Find(request.CampaignId);
}
ctx.Configuration.ProxyCreationEnabled = true;
}
}
catch (Exception ex)
{
Error.WriteException(TraceEventType.Error, ex.Message.ToString(), "CampaigTargetFileInq");
throw;
}
return response;
}
public ACM.Model.Ad AdAdd(ACM.Model.Ad request)
{
ACM.Model.Ad response = new ACM.Model.Ad();
try
{
using (ACM_Redesign2014Context ctx = new ACM_Redesign2014Context())
{
ctx.Ads.Add(request);
ctx.SaveChanges();
response = (from ad in ctx.Ads
where ad.AdGuid == request.AdGuid
orderby ad.AdId descending
select ad).First();
}
}
catch (Exception ex)
{
Error.WriteException(TraceEventType.Error, ex.Message.ToString(), "AdAdd");
throw;
}
return response;
}
public string CampaignMainFrameDel(CampaignMainFrame request)
{
try
{
using (ACM_Redesign2014Context ctx = new ACM_Redesign2014Context())
{
ctx.Configuration.ProxyCreationEnabled = false;
CampaignMainFrame campaign = ctx.CampaignMainFrames.Find(request.CampaignId);
ctx.CampaignMainFrames.Remove(campaign);
ctx.SaveChanges();
ctx.Configuration.ProxyCreationEnabled = true;
}
}
catch (Exception ex)
{
Error.WriteException(TraceEventType.Error, ex.Message.ToString(), "CampaignMainFrameDel");
throw;
}
return "Successfully deleted";
}
public string InsertAdDeploymentPeriod(int campaignId, int adid, int deploymentPeriodId, bool applyAllDeployments)
{
string retVal = string.Empty;
try
{
using (ACM_Redesign2014Context ctx = new ACM_Redesign2014Context())
{
int applyToAllDeployment = 0;
if (applyAllDeployments)
applyToAllDeployment = 1;
ACM.DAO.DeploymentPeriodDAO dao = new DeploymentPeriodDAO();
var allDeploymentPeriods = dao.GetFutureDeploymentPeriod(campaignId, deploymentPeriodId);
List<string> ads = new List<string>();
foreach (var item in allDeploymentPeriods)
{
ads.Add(item.ID.ToString());
}
string adList = string.Join(",", ads.ToList());
ctx.Database.ExecuteSqlCommand("SP_AddDeploymentPeriod @CampaignId, @AdId, @DeploymentPeriodId,@DeploymentPeriodIds, @applyAll",
new SqlParameter("CampaignId", campaignId),
new SqlParameter("AdId", adid),
new SqlParameter("DeploymentPeriodId", deploymentPeriodId),
new SqlParameter("DeploymentPeriodIds", adList),
new SqlParameter("applyAll", applyToAllDeployment)
);
}
}
catch (Exception ex)
{
Error.WriteException(TraceEventType.Error, ex.Message.ToString(), "InsertAdDeploymentPeriod");
throw;
}
return retVal;
}
public Dictionary<int, int> GetAdRestrictionFlag(int campaignId, int adid)
{
string adRestrictionIds = string.Empty;
Dictionary<int, int> res = new Dictionary<int, int>();
try
{
using (ctx = new ACM_Redesign2014Context())
{
var result = (ctx.Database.SqlQuery<GetRestrictionFlag>("SP_GetAdRestrictionFlag @campaignId, @adid",
new SqlParameter("campaignId", campaignId),
new SqlParameter("adid", adid)
)).ToList();
foreach (var item in result)
{
res.Add(item.CategoryID, item.RestrictionID);
}
adRestrictionIds = string.Join(",", result);
}
return res;
}
catch (Exception ex)
{
Error.WriteException(TraceEventType.Error, ex.Message.ToString(), "GetAdRestrictionCode");
throw;
}
}
public ACM.Model.Campaign CampaignInq(ACM.Model.Campaign request)
{
ACM.Model.Campaign response = new ACM.Model.Campaign();
try
{
using (ACM_Redesign2014Context ctx = new ACM_Redesign2014Context())
{
ctx.Configuration.LazyLoadingEnabled = true;
ctx.Configuration.ProxyCreationEnabled = false;
if (request != null)
{
response = ctx.Campaigns.Find(request.CampaignId);
ctx.Campaigns.Include("CampaignTableStatu").ToList();
}
}
}
catch (Exception ex)
{
Error.WriteException(TraceEventType.Error, ex.Message.ToString(), "CampaignInq");
throw;
}
return response;
}
public PartialViewInfo CampaignLeftNavigationDetails(int campaignId)
{
ACM.Model.Campaign response = new ACM.Model.Campaign();
PartialViewInfo partialInfo = new PartialViewInfo();
try
{
using (ACM_Redesign2014Context ctx = new ACM_Redesign2014Context())
{
var listItems = (ctx.Database.SqlQuery<GetLeftNavDetails_Result>("GetLeftNavDetails @CampaignId",
new SqlParameter("CampaignId", campaignId)
)).ToList();
foreach (var item in listItems)
{
partialInfo.CampaignId = item.campaignId;
partialInfo.CampaignType = item.CampaignTypeName;
partialInfo.CampaignName = item.campaignname;
partialInfo.ATMPM = item.primaryPMName;
partialInfo.SecondaryPM = item.secondaryPMName;
partialInfo.PromoButton = item.PromoButtonName;
partialInfo.Note = item.Notes;
partialInfo.Status = item.campaignstatus;
}
return partialInfo;
}
}
catch (Exception ex)
{
Error.WriteException(TraceEventType.Error, ex.Message.ToString(), "CampaignLeftNavigationDetails");
throw;
}
}
public List<AdlocationList> AdLocationsByCampaign(int campaignId, int adid)
{
string status = "Edit";
if (adid == 0)
status = "New";
try
{
using (ctx = new ACM_Redesign2014Context())
{
var listItems = (ctx.Database.SqlQuery<AdlocationList>("SP_GetAdLocationsByCampaignType @CampaignId, @Status,@adid",
new SqlParameter("CampaignId", campaignId),
new SqlParameter("Status", status),
new SqlParameter("adid",adid)
)).ToList();
return listItems;
}
}
catch (Exception ex)
{
Error.WriteException(TraceEventType.Error, ex.Message.ToString(), "GetMasterDropDownDataforMasterTables");
throw;
}
}
public ACM.Model.CustomModel.AdInfo AdInfoInq(int campaignId, int adid, int deploymentPeriodId)
{
ACM.Model.CustomModel.AdInfo adInfo = new Model.CustomModel.AdInfo();
List<AdRestrictions> listRes = new List<AdRestrictions>();
try
{
using (ctx = new ACM_Redesign2014Context())
{
var listItems = (ctx.Database.SqlQuery<AdInfo_Result>("AdInfo @DeploymentPeriodId, @CampaignId, @Adid",
new SqlParameter("DeploymentPeriodId", deploymentPeriodId),
new SqlParameter("CampaignId", campaignId),
new SqlParameter("Adid", adid)
)).SingleOrDefault();
adInfo.Ad = listItems;
var adResInfo = (from ad in ctx.AdRestrictionAds
where ad.CampaignId == campaignId && ad.AdId == adid
select new { Id = ad.Id, AdRestrictionId = ad.AdRestrictionId, AdId = ad.AdId, CampaignId = ad.CampaignId }).ToList();
AdRestrictions adRes = new AdRestrictions();
foreach (var item in adResInfo)
{
adRes = new AdRestrictions();
adRes.AdId = item.AdId;
adRes.AdRestrictionId = item.AdRestrictionId;
adRes.CampaignId = item.CampaignId;
adRes.Id = item.Id;
listRes.Add(adRes);
}
adInfo.AdRestriction = listRes;
}
return adInfo;
}
catch (Exception ex)
{
Error.WriteException(TraceEventType.Error, ex.Message.ToString(), "GetMasterDropDownDataforMasterTables");
throw;
}
}
public List<AdInfo_Result> AdsByCampaign(int campaignId, int deploymentPeriodId)
{
try
{
using (ctx = new ACM_Redesign2014Context())
{
var listItems = (ctx.Database.SqlQuery<AdInfo_Result>("AdInfo @DeploymentPeriodId, @CampaignId",
new SqlParameter("DeploymentPeriodId", deploymentPeriodId),
new SqlParameter("CampaignId", campaignId)
)).ToList();
return listItems;
}
}
catch (Exception ex)
{
Error.WriteException(TraceEventType.Error, ex.Message.ToString(), "GetMasterDropDownDataforMasterTables");
throw;
}
}
public ACM.Model.AdDeploymentPeriod AdStatusInquiry(ACM.Model.AdDeploymentPeriod request, int deploymentPeriodId)
{
ACM.Model.AdDeploymentPeriod response = new ACM.Model.AdDeploymentPeriod();
try
{
using (ctx = new ACM_Redesign2014Context())
{
ctx.Configuration.LazyLoadingEnabled = true;
ctx.Configuration.ProxyCreationEnabled = false;
response = (from ad in ctx.AdDeploymentPeriods
where ad.CampaignId == request.CampaignId && ad.Adid == request.Adid && ad.DeploymentPeriodId== deploymentPeriodId
select ad).FirstOrDefault();
ctx.Configuration.ProxyCreationEnabled = true;
}
}
catch (Exception ex)
{
Error.WriteException(TraceEventType.Error, ex.Message.ToString(), "AdInq");
throw;
}
return response;
}
public List<ACM.Model.Ad> AdInfo(ACM.Model.Ad request)
{
try
{
List<ACM.Model.Ad> response = new List<ACM.Model.Ad>();
using (ctx = new ACM_Redesign2014Context())
{
ctx.Configuration.LazyLoadingEnabled = true;
ctx.Configuration.ProxyCreationEnabled = false;
response = (from ad in ctx.Ads
where ad.CampaignId == request.CampaignId
select ad).ToList();
// ctx.Ads.Include("AdRestriction").ToList();
ctx.Ads.Include("AdLocation").ToList();
ctx.Ads.Include("AdProductType").ToList();
ctx.Configuration.ProxyCreationEnabled = true;
}
return response;
}
catch (Exception ex)
{
Error.WriteException(TraceEventType.Error, ex.Message.ToString(), "AdInfo");
throw;
}
}
public Restrictions GetAdRestrictionCategory()
{
Restrictions restriction = new Restrictions();
try
{
using (ctx = new ACM_Redesign2014Context())
{
ctx.Configuration.LazyLoadingEnabled = true;
var response = (from adres in ctx.AdRestrictions
group adres by new { adres.ACMName, adres.AdRestrictionId } into r
select new { ACMName = r.Key.ACMName, RestrictionID = r.Key.AdRestrictionId, ACMCategoryId = r.Max(d => d.ACMCategoryId) }).ToList();
List<Restrictions> restrictionList = new List<Restrictions>();
restriction.DepositoryType = new Dictionary<int, string>();
restriction.EFcutoff = new Dictionary<int, string>();
restriction.Other = new Dictionary<int, string>();
foreach (var item in response)
{
switch (item.ACMCategoryId)
{
case (Int32)AdRestrictionFlag.DepositoryType:
restriction.DepositoryType.Add(item.RestrictionID, item.ACMName);
break;
case (Int32)AdRestrictionFlag.EFcutoff:
restriction.EFcutoff.Add(item.RestrictionID, item.ACMName);
break;
case (Int32)AdRestrictionFlag.Other:
restriction.Other.Add(item.RestrictionID, item.ACMName);
break;
}
}
}
return restriction;
}
catch (Exception ex)
{
Error.WriteException(TraceEventType.Error, ex.Message.ToString(), "GetAdRestrictionCategory");
throw;
}
}
public List<GetDropDownListByID> GetFutureDeploymentPeriod(int campaignId, int deploymentPeriodId)
{
try
{
List<GetDropDownListByID> listItems = new List<GetDropDownListByID>();
using (ACM_Redesign2014Context ctx = new ACM_Redesign2014Context())
{
listItems = (ctx.Database.SqlQuery<GetDropDownListByID>("exec SP_GetFutureDeploymentPeriod @campaignId,@deploymentPeriodId",
new SqlParameter("campaignId", campaignId),
new SqlParameter("deploymentPeriodId", deploymentPeriodId)
)).ToList();
}
return listItems;
}
catch (Exception ex)
{
Error.WriteException(TraceEventType.Error, ex.Message.ToString(), "GetAvailableDeploymentPeriod");
throw;
}
}
public string CampaignMainFrameMod(CampaignMainFrame request)
{
try
{
using (ACM_Redesign2014Context ctx = new ACM_Redesign2014Context())
{
ctx.Entry(request).State = EntityState.Modified;
ctx.SaveChanges();
}
}
catch (Exception ex)
{
Error.WriteException(TraceEventType.Error, ex.Message.ToString(), "CampaignMainFrameMod");
throw;
}
return "Successfully updated";
}
public List<AdOutStandingTask> GetOutstandingTask(ACM.Model.Ad request)
{
List<AdOutStandingTask> response = new List<AdOutStandingTask>();
try
{
using (ctx = new ACM_Redesign2014Context())
{
ctx.Configuration.LazyLoadingEnabled = true;
response = (from tasks in ctx.AdOutStandingTasks
where tasks.AdId == request.AdId
select tasks).ToList();
}
return response;
}
catch (Exception ex)
{
Error.WriteException(TraceEventType.Error, ex.Message.ToString(), "GetOutstandingTask");
throw;
}
}
public string UpdateAdRestriction(ACM.Model.Ad request)
{
try
{
using (ACM_Redesign2014Context ctx = new ACM_Redesign2014Context())
{
var listAd = (from ads in ctx.Ads
where ads.CampaignId == request.CampaignId
select ads.AdId).ToList();
var some = ctx.Ads.Where(x => listAd.Contains(x.AdId)).ToList();
some.ForEach(a => a.AdRestrictionId = request.AdRestrictionId);
ctx.SaveChanges();
}
}
catch (Exception ex)
{
Error.WriteException(TraceEventType.Error, ex.Message.ToString(), "UpdateAdRestriction");
throw;
}
return "Ad restriction applied for the campaign";
}
public ACM.Model.DeploymentPeriod DeploymentPeriodInquiry(ACM.Model.DeploymentPeriod request)
{
ACM.Model.DeploymentPeriod response = new ACM.Model.DeploymentPeriod();
try
{
using (ACM_Redesign2014Context ctx = new ACM_Redesign2014Context())
{
ctx.Configuration.LazyLoadingEnabled = true;
ctx.Configuration.ProxyCreationEnabled = false;
if (request != null)
{
response = ctx.DeploymentPeriods.Find(request.DeploymentPeriodId);
}
}
}
catch (Exception ex)
{
Error.WriteException(TraceEventType.Error, ex.Message.ToString(), "DeploymentPeriodInquiry");
throw;
}
return response;
}
