private void lstbSessions_SelectedIndexChanged(object sender, EventArgs e)
{
ListBoxSessionItem item = (ListBoxSessionItem)lstbSessions.SelectedItem;
if (item != null)
{
Session session = storage.findSession(item.id);
if (session == null)
{
return;
}
pGridSession.SelectedObject = session;
currentSession = session;
enableDisableButtons(true, true);
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
DialogResult result = MessageBox.Show("Are you sure you want to permanently delete this session?", "Delete session", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
ListBoxSessionItem item = (ListBoxSessionItem)lstbSessions.SelectedItem;
if (item != null)
{
storage.deleteSession(item.id);
loadSessionsInList();
loadStatistics();
enableDisableButtons(false, true);
}
}
}
public List <ListBoxSessionItem> findSessionsForUser(string user, EventType cof)
{
SQLiteConnection con = new SQLiteConnection(connString);
con.Open();
SQLiteCommand cmd = new SQLiteCommand("select id, decimalScoring, score, decimalScore,innerX, startTime " +
" from Sessions where user = @user and courseOfFire = @cof " +
" order by id desc", con);
cmd.Parameters.AddWithValue("@cof", cof.Name);
cmd.Parameters.AddWithValue("@user", user);
SQLiteDataReader rdr = cmd.ExecuteReader();
List <ListBoxSessionItem> ret = new List <ListBoxSessionItem>();
while (rdr.Read())
{
long id = rdr.GetInt64(0);
int decimalScoring = rdr.GetInt32(1);
int score = rdr.GetInt32(2);
decimal decimalScore = rdr.GetDecimal(3);
int innerX = rdr.GetInt32(4);
DateTime date = convertStringToDate(rdr.GetString(5));
if (decimalScoring == 0)
{
ListBoxSessionItem item = new ListBoxSessionItem(date.ToString("yyyy-MM-dd"), score + "-" + innerX + "x", id);
ret.Add(item);
}
else
{
ListBoxSessionItem item = new ListBoxSessionItem(date.ToString("yyyy-MM-dd"), decimalScore + "-" + innerX + "x", id);
ret.Add(item);
}
}
rdr.Close();
con.Close();
return(ret);
}