public static int TExecuteNonQuery(string sqlCommand, IDataParameter[] parameters, DbTransaction transaction) { int affectRows = 0; DbCommand dbCommand = DbProviderFactory.CreateCommand(); dbCommand.CommandText = sqlCommand; if (parameters != null) { dbCommand.Parameters.AddRange(parameters); } GenericDatabase db = new GenericDatabase(ConnectionString, OdbcFactory.Instance); //if (parameters != null) //{ // foreach (SqlParameter parm in parameters) // { // dbCommand.Parameters.Add(parm); // } //} if (transaction != null) { affectRows = db.ExecuteNonQuery(dbCommand, transaction); } else { affectRows = db.ExecuteNonQuery(dbCommand); } return(affectRows); }
/// <summary> /// Cria um novo usuário para o Banco de dados. /// </summary> /// <param name="id_user">Chave do usuário</param> /// <param name="username">Login do usuário</param> /// <param name="password">Senha do usuário</param> public void CreateRole(int id_user, string username, string password) { try { dbCommand = db.GetSqlStringCommand("CREATE ROLE " + username.ToLower() + " LOGIN ENCRYPTED PASSWORD '" + password.ToLower() + "mechtech" + id_user.ToString() + "' SUPERUSER NOINHERIT;"); db.ExecuteNonQuery(dbCommand); } catch { throw; } }
public static Status Submit(int id, string leadin, string count, string newsitems, string highlightitems) { Status stat = new Status(); GenericDatabase db = new GenericDatabase(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString, DbProviderFactories.GetFactory("MySql.Data.MySqlClient")); DbCommand cmd = db.GetStoredProcCommand("ins_media"); DateTime dte = DateTime.Now; string name = ""; name = "BOD_News_" + GetWeekNumber(dte).ToString() + "_" + id.ToString() + "_" + dte.Year.ToString(); db.AddOutParameter(cmd, "ReturnCode", DbType.Int32, 8); db.AddOutParameter(cmd, "ErrorMessage", DbType.String, 500); db.AddOutParameter(cmd, "NewID", DbType.Int32, 8); db.AddInParameter(cmd, "InID", DbType.Int32, id); db.AddInParameter(cmd, "InName", DbType.String, name); db.AddInParameter(cmd, "InLeadin", DbType.String, leadin); db.AddInParameter(cmd, "InCount", DbType.String, count); db.AddInParameter(cmd, "InNewsItems", DbType.String, newsitems); db.AddInParameter(cmd, "InHighlightItems", DbType.String, highlightitems); db.ExecuteNonQuery(cmd); stat.ReturnCode = db.GetParameterValue(cmd, "ReturnCode") != null ? (Int32)db.GetParameterValue(cmd, "ReturnCode") : 0; stat.ErrorMessage = name + ".html"; stat.NewID = db.GetParameterValue(cmd, "NewID") != null?db.GetParameterValue(cmd, "NewID").ToString() : "0"; Entry item = new Entry(); item.Name = name; item.LeadIn = leadin; item.NewItems = newsitems; item.HighlightItems = highlightitems; item.Count = count; CreateHTML(item); return(stat); }
/// <summary> /// Cria o schema (estrutura) do Banco de dados. /// </summary> /// <param name="schema">Nome do schema representado no Banco de dados. Ex.: emp0001</param> public void CreateSchema(string schema) { try { dbCommand = db.GetSqlStringCommand("CREATE SCHEMA " + schema + " AUTHORIZATION postgres;"); db.ExecuteNonQuery(dbCommand); } catch { throw; } }