private int GetUserID(string user)
{
object userID = new SQLiteCommand(SQLFixedQueries.GetUserIDFromName(user), conn)
.ExecuteScalar();
if (userID != null)
{
return(Convert.ToInt32(userID));
}
else
{
new SQLiteCommand(SQLFixedQueries.InsertUsername(user), conn)
.ExecuteNonQuery();
return(Convert.ToInt32(new SQLiteCommand(SQLFixedQueries.GetRowID(), conn)
.ExecuteScalar()));
}
}
