public ExecutionResult InsertData(DatabaseModel insert)
{
DatabaseQuery query = DatabaseQuery.ConstructInsertStatement(insert);
ExecutionResult result = new ExecutionResult()
{
Stat = ExecutionResult.Status.Success, Data = query.Results
};
string execQuery = query.GetSQLRepresentation();
DatabaseConnection dbConn = DBController.RetrieveDBConnection();
try
{
dbConn.ExecuteQuery(execQuery);
}
catch (DBQExecutionFailException exception)
{
result.Stat = ExecutionResult.Status.Fail;
result.FailInfo = exception.InnerExceptMess;
}
DBController.ReleaseDBConnection(dbConn);
return(result);
}