public async Task <DbStatus> Execute() { MySqlConnection connection = connector.CreateConnection(); try { await connector.OpenConnection(connection); await CreateProcedure(connection); MySqlCommand callCommand = new MySqlCommand { Connection = connection, CommandType = System.Data.CommandType.StoredProcedure, CommandText = GetProcedureName() }; await callCommand.ExecuteNonQueryAsync(); return(DbStatus.SUCCESS); } catch (MySqlException ex) { return(errorHandler.HandleException(ex)); } catch (Exception) { return(DbStatus.DATABASE_ERROR); } finally { await connector.CloseConnection(connection); } }
public async static Task <object> ExecuteScalarCommand(DbCommand <T> command) { IConnector connector = ConnectorFactory.CreateConnector(); IErrorHandling errorHandler = ErrorHandlerFactory.CreateErrorHandler(); object scalarResult = null; MySqlConnection connection = connector.CreateConnection(); try { await connector.OpenConnection(connection); scalarResult = await CommandExecutor <T> .TryExecutingScalarRead(connection, command); return(scalarResult); } catch (MySqlException exception) { errorHandler.HandleException(exception); return(scalarResult); } finally { await connector.CloseConnection(connection); } }
public async static Task <List <T> > ExecuteSelectCommand(DbCommand <T> command, T entity = default(T)) { IConnector connector = ConnectorFactory.CreateConnector(); IErrorHandling errorHandler = ErrorHandlerFactory.CreateErrorHandler(); List <T> clinics = new List <T>(); MySqlConnection connection = connector.CreateConnection(); try { await connector.OpenConnection(connection); var reader = await CommandExecutor <T> .TryExecutingSelectQueryDataReader(connection, command, entity); while (await reader.ReadAsync()) { clinics.Add(ReadOneObject(reader)); } return(clinics); } catch (MySqlException exception) { errorHandler.HandleException(exception); return(clinics); } finally { await connector.CloseConnection(connection); } }
public async Task <object> ExecuteCommand() { MySqlCommand command = new MySqlCommand(); MySqlConnection connection = connector.CreateConnection(); try { await connector.OpenConnection(connection); command.Connection = connection; command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddRange(SetParameters()); command.CommandText = GetStoredProcedureName(); return(await Execute(command)); } catch (MySqlException ex) { errorHandler.HandleException(ex); return(null); } catch (Exception) { return(null); } finally { await connector.CloseConnection(connection); } }
public async static Task <DbStatus> ExecuteCRUDCommand(DbCommand <T> command, T entity) { IConnector connector = ConnectorFactory.CreateConnector(); IErrorHandling errorHandler = ErrorHandlerFactory.CreateErrorHandler(); MySqlConnection connection = connector.CreateConnection(); try { await connector.OpenConnection(connection); return(await CommandExecutor <T> .TryExecutingCRUDQuery(connection, command, entity)); } catch (MySqlException exception) { return(errorHandler.HandleException(exception)); } finally { await connector.CloseConnection(connection); } }