private void Save2DB()
{
ODMSource odm = new ODMSource();
string msg = "";
odm.Open(@"F:\System\Database\Pearl River Basin.mdb", ref msg);
var sites = odm.GetSites("select * from Sites");
StreamReader sr = new StreamReader(Filename);
Dictionary <string, Site> dic = new Dictionary <string, Site>();
foreach (var ss in sites)
{
dic.Add(ss.Name, ss);
}
var line = sr.ReadLine();
line = sr.ReadLine();
var varid = TypeConverterEx.SkipSplit <int>(line, 6);
while (!sr.EndOfStream)
{
line = sr.ReadLine();
var buf = TypeConverterEx.Split <string>(line, TypeConverterEx.Comma);
for (int i = 0; i < varid.Length; i++)
{
odm.SaveDataValue(dic[buf[1].Trim()], varid[i], DateTime.Parse(buf[2].Trim()), double.Parse(buf[6 + i].Trim()));
}
}
odm.UpdateSeriesCatalog();
sr.Close();
odm.Close();
}
protected void Application_Start(object sender, EventArgs e)
{
string msg = "";
DBSource = new ODMSource();
DBSource.Open(Settings.Default.DBPath, ref msg);
HdyroCloud.Web.RS.RSConfig.Load();
}
private void btnConectODM_Click(object sender, EventArgs e)
{
if (viewModel.Value.ODMSource != null)
{
if (_SeriesCatalog == null)
{
_SeriesCatalog = new SeriesCatalog(viewModel.Value.ODMSource);
btnRefresh_Click(null, null);
}
else
{
MessageBox.Show("An ODM database has been connected. If you want to connect to another database, please removec connection to current database at first"
, "Database Connection", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
OpenFileDialog form = new OpenFileDialog();
form.Filter = "access 2003 file |*.mdb|access 2007-2013 file|*.accdb";
if (form.ShowDialog() == DialogResult.OK)
{
ODMSource odm = new ODMSource();
string msg = "";
if (odm.Open(form.FileName, ref msg))
{
viewModel.Value.ProjectService.Project.ODMSource = odm;
viewModel.Value.ODMSource = odm;
_SeriesCatalog = new SeriesCatalog(odm);
btnRefresh_Click(null, null);
}
else
{
MessageBox.Show("Failed to connect to the database. Error message: " + msg, "Database Connection", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
}