private void loadButton_Click(object sender, RoutedEventArgs e)
{
errorMessage.Content = null;
try
{
using (SessionNoServer session = new SessionNoServer(s_systemDir))
{
Console.WriteLine($"Running with databases in directory: {session.SystemDirectory}");
session.BeginUpdate();
File.Copy(s_licenseDbFile, System.IO.Path.Combine(session.SystemDirectory, "4.odb"), true);
string line;
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\Allstar.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
AllStar allStar = new AllStar(line);
session.Persist(allStar);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\AllstarFull.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
AllStarFull allStar = new AllStarFull(line);
session.Persist(allStar);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\Appearances.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
Appearances a = new Appearances(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\AwardsManagers.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
AwardsManagers a = new AwardsManagers(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\AwardsPlayers.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
AwardsPlayers a = new AwardsPlayers(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\AwardsShareManagers.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
AwardsShareManagers a = new AwardsShareManagers(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\AwardsSharePlayers.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
AwardsSharePlayers a = new AwardsSharePlayers(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\Batting.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
Batting a = new Batting(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\BattingPost.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
BattingPost a = new BattingPost(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\Fielding.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
Fielding a = new Fielding(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\FieldingOF.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
FieldingOF a = new FieldingOF(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\FieldingPost.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
FieldingPost a = new FieldingPost(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\HallOfFame.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
HallOfFame a = new HallOfFame(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\HOFold.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
HOFold a = new HOFold(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\Managers.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
Managers a = new Managers(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\ManagersHalf.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
ManagersHalf a = new ManagersHalf(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\Master.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
Master a = new Master(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\Pitching.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
Pitching a = new Pitching(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\PitchingPost.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
PitchingPost a = new PitchingPost(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\Salaries.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
Salaries a = new Salaries(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\Schools.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
Schools a = new Schools(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\SchoolsPlayers.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
SchoolsPlayers a = new SchoolsPlayers(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\SeriesPost.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
SeriesPost a = new SeriesPost(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\Teams.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
Teams a = new Teams(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\TeamsFranchises.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
TeamsFranchises a = new TeamsFranchises(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\TeamsHalf.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
TeamsHalf a = new TeamsHalf(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\Xref_Stats.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
Xref_Stats a = new Xref_Stats(line);
session.Persist(a);
}
}
session.Commit();
errorMessage.Content = "Done, databases located in: " + session.SystemDirectory + " View objects using VelocityDBBrowser";
}
}
catch (Exception ex)
{
errorMessage.Content = ex.Message == null?ex.ToString() : ex.Message;
}
}
private void loadButton_Click(object sender, RoutedEventArgs e)
{
errorMessage.Content = null;
try
{
using (SessionNoServer session = new SessionNoServer(s_systemDir))
{
Console.WriteLine($"Running with databases in directory: {session.SystemDirectory}");
session.BeginUpdate();
File.Copy(s_licenseDbFile, System.IO.Path.Combine(session.SystemDirectory, "4.odb"), true);
string line;
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\Allstar.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
AllStar allStar = new AllStar(line);
session.Persist(allStar);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\AllstarFull.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
AllStarFull allStar = new AllStarFull(line);
session.Persist(allStar);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\Appearances.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
Appearances a = new Appearances(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\AwardsManagers.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
AwardsManagers a = new AwardsManagers(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\AwardsPlayers.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
AwardsPlayers a = new AwardsPlayers(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\AwardsShareManagers.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
AwardsShareManagers a = new AwardsShareManagers(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\AwardsSharePlayers.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
AwardsSharePlayers a = new AwardsSharePlayers(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\Batting.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
Batting a = new Batting(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\BattingPost.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
BattingPost a = new BattingPost(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\Fielding.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
Fielding a = new Fielding(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\FieldingOF.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
FieldingOF a = new FieldingOF(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\FieldingPost.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
FieldingPost a = new FieldingPost(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\HallOfFame.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
HallOfFame a = new HallOfFame(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\HOFold.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
HOFold a = new HOFold(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\Managers.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
Managers a = new Managers(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\ManagersHalf.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
ManagersHalf a = new ManagersHalf(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\Master.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
Master a = new Master(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\Pitching.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
Pitching a = new Pitching(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\PitchingPost.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
PitchingPost a = new PitchingPost(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\Salaries.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
Salaries a = new Salaries(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\Schools.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
Schools a = new Schools(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\SchoolsPlayers.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
SchoolsPlayers a = new SchoolsPlayers(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\SeriesPost.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
SeriesPost a = new SeriesPost(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\Teams.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
Teams a = new Teams(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\TeamsFranchises.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
TeamsFranchises a = new TeamsFranchises(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\TeamsHalf.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
TeamsHalf a = new TeamsHalf(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\Xref_Stats.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
Xref_Stats a = new Xref_Stats(line);
session.Persist(a);
}
}
session.Commit();
errorMessage.Content = "Done, databases located in: " + session.SystemDirectory + " View objects using VelocityDBBrowser";
}
}
catch (Exception ex)
{
errorMessage.Content = ex.Message == null ? ex.ToString() : ex.Message;
}
}
