internal override void AddPromptsToRecordingList(PromptRecordingList recordingList, DateTime?onOrAfterDate) { Table table = GetPrompts(); for (int r = 0; r < table.GetNumRows(); r++) { string wording = table.GetData(r, (int)TableColumns.Prompts.Wording); string id = table.GetData(r, (int)TableColumns.Prompts.Id); string wordingDateString = table.GetData(r, (int)TableColumns.Prompts.WordingDateStamp); string idDateString = table.GetData(r, (int)TableColumns.Prompts.IdDateStamp); if (onOrAfterDate != null) { if (Common.ForcedStringToDate(wordingDateString) >= onOrAfterDate || Common.ForcedStringToDate(idDateString) >= onOrAfterDate) { if (id != null && id.Length > 0) { recordingList.AddPromptRecording(id, wording); } } } else if (id != null && id.Length > 0) { recordingList.AddPromptRecording(id, wording); } } }
internal override void AddPromptsToRecordingListVer(PromptRecordingList recordingList, String onOrAfterVersion) { Table table = GetPrompts(); //double number; for (int r = 0; r < table.GetNumRows(); r++) { string wording = table.GetData(r, (int)TableColumns.Prompts.Wording); string id = table.GetData(r, (int)TableColumns.Prompts.Id); string wordingDateString = table.GetData(r, (int)TableColumns.Prompts.WordingDateStamp); string idDateString = table.GetData(r, (int)TableColumns.Prompts.IdDateStamp); if (wordingDateString.Contains("/")) { DateTime tempDTStamp; if (DateTime.TryParse(onOrAfterVersion, out tempDTStamp)) { string tempVersionStampFix = PathMaker.LookupChangeLogShadow().GetVersionStringForChange(tempDTStamp); wordingDateString = tempVersionStampFix; } } if (idDateString.Contains("/")) { DateTime tempDTStamp; if (DateTime.TryParse(onOrAfterVersion, out tempDTStamp)) { string tempVersionStampFix = PathMaker.LookupChangeLogShadow().GetVersionStringForChange(tempDTStamp); idDateString = tempVersionStampFix; } } if (onOrAfterVersion != null) { if (!wordingDateString.Contains("/") && !idDateString.Contains("/")) { if (Common.ForcedStringVersionToDouble(wordingDateString) >= Common.ForcedStringVersionToDouble(onOrAfterVersion) || Common.ForcedStringVersionToDouble(idDateString) >= Common.ForcedStringVersionToDouble(onOrAfterVersion)) { if (id != null && id.Length > 0) { recordingList.AddPromptRecording(id, wording); } } } } else if (id != null && id.Length > 0) { recordingList.AddPromptRecording(id, wording); } } }
internal override void AddPromptsToRecordingList(PromptRecordingList recordingList, DateTime? onOrAfterDate) { Table table = GetPrompts(); for (int r = 0; r < table.GetNumRows(); r++) { string wording = table.GetData(r, (int)TableColumns.Prompts.Wording); string id = table.GetData(r, (int)TableColumns.Prompts.Id); string wordingDateString = table.GetData(r, (int)TableColumns.Prompts.WordingDateStamp); string idDateString = table.GetData(r, (int)TableColumns.Prompts.IdDateStamp); if (onOrAfterDate != null) { if (Common.ForcedStringToDate(wordingDateString) >= onOrAfterDate || Common.ForcedStringToDate(idDateString) >= onOrAfterDate) { if (id != null && id.Length > 0) recordingList.AddPromptRecording(id, wording); } } else if (id != null && id.Length > 0) recordingList.AddPromptRecording(id, wording); } }
internal override void AddPromptsToRecordingListVer(PromptRecordingList recordingList, String onOrAfterVersion) { Table table = GetPromptTypes(); //double number; for (int r = 0; r < table.GetNumRows(); r++) { string wording = table.GetData(r, (int)TableColumns.PromptTypes.Wording); string id = table.GetData(r, (int)TableColumns.PromptTypes.Id); string wordingDateString = table.GetData(r, (int)TableColumns.PromptTypes.WordingDateStamp); string idDateString = table.GetData(r, (int)TableColumns.PromptTypes.IdDateStamp); if (wordingDateString.Contains("/")) { DateTime tempDTStamp; if (DateTime.TryParse(onOrAfterVersion, out tempDTStamp)) { string tempVersionStampFix = PathMaker.LookupChangeLogShadow().GetVersionStringForChange(tempDTStamp); wordingDateString = tempVersionStampFix; } } if (idDateString.Contains("/")) { DateTime tempDTStamp; if (DateTime.TryParse(onOrAfterVersion, out tempDTStamp)) { string tempVersionStampFix = PathMaker.LookupChangeLogShadow().GetVersionStringForChange(tempDTStamp); idDateString = tempVersionStampFix; } } if (onOrAfterVersion != null) { if (!wordingDateString.Contains("/") && !idDateString.Contains("/")) { if (Common.ForcedStringVersionToDouble(wordingDateString) >= Common.ForcedStringVersionToDouble(onOrAfterVersion) || Common.ForcedStringVersionToDouble(idDateString) >= Common.ForcedStringVersionToDouble(onOrAfterVersion)) { if (id != null && id.Length > 0) recordingList.AddPromptRecording(id, wording); } } } else if (id != null && id.Length > 0) recordingList.AddPromptRecording(id, wording); } table = GetConfirmationPrompts(); for (int r = 0; r < table.GetNumRows(); r++) { string wording = table.GetData(r, (int)TableColumns.ConfirmationPrompts.Wording); string id = table.GetData(r, (int)TableColumns.ConfirmationPrompts.Id); string wordingDateString = table.GetData(r, (int)TableColumns.ConfirmationPrompts.WordingDateStamp); string idDateString = table.GetData(r, (int)TableColumns.ConfirmationPrompts.IdDateStamp); if (idDateString == "" && wordingDateString != "") { idDateString = wordingDateString; } else if (wordingDateString == "" && idDateString != "") { wordingDateString = idDateString; } if (onOrAfterVersion != null) { if (!wordingDateString.Contains("/") && !idDateString.Contains("/")) { if (Common.ForcedStringVersionToDouble(wordingDateString) >= Common.ForcedStringVersionToDouble(onOrAfterVersion) && Common.ForcedStringVersionToDouble(idDateString) >= Common.ForcedStringVersionToDouble(onOrAfterVersion)) { if (id != null && id.Length > 0) recordingList.AddPromptRecording(id, wording); } } } else if (id != null && id.Length > 0) recordingList.AddPromptRecording(id, wording); } }
internal static void ImportPromptList(string initialDirectory) { string fileName; // Set up the open file dialog and let the user select the file to open. if (openFileDialog == null) { openFileDialog = new OpenFileDialog(); openFileDialog.Title = Common.GetResourceString(Strings.OpenPromptsTitleRes); openFileDialog.Filter = Common.GetResourceString(Strings.OpenPromptsFilterRes); openFileDialog.FilterIndex = 1; } openFileDialog.InitialDirectory = initialDirectory; if (openFileDialog.ShowDialog() == DialogResult.OK) { // The user selected a valid file name and hit OK. Get the // file name from the dialog and open the file. fileName = openFileDialog.FileName; Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application(); if (excelApp == null) { Common.ErrorMessage("Couldn't start Excel - make sure it's installed"); return; } excelApp.Visible = false; Workbook wb = excelApp.Workbooks.Open(fileName, ReadOnly: true); if (wb.Worksheets.Count > 0) { Worksheet ws = (Worksheet)wb.Worksheets[1]; string promptId, dupIds, wording, notes; PromptRecordingList recordingList = new PromptRecordingList(); int row = 7; do { promptId = ws.Cells[row, 2].Text; dupIds = ws.Cells[row, 3].Text; wording = ws.Cells[row, 4].Text; notes = ws.Cells[row, 5].Text; if (notes.Length > 0) { wording = wording + " " + Strings.LabelStartBracket + notes + Strings.LabelEndBracket; } if (promptId != null && promptId.Length > 0 && wording != null) { recordingList.AddPromptRecording(promptId, wording); if (dupIds != null && dupIds.Length > 0) { string[] otherIds = dupIds.Split(DuplicateIdDelimiter); foreach (string dupId in otherIds) { recordingList.AddPromptRecording(dupId, wording); } } } row++; } while (promptId != null && promptId.Length > 0); Common.ApplyPromptRecordingList(recordingList); } wb.Close(); excelApp.Quit(); System.Runtime.InteropServices.Marshal.ReleaseComObject(excelApp); excelApp = null; } }
internal static void ImportPromptList(string initialDirectory) { string fileName; // Set up the open file dialog and let the user select the file to open. if (openFileDialog == null) { openFileDialog = new OpenFileDialog(); openFileDialog.Title = Common.GetResourceString(Strings.OpenPromptsTitleRes); openFileDialog.Filter = Common.GetResourceString(Strings.OpenPromptsFilterRes); openFileDialog.FilterIndex = 1; } openFileDialog.InitialDirectory = initialDirectory; if (openFileDialog.ShowDialog() == DialogResult.OK) { // The user selected a valid file name and hit OK. Get the // file name from the dialog and open the file. fileName = openFileDialog.FileName; Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application(); if (excelApp == null) { Common.ErrorMessage("Couldn't start Excel - make sure it's installed"); return; } excelApp.Visible = false; Workbook wb = excelApp.Workbooks.Open(fileName, ReadOnly: true); if (wb.Worksheets.Count > 0) { Worksheet ws = (Worksheet)wb.Worksheets[1]; string promptId, dupIds, wording, notes; PromptRecordingList recordingList = new PromptRecordingList(); int row = 7; do { promptId = ws.Cells[row, 2].Text; dupIds = ws.Cells[row, 3].Text; wording = ws.Cells[row, 4].Text; notes = ws.Cells[row, 5].Text; if (notes.Length > 0) wording = wording + " " + Strings.LabelStartBracket + notes + Strings.LabelEndBracket; if (promptId != null && promptId.Length > 0 && wording != null) { recordingList.AddPromptRecording(promptId, wording); if (dupIds != null && dupIds.Length > 0) { string[] otherIds = dupIds.Split(DuplicateIdDelimiter); foreach (string dupId in otherIds) recordingList.AddPromptRecording(dupId, wording); } } row++; } while (promptId != null && promptId.Length > 0); Common.ApplyPromptRecordingList(recordingList); } wb.Close(); excelApp.Quit(); System.Runtime.InteropServices.Marshal.ReleaseComObject(excelApp); excelApp = null; } }