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