public List <AirmenFscEntry> GetRows() { var data = new List <AirmenFscEntry>(); using (var stream = File.Open(txt_PathToExcel.Text, FileMode.Open, FileAccess.Read)) { using (var reader = ExcelReaderFactory.CreateReader(stream)) { reader.Read(); //-- Skip the header row while (reader.Read()) { if (!string.IsNullOrEmpty(reader.GetString(6))) { AirmenFscEntry entry = new AirmenFscEntry(); entry.SffpNumber = (int)reader.GetDouble(0); entry.SffpCtfn = reader.GetString(1); data.Add(entry); } } } } return(data); }
internal static string ToStringAskedEngineMethod(this AirmenFscEntry entry) { return(string.Format(@" internal static Tuple<string[], string[]> {0}_SetAskedStateForChildren(Dictionary<string, string> savedValues) {{ //Get the saved value if it exists, otherwise value is blank var savedValue = savedValues.ContainsKey(""{0}"") ? savedValues[""{0}""] : """"; //Asked/Not Asked Lists List<string> askedCtfns = new List<string>(); List<string> notAskedCtfns = new List<string>(); //Determine if the ""{0}"" is answered as ""Y"" and sets Asked State if (savedValue == ""Y"") {{ askedCtfns.Add(""{1}""); askedCtfns.Add(""{2}""); askedCtfns.Add(""{3}""); askedCtfns.Add(""{4}""); askedCtfns.Add(""{5}""); }} else {{ notAskedCtfns.Add(""{1}""); notAskedCtfns.Add(""{2}""); notAskedCtfns.Add(""{3}""); notAskedCtfns.Add(""{4}""); notAskedCtfns.Add(""{5}""); }} //Return the Asked lists as string arrays return new Tuple<string[], string[]>(askedCtfns.ToArray(), notAskedCtfns.ToArray()); }} ", entry.SffpCtfn, entry.SffpTextCtfn, entry.FscProvCommentsCtfn, entry.FscCdNcdCtfn, entry.FscWaiverCtfn, entry.FscIcd10Ctfn)); }
internal static string ToStringHtml(this AirmenFscEntry entry) { return(string.Format(@" <tr id=""row{6}"" runat=""server"" class=""hiddenQuestion""> <td> <span>SFFP {0}</span> </td> <td> <span id=""lbl_{1}"" runat=""server"" class=""textCounter width-large""> </span> </td> <td> <span class=""textCounter width-large""> <asp:CustomValidator ID=""cVal_{2}"" Enabled=""false"" Text=""*required"" ValidationGroup=""{2}"" ClientValidationFunction=""Validate_{2}"" EnableClientScript=""true"" runat=""server"" Display=""Dynamic"" CssClass=""error"" ></asp:CustomValidator> <br /> <PTCEnhanced:TextboxEnhanced ID=""txt_{2}"" CrossTabFname=""{2}"" TextMode=""Multiline"" MaxLength=""250"" TabIndex=""0"" runat=""server"" isDirty=""false""></PTCEnhanced:TextboxEnhanced> </span> </td> <td> <PTCEnhanced:DropDownListEnhanced ID=""drplst_{3}"" Enabled=""false"" CrossTabFname=""{3}"" TextMode=""SingleLine"" MaxLength=""3"" TabIndex=""0"" runat=""server"" isDirty=""false""></PTCEnhanced:DropDownListEnhanced> </td> <td> <asp:CustomValidator ID=""cVal_{4}"" Enabled=""false"" Text=""*required"" ValidationGroup=""{4}"" ClientValidationFunction=""Validate_{4}"" EnableClientScript=""true"" runat=""server"" Display=""Dynamic"" CssClass=""error"" ></asp:CustomValidator> <PTCEnhanced:DropDownListEnhanced ID=""drplst_{4}"" CrossTabFname=""{4}"" TextMode=""SingleLine"" MaxLength=""3"" TabIndex=""0"" runat=""server"" isDirty=""false""></PTCEnhanced:DropDownListEnhanced> </td> <td> <PTCEnhanced:TextboxEnhanced ID=""txt_{5}"" CrossTabFname=""{5}"" TextMode=""SingleLine"" MaxLength=""10"" TabIndex=""0"" runat=""server"" isDirty=""false""></PTCEnhanced:TextboxEnhanced> </td> </tr>", entry.SffpNumber, entry.SffpTextCtfn, entry.FscProvCommentsCtfn, entry.FscCdNcdCtfn, entry.FscWaiverCtfn, entry.FscIcd10Ctfn, entry.SffpCtfn)); }
internal static string ToStringInitialControlState(this AirmenFscEntry entry) { return(string.Format(@" if (SegmentData.ContainsKey(""{0}"") && SegmentData[""{0}""] == ""Y"") {{ row{0}.Attributes[""class""] = """"; if (IsHCP) {{ this.cVal_{1}.Enabled = true; this.cVal_{2}.Enabled = true; }} }}", entry.SffpCtfn, entry.FscProvCommentsCtfn, entry.FscWaiverCtfn)); }
internal static string ToStringValidValues(this AirmenFscEntry entry) { return(string.Format(@" new CFNameValidValue(""{0}"","""", CFNameValidValueType.Text, 250), new CFNameValidValue(""{1}"", ""CD"", CFNameValidValueType.DropList), new CFNameValidValue(""{1}"", ""NCD"", CFNameValidValueType.DropList), new CFNameValidValue(""{2}"", ""WR"", CFNameValidValueType.DropList), new CFNameValidValue(""{2}"", ""WP"", CFNameValidValueType.DropList), new CFNameValidValue(""{2}"", ""WG"", CFNameValidValueType.DropList), new CFNameValidValue(""{2}"", ""WNR"", CFNameValidValueType.DropList), new CFNameValidValue(""{2}"", ""Other"", CFNameValidValueType.DropList), new CFNameValidValue(""{3}"", """", CFNameValidValueType.Text, 10), ", entry.FscProvCommentsCtfn, entry.FscCdNcdCtfn, entry.FscWaiverCtfn, entry.FscIcd10Ctfn)); }
internal static string ToStringValidation(this AirmenFscEntry entry) { return(String.Format(@" function Validate_{0}(sender, args) {{ if ( <%= IsHCP ? ""true"" : ""false""%> && document.getElementById(""txt_{0}"").value.length < 1) {{ args.IsValid = false; }} else {{ args.IsValid = true; }} }} function Validate_{1}(sender, args) {{ if ( <%= IsHCP ? ""true"" : ""false""%> && document.getElementById(""drplst_{2}"").value == ""CD"" && document.getElementById(""drplst_{1}"").value.length < 1) {{ args.IsValid = false; }} else {{ args.IsValid = true; }} }}", entry.FscProvCommentsCtfn, entry.FscWaiverCtfn, entry.FscCdNcdCtfn)); }
internal static string ToStringResponseReview(this AirmenFscEntry entry) { return(string.Format(@" //ROW {0} // SFFP Number new ReviewContentHTML {{ CrossTabFieldName = ""{1}"", IsRedirectable = true, translate = kvp => LabelDefinitions.FSC_SFFP_FPE_StaticLabel() }}, new ReviewContentResponse {{ CrossTabFieldName = ""{1}"", IsRedirectable = true, translate = kvp => LabelDefinitions.SFFP_{0}StaticLabel() }}, // SFFP SM Response new ReviewContentHTML {{ CrossTabFieldName = ""{2}"", IsRedirectable = true, translate = kvp => LabelDefinitions.FSC_COMMENTS_StaticLabel() }}, new ReviewContentResponse {{ CrossTabFieldName = ""{2}"", IsRedirectable = true, translate = kvp => AHLTA_ValueConversion.TranslateTextboxValue(kvp[""{2}""]) }}, // Provider Comments new ReviewContentHTML {{ CrossTabFieldName = ""{3}"", IsRedirectable = true, translate = kvp => LabelDefinitions.FSC_PROVIDER_COMMENTS_StaticLabel() }}, new ReviewContentResponse {{ CrossTabFieldName = ""{3}"", IsRedirectable = true, translate = kvp => AHLTA_ValueConversion.TranslateTextboxValue(kvp[""{3}""]) }}, // NCD/CD new ReviewContentHTML {{ CrossTabFieldName = ""{4}"", IsRedirectable = true, translate = kvp => LabelDefinitions.FSC_CD_NCD_StaticLabel() }}, new ReviewContentResponse {{ CrossTabFieldName = ""{4}"", IsRedirectable = true, translate = kvp => AHLTA_ValueConversion.TranslateTextboxValue(kvp[""{4}""]) }}, // Waiver new ReviewContentHTML {{ CrossTabFieldName = ""{5}"", IsRedirectable = true, translate = kvp => LabelDefinitions.FSC_WAIVER_StaticLabel() }}, new ReviewContentResponse {{ CrossTabFieldName = ""{5}"", IsRedirectable = true, translate = kvp => AHLTA_ValueConversion.TranslateTextboxValue(kvp[""{5}""]) }}, // ICD10 new ReviewContentHTML {{ CrossTabFieldName = ""{6}"", IsRedirectable = true, translate = kvp => LabelDefinitions.FSC_ICD10_StaticLabel() }}, new ReviewContentResponse {{ CrossTabFieldName = ""{6}"", IsRedirectable = true, translate = kvp => AHLTA_ValueConversion.TranslateTextboxValue(kvp[""{6}""]) }},", entry.SffpNumber, entry.SffpCtfn, entry.SffpTextCtfn, entry.FscProvCommentsCtfn, entry.FscCdNcdCtfn, entry.FscWaiverCtfn, entry.FscIcd10Ctfn)); }
internal static string ToStringAskedEngineRegistry(this AirmenFscEntry entry) { return(string.Format(@" {{ ""{0}"", AskedCalculators.{0}_SetAskedStateForChildren }},", entry.SffpCtfn)); }