public void Save(ExcelRollSettings ExcellRollSettings)
{
XMLhelper XML = new XMLhelper(UserSettings);
XML.XMLWriteFile(xmlEXCELNodeNameLocation, ExportKey, ExcellRollSettings.Export.ToString(CultureInfo.CurrentCulture));
XML.XMLWriteFile(xmlEXCELNodeNameLocation, ExportWaitListKey, ExcellRollSettings.ExportWaitlist.ToString(CultureInfo.CurrentCulture));
XML.XMLWriteFile(xmlEXCELNodeNameLocation, ExportLabKey, ExcellRollSettings.ExportLab.ToString(CultureInfo.CurrentCulture));
XML.XMLWriteFile(xmlEXCELNodeNameLocation, ClassIncrementKey, ExcellRollSettings.ClassIncrement.ToString(CultureInfo.CurrentCulture));
XML.XMLWriteFile(xmlEXCELNodeNameLocation, ClassNameColumnLetterKey, ExcellRollSettings.ClassNameColumnLetter);
XML.XMLWriteFile(xmlEXCELNodeNameLocation, FirstClassKey, ExcellRollSettings.FirstClass.ToString(CultureInfo.CurrentCulture));
XML.XMLWriteFile(xmlEXCELNodeNameLocation, FirstMondayDayCellKey, ExcellRollSettings.FirstMondayDayCell);
XML.XMLWriteFile(xmlEXCELNodeNameLocation, FirstNameColumnLetterKey, ExcellRollSettings.FirstNameColumnLetter);
XML.XMLWriteFile(xmlEXCELNodeNameLocation, HeaderKey, ExcellRollSettings.Header);
//XML.XMLWriteFile(xmlEXCELNodeNameLocation, HeightKey, ExcellRollSettings.Height.ToString(CultureInfo.CurrentCulture));
XML.XMLWriteFile(xmlEXCELNodeNameLocation, LastNameColumnLetterKey, ExcellRollSettings.LastNameColumnLetter);
XML.XMLWriteFile(xmlEXCELNodeNameLocation, MondayDateCellKey, ExcellRollSettings.MondayDateCell);
}
private void BtnExcelLoadConfiguration_Click(object sender, EventArgs e)
{
Excel Excel = new Excel(UserSettings);
// make copies
ExcelRollSettings Roll = ExcelRollSettings.Clone();
ExcelClassSettings Class = ExcelClassSettings.Clone();
Class.TemplateDirectory = Path.GetDirectoryName(TxtExcelTemplateNameAndDirectory.Text);
Class.TemplateFileName = Path.GetFileName(TxtExcelTemplateNameAndDirectory.Text);
if (Excel.LoadConfigurationFromSpreadSheet(Roll, Class))
{
// - Found information - set form values
InitilizeExcel(Roll, Class);
MessageBox.Show("Retrieved values and updated the form", "Success!");
}
}
public void InitilizeExcel(ExcelRollSettings Roll, ExcelClassSettings Class)
{
#region Excel Class
ChkExcelClassExport.Checked = Class.Export;
ChkExcelClassWaitListExport.Checked = Class.ExportWaitlist;
if (!Class.TemplateDirectory.EndsWith("\\"))
{
Class.TemplateDirectory += "\\";
}
TxtExcelTemplateNameAndDirectory.Text = Class.TemplateDirectory + Class.TemplateFileName;
TxtExcelSaveAsDirectory.Text = Class.SaveFileDirectory;
TxtExcelSaveAsFileName.Text = Class.SaveFileName;
ChkExcelCommonIncludeQuarter.Checked = Class.SaveFileNameIncludesQuarter;
TxtExcelClassFirstStudentRow.Text = Class.FirstStudent.ToString(CultureInfo.CurrentCulture);
TxtExcelClassSID.Text = Class.SIDColumnLetter;
chkExcelClassExportSID.Checked = Class.ExportSID;
TxtExcelClassSIDLast4.Text = Class.SIDLast4ColumnLetter;
chkExcelClassExportSIDLast4.Checked = Class.ExportSIDLast4;
TxtExcelClassLastName.Text = Class.LastNameColumnLetter;
TxtExcelClassFirstName.Text = Class.FirstNameColumnLetter;
TxtExcelClassItemCell.Text = Class.ItemCell;
ChkExcelClassWaitListExport.Checked = Class.ExportWaitlist;
#region OptHeader Textbox and Checkboxes
TxtExcelClassOptHeader1.Text = Class.OptHead1ColumnLetter;
chkExcelClassExportoptHeader1.Checked = Class.ExportoptHead1;
TxtExcelClassOptHeader2.Text = Class.OptHead2ColumnLetter;
chkExcelClassExportoptHeader2.Checked = Class.ExportoptHead2;
TxtExcelClassOptHeader3.Text = Class.OptHead3ColumnLetter;
chkExcelClassExportoptHeader3.Checked = Class.ExportoptHead3;
#endregion
#region OptHeader Labels
// Change to XML
LblExcelClassOptHeader1.Text = Class.HeaderNames.Header1;
chkExcelClassExportoptHeader1.Text = "Export " + Class.HeaderNames.Header1;
LblExcelClassOptHeader2.Text = Class.HeaderNames.Header2;
chkExcelClassExportoptHeader2.Text = "Export " + Class.HeaderNames.Header2;
LblExcelClassOptHeader3.Text = Class.HeaderNames.Header3;
chkExcelClassExportoptHeader3.Text = "Export " + Class.HeaderNames.Header3;
#endregion
#endregion
#region Excel Roll
ChkExcelRollExport.Checked = Roll.Export;
ChkExcelRollExportWaitlist.Checked = Roll.ExportWaitlist;
ChkExcelLabExport.Checked = Roll.ExportLab;
txtRollFirstClass.Text = Roll.FirstClass.ToString(CultureInfo.CurrentCulture);
txtRollClassIncrement.Text = Roll.ClassIncrement.ToString(CultureInfo.CurrentCulture);
txtRollHeader.Text = Roll.Header;
txtRollLastName.Text = Roll.LastNameColumnLetter;
txtRollFirstName.Text = Roll.FirstNameColumnLetter;
txtRollMondayDateCell.Text = Roll.MondayDateCell;
txtRollFirstDayCell.Text = Roll.FirstMondayDayCell;
#endregion
}
public ExcelRollSettings Load()
{
ExcelRollSettings ExcellRollSettings = new ExcelRollSettings();
XMLhelper XML = new XMLhelper(UserSettings);
try
{
ExcellRollSettings.Export = Convert.ToBoolean(XML.XMLReadFile(xmlEXCELNodeNameLocation, ExportKey).ToLower());
}
catch
{
ExcellRollSettings.Export = false;
XML.XMLWriteFile(xmlEXCELNodeNameLocation, ExportKey, ExcellRollSettings.Export.ToString(CultureInfo.CurrentCulture));
}
try
{
ExcellRollSettings.ExportWaitlist = Convert.ToBoolean(XML.XMLReadFile(xmlEXCELNodeNameLocation, ExportWaitListKey).ToLower());
}
catch
{
ExcellRollSettings.ExportWaitlist = false;
XML.XMLWriteFile(xmlEXCELNodeNameLocation, ExportWaitListKey, ExcellRollSettings.ExportWaitlist.ToString(CultureInfo.CurrentCulture));
}
try
{
ExcellRollSettings.ExportLab = Convert.ToBoolean(XML.XMLReadFile(xmlEXCELNodeNameLocation, ExportLabKey).ToLower());
}
catch
{
ExcellRollSettings.ExportLab = false;
XML.XMLWriteFile(xmlEXCELNodeNameLocation, ExportLabKey, ExcellRollSettings.ExportLab.ToString(CultureInfo.CurrentCulture));
}
try
{
ExcellRollSettings.ClassIncrement = Convert.ToInt32(XML.XMLReadFile(xmlEXCELNodeNameLocation, ClassIncrementKey));
}
catch
{
ExcellRollSettings.FirstClass = ClassIncrementDefault;
XML.XMLWriteFile(xmlEXCELNodeNameLocation, ClassIncrementKey, ExcellRollSettings.ClassIncrement.ToString(CultureInfo.CurrentCulture));
}
try
{
ExcellRollSettings.FirstClass = Convert.ToInt32(XML.XMLReadFile(xmlEXCELNodeNameLocation, FirstClassKey));
}
catch
{
ExcellRollSettings.FirstClass = FirstClassDefault;
XML.XMLWriteFile(xmlEXCELNodeNameLocation, FirstClassKey, ExcellRollSettings.FirstClass.ToString(CultureInfo.CurrentCulture));
}
ExcellRollSettings.ClassNameColumnLetter = XML.XMLReadFile(xmlEXCELNodeNameLocation, ClassNameColumnLetterKey);
if (ExcellRollSettings.ClassNameColumnLetter == "")
{
ExcellRollSettings.ClassNameColumnLetter = ClassNameColumnLetterDefault;
XML.XMLWriteFile(xmlEXCELNodeNameLocation, ClassNameColumnLetterKey, ExcellRollSettings.ClassNameColumnLetter);
}
ExcellRollSettings.FirstMondayDayCell = XML.XMLReadFile(xmlEXCELNodeNameLocation, FirstMondayDayCellKey);
if (ExcellRollSettings.FirstMondayDayCell == "")
{
ExcellRollSettings.FirstMondayDayCell = FirstMondayDayCellDefault;
XML.XMLWriteFile(xmlEXCELNodeNameLocation, FirstMondayDayCellKey, ExcellRollSettings.FirstMondayDayCell);
}
ExcellRollSettings.FirstNameColumnLetter = XML.XMLReadFile(xmlEXCELNodeNameLocation, FirstNameColumnLetterKey);
if (ExcellRollSettings.FirstNameColumnLetter == "")
{
ExcellRollSettings.FirstNameColumnLetter = FirstNameColumnLetterDefault;
XML.XMLWriteFile(xmlEXCELNodeNameLocation, FirstNameColumnLetterKey, ExcellRollSettings.FirstNameColumnLetter);
}
ExcellRollSettings.Header = XML.XMLReadFile(xmlEXCELNodeNameLocation, HeaderKey);
if (ExcellRollSettings.Header == "")
{
ExcellRollSettings.Header = HeaderDefault;
XML.XMLWriteFile(xmlEXCELNodeNameLocation, HeaderKey, ExcellRollSettings.Header);
}
//try
//{
// ExcellRollSettings.Height = Convert.ToSingle(XML.XMLReadFile(xmlEXCELNodeNameLocation, HeightKey));
//}
//catch
//{
// ExcellRollSettings.Height = HeightDefault;
// XML.XMLWriteFile(xmlEXCELNodeNameLocation, HeightKey, ExcellRollSettings.Height.ToString(CultureInfo.CurrentCulture));
//}
ExcellRollSettings.LastNameColumnLetter = XML.XMLReadFile(xmlEXCELNodeNameLocation, LastNameColumnLetterKey);
if (ExcellRollSettings.LastNameColumnLetter == "")
{
ExcellRollSettings.LastNameColumnLetter = LastNameColumnLetterDefault;
XML.XMLWriteFile(xmlEXCELNodeNameLocation, LastNameColumnLetterKey, ExcellRollSettings.LastNameColumnLetter);
}
ExcellRollSettings.MondayDateCell = XML.XMLReadFile(xmlEXCELNodeNameLocation, MondayDateCellKey);
if (ExcellRollSettings.MondayDateCell == "")
{
ExcellRollSettings.MondayDateCell = MondayDateCellDefault;
XML.XMLWriteFile(xmlEXCELNodeNameLocation, MondayDateCellKey, ExcellRollSettings.MondayDateCell);
}
return(ExcellRollSettings);
}
