public int MaxID(string query)
{
try
{
con = new SQLiteConnection(connection);
cmd = new SQLiteCommand(query, con);
con.Open();
object val = cmd.ExecuteScalar();
int max = int.Parse(val.ToString());
return max;
}
catch (Exception)
{
//MessageBox.Show("Error\n" + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return -1;
}
}