public int Execute_ReturnID(ConnectionString connString, DbCommandGeneric dbCmd) { MySqlCommand cmd = new MySqlCommand(); try { cmd.Connection = new MySqlConnection(connString.ConnString); cmd.Connection.Open(); cmd.CommandText = dbCmd.DbCommand.CommandText; int rowsAffected = cmd.ExecuteNonQuery(); if (rowsAffected > 0) { return(Convert.ToInt32(cmd.LastInsertedId)); } else { return(-1); } } catch (Exception ex) { Uteis.GravarLogErro(ex.TargetSite.Name, ex.Message); return(-1); } finally { cmd.Connection.Close(); } }
private DbCommandGeneric GetCommand() { var dbCmd = new DbCommandGeneric(); DAO dao = new DAO(); dbCmd.DbCommand = dao.getCommand(ConnectionString); dbCmd.DbCommand.CommandText = CommandText; return(dbCmd); }
public Object ExecuteScalar(DbCommandGeneric dbCmd) { Object obj; try { obj = dbCmd.DbCommand.ExecuteScalar(); } catch (Exception ex) { obj = null; throw ex; } if (Connection.DbCommand == null) { dbCmd.DbCommand.Connection.Close(); } return(obj); }
public int Execute(DbCommandGeneric dbCmd) { int rowsAffected = -1; try { string commandTextTemp = dbCmd.DbCommand.CommandText; List <DbParameter> parametersTemp = new List <DbParameter>(); foreach (DbParameter parametro in dbCmd.DbCommand.Parameters) { parametersTemp.Add(parametro); } dbCmd.DbCommand.CommandText = commandTextTemp; dbCmd.DbCommand.Parameters.Clear(); foreach (DbParameter parametro in parametersTemp) { dbCmd.DbCommand.Parameters.Add(parametro); } rowsAffected = dbCmd.DbCommand.ExecuteNonQuery(); } catch (Exception ex) { rowsAffected = 0; throw ex; } finally { if (Connection.DbCommand == null) { dbCmd.DbCommand.Connection.Close(); } } return(rowsAffected); }