public virtual bool Check(System.Data.DataTable dt)
{
bool succ = true;
var dt_source = ODM.GetDataTable(TableName, 1);
var col_external = from DataColumn dc in dt.Columns select dc.ColumnName;
var col_source = from DataColumn dc in dt_source.Columns select dc.ColumnName;
foreach (var str in col_source)
{
if (!col_external.Contains(str))
{
_Message = string.Format("The neccessary field {0} is missing", str);
succ = false;
break;
}
}
if (!succ)
{
return(false);
}
else
{
return(succ);
}
}
private void cmbObsVars_SelectedIndexChanged(object sender, EventArgs e)
{
if (ODM != null)
{
var pck = Package as IDataPackage;
var site = cmbObsSite.SelectedItem as Site;
var varb = cmbObsVars.SelectedItem as Variable;
var ts = ODM.GetTimeSeries(new QueryCriteria()
{
Start = pck.StartOfLoading,
End = pck.EndOfLoading,
SiteID = site.ID,
VariableID = varb.ID,
VariableName = varb.Name
});
if (ts != null)
{
var derieved_ts = TimeSeriesAnalyzer.Derieve(ts, pck.NumericalDataType, pck.TimeUnits);
string sereis = string.Format("{1} at {0}", site.Name, varb.Name);
if (btnCompareMode.Checked)
{
var sim_site = cmbSimSite.SelectedItem as Site;
if (sim_site != null && sim_site.TimeSeries != null)
{
TimeSeriesAnalyzer.Compensate(derieved_ts, sim_site.TimeSeries);
winChart_timeseries.Plot <double>(derieved_ts.DateTimes, derieved_ts[0, ":", "0"], sereis);
}
}
else
{
winChart_timeseries.Plot <double>(derieved_ts.DateTimes, derieved_ts[0, ":", "0"], sereis);
}
}
}
}
public override void CustomExport(DataTable source)
{
if (source != null)
{
var sites = GetSites(source);
var setting = _ExportSetting as SiteExportSetting;
foreach (var site in sites)
{
var series = new ObservationSeries()
{
SiteID = site.ID,
VariableID = setting.VariableID
};
var ts = ODM.GetTimeSereis(series);
if (ts != null)
{
var filename = Path.Combine(setting.Directory, site.Name + ".csv");
var var_odm = ODM.GetVariable(setting.VariableID);
ts.Name = var_odm.Name;
CSVFileStream csv = new CSVFileStream(filename);
csv.Save(ts);
}
}
}
}
public override bool Check(DataTable dt)
{
bool succ = true;
var dt_source = ODM.GetDataTable(TableName, 1);
var col_external = from DataColumn dc in dt.Columns select dc.ColumnName;
var col_source = (from DataColumn dc in dt_source.Columns select dc.ColumnName).ToList();
col_source.Remove("ValueID");
foreach (var str in col_source)
{
if (!col_external.Contains(str))
{
_Message = string.Format("The neccessary field {0} is missing", str);
succ = false;
break;
}
}
if (!succ)
{
return(false);
}
else
{
return(succ);
}
}
private void ODMDatabaseListLoad()
{
odmList.Items.Clear();
List <string> odmDBList = new List <string>();
TimeSeriesResources tmObj = new TimeSeriesResources();
odmDBList = tmObj.GetODMList();
foreach (string s in odmDBList)
{
odmList.Items.Add(s);
}
if (odmList.Items.Count > 0)
{
odmList.SelectedValue = odmList.Items[odmList.Items.Count - 1].ToString();
}
siteCodeDropDownList.Items.Clear();
variableCodeDropDownList.Items.Clear();
ODM odmInfo = new ODM();
DataTable dt = new DataTable();
if (odmList.Items.Count > 0)
{
dt = odmInfo.GetODMInfo(odmList.Items[odmList.Items.Count - 1].ToString());
}
foreach (DataRow row in dt.Rows)
{
Title.Text = row["title"].ToString();
serverName.Text = row["serveraddress"].ToString();
Topic.Text = row["topiccategory"].ToString();
abstractODM.Text = row["abstract"].ToString();
citation.Text = row["citation"].ToString();
}
TimeSeriesResources tmResObj = new TimeSeriesResources();
if (odmList.Items.Count > 0)
{
timeSeriesTable = tmResObj.GetTimeSeriesResources(odmList.Items[odmList.Items.Count - 1].ToString());
}
odmInfoGridView.DataSource = timeSeriesTable;
odmInfoGridView.DataBind();
ViewState["mydata"] = timeSeriesTable;
//recordCount.Text = timeSeriesTable.Rows.Count.ToString() + " records";
List <string> siteCodeListObj = new List <string>();
List <string> variableCodeListObj = new List <string>();
foreach (DataRow row in timeSeriesTable.Rows)
{
siteCodeListObj.Add(row["sitecode"].ToString());
variableCodeListObj.Add(row["variablecode"].ToString());
}
siteCodeDropDownList.DataSource = siteCodeListObj.Distinct().ToList();
siteCodeDropDownList.DataBind();
variableCodeDropDownList.DataSource = variableCodeListObj.Distinct().ToList();
variableCodeDropDownList.DataBind();
}
/// <summary>
/// Initializes a new instance of the <see cref="RWSSubjects"/> class.
/// </summary>
/// <param name="xmlString">The XML string.</param>
public RWSSubjects(string xmlString)
{
ODM odm = RWSHelpers.Serializers.XmlDeserializeFromString <ODM>(xmlString);
foreach (var clinData in odm.ClinicalData)
{
SubjectListItems.Add(new RWSSubjectListItem(clinData));
}
}
/// <summary>
/// Initializes a new instance of the <see cref="RWSStudies"/> class.
/// </summary>
/// <param name="xmlString">The XML string.</param>
public RWSStudies(string xmlString)
{
ODM odm = RWSHelpers.Serializers.XmlDeserializeFromString <ODM>(xmlString);
foreach (var study in odm.Study)
{
StudyListItems.Add(new RWSStudyListItem(study));
}
}
private void cmbSite_SelectedIndexChanged(object sender, EventArgs e)
{
if (cmbSite.SelectedItem != null && ODM != null)
{
var site = cmbSite.SelectedItem as Site;
var varbs = ODM.GetVariables(site.ID);
cmbObsVars.DataSource = varbs;
}
}
protected void Page_Load(object sender, EventArgs e)
{
resourceInfoDisplayGrid.Width = 6000;
if (!IsPostBack)
{
string odmName = Request.QueryString["odmname"];
ODM odmObj = new ODM();
DataTable dt = new DataTable();
dt = odmObj.GetUploadODMInfo(odmName);
resourceInfoDisplayGrid.DataSource = dt;
resourceInfoDisplayGrid.DataBind();
}
}
protected void Button2_Click(object sender, EventArgs e)
{
if (automatedDOICheckBox.Checked)
{
ODM odmObj = new ODM();
odmObj.LoadODM(odmList.SelectedValue.ToString());
odmList.Items.Clear();
loadODMList();
}
else
{
Response.Redirect("customdoi.aspx?odmname=" + odmList.SelectedValue.ToString());
}
}
private void BindSites()
{
var projectService = MyAppManager.Instance.CompositionContainer.GetExportedValue <IProjectService>();
ODM = projectService.Project.ODMSource;
if (ODM != null)
{
var sites = ODM.GetSites(Settings.Default.GagingStationSQL);
if (sites != null)
{
cmbSite.DataSource = sites;
}
}
}
private void BindSites()
{
var projectService = MyAppManager.Instance.CompositionContainer.GetExportedValue <IProjectService>();
ODM = projectService.Project.ODMSource;
if (ODM != null)
{
var sites = ODM.GetSites(SQLSelection);
if (sites != null)
{
cmbObsSite.DataSource = sites;
}
}
}
private void OnTriggerEnter2D(Collider2D collision)
{
//Debug.Log(collision.gameObject.ToString());
Attached = true;
self.simulated = false;
if (Shooter != null)
{
ODM script = Shooter.GetComponent <ODM>();
if (script != null)
{
script.OnAttached(gameObject);
}
}
}
private void btnTest_Click(object sender, EventArgs e)
{
var sql = tbSQL.Text;
if (sql != "" && ODM != null)
{
var dt = ODM.Execute(sql);
if (dt != null)
{
this.bindingSource1.DataSource = dt;
this.dataGridView1.DataSource = this.bindingSource1;
this.btnOK.Enabled = true;
SQLScript = tbSQL.Text;
}
}
}
/// <summary>
/// Initializes a new instance of the <see cref="RWSStudyMetadataVersions"/> class.
/// </summary>
/// <param name="xmlString">The XML string.</param>
public RWSStudyMetadataVersions(string xmlString)
{
ODM odm = RWSHelpers.Serializers.XmlDeserializeFromString <ODM>(xmlString);
if (odm.Study.Count == 0)
{
return;
}
Study = new RWSStudyListItem(odm.Study.First());
foreach (var version in odm.Study.First().MetaDataVersion)
{
MetaDataVersions.Add(new RWSMetaDataVersion(version));
}
}
protected void odmList_SelectedIndexChanged(object sender, EventArgs e)
{
ODM odmInfo = new ODM();
DataTable dt = new DataTable();
string s = odmList.SelectedItem.ToString();
dt = odmInfo.GetODMInfo(odmList.SelectedValue.ToString());
foreach (DataRow row in dt.Rows)
{
Title.Text = row["title"].ToString();
serverName.Text = row["serveraddress"].ToString();
Topic.Text = row["topiccategory"].ToString();
abstractODM.Text = row["abstract"].ToString();
citation.Text = row["citation"].ToString();
waterOneWSDL.Text = row["wateroneflowwsdl"].ToString();
}
}
public override void Finish()
{
SMW.ODM odmUtils = new ODM();
//Utilities utils = new Utilities();
string outputPath;
if (_outDir != null)
{
outputPath = _outDir + "/GreenAmpt_output.csv";
}
else
{
outputPath = "../GreenAmpt_output.csv";
}
//------ Create ODM csv -----
if (_Vals.Count > 0)
{
//Set Datetimes
odmUtils.DateTimes = _DateTimes;
//Set Values
odmUtils.Values = _Vals;
//Set Variable
odmUtils.VariableName = "Streamflow";
//Set Corresponding Variable Code
odmUtils.VariableCode = "3";
//Set Site Name
string siteName = this.GetModelID().ToString();
odmUtils.SiteName = siteName;
//Select a Unique Site ID
odmUtils.SiteCode = "40";
//Set CSV Path
odmUtils.CSVPath = System.Environment.CurrentDirectory;
//Write CSV file
odmUtils.CreateODMcsv();
Console.WriteLine("ODM .csv has been written");
//Write BAT file
odmUtils.CreateBat();
Console.WriteLine("ODM .bat has been written");
//Load CSV into ODM by executing the BAT file
odmUtils.LoadIntoODM();
Console.WriteLine("Data has been loaded");
}
}
private void loadODMList()
{
odmList.Items.Clear();
TimeSeriesResources tmRes = new TimeSeriesResources();
List <string> loadedODMList = tmRes.GetODMList();
ODM odmObj = new ODM();
List <string> loadList = odmObj.GetODMList();
foreach (string s in loadedODMList)
{
loadList.Remove(s);
}
foreach (string s in loadList)
{
odmList.Items.Add(s);
}
}
private void ODMInfoload(string odmName)
{
odmList.SelectedValue = odmName;
ODM odmInfo = new ODM();
DataTable dt = new DataTable();
string s = odmList.SelectedItem.ToString();
dt = odmInfo.GetODMInfo(odmName);
foreach (DataRow row in dt.Rows)
{
Title.Text = row["title"].ToString();
serverName.Text = row["serveraddress"].ToString();
Topic.Text = row["topiccategory"].ToString();
abstractODM.Text = row["abstract"].ToString();
citation.Text = row["citation"].ToString();
waterOneWSDL.Text = row["wateroneflowwsdl"].ToString();
}
}
private void cmbObsSite_SelectedIndexChanged(object sender, EventArgs e)
{
if (ODM != null)
{
var site = cmbObsSite.SelectedItem as Site;
var varbs = ODM.GetVariables(site.ID);
var pck = Package as IDataPackage;
if (varbs != null)
{
var selected_var = from vv in varbs where vv.ID == pck.ODMVariableID select vv;
if (selected_var != null)
{
cmbObsVars.DataSource = selected_var.ToArray();
}
else
{
cmbObsVars.DataSource = null;
}
}
}
}
protected void odmList_SelectedIndexChanged(object sender, EventArgs e)
{
siteCodeDropDownList.Items.Clear();
variableCodeDropDownList.Items.Clear();
ODM odmInfo = new ODM();
DataTable dt = new DataTable();
dt = odmInfo.GetODMInfo(odmList.SelectedValue.ToString());
foreach (DataRow row in dt.Rows)
{
Title.Text = row["title"].ToString();
serverName.Text = row["serveraddress"].ToString();
Topic.Text = row["topiccategory"].ToString();
abstractODM.Text = row["abstract"].ToString();
citation.Text = row["citation"].ToString();
}
TimeSeriesResources tmResObj = new TimeSeriesResources();
timeSeriesTable = tmResObj.GetTimeSeriesResources(odmList.SelectedValue.ToString());
odmInfoGridView.DataSource = timeSeriesTable;
odmInfoGridView.DataBind();
ViewState["mydata"] = timeSeriesTable;
//recordCount.Text = timeSeriesTable.Rows.Count.ToString() + " records";
List <string> siteCodeListObj = new List <string>();
List <string> variableCodeListObj = new List <string>();
foreach (DataRow row in timeSeriesTable.Rows)
{
siteCodeListObj.Add(row["sitecode"].ToString());
variableCodeListObj.Add(row["variablecode"].ToString());
}
siteCodeDropDownList.DataSource = siteCodeListObj.Distinct().ToList();
siteCodeDropDownList.DataBind();
variableCodeDropDownList.DataSource = variableCodeListObj.Distinct().ToList();
variableCodeDropDownList.DataBind();
}
private void cmbObsVars_SelectedIndexChanged(object sender, EventArgs e)
{
if (ODM != null)
{
var site = cmbSite.SelectedItem as Site;
var varb = cmbObsVars.SelectedItem as Variable;
var ts = ODM.GetTimeSeries(new QueryCriteria()
{
Start = _SFROutputPackage.StartOfLoading,
End = _SFROutputPackage.EndOfLoading,
SiteID = site.ID,
VariableID = varb.ID,
VariableName = varb.Name
});
if (ts != null)
{
var derieved_ts = TimeSeriesAnalyzer.Derieve(ts, _SFROutputPackage.NumericalDataType, _SFROutputPackage.TimeUnits);
string sereis = string.Format("{1} at {0}", site.Name, varb.Name);
winChart_timeseries.Plot <double>(derieved_ts.DateTimes, derieved_ts[0, ":", "0"], sereis);
}
}
}
/*
* Function : gatherSpreadsheet()
* Description : Gets data from excel spreadsheet and store it into the dictionaries accordingly.
* Params : (ref Dictionary<string, List<rowInfo>>) weeklyRowDict
* (ref Dictionary<string, List<rowInfo>>) dailyRowDict
* (ref Dictionary<string, List<rowInfo>>) wigigRowDict
* (string) dateString
* Return :
*/
public void GatherSpreadsheet(ref Dictionary <string, List <rowInfo> > weeklyRowDict, ref Dictionary <string, List <rowInfo> > dailyRowDict, ref Dictionary <string, List <rowInfo> > wigigRowDict, string dateString)
{
p.logger("[DataRetrieval.cs] Gathering data from spreadsheets");
string[] cx = Directory.GetFiles(ConfigurationManager.AppSettings["reportPath"], dateString + "_CX*");
string[] wz = Directory.GetFiles(ConfigurationManager.AppSettings["reportPath"], dateString + "_WZ*");
string[] cx_wigig = Directory.GetFiles(ConfigurationManager.AppSettings["reportPath"], dateString + "_WIGIG_CX*");
string[] fs = Directory.GetFiles(ConfigurationManager.AppSettings["reportPath"], dateString + "_FS*");
string[] odmList = { "CX", "WZ", "FS" };
foreach (string ODM in odmList)
{
var application = new Microsoft.Office.Interop.Excel.Application();
application.Visible = false;
p.logger("[DataRetrieval.cs] Gathering data from " + ODM);
// Open up the Excel sheet for the current ODM
Workbooks workbooks = application.Workbooks;
Workbook workbook = null;
if (ODM.Equals("CX") && cx.Length > 0)
{
workbook = workbooks.Open(cx[0], ReadOnly: false);
}
else if (ODM.Equals("WZ") && wz.Length > 0)
{
workbook = workbooks.Open(wz[0], ReadOnly: false);
}
else if (ODM.Equals("FS") && fs.Length > 0)
{
workbook = workbooks.Open(fs[0], ReadOnly: false);
}
Process pid = GetProcess(application);
if (workbook == null)
{
continue;
}
var worksheets = workbook.Worksheets;
// Iterate over the products' worksheets to insert data
for (int i = 1; i <= worksheets.Count; i++)
{
Worksheet worksheet = (Worksheet)workbook.Worksheets[i];
var rowCountTemp = worksheet.UsedRange;
var rowCountTemp2 = rowCountTemp.Rows;
int rowCount = rowCountTemp2.Count - 1;
bool insertDailyData = false;
int titleCount = 0;
if (rowCountTemp != null)
{
Marshal.ReleaseComObject(rowCountTemp);
}
if (rowCountTemp2 != null)
{
Marshal.ReleaseComObject(rowCountTemp2);
}
// Start at the 2nd position because the first position contains the column titles.
// Iterate over all of the used rows to get data and save data to dictionaries.
for (int j = 2; j < (rowCount + 2); j++)
{
int k = 0;
var rangeTemp = worksheet.UsedRange;
Range range1 = rangeTemp.Rows[j];
rowInfo row = new rowInfo();
if (rangeTemp != null)
{
Marshal.ReleaseComObject(rangeTemp);
}
foreach (Range r in range1.Cells)
{
string value = r.Text;
if ((string.IsNullOrEmpty(value) || string.IsNullOrWhiteSpace(value)) && (titleCount < 6))
{
insertDailyData = true;
if (value.Equals("Work Year") ||
value.Equals("Work Week") ||
value.Equals("Work Day") ||
value.Equals("Failed Boards") ||
value.Equals("Total Boards") ||
value.Equals("Failure Rate (%)"))
{
titleCount++;
}
}
if (!insertDailyData)
{
switch (k)
{
case 0:
row.WorkYear = value;
break;
case 1:
row.WorkWeek = value;
break;
case 2:
int temp;
Int32.TryParse(value, out temp);
row.FailedBoards = temp;
break;
case 3:
int temp2;
Int32.TryParse(value, out temp2);
row.TotalBoards = temp2;
break;
case 4:
row.FailureRate = value;
break;
case 5:
row.Goal = value;
break;
}
}
else
{
if (string.IsNullOrEmpty(value) ||
string.IsNullOrWhiteSpace(value) ||
value.Equals("Work Year") ||
value.Equals("Work Week") ||
value.Equals("Work Day") ||
value.Equals("Failed Boards") ||
value.Equals("Total Boards") ||
value.Equals("Failure Rate (%)"))
{
continue;
}
else
{
switch (k)
{
case 0:
row.WorkYear = value;
break;
case 1:
row.WorkWeek = value;
break;
case 2:
row.WorkDay = value;
break;
case 3:
int temp;
Int32.TryParse(value, out temp);
row.FailedBoards = temp;
break;
case 4:
int temp2;
Int32.TryParse(value, out temp2);
row.TotalBoards = temp2;
break;
case 5:
row.FailureRate = value;
break;
}
}
}
k++;
if (r != null)
{
Marshal.ReleaseComObject(r);
}
}
row.ODM = ODM;
if (string.IsNullOrEmpty(row.WorkYear) ||
string.IsNullOrEmpty(row.WorkWeek) ||
string.IsNullOrWhiteSpace(row.WorkYear) ||
string.IsNullOrWhiteSpace(row.WorkWeek))
{
continue;
}
if (!insertDailyData)
{
weeklyRowDict[worksheet.Name].Add(row);
}
else
{
dailyRowDict[worksheet.Name].Add(row);
}
if (range1 != null)
{
Marshal.ReleaseComObject(range1);
}
}
if (worksheet != null)
{
Marshal.ReleaseComObject(worksheet);
}
}
// Clean up the COM objects to remove "EXCEL.EXE" process
if (worksheets != null)
{
Marshal.ReleaseComObject(worksheets);
}
if (workbooks != null)
{
Marshal.ReleaseComObject(workbooks);
}
if (workbook != null)
{
workbook.Close(Type.Missing, Type.Missing, Type.Missing);
Marshal.ReleaseComObject(workbook);
}
if (application != null)
{
application.Quit();
Marshal.ReleaseComObject(application);
}
pid.Kill();
p.logger("[DataRetrieval.cs] Finished gathering data for " + ODM);
}
if (cx_wigig.Length <= 0)
{
return;
}
// Gather CX WIGIG data from spreadsheet
var app = new Microsoft.Office.Interop.Excel.Application();
app.Visible = false;
Workbooks wbs = app.Workbooks;
Workbook wb = wbs.Open(cx_wigig[0], ReadOnly: false);
Process pidWigig = GetProcess(app);
p.logger("[DataRetrieval.cs] Gathering data for WIGIG");
var ws = wb.Worksheets;
for (int i = 1; i <= ws.Count; i++)
{
Worksheet worksheet = (Worksheet)wb.Worksheets[i];
var rowCountTemp = worksheet.UsedRange;
var rowCountTemp2 = rowCountTemp.Rows;
int rowCount = rowCountTemp2.Count - 1;
if (rowCountTemp != null)
{
Marshal.ReleaseComObject(rowCountTemp);
}
if (rowCountTemp2 != null)
{
Marshal.ReleaseComObject(rowCountTemp2);
}
for (int j = 2; j < (rowCount + 2); j++)
{
int k = 0;
var rangeTemp = worksheet.UsedRange;
Range range1 = rangeTemp.Rows[j];
rowInfo row = new rowInfo();
if (rangeTemp != null)
{
Marshal.ReleaseComObject(rangeTemp);
}
foreach (Range r in range1.Cells)
{
string value = r.Text;
switch (k)
{
case 0:
row.WorkYear = value;
break;
case 1:
row.WorkWeek = value;
break;
case 2:
row.WorkDay = value;
break;
case 3:
int temp;
Int32.TryParse(value, out temp);
row.FailedBoards = temp;
break;
case 4:
int temp2;
Int32.TryParse(value, out temp2);
row.TotalBoards = temp2;
break;
case 5:
row.FailureRate = value;
break;
}
k++;
if (r != null)
{
Marshal.ReleaseComObject(r);
}
}
row.ODM = "CX";
if (string.IsNullOrEmpty(row.WorkYear) ||
string.IsNullOrEmpty(row.WorkWeek) ||
string.IsNullOrWhiteSpace(row.WorkYear) ||
string.IsNullOrWhiteSpace(row.WorkWeek))
{
continue;
}
else
{
wigigRowDict[worksheet.Name].Add(row);
}
if (range1 != null)
{
Marshal.ReleaseComObject(range1);
}
}
if (worksheet != null)
{
Marshal.ReleaseComObject(worksheet);
}
}
if (ws != null)
{
Marshal.ReleaseComObject(ws);
}
if (wbs != null)
{
Marshal.ReleaseComObject(wbs);
}
if (wb != null)
{
wb.Close(Type.Missing, Type.Missing, Type.Missing);
Marshal.ReleaseComObject(wb);
}
if (app != null)
{
app.Quit();
Marshal.ReleaseComObject(app);
}
pidWigig.Kill();
p.logger("[DataRetrieval.cs] Finished gathering data for WIGIG");
}
