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