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); }