/// <summary>
/// Выполнить SQL скрипт
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnExecute_Click(object sender, EventArgs e)
{
if (SQLExecutor.ConnectionStringTest())
{
SQLExecutor.Execute(rtextboxSQLQuery.Text);
}
else
{
MessageBox.Show("Нет соединения с базой данных.\r\nПроверьте строку подключения.", "Невозможно выполнить запрос.", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public ActionResult Index(SQLRequest request, bool exportToFile = false)
{
var executor = new SQLExecutor();
var result = executor.Execute(request);
if (exportToFile)
{
return(new FileContentResult(Encoding.UTF8.GetBytes(result.ToString()), "text/plain")
{
FileDownloadName = "QueryResult.txt"
});
}
return(View(result));
}
protected override bool AddUserData(AccountData userData)
{
string query = "INSERT INTO Accounts VALUES (@username, @passwordhash, @salt, @difficulty, @accesslevel, @contact)";
try
{
SqlCommand command = new SqlCommand(query, sqlExecutor.Connection);
command.Parameters.AddWithValue("@username", userData.Username);
command.Parameters.AddWithValue("@passwordhash", userData.PasswordHash);
command.Parameters.AddWithValue("@salt", userData.Salt);
command.Parameters.AddWithValue("@difficulty", userData.Difficulty);
command.Parameters.AddWithValue("@accesslevel", userData.AccessLevel);
command.Parameters.AddWithValue("@contact", userData.Contact);
return(sqlExecutor.Execute(command.ExecuteNonQuery) > 0);
}
catch (SqlException ex)
{
Logger.Log(LogLevel.Error, "Error while adding to database: {0}", ex.Message);
}
return(false);
}
