private void PlayTimeListView_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
var listView = (ListView)sender;
var item = listView.ContainerFromElement((DependencyObject)e.OriginalSource) as ListViewItem;
if (item != null)
{
TimeSummary g = (TimeSummary)PlayTimeListView.SelectedItem;
if (g.time != 0)
{
List <GameTimeSummary> glist = new List <GameTimeSummary>();
using (SQLiteCommand command = conn.CreateCommand())
{
conn.Open();
command.CommandText = @"SELECT g.title, p.playtime FROM games g,playtime p
WHERE g.uid=p.game AND p.datetime=date('"
+ g.d.ToString("yyyy-MM-dd") + @"') ";
using (SQLiteDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
glist.Add(new GameTimeSummary(reader["title"].ToString(), Convert.ToInt32(reader["playtime"].ToString())));
}
}
}
conn.Close();
Dialog.GameTimeGraph gtg = new GameTimeGraph(glist, g.d.ToString("yyyy-MM-dd"));
gtg.Owner = Window.GetWindow(this);
if (gtg.ShowDialog() == true)
{
}
}
}
}
private void PlayTimeListView_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
var listView = (ListView)sender;
var item = listView.ContainerFromElement((DependencyObject)e.OriginalSource) as ListViewItem;
if (item != null)
{
TimeSummary g = (TimeSummary)PlayTimeListView.SelectedItem;
if (g.time != 0)
{
List <GameTimeSummary> glist = new List <GameTimeSummary>();
using (SQLiteCommand command = conn.CreateCommand())
{
string hideNukige = "";
if (Settings.Default.hideNukige)
{
hideNukige = @" AND g.nukige = 0 ";
}
conn.Open();
command.CommandText =
@"SELECT g.title,SUM(p.playtime) playtime
FROM games g,playtime p
WHERE g.uid=p.game " + hideNukige + @"
AND p.datetime BETWEEN
date('" + g.d.ToString("yyyy-MM-dd") + @"') AND
date('" + g.d.AddMonths(1).AddDays(-1).ToString("yyyy-MM-dd") + @"')
GROUP BY g.uid" ;
using (SQLiteDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
glist.Add(new GameTimeSummary(reader["title"].ToString(), Convert.ToInt32(reader["playtime"].ToString())));
}
}
}
conn.Close();
Dialog.GameTimeGraph gtg = new GameTimeGraph(glist, g.d.ToString("yyyy-MM-dd") + "~" + g.d.AddMonths(1).AddDays(-1).ToString("yyyy-MM-dd"), GraphType.Monthly);
gtg.Owner = Window.GetWindow(this);
if (gtg.ShowDialog() == true)
{
}
}
}
}
