private ListManager()
{
SlideHeaders = new List <string>();
Websites = new List <string>();
Strengths = new List <string>();
Categories = new List <Category>();
ProductSources = new List <ProductSource>();
Statuses = new List <string>();
PricingStrategies = new List <string>();
ColumnPositions = new List <string>();
SpecialLinksGroupName = String.Empty;
SpecialLinkButtons = new List <SpecialLinkButton>();
SpecialLinkBrowsers = new List <string>();
TargetingRecods = new List <ProductInfo>();
RichMediaRecods = new List <ProductInfo>();
DefaultHomeViewSettings = new DigitalProductListViewSettings();
DefaultDigitalProductSettings = new DigitalProductSettings();
DefaultDigitalProductPackageSettings = new DigitalTemplatePackageSettings();
DefaultDigitalStandalonePackageSettings = new DigitalTemplatePackageSettings();
DefaultControlsConfiguration = new DigitalControlsConfiguration();
Images = new List <ImageSourceGroup>();
}
public static void UpdateData()
{
var slideHeaders = new List<SlideHeader>();
var sites = new List<SlideHeader>();
var strengths = new List<SlideHeader>();
var products = new List<Product>();
var statuses = new List<SlideHeader>();
var defaultFormula = String.Empty;
var lockedMode = false;
var pricingStrategies = new List<string>();
var columnPositions = new List<string>();
var specialLinksEnable = false;
var specialLinksGroupName = String.Empty;
Image specialLinksGroupLogo = null;
var specialLinksBrowsers = new List<string>();
var specialLinkButtons = new List<SpecialLinkButton>();
var targetingRecords = new List<DigitalProductInfo>();
var richMediaRecords = new List<DigitalProductInfo>();
var defaultHomeViewSettings = new HomeViewSettings();
var defaultDigitalProductSettings = new DigitalProductSettings();
var defaultDigitalProductPackageSettings = new DigitalPackageSettings();
var defaultDigitalStandalonePackageSettings = new DigitalPackageSettings();
var controlsConfiguration = new DigitalControlsConfiguration();
var connnectionString = string.Format(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"";", Path.Combine(Application.StartupPath, SourceFileName));
var connection = new OleDbConnection(connnectionString);
try
{
connection.Open();
}
catch
{
AppManager.Instance.ShowWarning("Couldn't open source file");
return;
}
if (connection.State == ConnectionState.Open)
{
//Load Headers
var dataAdapter = new OleDbDataAdapter("SELECT * FROM [Headers$]", connection);
var dataTable = new DataTable();
slideHeaders.Clear();
try
{
dataAdapter.Fill(dataTable);
if (dataTable.Rows.Count > 0 && dataTable.Columns.Count > 0)
foreach (DataRow row in dataTable.Rows)
{
var title = new SlideHeader();
title.Value = row[0].ToString().Trim();
if (dataTable.Columns.Count > 1)
if (row[1] != null)
title.IsDefault = row[1].ToString().Trim().ToLower().Equals("d");
if (!string.IsNullOrEmpty(title.Value))
slideHeaders.Add(title);
}
slideHeaders.Sort((x, y) =>
{
var result = y.IsDefault.CompareTo(x.IsDefault);
if (result == 0)
result = 1;
return result;
});
}
catch
{
}
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
//Load Statuses
dataAdapter = new OleDbDataAdapter("SELECT * FROM [File-Status$]", connection);
dataTable = new DataTable();
statuses.Clear();
try
{
dataAdapter.Fill(dataTable);
if (dataTable.Rows.Count > 0 && dataTable.Columns.Count > 0)
foreach (DataRow row in dataTable.Rows)
{
var status = new SlideHeader();
status.Value = row[0].ToString().Trim();
if (dataTable.Columns.Count > 1)
if (row[1] != null)
status.IsDefault = row[1].ToString().Trim().ToLower().Equals("d");
if (!string.IsNullOrEmpty(status.Value))
statuses.Add(status);
}
statuses.Sort((x, y) =>
{
int result = y.IsDefault.CompareTo(x.IsDefault);
if (result == 0)
result = WinAPIHelper.StrCmpLogicalW(x.Value, y.Value);
return result;
});
}
catch
{
}
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
//Load Sites
dataAdapter = new OleDbDataAdapter("SELECT * FROM [Sites$]", connection);
dataTable = new DataTable();
sites.Clear();
try
{
dataAdapter.Fill(dataTable);
if (dataTable.Rows.Count > 0 && dataTable.Columns.Count > 0)
foreach (DataRow row in dataTable.Rows)
{
var site = new SlideHeader();
site.Value = row[0].ToString().Trim();
if (dataTable.Columns.Count > 1)
if (row[1] != null)
site.IsDefault = row[1].ToString().Trim().Equals("d", StringComparison.OrdinalIgnoreCase);
if (!string.IsNullOrEmpty(site.Value))
sites.Add(site);
}
}
catch
{
}
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
//Load Strengths
dataAdapter = new OleDbDataAdapter("SELECT * FROM [Strengths$]", connection);
dataTable = new DataTable();
strengths.Clear();
try
{
dataAdapter.Fill(dataTable);
if (dataTable.Rows.Count > 0 && dataTable.Columns.Count > 0)
foreach (DataRow row in dataTable.Rows)
{
var strength = new SlideHeader();
strength.Value = row[0].ToString().Trim();
if (dataTable.Columns.Count > 1)
if (row[1] != null)
strength.IsDefault = row[1].ToString().Trim().ToLower().Equals("d");
if (!string.IsNullOrEmpty(strength.Value))
strengths.Add(strength);
}
strengths.Sort((x, y) =>
{
var result = y.IsDefault.CompareTo(x.IsDefault);
if (result == 0)
result = WinAPIHelper.StrCmpLogicalW(x.Value, y.Value);
return result;
});
}
catch
{
}
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
//Load Default Formula
dataAdapter = new OleDbDataAdapter("SELECT * FROM [WebFormula$]", connection);
dataTable = new DataTable();
try
{
dataAdapter.Fill(dataTable);
if (dataTable.Rows.Count > 0 && dataTable.Columns.Count >= 2)
foreach (DataRow row in dataTable.Rows)
{
if (row[0] != null && row[1] != null && row[1].ToString().Trim().ToLower().Equals("d"))
{
defaultFormula = row[0].ToString();
break;
}
}
}
catch
{
}
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
//Load Locked Mode
dataAdapter = new OleDbDataAdapter("SELECT * FROM [LockedMode$]", connection);
dataTable = new DataTable();
try
{
dataAdapter.Fill(dataTable);
if (dataTable.Columns.Count > 0)
foreach (DataRow row in dataTable.Rows)
{
bool temp;
if (row[0] == null) continue;
var rowValue = row[0].ToString();
if (!String.IsNullOrEmpty(rowValue) &&
!rowValue.StartsWith("*") &&
Boolean.TryParse(rowValue, out temp))
{
lockedMode = temp;
break;
}
}
}
catch
{
}
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
//Load Pricing Strategy
dataAdapter = new OleDbDataAdapter("SELECT * FROM [PricingStrategy$]", connection);
dataTable = new DataTable();
try
{
dataAdapter.Fill(dataTable);
if (dataTable.Columns.Count > 0)
foreach (DataRow row in dataTable.Rows)
{
if (row[0] == null) continue;
var rowValue = row[0].ToString();
if (!String.IsNullOrEmpty(rowValue) && !pricingStrategies.Contains(rowValue))
pricingStrategies.Add(rowValue);
}
}
catch
{
}
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
//Load Position Column
dataAdapter = new OleDbDataAdapter("SELECT * FROM [PositionColumn$]", connection);
dataTable = new DataTable();
try
{
dataAdapter.Fill(dataTable);
if (dataTable.Columns.Count > 0)
foreach (DataRow row in dataTable.Rows)
{
if (row[0] == null) continue;
var rowValue = row[0].ToString();
if (!String.IsNullOrEmpty(rowValue) && !columnPositions.Contains(rowValue))
columnPositions.Add(rowValue);
}
}
catch
{
}
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
//Load Special Links Group
dataAdapter = new OleDbDataAdapter("SELECT * FROM [SpecialRBNLinks$A1:A2]", connection);
dataTable = new DataTable();
try
{
dataAdapter.Fill(dataTable);
if (dataTable.Columns.Count > 0)
foreach (DataRow row in dataTable.Rows)
{
if (row[0] == null) continue;
var rowValue = row[0].ToString();
bool temp;
if (!String.IsNullOrEmpty(rowValue) && Boolean.TryParse(rowValue, out temp))
{
specialLinksEnable = temp;
break;
}
}
}
catch
{
}
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
dataAdapter = new OleDbDataAdapter("SELECT * FROM [SpecialRBNLinks$A4:A5]", connection);
dataTable = new DataTable();
try
{
dataAdapter.Fill(dataTable);
if (dataTable.Columns.Count > 0)
foreach (DataRow row in dataTable.Rows)
{
var rowValue = row[0]?.ToString();
if (String.IsNullOrEmpty(rowValue)) continue;
specialLinksGroupName = rowValue;
var imageFilePath = Path.Combine(Application.StartupPath, SpecialButtonsImageSourceFolder, "!RibbonGroup.png");
if (File.Exists(imageFilePath))
specialLinksGroupLogo = new Bitmap(imageFilePath);
break;
}
}
catch
{
}
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
dataAdapter = new OleDbDataAdapter("SELECT * FROM [SpecialRBNLinks$A7:E8]", connection);
dataTable = new DataTable();
try
{
dataAdapter.Fill(dataTable);
if (dataTable.Columns.Count > 0)
foreach (DataRow row in dataTable.Rows)
{
var colCount = dataTable.Columns.Count;
for (var i = 0; i < colCount; i++)
{
if (row[i] == null) continue;
var rowValue = row[i].ToString().Trim();
if (String.IsNullOrEmpty(rowValue)) continue;
specialLinksBrowsers.Add(rowValue);
}
break;
}
}
catch
{
}
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
//Load Special Link Buttons
dataAdapter = new OleDbDataAdapter("SELECT * FROM [SpecialRBNLinks$A10:J30]", connection);
dataTable = new DataTable();
try
{
dataAdapter.Fill(dataTable);
foreach (DataRow row in dataTable.Rows)
{
var specialButton = new SpecialLinkButton();
var colCount = dataTable.Columns.Count;
for (var i = 0; i < colCount; i++)
{
if (row[i] == null) continue;
var rowValue = row[i].ToString().Trim();
if (String.IsNullOrEmpty(rowValue)) continue;
switch (i)
{
case 0:
specialButton.Name = rowValue;
break;
case 1:
specialButton.Type = rowValue;
break;
case 2:
specialButton.Tooltip = rowValue;
break;
case 3:
var imageFilePath = Path.Combine(Application.StartupPath, SpecialButtonsImageSourceFolder, rowValue);
if (File.Exists(imageFilePath))
specialButton.Image = new Bitmap(imageFilePath);
break;
default:
specialButton.Paths.Add(rowValue);
break;
}
}
if (!String.IsNullOrEmpty(specialButton.Name) && !String.IsNullOrEmpty(specialButton.Type) && specialButton.Paths.Any())
specialLinkButtons.Add(specialButton);
}
}
catch
{
}
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
//Load Targeting
dataAdapter = new OleDbDataAdapter("SELECT * FROM [TGT_Popup$]", connection);
dataTable = new DataTable();
try
{
dataAdapter.Fill(dataTable);
foreach (DataRow row in dataTable.Rows)
{
var digitalProductInfo = new DigitalProductInfo();
var colCount = dataTable.Columns.Count;
for (var i = 0; i < colCount; i++)
{
if (row[i] == null) continue;
var rowValue = row[i].ToString().Trim();
if (String.IsNullOrEmpty(rowValue)) continue;
switch (i)
{
case 0:
digitalProductInfo.Group = rowValue;
break;
case 1:
{
bool temp;
if (Boolean.TryParse(rowValue, out temp))
digitalProductInfo.Selected = temp;
}
break;
default:
digitalProductInfo.Phrases.Add(rowValue);
break;
}
}
if (!String.IsNullOrEmpty(digitalProductInfo.Group) && digitalProductInfo.Phrases.Any())
targetingRecords.Add(digitalProductInfo);
}
}
catch
{
}
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
//Load Rich Media
dataAdapter = new OleDbDataAdapter("SELECT * FROM [RM_Popup$]", connection);
dataTable = new DataTable();
try
{
dataAdapter.Fill(dataTable);
foreach (DataRow row in dataTable.Rows)
{
var digitalProductInfo = new DigitalProductInfo();
var colCount = dataTable.Columns.Count;
for (var i = 0; i < colCount; i++)
{
if (row[i] == null) continue;
var rowValue = row[i].ToString().Trim();
if (String.IsNullOrEmpty(rowValue)) continue;
switch (i)
{
case 0:
digitalProductInfo.Group = rowValue;
break;
case 1:
{
bool temp;
if (Boolean.TryParse(rowValue, out temp))
digitalProductInfo.Selected = temp;
}
break;
default:
digitalProductInfo.Phrases.Add(rowValue);
break;
}
}
if (!String.IsNullOrEmpty(digitalProductInfo.Group) && digitalProductInfo.Phrases.Any())
richMediaRecords.Add(digitalProductInfo);
}
}
catch
{
}
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
//Load Categories
GetCategories(connection);
dataAdapter = new OleDbDataAdapter("SELECT * FROM [Categories$]", connection);
dataTable = new DataTable();
try
{
dataAdapter.Fill(dataTable);
int i = 0;
if (dataTable.Rows.Count > 0 && dataTable.Columns.Count >= 4)
foreach (DataRow row in dataTable.Rows)
{
var originalName = row[0].ToString().Trim();
var schemaName = originalName
.Replace(".", "#")
.Replace("!", "_")
.Replace("`", "_")
.Replace("[", "(")
.Replace("]", ")");
var category = _categories.FirstOrDefault(x => x.Name.Equals(schemaName));
if (category != null)
{
category.Name = originalName;
category.Order = i;
category.TooltipTitle = row[1].ToString().Trim();
category.TooltipValue = row[2].ToString().Trim();
var filePath = Path.Combine(Application.StartupPath, CategoryImageSourceFolder, row[3].ToString().Trim());
if (File.Exists(filePath))
category.Logo = new Bitmap(filePath);
}
i++;
}
_categories.Sort((x, y) => x.Order.CompareTo(y.Order));
}
catch
{
}
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
//Load Products
products.Clear();
foreach (var category in _categories)
{
dataAdapter = new OleDbDataAdapter(
String.Format("SELECT * FROM [{0}$]",
category.Name
.Replace("!", "")
)
, connection);
dataTable = new DataTable();
try
{
dataAdapter.Fill(dataTable);
if (dataTable.Rows.Count > 0 && dataTable.Columns.Count >= 12)
foreach (DataRow row in dataTable.Rows)
{
var product = new Product();
product.SubCategory = row[0].ToString().Trim();
product.Name = row[1].ToString().Trim();
product.RateType = row[2].ToString().Trim();
product.Rate = row[3].ToString().Trim();
product.Width = row[4].ToString().Trim();
product.Height = row[5].ToString().Trim();
product.EnableTarget = row[6].ToString().Trim().ToLower() == "e";
product.EnableLocation = row[7].ToString().Trim().ToLower() == "e";
product.EnableRichMedia = row[8].ToString().Trim().ToLower() == "e";
product.Overview = row[9].ToString().Trim();
product.DefaultWebsite = row[10] != null ? row[10].ToString().Trim() : null;
product.EnableRate = row[11].ToString().Trim().ToLower() == "e";
product.Category = category;
if (!string.IsNullOrEmpty(product.Name))
products.Add(product);
}
}
catch(Exception ex)
{
}
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
}
//Load Home Settings
dataAdapter = new OleDbDataAdapter("SELECT * FROM [Home$]", connection);
dataTable = new DataTable();
try
{
dataAdapter.Fill(dataTable);
if (dataTable.Columns.Count >= 3)
foreach (DataRow row in dataTable.Rows)
{
var optionName = row[0] != null ? row[0].ToString().Trim() : null;
if (String.IsNullOrEmpty(optionName)) continue;
switch (optionName)
{
case "Ad Dimensions":
{
bool temp;
if (row[1] != null && Boolean.TryParse(row[1].ToString(), out temp))
defaultHomeViewSettings.EnableDigitalDimensions = temp;
if (row[2] != null && Boolean.TryParse(row[2].ToString(), out temp))
defaultHomeViewSettings.ShowDigitalDimensions = temp;
}
break;
case "Location":
{
bool temp;
if (row[1] != null && Boolean.TryParse(row[1].ToString(), out temp))
defaultHomeViewSettings.EnableDigitalLocation = temp;
if (row[2] != null && Boolean.TryParse(row[2].ToString(), out temp))
defaultHomeViewSettings.ShowDigitalLocation = temp;
}
break;
case "Pricing Strategy":
{
bool temp;
if (row[1] != null && Boolean.TryParse(row[1].ToString(), out temp))
defaultHomeViewSettings.EnableDigitalStrategy = temp;
if (row[2] != null && Boolean.TryParse(row[2].ToString(), out temp))
defaultHomeViewSettings.ShowDigitalStrategy = temp;
}
break;
case "Rich Media":
{
bool temp;
if (row[1] != null && Boolean.TryParse(row[1].ToString(), out temp))
defaultHomeViewSettings.EnableDigitalRichMedia = temp;
if (row[2] != null && Boolean.TryParse(row[2].ToString(), out temp))
defaultHomeViewSettings.ShowDigitalRichMedia = temp;
}
break;
case "Targeting":
{
bool temp;
if (row[1] != null && Boolean.TryParse(row[1].ToString(), out temp))
defaultHomeViewSettings.EnableDigitalTargeting = temp;
if (row[2] != null && Boolean.TryParse(row[2].ToString(), out temp))
defaultHomeViewSettings.ShowDigitalTargeting = temp;
}
break;
}
}
}
catch
{
}
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
//Load Digital Product Settings
dataAdapter = new OleDbDataAdapter("SELECT * FROM [WebSlide$]", connection);
dataTable = new DataTable();
try
{
dataAdapter.Fill(dataTable);
if (dataTable.Columns.Count >= 3)
foreach (DataRow row in dataTable.Rows)
{
var optionName = row[0] != null ? row[0].ToString().Trim() : null;
if (String.IsNullOrEmpty(optionName)) continue;
switch (optionName)
{
case "Strategy":
{
bool temp;
if (row[1] != null && Boolean.TryParse(row[1].ToString(), out temp))
defaultDigitalProductSettings.EnableCategory = temp;
if (row[2] != null && Boolean.TryParse(row[2].ToString(), out temp))
defaultDigitalProductSettings.ShowCategory = temp;
}
break;
case "Campaign Dates":
{
bool temp;
if (row[1] != null && Boolean.TryParse(row[1].ToString(), out temp))
defaultDigitalProductSettings.EnableFlightDates = temp;
if (row[2] != null && Boolean.TryParse(row[2].ToString(), out temp))
defaultDigitalProductSettings.ShowFlightDates = temp;
}
break;
case "Duration":
{
bool temp;
if (row[1] != null && Boolean.TryParse(row[1].ToString(), out temp))
defaultDigitalProductSettings.EnableDuration = temp;
if (row[2] != null && Boolean.TryParse(row[2].ToString(), out temp))
defaultDigitalProductSettings.ShowDuration = temp;
}
break;
case "Pricing Default":
{
int temp;
if (row[2] != null && Int32.TryParse(row[2].ToString(), out temp))
defaultDigitalProductSettings.DefaultPricing = temp;
}
break;
}
}
}
catch
{
}
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
//Load Digital Package Settings
dataAdapter = new OleDbDataAdapter("SELECT * FROM [DigPkgA$]", connection);
dataTable = new DataTable();
try
{
dataAdapter.Fill(dataTable);
if (dataTable.Columns.Count >= 3)
foreach (DataRow row in dataTable.Rows)
{
var optionName = row[0]?.ToString().Trim();
if (String.IsNullOrEmpty(optionName)) continue;
switch (optionName)
{
case "Category":
{
bool temp;
if (row[1] != null && Boolean.TryParse(row[1].ToString(), out temp))
defaultDigitalProductPackageSettings.EnableCategory = temp;
if (row[2] != null && Boolean.TryParse(row[2].ToString(), out temp))
defaultDigitalProductPackageSettings.ShowCategory = temp;
}
break;
case "Group":
{
bool temp;
if (row[1] != null && Boolean.TryParse(row[1].ToString(), out temp))
defaultDigitalProductPackageSettings.EnableGroup = temp;
if (row[2] != null && Boolean.TryParse(row[2].ToString(), out temp))
defaultDigitalProductPackageSettings.ShowGroup = temp;
}
break;
case "Product":
{
bool temp;
if (row[1] != null && Boolean.TryParse(row[1].ToString(), out temp))
defaultDigitalProductPackageSettings.EnableProduct = temp;
if (row[2] != null && Boolean.TryParse(row[2].ToString(), out temp))
defaultDigitalProductPackageSettings.ShowProduct = temp;
}
break;
case "Impressions":
{
bool temp;
if (row[1] != null && Boolean.TryParse(row[1].ToString(), out temp))
defaultDigitalProductPackageSettings.EnableImpressions = temp;
if (row[2] != null && Boolean.TryParse(row[2].ToString(), out temp))
defaultDigitalProductPackageSettings.ShowImpressions = temp;
}
break;
case "CPM":
{
bool temp;
if (row[1] != null && Boolean.TryParse(row[1].ToString(), out temp))
defaultDigitalProductPackageSettings.EnableCPM = temp;
if (row[2] != null && Boolean.TryParse(row[2].ToString(), out temp))
defaultDigitalProductPackageSettings.ShowCPM = temp;
}
break;
case "Rate":
{
bool temp;
if (row[1] != null && Boolean.TryParse(row[1].ToString(), out temp))
defaultDigitalProductPackageSettings.EnableRate = temp;
if (row[2] != null && Boolean.TryParse(row[2].ToString(), out temp))
defaultDigitalProductPackageSettings.ShowRate = temp;
}
break;
case "Investment":
{
bool temp;
if (row[1] != null && Boolean.TryParse(row[1].ToString(), out temp))
defaultDigitalProductPackageSettings.EnableInvestment = temp;
if (row[2] != null && Boolean.TryParse(row[2].ToString(), out temp))
defaultDigitalProductPackageSettings.ShowInvestment = temp;
}
break;
case "Schedule Info":
{
bool temp;
if (row[1] != null && Boolean.TryParse(row[1].ToString(), out temp))
defaultDigitalProductPackageSettings.EnableInfo = temp;
if (row[2] != null && Boolean.TryParse(row[2].ToString(), out temp))
defaultDigitalProductPackageSettings.ShowInfo = temp;
}
break;
case "Campaign":
{
bool temp;
if (row[1] != null && Boolean.TryParse(row[1].ToString(), out temp))
defaultDigitalProductPackageSettings.EnableLocation = temp;
if (row[2] != null && Boolean.TryParse(row[2].ToString(), out temp))
defaultDigitalProductPackageSettings.ShowLocation = temp;
}
break;
case "Screenshot":
{
bool temp;
if (row[1] != null && Boolean.TryParse(row[1].ToString(), out temp))
defaultDigitalProductPackageSettings.EnableScreenshot = temp;
if (row[2] != null && Boolean.TryParse(row[2].ToString(), out temp))
defaultDigitalProductPackageSettings.ShowScreenshot = temp;
}
break;
}
}
}
catch
{ }
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
//Load Digital Standalone Package Settings
dataAdapter = new OleDbDataAdapter("SELECT * FROM [DigPkgB$]", connection);
dataTable = new DataTable();
try
{
dataAdapter.Fill(dataTable);
if (dataTable.Columns.Count >= 3)
foreach (DataRow row in dataTable.Rows)
{
var optionName = row[0]?.ToString().Trim();
if (String.IsNullOrEmpty(optionName)) continue;
switch (optionName)
{
case "Category":
{
bool temp;
if (row[1] != null && Boolean.TryParse(row[1].ToString(), out temp))
defaultDigitalStandalonePackageSettings.EnableCategory = temp;
if (row[2] != null && Boolean.TryParse(row[2].ToString(), out temp))
defaultDigitalStandalonePackageSettings.ShowCategory = temp;
}
break;
case "Group":
{
bool temp;
if (row[1] != null && Boolean.TryParse(row[1].ToString(), out temp))
defaultDigitalStandalonePackageSettings.EnableGroup = temp;
if (row[2] != null && Boolean.TryParse(row[2].ToString(), out temp))
defaultDigitalStandalonePackageSettings.ShowGroup = temp;
}
break;
case "Product":
{
bool temp;
if (row[1] != null && Boolean.TryParse(row[1].ToString(), out temp))
defaultDigitalStandalonePackageSettings.EnableProduct = temp;
if (row[2] != null && Boolean.TryParse(row[2].ToString(), out temp))
defaultDigitalStandalonePackageSettings.ShowProduct = temp;
}
break;
case "Impressions":
{
bool temp;
if (row[1] != null && Boolean.TryParse(row[1].ToString(), out temp))
defaultDigitalStandalonePackageSettings.EnableImpressions = temp;
if (row[2] != null && Boolean.TryParse(row[2].ToString(), out temp))
defaultDigitalStandalonePackageSettings.ShowImpressions = temp;
}
break;
case "CPM":
{
bool temp;
if (row[1] != null && Boolean.TryParse(row[1].ToString(), out temp))
defaultDigitalStandalonePackageSettings.EnableCPM = temp;
if (row[2] != null && Boolean.TryParse(row[2].ToString(), out temp))
defaultDigitalStandalonePackageSettings.ShowCPM = temp;
}
break;
case "Rate":
{
bool temp;
if (row[1] != null && Boolean.TryParse(row[1].ToString(), out temp))
defaultDigitalStandalonePackageSettings.EnableRate = temp;
if (row[2] != null && Boolean.TryParse(row[2].ToString(), out temp))
defaultDigitalStandalonePackageSettings.ShowRate = temp;
}
break;
case "Investment":
{
bool temp;
if (row[1] != null && Boolean.TryParse(row[1].ToString(), out temp))
defaultDigitalStandalonePackageSettings.EnableInvestment = temp;
if (row[2] != null && Boolean.TryParse(row[2].ToString(), out temp))
defaultDigitalStandalonePackageSettings.ShowInvestment = temp;
}
break;
case "Schedule Info":
{
bool temp;
if (row[1] != null && Boolean.TryParse(row[1].ToString(), out temp))
defaultDigitalStandalonePackageSettings.EnableInfo = temp;
if (row[2] != null && Boolean.TryParse(row[2].ToString(), out temp))
defaultDigitalStandalonePackageSettings.ShowInfo = temp;
}
break;
case "Campaign":
{
bool temp;
if (row[1] != null && Boolean.TryParse(row[1].ToString(), out temp))
defaultDigitalStandalonePackageSettings.EnableLocation = temp;
if (row[2] != null && Boolean.TryParse(row[2].ToString(), out temp))
defaultDigitalStandalonePackageSettings.ShowLocation = temp;
}
break;
case "Screenshot":
{
bool temp;
if (row[1] != null && Boolean.TryParse(row[1].ToString(), out temp))
defaultDigitalStandalonePackageSettings.EnableScreenshot = temp;
if (row[2] != null && Boolean.TryParse(row[2].ToString(), out temp))
defaultDigitalStandalonePackageSettings.ShowScreenshot = temp;
}
break;
}
}
}
catch
{ }
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
connection.Close();
connnectionString = string.Format(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=""Excel 8.0;HDR=No;IMEX=1"";", Path.Combine(Application.StartupPath, SourceFileName));
connection = new OleDbConnection(connnectionString);
try
{
connection.Open();
}
catch
{
AppManager.Instance.ShowWarning("Couldn't open source file");
return;
}
if (connection.State != ConnectionState.Open) return;
//Load Digital Tab Controls Configuration
dataAdapter = new OleDbDataAdapter("SELECT * FROM [DigitalRBNLabels$]", connection);
dataTable = new DataTable();
try
{
dataAdapter.Fill(dataTable);
var groupName = String.Empty;
var groupValues = new List<string>();
foreach (DataRow row in dataTable.Rows)
{
var rowValue = row[0]?.ToString().Trim();
if (String.IsNullOrEmpty(rowValue)) continue;
if (rowValue.Contains("*"))
{
if (!String.IsNullOrEmpty(groupName) && groupValues.Any())
controlsConfiguration.ApplyValues(groupName, groupValues);
groupName = rowValue.Replace("*", "");
groupValues.Clear();
}
else
groupValues.Add(rowValue);
}
if (!String.IsNullOrEmpty(groupName) && groupValues.Any())
controlsConfiguration.ApplyValues(groupName, groupValues);
}
catch
{
}
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
//Load Digital Section Controls Configuration
dataAdapter = new OleDbDataAdapter("SELECT * FROM [DigitalSubScheduleLabels$]", connection);
dataTable = new DataTable();
try
{
dataAdapter.Fill(dataTable);
var groupName = String.Empty;
var groupValues = new List<string>();
foreach (DataRow row in dataTable.Rows)
{
var rowValue = row[0]?.ToString().Trim();
if (String.IsNullOrEmpty(rowValue)) continue;
if (rowValue.Contains("*"))
{
if (!String.IsNullOrEmpty(groupName) && groupValues.Any())
controlsConfiguration.ApplyValues(groupName, groupValues);
groupName = rowValue.Replace("*", "");
groupValues.Clear();
}
else
groupValues.Add(rowValue);
}
if (!String.IsNullOrEmpty(groupName) && groupValues.Any())
controlsConfiguration.ApplyValues(groupName, groupValues);
}
catch
{
}
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
connection.Close();
}
//Save XML
var converter = TypeDescriptor.GetConverter(typeof(Bitmap));
var xml = new StringBuilder();
xml.AppendLine("<OnlineStrategy>");
foreach (var header in slideHeaders)
{
xml.Append(@"<Header ");
xml.Append("Value = \"" + header.Value.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.AppendLine(@"/>");
}
foreach (var status in statuses)
{
xml.Append(@"<Status ");
xml.Append("Value = \"" + status.Value.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.AppendLine(@"/>");
}
foreach (var site in sites)
{
xml.Append(@"<Site ");
xml.Append("Value = \"" + site.Value.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.AppendLine(@"/>");
}
foreach (var strength in strengths)
{
xml.Append(@"<Strength ");
xml.Append("Value = \"" + strength.Value.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.AppendLine(@"/>");
}
xml.AppendLine("<DefaultFormula>" + defaultFormula.Replace(@"&", "&").Replace("\"", """) + "</DefaultFormula>");
xml.AppendLine("<LockedMode>" + lockedMode + "</LockedMode>");
foreach (var pricingStrategy in pricingStrategies)
{
xml.Append(@"<PricingStrategy ");
xml.Append("Value = \"" + pricingStrategy.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.AppendLine(@"/>");
}
foreach (var columnPosition in columnPositions)
{
xml.Append(@"<PositionColumn ");
xml.Append("Value = \"" + columnPosition.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.AppendLine(@"/>");
}
xml.AppendLine("<SpecialLinksEnable>" + specialLinksEnable + "</SpecialLinksEnable>");
xml.AppendLine("<SpecialButtonsGroupName>" + specialLinksGroupName.Replace(@"&", "&").Replace("\"", """) + "</SpecialButtonsGroupName>");
if (specialLinksGroupLogo != null)
xml.AppendLine("<SpecialButtonsGroupLogo>" + Convert.ToBase64String((byte[])converter.ConvertTo(specialLinksGroupLogo, typeof(byte[]))).Replace(@"&", "&").Replace("\"", """) + "</SpecialButtonsGroupLogo>");
foreach (var browser in specialLinksBrowsers)
xml.AppendLine("<Browser>" + browser + "</Browser>");
foreach (var specialLinkButton in specialLinkButtons)
{
xml.Append(@"<SpecialButton ");
xml.Append("Name = \"" + specialLinkButton.Name.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.Append("Type = \"" + specialLinkButton.Type.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.Append("Tooltip = \"" + specialLinkButton.Tooltip.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.Append("Image = \"" + Convert.ToBase64String((byte[])converter.ConvertTo(specialLinkButton.Image, typeof(byte[]))).Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.AppendLine(@">");
foreach (var path in specialLinkButton.Paths)
xml.AppendLine(String.Format(@"<Path>{0}</Path>", path.Replace(@"&", "&").Replace("\"", """)));
xml.AppendLine(@"</SpecialButton>");
}
foreach (var productInfo in targetingRecords)
xml.AppendLine(String.Format(@"<Targeting>{0}</Targeting>", productInfo.Serialize()));
foreach (var productInfo in richMediaRecords)
xml.AppendLine(String.Format(@"<RichMedia>{0}</RichMedia>", productInfo.Serialize()));
foreach (var category in _categories.Where(c => !String.IsNullOrEmpty(c.Name) && !String.IsNullOrEmpty(c.TooltipTitle) && !String.IsNullOrEmpty(c.TooltipValue) && c.Logo != null))
{
xml.Append(@"<Category ");
xml.Append("Name = \"" + category.Name.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.Append("TooltipTitle = \"" + category.TooltipTitle.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.Append("TooltipValue = \"" + category.TooltipValue.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.Append("Logo = \"" + Convert.ToBase64String((byte[])converter.ConvertTo(category.Logo, typeof(byte[]))).Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.AppendLine(@"/>");
}
foreach (var product in products)
{
xml.Append(@"<Product ");
xml.Append("Category = \"" + product.Category.Name.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.Append("SubCategory = \"" + product.SubCategory.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.Append("Name = \"" + product.Name.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.Append("RateType = \"" + product.RateType.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.Append("Rate = \"" + product.Rate.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.Append("Width = \"" + product.Width.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.Append("Height = \"" + product.Height.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.Append("EnableTarget = \"" + product.EnableTarget + "\" ");
xml.Append("EnableLocation = \"" + product.EnableLocation + "\" ");
xml.Append("EnableRichMedia = \"" + product.EnableRichMedia + "\" ");
xml.Append("EnableRate = \"" + product.EnableRate + "\" ");
xml.Append("Overview = \"" + product.Overview.Replace(@"&", "&").Replace("\"", """) + "\" ");
if (!String.IsNullOrEmpty(product.DefaultWebsite))
xml.Append("DefaultWebsite = \"" + product.DefaultWebsite.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.AppendLine(@"/>");
}
xml.AppendLine(String.Format(@"<DefaultHomeViewSettings>{0}</DefaultHomeViewSettings>", defaultHomeViewSettings.Serialize()));
xml.AppendLine(String.Format(@"<DefaultDigitalProductSettings>{0}</DefaultDigitalProductSettings>", defaultDigitalProductSettings.Serialize()));
xml.AppendLine(String.Format(@"<DefaultDigitalProductPackageSettings>{0}</DefaultDigitalProductPackageSettings>", defaultDigitalProductPackageSettings.Serialize()));
xml.AppendLine(String.Format(@"<DefaultDigitalStandalonePackageSettings>{0}</DefaultDigitalStandalonePackageSettings>", defaultDigitalStandalonePackageSettings.Serialize()));
xml.AppendLine(String.Format(@"<DigitalControlsConfiguration>{0}</DigitalControlsConfiguration>", Convert.ToBase64String(Encoding.Unicode.GetBytes(JsonConvert.SerializeObject(controlsConfiguration, Formatting.None, new JsonImageConverter())))));
xml.AppendLine(@"</OnlineStrategy>");
var xmlPath = Path.Combine(Application.StartupPath, DestinationFileName);
using (var sw = new StreamWriter(xmlPath, false))
{
sw.Write(xml.ToString());
sw.Flush();
}
ProductionFilesUpdateHelper.UpdateProductionFies(xmlPath);
AppManager.Instance.ShowInformation("Data was updated.");
}
