public bool CreateAdmin(string login, string password)
{
if (string.IsNullOrWhiteSpace(login))
{
throw new Exception("Empty Login");
}
if (string.IsNullOrWhiteSpace(password))
{
throw new Exception("Empty Password");
}
string q = "insert into tbl_admins (login,pass) values (@L,@P)";
SQLiteCommand cmd = Conn.CreateCommand();
cmd.CommandText = q;
cmd.Parameters.Add(new SQLiteParameter("L", login));
cmd.Parameters.Add(new SQLiteParameter("P", password.MD5Hash()));
try
{
SQLiteTransaction trans = Conn.BeginTransaction();
cmd.ExecuteNonQuery();
trans.Commit();
return(true);
}
catch (Exception ex)
{
KCore.ShowKError(ex.Message);
return(false);
}
}
public bool ExecuteNonQuery(SQLiteCommand cmd)
{
bool answer = false;
SQLiteTransaction t = Conn.BeginTransaction();
try
{
cmd.ExecuteNonQuery();
t.Commit();
answer = true;
}
catch (SQLiteException sex)
{
KCore.ShowKError(sex.Message);
t.Rollback();
}
catch (Exception ex)
{
KCore.ShowKError(ex.Message);
t.Rollback();
}
return(answer);
}
