private XDocument ResultsXMLtoSDBHeader(XElement xmlDB) { //Translates TNS Formatted data into TSX readable text header // but still XML formatted // //Create a TSXSDB formatter to work with // this object will include a standard set of control fields // and empty sets of builtin and user data fields //tsxSDBdesign = new SDBDesigner(); //Stick with the standard set of control fields // Except for identifier and sdbdescription sdbDesign.ControlFields.Single(cf => cf.ControlName == SDBDesigner.IdentifierX).ControlValue = SDBIdentifier; sdbDesign.ControlFields.Single(cf => cf.ControlName == SDBDesigner.SDBDescriptionX).ControlValue = SDBDescription; //Map the tns fields on to the tsx built-in and user-defined fields // keeping track of the start of the column int fieldStart = 1; foreach (DataColumn sb in sdbDesign.HeaderMap) { string fieldName = sb.SourceDataName; int fieldWidth = sb.ColumnWidth; sb.TSXEntryName = fieldName; sb.ColumnStart = fieldStart; sb.ColumnWidth = fieldWidth; switch (fieldName) { case "ID": //1 sb.IsBuiltIn = false; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; case "Name": sb.TSXEntryName = SDBDesigner.LabelOrSearchX; sb.IsBuiltIn = true; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; case "RA": sb.TSXEntryName = SDBDesigner.RAHoursX; sb.IsBuiltIn = true; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; case "DEC": sb.TSXEntryName = SDBDesigner.DecDegreesX; sb.IsBuiltIn = true; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; case "Obj_Type": //2 sb.IsBuiltIn = false; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; case "Redshift": //3 sb.IsBuiltIn = false; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; case "Host_Name": //4 sb.IsBuiltIn = false; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; case "Host_RedShift": //5 sb.IsBuiltIn = false; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; case "Reporting_Groups": //12 sb.IsBuiltIn = false; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; //case "Discovery_Data_Sources": // sb.IsBuiltIn = false; // sb.IsPassed = true; // sdbDesign.DataFields.Add(sb); // fieldStart += fieldWidth; // break; //case "Classifying_Groups": // sb.IsBuiltIn = false; // sb.ColumnStart = fieldStart; // sb.ColumnWidth = fieldWidth; // sb.IsPassed = true; // sdbDesign.DataFields.Add(sb); // fieldStart += fieldWidth; // break; //case "Associated_Groups": // sb.IsBuiltIn = false; // sb.IsPassed = true; // sdbDesign.DataFields.Add(sb); // fieldStart += fieldWidth; // break; case "Disc_Internal_Name": //6 sb.IsBuiltIn = false; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; case "Disc_Instruments": //11 sb.IsBuiltIn = false; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; //case "Class_Instruments": // sb.IsBuiltIn = false; // sb.IsPassed = true; // sdbDesign.DataFields.Add(sb); // fieldStart += fieldWidth; // break; //case "TNS_AT": // sb.IsBuiltIn = false; // sb.IsPassed = true; // sdbDesign.DataFields.Add(sb); // fieldStart += fieldWidth; // break; //case "Public": // sb.IsBuiltIn = false; // sb.IsPassed = true; // sdbDesign.DataFields.Add(sb); // fieldStart += fieldWidth; // break; //case "End_Prop_Period": // sb.IsBuiltIn = false; // sb.IsPassed = true; // sdbDesign.DataFields.Add(sb); // fieldStart += fieldWidth; // break; case "Discovery_MagFlux": //7 sb.TSXEntryName = SDBDesigner.MagnitudeX; sb.IsBuiltIn = true; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); DataColumn sbExtra = new DataColumn(); sbExtra.SourceDataName = fieldName; sbExtra.TSXEntryName = fieldName; sbExtra.IsBuiltIn = false; sbExtra.ColumnStart = fieldStart; sbExtra.ColumnWidth = fieldWidth; sbExtra.IsPassed = true; sbExtra.IsDuplicate = true; sdbDesign.DataFields.Add(sbExtra); fieldStart += fieldWidth; break; case "Discovery_Filter": //8 sb.IsBuiltIn = false; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; case "Discovery_Date_UT": //9 sb.IsBuiltIn = false; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; case "Sender": break; case "Remarks": //10 sb.IsBuiltIn = false; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; case "Ext_catalogs": break; default: sb.IsPassed = false; break; } } //Generate the header xml return(sdbDesign.HeaderGenerator()); }
private XDocument ResultsXMLtoSDBHeader(XElement xmlDB) { sdbDesign.ControlFields.Single(cf => cf.ControlName == SDBDesigner.IdentifierX).ControlValue = SDBIdentifier; sdbDesign.ControlFields.Single(cf => cf.ControlName == SDBDesigner.SDBDescriptionX).ControlValue = SDBDescription; int fieldStart = 1; foreach (DataColumn sb in sdbDesign.HeaderMap) { string fieldName = sb.SourceDataName; int fieldWidth = sb.ColumnWidth; sb.TSXEntryName = fieldName; sb.ColumnStart = fieldStart; sb.ColumnWidth = fieldWidth; switch (fieldName) { case "Name": sb.TSXEntryName = SDBDesigner.LabelOrSearchX; sb.IsBuiltIn = true; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; case "RA": sb.TSXEntryName = SDBDesigner.RAHoursX; sb.IsBuiltIn = true; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; case "DEC": sb.TSXEntryName = SDBDesigner.DecDegreesX; sb.IsBuiltIn = true; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; case "Magnitude": sb.TSXEntryName = SDBDesigner.MagnitudeX; sb.IsBuiltIn = true; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); DataColumn sbExtra = new DataColumn(); sbExtra.SourceDataName = fieldName; sbExtra.TSXEntryName = fieldName; sbExtra.IsBuiltIn = false; sbExtra.ColumnStart = fieldStart; sbExtra.ColumnWidth = fieldWidth; sbExtra.IsPassed = true; sbExtra.IsDuplicate = true; sdbDesign.DataFields.Add(sbExtra); fieldStart += fieldWidth; break; case "NotSeen": sb.IsBuiltIn = false; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; default: sb.IsPassed = false; break; } } //Generate the header xml return(sdbDesign.HeaderGenerator()); }
private XDocument ResultsXMLtoSDBHeader(XElement xmlDB) { //Translates EXO Formatted data into TSX readable text header // but still XML formatted // //Create a TSXSDB formatter to work with // this object will include a standard set of control fields // and empty sets of builtin and user data fields //Stick with the standard set of control fields // Except for identifier and sdbdescription sdbDesign.ControlFields.Single(cf => cf.ControlName == SDBDesigner.IdentifierX).ControlValue = SDBIdentifier; sdbDesign.ControlFields.Single(cf => cf.ControlName == SDBDesigner.SDBDescriptionX).ControlValue = SDBDescription; //Map the exo fields on to the tsx built-in and user-defined fields // keeping track of the start of the column int fieldStart = 1; foreach (DataColumn sb in sdbDesign.HeaderMap) { string fieldName = sb.SourceDataName; int fieldWidth = sb.ColumnWidth; sb.TSXEntryName = fieldName; sb.ColumnStart = fieldStart; sb.ColumnWidth = fieldWidth; switch (fieldName) { case TAPName: sb.TSXEntryName = SDBDesigner.LabelOrSearchX; sb.IsBuiltIn = true; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; case TAPRA: sb.TSXEntryName = SDBDesigner.RAHoursX; sb.IsBuiltIn = true; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; case TAPDec: sb.TSXEntryName = SDBDesigner.DecDegreesX; sb.IsBuiltIn = true; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; case TAPVMag: sb.TSXEntryName = SDBDesigner.MagnitudeX; sb.IsBuiltIn = true; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); DataColumn sbExtra = new DataColumn(); sbExtra.SourceDataName = fieldName; sbExtra.TSXEntryName = fieldName; sbExtra.IsBuiltIn = false; sbExtra.ColumnStart = fieldStart; sbExtra.ColumnWidth = fieldWidth; sbExtra.IsPassed = true; sbExtra.IsDuplicate = true; sdbDesign.DataFields.Add(sbExtra); fieldStart += fieldWidth; break; case TAPSolutionType: sb.IsBuiltIn = false; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; case TAPPeriod: sb.IsBuiltIn = false; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; case TAPDistance: sb.IsBuiltIn = false; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; case TAPSpecType: sb.IsBuiltIn = false; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; case TAPTransitDuration: sb.IsBuiltIn = false; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; case TAPTransitDepth: sb.IsBuiltIn = false; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; case TAPTransitMid: sb.IsBuiltIn = false; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; case NextTransitX: sb.IsBuiltIn = false; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; case NextTransitEarliestX: sb.IsBuiltIn = false; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; case NextTransitLatestX: sb.IsBuiltIn = false; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; default: sb.IsPassed = false; break; } } //Generate the header xml return(sdbDesign.HeaderGenerator()); }
private XDocument ResultsXMLtoSDBHeader(XElement xmlDB) { //Translates TNS Formatted data into TSX readable text header // but still XML formatted // //Create a TSXSDB formatter to work with // this object will include a standard set of control fields // and empty sets of builtin and user data fields //Stick with the standard set of control fields // Except for identifier and sdbdescription sdbDesign.ControlFields.Single(cf => cf.ControlName == SDBDesigner.IdentifierX).ControlValue = SDBIdentifier; sdbDesign.ControlFields.Single(cf => cf.ControlName == SDBDesigner.SDBDescriptionX).ControlValue = SDBDescription; //Map the tns fields on to the tsx built-in and user-defined fields // keeping track of the start of the column int fieldStart = 1; foreach (DataColumn sb in sdbDesign.HeaderMap) //for (int i = 0; i < sbdDesign .HeaderMap.Count; i++) //sbdDesign.DataFields.Single(f => f.SDBColumnName == SDBDesigner.LabelOrSearchX).TNSColumnName = "Name"; { string fieldName = sb.SourceDataName; int fieldWidth = sb.ColumnWidth; sb.TSXEntryName = fieldName; sb.ColumnStart = fieldStart; sb.ColumnWidth = fieldWidth; switch (fieldName) { case "auid": sb.IsBuiltIn = false; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; case "name": sb.TSXEntryName = SDBDesigner.LabelOrSearchX; sb.IsBuiltIn = true; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; case "const": sb.IsBuiltIn = false; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; case "RA2000": sb.TSXEntryName = SDBDesigner.RAHoursX; sb.IsBuiltIn = true; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; case "Dec2000": sb.TSXEntryName = SDBDesigner.DecDegreesX; sb.IsBuiltIn = true; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; case "varType": sb.IsBuiltIn = false; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; case "maxMag": sb.TSXEntryName = SDBDesigner.MagnitudeX; sb.IsBuiltIn = true; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); DataColumn sbExtra = new DataColumn(); sbExtra.SourceDataName = fieldName; sbExtra.TSXEntryName = fieldName; sbExtra.IsBuiltIn = false; sbExtra.ColumnStart = fieldStart; sbExtra.ColumnWidth = fieldWidth; sbExtra.IsPassed = true; sbExtra.IsDuplicate = true; sdbDesign.DataFields.Add(sbExtra); fieldStart += fieldWidth; break; case "maxPass": sb.IsBuiltIn = false; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; case "minMag": sb.IsBuiltIn = false; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; case "minPass": sb.IsBuiltIn = false; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; case "epoch": break; case "novaYr": //culled -- not useful and very often empty break; case "period": sb.IsBuiltIn = false; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; case "riseDur": sb.IsBuiltIn = false; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; case "specType": sb.IsBuiltIn = false; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; case "disc": sb.IsBuiltIn = false; sb.IsPassed = true; sdbDesign.DataFields.Add(sb); fieldStart += fieldWidth; break; default: sb.IsPassed = false; break; } } //Generate the header xml return(sdbDesign.HeaderGenerator()); }