private static void GetDayparts(OleDbConnection connection)
{
try
{
_dayparts.Clear();
var dataTable = connection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
foreach (DataRow row in dataTable.Rows)
{
var daypart = new NameCodePair();
daypart.Name = row["TABLE_NAME"].ToString().Replace("$", "").Replace('"'.ToString(), "'").Replace("'", "");
if (!new[]
{
"Headers-Positioning Point",
"Length",
"Dayparts",
"Stations",
"Client Type",
"Date",
"Custom Demos",
"Sources",
"File-Status",
"Toggle Defaults"
}.Contains(daypart.Name.Trim()))
_dayparts.Add(daypart);
}
}
catch
{
}
}
public static void UpdateData()
{
bool tempBool;
int tempInt;
bool allowToLoad;
var slideHeaders = new List<SlideHeader>();
var publications = new List<Publication>();
var adSizes = new List<AdSize>();
var notes = new List<NameCodePair>();
var clientTypes = new List<string>();
var sections = new List<Section>();
var mechanicals = new List<MechanicalType>();
var deadlines = new List<string>();
var statuses = new List<SlideHeader>();
var shareUnits = new List<ShareUnit>();
string selectedNotesBorderValue = string.Empty;
string selectedSectionsBorderValue = string.Empty;
var defaultHomeViewSettings = new HomeViewSettings();
var defaultPrintScheduleViewSettings = new PrintScheduleViewSettings();
var defaultPublicationBasicOverviewSettings = new PublicationBasicOverviewSettings();
var defaultPublicationMultiSummarySettings = new PublicationMultiSummarySettings();
var defaultSnapshotViewSettings = new SnapshotViewSettings();
var defaultDetailedGridColumnState = new GridColumnsState();
var defaultDetailedGridAdNotesState = new AdNotesState();
var defaultDetailedGridSlideBulletsState = new SlideBulletsState();
var defaultDetailedGridSlideHeaderState = new SlideHeaderState();
var defaultMultiGridColumnState = new GridColumnsState();
var defaultMultiGridAdNotesState = new AdNotesState();
var defaultMultiGridSlideBulletsState = new SlideBulletsState();
var defaultMultiGridSlideHeaderState = new SlideHeaderState();
var defaultCalendarViewSettings = new CalendarViewSettings();
string 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));
var connection = new OleDbConnection(connnectionString);
try
{
connection.Open();
}
catch
{
AppManager.Instance.ShowWarning("Couldn't open source file");
return;
}
if (connection.State == ConnectionState.Open)
{
DataTable dataTable;
#region Load Headers
OleDbDataAdapter dataAdapter = new OleDbDataAdapter("SELECT * FROM [Headers$]", connection);
dataTable = new DataTable();
bool loadHeaders = false;
slideHeaders.Clear();
try
{
dataAdapter.Fill(dataTable);
if (dataTable.Rows.Count > 0 && dataTable.Columns.Count > 0)
foreach (DataRow row in dataTable.Rows)
{
if (row[0].ToString().Trim().Equals("*Ad Schedule Slide Headers"))
{
loadHeaders = true;
continue;
}
if (loadHeaders)
{
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) =>
{
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();
}
#endregion
#region Load Statuses
dataAdapter = new OleDbDataAdapter("SELECT * FROM [File-Status$]", connection);
dataTable = new DataTable();
loadHeaders = false;
statuses.Clear();
try
{
dataAdapter.Fill(dataTable);
if (dataTable.Rows.Count > 0 && dataTable.Columns.Count > 0)
foreach (DataRow row in dataTable.Rows)
{
if (row[0].ToString().Trim().Equals("*File-Status"))
{
loadHeaders = true;
continue;
}
if (loadHeaders)
{
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 = 1;
return result;
});
}
catch { }
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
#endregion
#region Load Publications
dataAdapter = new OleDbDataAdapter("SELECT * FROM [Publications$]", connection);
dataTable = new DataTable();
bool loadPublications = false;
publications.Clear();
try
{
dataAdapter.Fill(dataTable);
if (dataTable.Rows.Count > 0 && dataTable.Columns.Count >= 16)
foreach (DataRow row in dataTable.Rows)
{
if (row[0].ToString().Trim().Equals("User-Entry"))
{
loadPublications = true;
continue;
}
if (loadPublications)
{
var publication = new Publication();
publication.Name = row[0].ToString().Trim();
if (row[1] != null)
publication.SortOrder = row[1].ToString().Trim();
if (row[2] != null)
publication.Abbreviation = row[2].ToString().Trim();
if (row[3] != null)
publication.BigLogo = row[3].ToString().Trim();
if (row[4] != null)
publication.LittleLogo = row[4].ToString().Trim();
if (row[5] != null)
publication.TinyLogo = row[5].ToString().Trim();
if (row[6] != null)
publication.DailyCirculation = row[6].ToString().Trim();
if (row[7] != null)
publication.DailyReadership = row[7].ToString().Trim();
if (row[8] != null)
publication.SundayCirculation = row[8].ToString().Trim();
if (row[9] != null)
publication.SundayReadership = row[9].ToString().Trim();
if (row[10] != null)
publication.AllowSundaySelect = row[10].ToString().Trim().ToLower().Equals("y");
if (row[11] != null)
publication.AllowMondaySelect = row[11].ToString().Trim().ToLower().Equals("y");
if (row[12] != null)
publication.AllowTuesdaySelect = row[12].ToString().Trim().ToLower().Equals("y");
if (row[13] != null)
publication.AllowWednesdaySelect = row[13].ToString().Trim().ToLower().Equals("y");
if (row[14] != null)
publication.AllowThursdaySelect = row[14].ToString().Trim().ToLower().Equals("y");
if (row[15] != null)
publication.AllowFridaySelect = row[15].ToString().Trim().ToLower().Equals("y");
if (row[16] != null)
publication.AllowSaturdaySelect = row[16].ToString().Trim().ToLower().Equals("y");
if (!string.IsNullOrEmpty(publication.Name))
publications.Add(publication);
}
}
publications.Sort((x, y) => x.SortOrder.CompareTo(y.SortOrder) == 0 ? WinAPIHelper.StrCmpLogicalW(x.Name, y.Name) : (string.IsNullOrEmpty(x.SortOrder) ? "z" : x.SortOrder).CompareTo((string.IsNullOrEmpty(y.SortOrder) ? "z" : y.SortOrder)));
}
catch { }
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
#endregion
#region Load AdSizes
dataAdapter = new OleDbDataAdapter("SELECT * FROM [Ad-Sizes$]", connection);
dataTable = new DataTable();
adSizes.Clear();
try
{
dataAdapter.Fill(dataTable);
foreach (DataColumn column in dataTable.Columns)
{
var groupName = String.Empty;
foreach (DataRow row in dataTable.Rows)
{
var rowValue = row[column] as String;
if (String.IsNullOrEmpty(rowValue)) break;
if (rowValue.StartsWith("*"))
{
groupName = rowValue.Replace("*", String.Empty);
continue;
}
if (String.IsNullOrEmpty(groupName)) continue;
adSizes.Add(new AdSize { Group = groupName, Name = rowValue });
}
}
}
catch { }
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
#endregion
#region Load ShareUnits
dataAdapter = new OleDbDataAdapter("SELECT * FROM [Share-Units$]", connection);
dataTable = new DataTable();
bool loadShareUnits = false;
shareUnits.Clear();
try
{
dataAdapter.Fill(dataTable);
if (dataTable.Rows.Count > 0 && dataTable.Columns.Count >= 6)
foreach (DataRow row in dataTable.Rows)
{
if (row[0].ToString().Trim().Equals("*Rate Card"))
{
loadShareUnits = true;
continue;
}
if (loadShareUnits)
{
var shareUnit = new ShareUnit();
if (row[0] != null)
shareUnit.RateCard = row[0].ToString().Trim();
if (row[1] != null)
shareUnit.PercentOfPage = row[1].ToString().Trim();
if (row[2] != null)
shareUnit.Width = row[2].ToString().Trim();
if (row[3] != null)
shareUnit.WidthMeasureUnit = row[3].ToString().Trim();
if (row[4] != null)
shareUnit.Height = row[4].ToString().Trim();
if (row[5] != null)
shareUnit.HeightMeasureUnit = row[5].ToString().Trim();
if (!string.IsNullOrEmpty(shareUnit.RateCard))
shareUnits.Add(shareUnit);
}
}
}
catch { }
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
#endregion
#region Load Notes
dataAdapter = new OleDbDataAdapter("SELECT * FROM [Notes$]", connection);
dataTable = new DataTable();
bool loadNotes = false;
notes.Clear();
try
{
dataAdapter.Fill(dataTable);
if (dataTable.Rows.Count > 0 && dataTable.Columns.Count > 0)
foreach (DataRow row in dataTable.Rows)
{
if (row[0].ToString().Trim().Equals("*Notes Library"))
{
loadNotes = true;
if (dataTable.Columns.Count >= 2)
selectedNotesBorderValue = row[1].ToString().Trim();
continue;
}
if (loadNotes)
{
var note = new NameCodePair();
note.Name = row[0].ToString().Trim();
if (dataTable.Columns.Count >= 2)
note.Code = row[1].ToString().Trim();
if (!string.IsNullOrEmpty(note.Name))
notes.Add(note);
}
}
}
catch { }
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
#endregion
#region Load Client Types
dataAdapter = new OleDbDataAdapter("SELECT * FROM [Client Type$]", connection);
dataTable = new DataTable();
bool loadClientTypes = false;
clientTypes.Clear();
try
{
dataAdapter.Fill(dataTable);
if (dataTable.Rows.Count > 0 && dataTable.Columns.Count > 0)
foreach (DataRow row in dataTable.Rows)
{
if (row[0].ToString().Trim().Equals("*Client Type"))
{
loadClientTypes = true;
continue;
}
if (loadClientTypes)
{
string clientType = row[0].ToString().Trim();
if (!string.IsNullOrEmpty(clientType))
clientTypes.Add(clientType);
}
}
}
catch { }
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
#endregion
#region Load Sections
dataAdapter = new OleDbDataAdapter("SELECT * FROM [Sections$]", connection);
dataTable = new DataTable();
bool loadSections = false;
sections.Clear();
try
{
dataAdapter.Fill(dataTable);
if (dataTable.Rows.Count > 0 && dataTable.Columns.Count > 0)
foreach (DataRow row in dataTable.Rows)
{
if (row[0].ToString().Trim().Equals("*Sections"))
{
loadSections = true;
if (dataTable.Columns.Count >= 2)
selectedSectionsBorderValue = row[1].ToString().Trim();
continue;
}
if (loadSections)
{
var section = new Section();
section.Name = row[0].ToString().Trim();
if (dataTable.Columns.Count > 1)
if (row[1] != null)
section.Abbreviation = row[1].ToString().Trim();
if (!string.IsNullOrEmpty(section.Name))
sections.Add(section);
}
}
}
catch { }
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
#endregion
#region Load Mechanicals
dataAdapter = new OleDbDataAdapter("SELECT * FROM [Mechanicals$]", connection);
dataTable = new DataTable();
mechanicals.Clear();
MechanicalType mechanicalType = null;
try
{
dataAdapter.Fill(dataTable);
if (dataTable.Rows.Count > 0 && dataTable.Columns.Count > 0)
foreach (DataRow row in dataTable.Rows)
{
if (row[0].ToString().Trim().Contains("*") && !row[0].ToString().Trim().Contains("*Comment:"))
{
if (mechanicalType != null)
mechanicals.Add(mechanicalType);
mechanicalType = new MechanicalType();
mechanicalType.Name = row[0].ToString().Replace("*", "");
continue;
}
if (mechanicalType != null)
{
var mechanicalItem = new MechanicalItem();
mechanicalItem.Name = row[0].ToString().Trim();
if (dataTable.Columns.Count > 1)
if (row[1] != null)
mechanicalItem.Value = row[1].ToString().Trim();
if (!string.IsNullOrEmpty(mechanicalItem.Name))
mechanicalType.Items.Add(mechanicalItem);
}
}
if (mechanicalType != null)
mechanicals.Add(mechanicalType);
}
catch { }
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
#endregion
#region Load Deadlines
dataAdapter = new OleDbDataAdapter("SELECT * FROM [Deadlines$]", connection);
dataTable = new DataTable();
bool loadDeadlines = false;
deadlines.Clear();
try
{
dataAdapter.Fill(dataTable);
if (dataTable.Rows.Count > 0 && dataTable.Columns.Count > 0)
foreach (DataRow row in dataTable.Rows)
{
if (row[0].ToString().Trim().Equals("*Deadlines"))
{
loadDeadlines = true;
continue;
}
if (loadDeadlines)
{
string deadline = row[0].ToString().Trim();
if (!string.IsNullOrEmpty(deadline))
deadlines.Add(deadline);
}
}
}
catch { }
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
#endregion
#region Load Default Home Settings
dataAdapter = new OleDbDataAdapter("SELECT * FROM [HOME$]", connection);
dataTable = new DataTable();
try
{
dataAdapter.Fill(dataTable);
if (dataTable.Rows.Count > 0 && dataTable.Columns.Count > 0)
foreach (DataRow row in dataTable.Rows)
{
string header = string.Empty;
if (row[0] != null)
header = row[0].ToString().Trim();
switch (header)
{
case "Acct #":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultHomeViewSettings.EnableAccountNumber = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultHomeViewSettings.ShowAccountNumber = tempBool;
break;
case "Logo":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultHomeViewSettings.EnableLogo = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultHomeViewSettings.ShowLogo = tempBool;
break;
case "Code":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultHomeViewSettings.EnableCode = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultHomeViewSettings.ShowCode = tempBool;
break;
case "Delivery":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultHomeViewSettings.EnableDelivery = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultHomeViewSettings.ShowDelivery = tempBool;
break;
case "Readership":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultHomeViewSettings.EnableReadership = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultHomeViewSettings.ShowReadership = tempBool;
break;
}
}
}
catch { }
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
#endregion
#region Load Default Print Schedule Settings
dataAdapter = new OleDbDataAdapter("SELECT * FROM [Print Schedule$]", connection);
dataTable = new DataTable();
try
{
dataAdapter.Fill(dataTable);
if (dataTable.Rows.Count > 0 && dataTable.Columns.Count > 0)
foreach (DataRow row in dataTable.Rows)
{
string header = string.Empty;
if (row[0] != null)
header = row[0].ToString().Trim();
switch (header)
{
case "Column Inches":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultPrintScheduleViewSettings.EnablePCI = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultPrintScheduleViewSettings.DefaultPCI = tempBool;
break;
case "Flat":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultPrintScheduleViewSettings.EnableFlat = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultPrintScheduleViewSettings.DefaultFlat = tempBool;
break;
case "Share":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultPrintScheduleViewSettings.EnableShare = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultPrintScheduleViewSettings.DefaultShare = tempBool;
break;
case "BW":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultPrintScheduleViewSettings.EnableBlackWhite = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultPrintScheduleViewSettings.DefaultBlackWhite = tempBool;
break;
case "Spot Color":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultPrintScheduleViewSettings.EnableSpotColor = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultPrintScheduleViewSettings.DefaultSpotColor = tempBool;
break;
case "Full Color":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultPrintScheduleViewSettings.EnableFullColor = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultPrintScheduleViewSettings.DefaultFullColor = tempBool;
break;
case "Per Ad":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultPrintScheduleViewSettings.EnableCostPerAd = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultPrintScheduleViewSettings.DefaultCostPerAd = tempBool;
break;
case "% of Ad":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultPrintScheduleViewSettings.EnablePercentOfAd = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultPrintScheduleViewSettings.DefaultPercentOfAd = tempBool;
break;
case "Included":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultPrintScheduleViewSettings.EnableColorIncluded = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultPrintScheduleViewSettings.DefaultColorIncluded = tempBool;
break;
case "PCI":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultPrintScheduleViewSettings.EnableCostPerInch = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultPrintScheduleViewSettings.DefaultCostPerInch = tempBool;
break;
case "Textbox":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultPrintScheduleViewSettings.EnableMechanicals = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultPrintScheduleViewSettings.DefaultMechanicals = tempBool;
break;
case "Before Color":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultPrintScheduleViewSettings.CalcDiscountBeforeColor = tempBool;
break;
}
}
}
catch { }
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
#endregion
#region Load Default Publication BasicOverview Settings
dataAdapter = new OleDbDataAdapter("SELECT * FROM [Overview$]", connection);
dataTable = new DataTable();
try
{
dataAdapter.Fill(dataTable);
if (dataTable.Rows.Count > 0 && dataTable.Columns.Count > 0)
foreach (DataRow row in dataTable.Rows)
{
string header = string.Empty;
if (row[0] != null)
header = row[0].ToString().Trim();
switch (header)
{
case "Column Inches":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultPublicationBasicOverviewSettings.EnableSquare = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultPublicationBasicOverviewSettings.ShowSquare = tempBool;
break;
case "Columns X Inches":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultPublicationBasicOverviewSettings.EnableDimensions = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultPublicationBasicOverviewSettings.ShowDimensions = tempBool;
break;
case "% of Page":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultPublicationBasicOverviewSettings.EnablePercentOfPage = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultPublicationBasicOverviewSettings.ShowPercentOfPage = tempBool;
break;
case "Page Size":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultPublicationBasicOverviewSettings.EnablePageSize = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultPublicationBasicOverviewSettings.ShowPageSize = tempBool;
break;
case "Color":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultPublicationBasicOverviewSettings.EnableColor = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultPublicationBasicOverviewSettings.ShowColor = tempBool;
break;
case "Total Ads":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultPublicationBasicOverviewSettings.EnableTotalInserts = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultPublicationBasicOverviewSettings.ShowTotalInserts = tempBool;
break;
case "Total Inches":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultPublicationBasicOverviewSettings.EnableTotalSquare = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultPublicationBasicOverviewSettings.ShowTotalSquare = tempBool;
break;
case "Avg Ad Rate":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultPublicationBasicOverviewSettings.EnableAvgAdCost = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultPublicationBasicOverviewSettings.ShowAvgAdCost = tempBool;
break;
case "Avg PCI":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultPublicationBasicOverviewSettings.EnableAvgPCI = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultPublicationBasicOverviewSettings.ShowAvgPCI = tempBool;
break;
case "Total Discounts":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultPublicationBasicOverviewSettings.EnableDiscounts = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultPublicationBasicOverviewSettings.ShowDiscounts = tempBool;
break;
case "Total Cost":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultPublicationBasicOverviewSettings.EnableInvestment = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultPublicationBasicOverviewSettings.ShowInvestment = tempBool;
break;
case "Flight Dates":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultPublicationBasicOverviewSettings.EnableFlightDates2 = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultPublicationBasicOverviewSettings.ShowFlightDates2 = tempBool;
break;
case "Specific Days":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultPublicationBasicOverviewSettings.EnableDates = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultPublicationBasicOverviewSettings.ShowDates = tempBool;
break;
case "Custom Field":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultPublicationBasicOverviewSettings.EnableComments = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultPublicationBasicOverviewSettings.ShowComments = tempBool;
break;
}
}
}
catch { }
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
#endregion
#region Load Default Publication Multi Summary Settings
dataAdapter = new OleDbDataAdapter("SELECT * FROM [Analysis$]", connection);
dataTable = new DataTable();
try
{
dataAdapter.Fill(dataTable);
if (dataTable.Rows.Count > 0 && dataTable.Columns.Count > 0)
foreach (DataRow row in dataTable.Rows)
{
string header = string.Empty;
if (row[0] != null)
header = row[0].ToString().Trim();
switch (header)
{
case "Total Ads":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultPublicationMultiSummarySettings.EnableTotalInserts = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultPublicationMultiSummarySettings.ShowTotalInserts = tempBool;
break;
case "Dimensions":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultPublicationMultiSummarySettings.EnableDimensions = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultPublicationMultiSummarySettings.ShowDimensions = tempBool;
break;
case "Page Size":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultPublicationMultiSummarySettings.EnablePageSize = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultPublicationMultiSummarySettings.ShowPageSize = tempBool;
break;
case "% of Page":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultPublicationMultiSummarySettings.EnablePercentOfPage = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultPublicationMultiSummarySettings.ShowPercentOfPage = tempBool;
break;
case "Color":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultPublicationMultiSummarySettings.EnableTotalColor = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultPublicationMultiSummarySettings.ShowTotalColor = tempBool;
break;
case "BW Avg Ad Cost":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultPublicationMultiSummarySettings.EnableAvgAdCost = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultPublicationMultiSummarySettings.ShowAvgAdCost = tempBool;
break;
case "FINAL Avg Ad Cost":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultPublicationMultiSummarySettings.EnableAvgFinalCost = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultPublicationMultiSummarySettings.ShowAvgFinalCost = tempBool;
break;
case "Discounts":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultPublicationMultiSummarySettings.EnableDiscounts = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultPublicationMultiSummarySettings.ShowDiscounts = tempBool;
break;
case "Sections":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultPublicationMultiSummarySettings.EnableSection = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultPublicationMultiSummarySettings.ShowSection = tempBool;
break;
case "Flight Dates":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultPublicationMultiSummarySettings.EnableFlightDates = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultPublicationMultiSummarySettings.ShowFlightDates = tempBool;
break;
case "Specific Days":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultPublicationMultiSummarySettings.EnableDates = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultPublicationMultiSummarySettings.ShowDates = tempBool;
break;
case "Custom Field":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultPublicationMultiSummarySettings.EnableComments = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultPublicationMultiSummarySettings.ShowComments = tempBool;
break;
}
}
}
catch { }
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
#endregion
#region Load Default Snapshot Settings
dataAdapter = new OleDbDataAdapter("SELECT * FROM [Snapshot$]", connection);
dataTable = new DataTable();
try
{
dataAdapter.Fill(dataTable);
if (dataTable.Rows.Count > 0 && dataTable.Columns.Count > 0)
foreach (DataRow row in dataTable.Rows)
{
string header = string.Empty;
if (row[0] != null)
header = row[0].ToString().Trim();
switch (header)
{
case "Logo":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultSnapshotViewSettings.EnableLogo = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultSnapshotViewSettings.ShowLogo = tempBool;
break;
case "Total Ads":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultSnapshotViewSettings.EnableTotalInserts = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultSnapshotViewSettings.ShowTotalInserts = tempBool;
break;
case "Investment":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultSnapshotViewSettings.EnableTotalFinalCost = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultSnapshotViewSettings.ShowTotalFinalCost = tempBool;
break;
case "Page Size":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultSnapshotViewSettings.EnablePageSize = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultSnapshotViewSettings.ShowPageSize = tempBool;
break;
case "Columns X Inches":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultSnapshotViewSettings.EnableDimensions = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultSnapshotViewSettings.ShowDimensions = tempBool;
break;
case "Total Column Inches":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultSnapshotViewSettings.EnableSquare = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultSnapshotViewSettings.ShowSquare = tempBool;
break;
case "Total Inches":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultSnapshotViewSettings.EnableTotalSquare = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultSnapshotViewSettings.ShowTotalSquare = tempBool;
break;
case "Final Ad Cost":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultSnapshotViewSettings.EnableAvgFinalCost = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultSnapshotViewSettings.ShowAvgFinalCost = tempBool;
break;
case "Total Color":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultSnapshotViewSettings.EnableTotalColor = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultSnapshotViewSettings.ShowTotalColor = tempBool;
break;
case "Discounts":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultSnapshotViewSettings.EnableTotalDiscounts = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultSnapshotViewSettings.ShowTotalDiscounts = tempBool;
break;
case "Readership":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultSnapshotViewSettings.EnableReadership = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultSnapshotViewSettings.ShowReadership = tempBool;
break;
case "Delivery":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultSnapshotViewSettings.EnableDelivery = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultSnapshotViewSettings.ShowDelivery = tempBool;
break;
case "% of Page":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultSnapshotViewSettings.EnablePercentOfPage = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultSnapshotViewSettings.ShowPercentOfPage = tempBool;
break;
}
}
}
catch { }
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
#endregion
#region Load Detailed Grid Column State
dataAdapter = new OleDbDataAdapter("SELECT * FROM [Detailed Grid$]", connection);
dataTable = new DataTable();
allowToLoad = false;
try
{
dataAdapter.Fill(dataTable);
if (dataTable.Rows.Count > 0 && dataTable.Columns.Count > 0)
foreach (DataRow row in dataTable.Rows)
{
string header = string.Empty;
if (row[0] != null)
header = row[0].ToString().Trim();
if (header.Contains("*"))
{
if (header.Equals("*Print Grid Columns"))
allowToLoad = true;
else
allowToLoad = false;
continue;
}
if (allowToLoad)
{
switch (header)
{
case "ID":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridColumnState.EnableID = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridColumnState.ShowID = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultDetailedGridColumnState.IDPosition = tempInt;
break;
case "INS#":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridColumnState.EnableIndex = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridColumnState.ShowIndex = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultDetailedGridColumnState.IndexPosition = tempInt;
break;
case "Date":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridColumnState.EnableDate = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridColumnState.ShowDate = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultDetailedGridColumnState.DatePosition = tempInt;
break;
case "Color":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridColumnState.EnableColor = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridColumnState.ShowColor = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultDetailedGridColumnState.ColorPosition = tempInt;
break;
case "Section":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridColumnState.EnableSection = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridColumnState.ShowSection = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultDetailedGridColumnState.SectionPosition = tempInt;
break;
case "PCI":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridColumnState.EnablePCI = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridColumnState.ShowPCI = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultDetailedGridColumnState.PCIPosition = tempInt;
break;
case "Total Cost":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridColumnState.EnableFinalCost = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridColumnState.ShowFinalCost = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultDetailedGridColumnState.FinalCostPosition = tempInt;
break;
case "Publication":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridColumnState.EnablePublication = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridColumnState.ShowPublication = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultDetailedGridColumnState.PublicationPosition = tempInt;
break;
case "% of Page":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridColumnState.EnablePercentOfPage = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridColumnState.ShowPercentOfPage = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultDetailedGridColumnState.PercentOfPagePosition = tempInt;
break;
case "BW Ad Cost":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridColumnState.EnableCost = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridColumnState.ShowCost = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultDetailedGridColumnState.CostPosition = tempInt;
break;
case "Col x In":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridColumnState.EnableDimensions = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridColumnState.ShowDimensions = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultDetailedGridColumnState.DimensionsPosition = tempInt;
break;
case "Mechanicals":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridColumnState.EnableMechanicals = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridColumnState.ShowMechanicals = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultDetailedGridColumnState.MechanicalsPosition = tempInt;
break;
case "Delivery":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridColumnState.EnableDelivery = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridColumnState.ShowDelivery = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultDetailedGridColumnState.DeliveryPosition = tempInt;
break;
case "Discounts":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridColumnState.EnableDiscount = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridColumnState.ShowDiscount = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultDetailedGridColumnState.DiscountPosition = tempInt;
break;
case "Page Size":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridColumnState.EnablePageSize = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridColumnState.ShowPageSize = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultDetailedGridColumnState.PageSizePosition = tempInt;
break;
case "Total Col. In.":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridColumnState.EnableSquare = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridColumnState.ShowSquare = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultDetailedGridColumnState.SquarePosition = tempInt;
break;
case "Deadline":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridColumnState.EnableDeadline = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridColumnState.ShowDeadline = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultDetailedGridColumnState.DeadlinePosition = tempInt;
break;
case "Readership":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridColumnState.EnableReadership = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridColumnState.ShowReadership = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultDetailedGridColumnState.ReadershipPosition = tempInt;
break;
case "Select up to 4 Ad-Notes":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridColumnState.EnableAdNotes = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridColumnState.ShowAdNotes = tempBool;
break;
}
}
}
}
catch { }
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
#endregion
#region Load Detailed Grid Ad Notes State
dataAdapter = new OleDbDataAdapter("SELECT * FROM [Detailed Grid$]", connection);
dataTable = new DataTable();
allowToLoad = false;
try
{
dataAdapter.Fill(dataTable);
if (dataTable.Rows.Count > 0 && dataTable.Columns.Count > 0)
foreach (DataRow row in dataTable.Rows)
{
string header = string.Empty;
if (row[0] != null)
header = row[0].ToString().Trim();
if (header.Contains("*"))
{
if (header.Equals("*AdNotes"))
allowToLoad = true;
else
allowToLoad = false;
continue;
}
if (allowToLoad)
{
switch (header)
{
case "Comment":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridAdNotesState.EnableComments = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridAdNotesState.ShowComments = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultDetailedGridAdNotesState.PositionComments = tempInt;
break;
case "Section":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridAdNotesState.EnableSection = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridAdNotesState.ShowSection = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultDetailedGridAdNotesState.PositionSection = tempInt;
break;
case "Mechanicals":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridAdNotesState.EnableMechanicals = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridAdNotesState.ShowMechanicals = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultDetailedGridAdNotesState.PositionMechanicals = tempInt;
break;
case "Col. X Inches":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridAdNotesState.EnableDimensions = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridAdNotesState.ShowDimensions = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultDetailedGridAdNotesState.PositionDimensions = tempInt;
break;
case "Delivery":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridAdNotesState.EnableDelivery = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridAdNotesState.ShowDelivery = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultDetailedGridAdNotesState.PositionDelivery = tempInt;
break;
case "Publication":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridAdNotesState.EnablePublication = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridAdNotesState.ShowPublication = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultDetailedGridAdNotesState.PositionPublication = tempInt;
break;
case "Total Col In":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridAdNotesState.EnableSquare = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridAdNotesState.ShowSquare = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultDetailedGridAdNotesState.PositionSquare = tempInt;
break;
case "Page Size":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridAdNotesState.EnablePageSize = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridAdNotesState.ShowPageSize = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultDetailedGridAdNotesState.PositionPageSize = tempInt;
break;
case "% of Page":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridAdNotesState.EnablePercentOfPage = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridAdNotesState.ShowPercentOfPage = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultDetailedGridAdNotesState.PositionPercentOfPage = tempInt;
break;
case "Readership":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridAdNotesState.EnableReadership = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridAdNotesState.ShowReadership = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultDetailedGridAdNotesState.PositionReadership = tempInt;
break;
case "Deadline":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridAdNotesState.EnableDeadline = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridAdNotesState.ShowDeadline = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultDetailedGridAdNotesState.PositionDeadline = tempInt;
break;
}
}
}
}
catch { }
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
#endregion
#region Load Detailed Grid Slide Bullets State
dataAdapter = new OleDbDataAdapter("SELECT * FROM [Detailed Grid$]", connection);
dataTable = new DataTable();
allowToLoad = false;
try
{
dataAdapter.Fill(dataTable);
if (dataTable.Rows.Count > 0 && dataTable.Columns.Count > 0)
foreach (DataRow row in dataTable.Rows)
{
string header = string.Empty;
if (row[0] != null)
header = row[0].ToString().Trim();
if (header.Contains("*"))
{
if (header.Equals("*Info Totals"))
allowToLoad = true;
else
allowToLoad = false;
continue;
}
if (allowToLoad)
{
switch (header)
{
case "Show Slide Totals":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridSlideBulletsState.EnableSlideBullets = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridSlideBulletsState.ShowSlideBullets = tempBool;
break;
case "Last Slide":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridSlideBulletsState.EnableOnlyOnLastSlide = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridSlideBulletsState.ShowOnlyOnLastSlide = tempBool;
break;
case "Total Ads":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridSlideBulletsState.EnableTotalInserts = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridSlideBulletsState.ShowTotalInserts = tempBool;
break;
case "Investment":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridSlideBulletsState.EnableTotalFinalCost = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridSlideBulletsState.ShowTotalFinalCost = tempBool;
break;
case "Page Size":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridSlideBulletsState.EnablePageSize = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridSlideBulletsState.ShowPageSize = tempBool;
break;
case "Col. X Inches":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridSlideBulletsState.EnableDimensions = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridSlideBulletsState.ShowDimensions = tempBool;
break;
case "% of Page":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridSlideBulletsState.EnablePercentOfPage = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridSlideBulletsState.ShowPercentOfPage = tempBool;
break;
case "Total Col. In.":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridSlideBulletsState.EnableColumnInches = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridSlideBulletsState.ShowColumnInches = tempBool;
break;
case "Total Inches":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridSlideBulletsState.EnableTotalSquare = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridSlideBulletsState.ShowTotalSquare = tempBool;
break;
case "BW Ad Cost":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridSlideBulletsState.EnableAvgAdCost = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridSlideBulletsState.ShowAvgAdCost = tempBool;
break;
case "Final Ad Cost":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridSlideBulletsState.EnableAvgFinalCost = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridSlideBulletsState.ShowAvgFinalCost = tempBool;
break;
case "Avg PCI":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridSlideBulletsState.EnableAvgPCI = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridSlideBulletsState.ShowAvgPCI = tempBool;
break;
case "Total Color":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridSlideBulletsState.EnableTotalColor = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridSlideBulletsState.ShowTotalColor = tempBool;
break;
case "Discounts":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridSlideBulletsState.EnableDiscounts = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridSlideBulletsState.ShowDiscounts = tempBool;
break;
case "Delivery":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridSlideBulletsState.EnableDelivery = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridSlideBulletsState.ShowDelivery = tempBool;
break;
case "Readership":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridSlideBulletsState.EnableReadership = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridSlideBulletsState.ShowReadership = tempBool;
break;
case "Show Signature":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridSlideBulletsState.EnableSignature = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridSlideBulletsState.ShowSignature = tempBool;
break;
}
}
}
}
catch { }
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
#endregion
#region Load Detailed Grid Slide Header State
dataAdapter = new OleDbDataAdapter("SELECT * FROM [Detailed Grid$]", connection);
dataTable = new DataTable();
allowToLoad = false;
try
{
dataAdapter.Fill(dataTable);
if (dataTable.Rows.Count > 0 && dataTable.Columns.Count > 0)
foreach (DataRow row in dataTable.Rows)
{
string header = string.Empty;
if (row[0] != null)
header = row[0].ToString().Trim();
if (header.Contains("*"))
{
if (header.Equals("*Info Headers"))
allowToLoad = true;
else
allowToLoad = false;
continue;
}
if (allowToLoad)
{
switch (header)
{
case "Slide Header Options":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridSlideHeaderState.EnableSlideInfo = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridSlideHeaderState.ShowSlideInfo = tempBool;
break;
case "Slide Title":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridSlideHeaderState.EnableSlideHeader = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridSlideHeaderState.ShowSlideHeader = tempBool;
break;
case "Advertiser":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridSlideHeaderState.EnableAdvertiser = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridSlideHeaderState.ShowAdvertiser = tempBool;
break;
case "Decision Maker":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridSlideHeaderState.EnableDecisionMaker = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridSlideHeaderState.ShowDecisionMaker = tempBool;
break;
case "Presentation Date":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridSlideHeaderState.EnablePresentationDate = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridSlideHeaderState.ShowPresentationDate = tempBool;
break;
case "Schedule Window":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridSlideHeaderState.EnableFlightDates = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridSlideHeaderState.ShowFlightDates = tempBool;
break;
case "Publication Name":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridSlideHeaderState.EnableName = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridSlideHeaderState.ShowName = tempBool;
break;
case "Publication Logo":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultDetailedGridSlideHeaderState.EnableLogo1 = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultDetailedGridSlideHeaderState.ShowLogo1 = tempBool;
break;
}
}
}
}
catch { }
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
#endregion
#region Load Multi Grid Column State
dataAdapter = new OleDbDataAdapter("SELECT * FROM [Logo Grid$]", connection);
dataTable = new DataTable();
allowToLoad = false;
try
{
dataAdapter.Fill(dataTable);
if (dataTable.Rows.Count > 0 && dataTable.Columns.Count > 0)
foreach (DataRow row in dataTable.Rows)
{
string header = string.Empty;
if (row[0] != null)
header = row[0].ToString().Trim();
if (header.Contains("*"))
{
if (header.Equals("*Print Grid Columns"))
allowToLoad = true;
else
allowToLoad = false;
continue;
}
if (allowToLoad)
{
switch (header)
{
case "ID":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridColumnState.EnableID = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridColumnState.ShowID = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultMultiGridColumnState.IDPosition = tempInt;
break;
case "INS#":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridColumnState.EnableIndex = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridColumnState.ShowIndex = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultMultiGridColumnState.IndexPosition = tempInt;
break;
case "Date":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridColumnState.EnableDate = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridColumnState.ShowDate = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultMultiGridColumnState.DatePosition = tempInt;
break;
case "Color":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridColumnState.EnableColor = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridColumnState.ShowColor = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultMultiGridColumnState.ColorPosition = tempInt;
break;
case "Section":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridColumnState.EnableSection = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridColumnState.ShowSection = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultMultiGridColumnState.SectionPosition = tempInt;
break;
case "PCI":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridColumnState.EnablePCI = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridColumnState.ShowPCI = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultMultiGridColumnState.PCIPosition = tempInt;
break;
case "Total Cost":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridColumnState.EnableFinalCost = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridColumnState.ShowFinalCost = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultMultiGridColumnState.FinalCostPosition = tempInt;
break;
case "Publication":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridColumnState.EnablePublication = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridColumnState.ShowPublication = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultMultiGridColumnState.PublicationPosition = tempInt;
break;
case "% of Page":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridColumnState.EnablePercentOfPage = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridColumnState.ShowPercentOfPage = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultMultiGridColumnState.PercentOfPagePosition = tempInt;
break;
case "BW Ad Cost":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridColumnState.EnableCost = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridColumnState.ShowCost = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultMultiGridColumnState.CostPosition = tempInt;
break;
case "Col x In":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridColumnState.EnableDimensions = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridColumnState.ShowDimensions = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultMultiGridColumnState.DimensionsPosition = tempInt;
break;
case "Mechanicals":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridColumnState.EnableMechanicals = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridColumnState.ShowMechanicals = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultMultiGridColumnState.MechanicalsPosition = tempInt;
break;
case "Delivery":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridColumnState.EnableDelivery = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridColumnState.ShowDelivery = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultMultiGridColumnState.DeliveryPosition = tempInt;
break;
case "Discounts":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridColumnState.EnableDiscount = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridColumnState.ShowDiscount = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultMultiGridColumnState.DiscountPosition = tempInt;
break;
case "Page Size":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridColumnState.EnablePageSize = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridColumnState.ShowPageSize = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultMultiGridColumnState.PageSizePosition = tempInt;
break;
case "Total Col. In.":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridColumnState.EnableSquare = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridColumnState.ShowSquare = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultMultiGridColumnState.SquarePosition = tempInt;
break;
case "Deadline":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridColumnState.EnableDeadline = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridColumnState.ShowDeadline = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultMultiGridColumnState.DeadlinePosition = tempInt;
break;
case "Readership":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridColumnState.EnableReadership = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridColumnState.ShowReadership = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultMultiGridColumnState.ReadershipPosition = tempInt;
break;
case "Select up to 4 Ad-Notes":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridColumnState.EnableAdNotes = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridColumnState.ShowAdNotes = tempBool;
break;
}
}
}
}
catch { }
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
#endregion
#region Load Multi Grid Ad Notes State
dataAdapter = new OleDbDataAdapter("SELECT * FROM [Logo Grid$]", connection);
dataTable = new DataTable();
allowToLoad = false;
try
{
dataAdapter.Fill(dataTable);
if (dataTable.Rows.Count > 0 && dataTable.Columns.Count > 0)
foreach (DataRow row in dataTable.Rows)
{
string header = string.Empty;
if (row[0] != null)
header = row[0].ToString().Trim();
if (header.Contains("*"))
{
if (header.Equals("*AdNotes"))
allowToLoad = true;
else
allowToLoad = false;
continue;
}
if (allowToLoad)
{
switch (header)
{
case "Comment":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridAdNotesState.EnableComments = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridAdNotesState.ShowComments = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultMultiGridAdNotesState.PositionComments = tempInt;
break;
case "Section":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridAdNotesState.EnableSection = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridAdNotesState.ShowSection = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultMultiGridAdNotesState.PositionSection = tempInt;
break;
case "Mechanicals":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridAdNotesState.EnableMechanicals = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridAdNotesState.ShowMechanicals = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultMultiGridAdNotesState.PositionMechanicals = tempInt;
break;
case "Col. X Inches":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridAdNotesState.EnableDimensions = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridAdNotesState.ShowDimensions = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultMultiGridAdNotesState.PositionDimensions = tempInt;
break;
case "Delivery":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridAdNotesState.EnableDelivery = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridAdNotesState.ShowDelivery = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultMultiGridAdNotesState.PositionDelivery = tempInt;
break;
case "Publication":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridAdNotesState.EnablePublication = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridAdNotesState.ShowPublication = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultMultiGridAdNotesState.PositionPublication = tempInt;
break;
case "Total Col In":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridAdNotesState.EnableSquare = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridAdNotesState.ShowSquare = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultMultiGridAdNotesState.PositionSquare = tempInt;
break;
case "Page Size":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridAdNotesState.EnablePageSize = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridAdNotesState.ShowPageSize = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultMultiGridAdNotesState.PositionPageSize = tempInt;
break;
case "% of Page":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridAdNotesState.EnablePercentOfPage = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridAdNotesState.ShowPercentOfPage = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultMultiGridAdNotesState.PositionPercentOfPage = tempInt;
break;
case "Readership":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridAdNotesState.EnableReadership = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridAdNotesState.ShowReadership = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultMultiGridAdNotesState.PositionReadership = tempInt;
break;
case "Deadline":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridAdNotesState.EnableDeadline = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridAdNotesState.ShowDeadline = tempBool;
if (row[3] != null)
if (int.TryParse(row[3].ToString().Trim(), out tempInt))
defaultMultiGridAdNotesState.PositionDeadline = tempInt;
break;
}
}
}
}
catch { }
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
#endregion
#region Load Multi Grid Slide Bullets State
dataAdapter = new OleDbDataAdapter("SELECT * FROM [Logo Grid$]", connection);
dataTable = new DataTable();
allowToLoad = false;
try
{
dataAdapter.Fill(dataTable);
if (dataTable.Rows.Count > 0 && dataTable.Columns.Count > 0)
foreach (DataRow row in dataTable.Rows)
{
string header = string.Empty;
if (row[0] != null)
header = row[0].ToString().Trim();
if (header.Contains("*"))
{
if (header.Equals("*Info Totals"))
allowToLoad = true;
else
allowToLoad = false;
continue;
}
if (allowToLoad)
{
switch (header)
{
case "Show Slide Totals":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridSlideBulletsState.EnableSlideBullets = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridSlideBulletsState.ShowSlideBullets = tempBool;
break;
case "Last Slide":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridSlideBulletsState.EnableOnlyOnLastSlide = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridSlideBulletsState.ShowOnlyOnLastSlide = tempBool;
break;
case "Total Ads":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridSlideBulletsState.EnableTotalInserts = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridSlideBulletsState.ShowTotalInserts = tempBool;
break;
case "Investment":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridSlideBulletsState.EnableTotalFinalCost = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridSlideBulletsState.ShowTotalFinalCost = tempBool;
break;
case "Page Size":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridSlideBulletsState.EnablePageSize = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridSlideBulletsState.ShowPageSize = tempBool;
break;
case "Col. X Inches":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridSlideBulletsState.EnableDimensions = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridSlideBulletsState.ShowDimensions = tempBool;
break;
case "% of Page":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridSlideBulletsState.EnablePercentOfPage = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridSlideBulletsState.ShowPercentOfPage = tempBool;
break;
case "Total Col. In.":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridSlideBulletsState.EnableColumnInches = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridSlideBulletsState.ShowColumnInches = tempBool;
break;
case "Total Inches":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridSlideBulletsState.EnableTotalSquare = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridSlideBulletsState.ShowTotalSquare = tempBool;
break;
case "BW Ad Cost":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridSlideBulletsState.EnableAvgAdCost = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridSlideBulletsState.ShowAvgAdCost = tempBool;
break;
case "Final Ad Cost":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridSlideBulletsState.EnableAvgFinalCost = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridSlideBulletsState.ShowAvgFinalCost = tempBool;
break;
case "Avg PCI":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridSlideBulletsState.EnableAvgPCI = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridSlideBulletsState.ShowAvgPCI = tempBool;
break;
case "Total Color":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridSlideBulletsState.EnableTotalColor = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridSlideBulletsState.ShowTotalColor = tempBool;
break;
case "Discounts":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridSlideBulletsState.EnableDiscounts = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridSlideBulletsState.ShowDiscounts = tempBool;
break;
case "Delivery":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridSlideBulletsState.EnableDelivery = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridSlideBulletsState.ShowDelivery = tempBool;
break;
case "Readership":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridSlideBulletsState.EnableReadership = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridSlideBulletsState.ShowReadership = tempBool;
break;
case "Show Signature":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridSlideBulletsState.EnableSignature = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridSlideBulletsState.ShowSignature = tempBool;
break;
}
}
}
}
catch { }
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
#endregion
#region Load Multi Grid Slide Header State
dataAdapter = new OleDbDataAdapter("SELECT * FROM [Logo Grid$]", connection);
dataTable = new DataTable();
allowToLoad = false;
try
{
dataAdapter.Fill(dataTable);
if (dataTable.Rows.Count > 0 && dataTable.Columns.Count > 0)
foreach (DataRow row in dataTable.Rows)
{
string header = string.Empty;
if (row[0] != null)
header = row[0].ToString().Trim();
if (header.Contains("*"))
{
if (header.Equals("*Info Headers"))
allowToLoad = true;
else
allowToLoad = false;
continue;
}
if (allowToLoad)
{
switch (header)
{
case "Slide Header Options":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridSlideHeaderState.EnableSlideInfo = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridSlideHeaderState.ShowSlideInfo = tempBool;
break;
case "Slide Title":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridSlideHeaderState.EnableSlideHeader = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridSlideHeaderState.ShowSlideHeader = tempBool;
break;
case "Advertiser":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridSlideHeaderState.EnableAdvertiser = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridSlideHeaderState.ShowAdvertiser = tempBool;
break;
case "Decision Maker":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridSlideHeaderState.EnableDecisionMaker = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridSlideHeaderState.ShowDecisionMaker = tempBool;
break;
case "Presentation Date":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridSlideHeaderState.EnablePresentationDate = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridSlideHeaderState.ShowPresentationDate = tempBool;
break;
case "Schedule Window":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridSlideHeaderState.EnableFlightDates = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridSlideHeaderState.ShowFlightDates = tempBool;
break;
case "Publication Name":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridSlideHeaderState.EnableName = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridSlideHeaderState.ShowName = tempBool;
break;
case "Publication Logo":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultMultiGridSlideHeaderState.EnableLogo1 = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultMultiGridSlideHeaderState.ShowLogo1 = tempBool;
break;
}
}
}
}
catch { }
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
#endregion
#region Load Default Calendar Settings
dataAdapter = new OleDbDataAdapter("SELECT * FROM [Calendar$]", connection);
dataTable = new DataTable();
try
{
dataAdapter.Fill(dataTable);
if (dataTable.Rows.Count > 0 && dataTable.Columns.Count > 0)
foreach (DataRow row in dataTable.Rows)
{
string header = string.Empty;
if (row[0] != null)
header = row[0].ToString().Trim();
switch (header)
{
case "Ad Section":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultCalendarViewSettings.EnableSection = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultCalendarViewSettings.ShowSection = tempBool;
break;
case "Color-BW":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultCalendarViewSettings.EnableColor = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultCalendarViewSettings.ShowColor = tempBool;
break;
case "Codes Only":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultCalendarViewSettings.EnableAbbreviationOnly = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultCalendarViewSettings.ShowAbbreviationOnly = tempBool;
break;
case "Col x In":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultCalendarViewSettings.EnableAdSize = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultCalendarViewSettings.ShowAdSize = tempBool;
break;
case "Page Size":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultCalendarViewSettings.EnablePageSize = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultCalendarViewSettings.ShowPageSize = tempBool;
break;
case "% of Page":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultCalendarViewSettings.EnablePercentOfPage = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultCalendarViewSettings.ShowPercentOfPage = tempBool;
break;
case "Big Dates":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultCalendarViewSettings.EnableBigDate = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultCalendarViewSettings.ShowBigDate = tempBool;
break;
case "Logo":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultCalendarViewSettings.EnableLogo = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultCalendarViewSettings.ShowLogo = tempBool;
break;
case "Monthly $":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultCalendarViewSettings.EnableCost = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultCalendarViewSettings.ShowCost = tempBool;
break;
case "Comment":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultCalendarViewSettings.EnableComments = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultCalendarViewSettings.ShowComments = tempBool;
break;
case "# Ads":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultCalendarViewSettings.EnableTotalAds = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultCalendarViewSettings.ShowTotalAds = tempBool;
break;
case "# Days":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultCalendarViewSettings.EnableActiveDays = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
defaultCalendarViewSettings.ShowActiveDays = tempBool;
break;
case "Gray":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultCalendarViewSettings.EnableGray = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
if (tempBool)
defaultCalendarViewSettings.SlideColor = "gray";
break;
case "Black":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultCalendarViewSettings.EnableBlack = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
if (tempBool)
defaultCalendarViewSettings.SlideColor = "black";
break;
case "Blue":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultCalendarViewSettings.EnableBlue = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
if (tempBool)
defaultCalendarViewSettings.SlideColor = "blue";
break;
case "Teal":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultCalendarViewSettings.EnableTeal = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
if (tempBool)
defaultCalendarViewSettings.SlideColor = "teal";
break;
case "Orange":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultCalendarViewSettings.EnableOrange = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
if (tempBool)
defaultCalendarViewSettings.SlideColor = "orange";
break;
case "Green":
if (row[1] != null)
if (bool.TryParse(row[1].ToString().Trim(), out tempBool))
defaultCalendarViewSettings.EnableGreen = tempBool;
if (row[2] != null)
if (bool.TryParse(row[2].ToString().Trim(), out tempBool))
if (tempBool)
defaultCalendarViewSettings.SlideColor = "green";
break;
}
}
}
catch { }
finally
{
dataAdapter.Dispose();
dataTable.Dispose();
}
#endregion
connection.Close();
#region Save XML
var xml = new StringBuilder();
xml.AppendLine("<PrintStrategy>");
foreach (SlideHeader header in slideHeaders)
{
xml.Append(@"<Header ");
xml.Append("Value = \"" + header.Value.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.AppendLine(@"/>");
}
foreach (SlideHeader status in statuses)
{
xml.Append(@"<Status ");
xml.Append("Value = \"" + status.Value.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.AppendLine(@"/>");
}
foreach (Publication publication in publications)
{
xml.Append(@"<Publication ");
xml.Append("Name = \"" + publication.Name.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.Append("Abbreviation = \"" + publication.Abbreviation.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.Append("BigLogo = \"" + publication.BigLogo.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.Append("LittleLogo = \"" + publication.LittleLogo.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.Append("TinyLogo = \"" + publication.TinyLogo.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.Append("DailyCirculation = \"" + publication.DailyCirculation.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.Append("DailyReadership = \"" + publication.DailyReadership.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.Append("SundayCirculation = \"" + publication.SundayCirculation.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.Append("SundayReadership = \"" + publication.SundayReadership.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.Append("AllowSundaySelect = \"" + publication.AllowSundaySelect + "\" ");
xml.Append("AllowMondaySelect = \"" + publication.AllowMondaySelect + "\" ");
xml.Append("AllowTuesdaySelect = \"" + publication.AllowTuesdaySelect + "\" ");
xml.Append("AllowWednesdaySelect = \"" + publication.AllowWednesdaySelect + "\" ");
xml.Append("AllowThursdaySelect = \"" + publication.AllowThursdaySelect + "\" ");
xml.Append("AllowFridaySelect = \"" + publication.AllowFridaySelect + "\" ");
xml.Append("AllowSaturdaySelect = \"" + publication.AllowSaturdaySelect + "\" ");
xml.AppendLine(@"/>");
}
foreach (AdSize adSize in adSizes)
{
xml.Append(@"<AdSize ");
xml.Append("Group = \"" + adSize.Group.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.Append("Name = \"" + adSize.Name.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.AppendLine(@"/>");
}
foreach (ShareUnit shareUnit in shareUnits)
{
xml.Append(@"<ShareUnit ");
xml.Append("RateCard = \"" + shareUnit.RateCard.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.Append("PercentOfPage = \"" + shareUnit.PercentOfPage.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.Append("Width = \"" + shareUnit.Width.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.Append("WidthMeasureUnit = \"" + shareUnit.WidthMeasureUnit.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.Append("Height = \"" + shareUnit.Height.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.Append("HeightMeasureUnit = \"" + shareUnit.HeightMeasureUnit.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.AppendLine(@"/>");
}
foreach (NameCodePair note in notes)
{
xml.Append(@"<Note ");
xml.Append("Value = \"" + note.Name.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.Append("Code = \"" + note.Code.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.AppendLine(@"/>");
}
xml.AppendLine(@"<SelectedNotesBorderValue>" + selectedNotesBorderValue.Replace(@"&", "&").Replace("\"", """) + @"</SelectedNotesBorderValue>");
foreach (string clientType in clientTypes)
{
xml.Append(@"<ClientType ");
xml.Append("Value = \"" + clientType.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.AppendLine(@"/>");
}
foreach (Section section in sections)
{
xml.Append(@"<Section ");
xml.Append("Name = \"" + section.Name.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.Append("Abbreviation = \"" + section.Abbreviation.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.AppendLine(@"/>");
}
xml.AppendLine(@"<SelectedSectionsBorderValue>" + selectedSectionsBorderValue.Replace(@"&", "&").Replace("\"", """) + @"</SelectedSectionsBorderValue>");
foreach (MechanicalType mechanical in mechanicals)
{
xml.Append(@"<Mechanicals ");
xml.Append("Name = \"" + mechanical.Name.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.AppendLine(@">");
foreach (MechanicalItem mechanicalItem in mechanical.Items)
{
xml.Append(@"<Mechanical ");
xml.Append("Name = \"" + mechanicalItem.Name.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.Append("Value = \"" + mechanicalItem.Value.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.AppendLine(@"/>");
}
xml.AppendLine(@"</Mechanicals>");
}
foreach (string deadline in deadlines)
{
xml.Append(@"<Deadline ");
xml.Append("Value = \"" + deadline.Replace(@"&", "&").Replace("\"", """) + "\" ");
xml.AppendLine(@"/>");
}
xml.AppendLine(@"<DefaultHomeViewSettings>" + defaultHomeViewSettings.Serialize() + @"</DefaultHomeViewSettings>");
xml.AppendLine(@"<DefaultPrintScheduleViewSettings>" + defaultPrintScheduleViewSettings.Serialize() + @"</DefaultPrintScheduleViewSettings>");
xml.AppendLine(@"<DefaultPublicationBasicOverviewSettings>" + defaultPublicationBasicOverviewSettings.Serialize() + @"</DefaultPublicationBasicOverviewSettings>");
xml.AppendLine(@"<DefaultPublicationMultiSummarySettings>" + defaultPublicationMultiSummarySettings.Serialize() + @"</DefaultPublicationMultiSummarySettings>");
xml.AppendLine(@"<DefaultSnapshotViewSettings>" + defaultSnapshotViewSettings.Serialize() + @"</DefaultSnapshotViewSettings>");
xml.AppendLine(@"<DefaultDetailedGridColumnState>" + defaultDetailedGridColumnState.Serialize() + @"</DefaultDetailedGridColumnState>");
xml.AppendLine(@"<DefaultDetailedGridAdNotesState>" + defaultDetailedGridAdNotesState.Serialize() + @"</DefaultDetailedGridAdNotesState>");
xml.AppendLine(@"<DefaultDetailedGridSlideBulletsState>" + defaultDetailedGridSlideBulletsState.Serialize() + @"</DefaultDetailedGridSlideBulletsState>");
xml.AppendLine(@"<DefaultDetailedGridSlideHeaderState>" + defaultDetailedGridSlideHeaderState.Serialize() + @"</DefaultDetailedGridSlideHeaderState>");
xml.AppendLine(@"<DefaultMultiGridColumnState>" + defaultMultiGridColumnState.Serialize() + @"</DefaultMultiGridColumnState>");
xml.AppendLine(@"<DefaultMultiGridAdNotesState>" + defaultMultiGridAdNotesState.Serialize() + @"</DefaultMultiGridAdNotesState>");
xml.AppendLine(@"<DefaultMultiGridSlideBulletsState>" + defaultMultiGridSlideBulletsState.Serialize() + @"</DefaultMultiGridSlideBulletsState>");
xml.AppendLine(@"<DefaultMultiGridSlideHeaderState>" + defaultMultiGridSlideHeaderState.Serialize() + @"</DefaultMultiGridSlideHeaderState>");
xml.AppendLine(@"<DefaultCalendarViewSettings>" + defaultCalendarViewSettings.Serialize() + @"</DefaultCalendarViewSettings>");
xml.AppendLine(@"</PrintStrategy>");
string xmlPath = Path.Combine(Application.StartupPath, DestinationFileName);
using (var sw = new StreamWriter(xmlPath, false))
{
sw.Write(xml.ToString());
sw.Flush();
}
ProductionFilesUpdateHelper.UpdateProductionFies(xmlPath);
#endregion
AppManager.Instance.ShowInformation("Data was updated.");
}
}
