/// <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); }