public void Inserir(Frase obj)
{
//cria um objeto de conexão
SqlConnection con = new SqlConnection();
con.ConnectionString = connString.ToString();
SqlCommand cmd = new SqlCommand();
try
{
cmd.Connection = con;
cmd.CommandText = "Insert into frases (frase, autor, categoria) values (@frase, @autor, @categoria);select @@IDENTITY;";
cmd.Parameters.AddWithValue("frase", obj.Text);
cmd.Parameters.AddWithValue("autor", obj.Autor);
cmd.Parameters.AddWithValue("categoria", obj.Categoria);
con.Open();
obj.Id = Convert.ToInt32(cmd.ExecuteScalar());
}
catch (Exception e)
{
throw new Exception(e.Message);
}
finally
{
con.Close();
}
}
public void Inserir(Autor obj)
{
//cria um objeto de conexão
SqlConnection con = new SqlConnection();
con.ConnectionString = connString.ToString();
SqlCommand cmd = new SqlCommand();
try
{
cmd.Connection = con;
cmd.CommandText = "Insert into autores (nome, foto) values (@nome, @foto);select @@IDENTITY;";
cmd.Parameters.AddWithValue("nome", obj.Nome);
cmd.Parameters.AddWithValue("foto", obj.Foto);
con.Open();
obj.Id = Convert.ToInt32(cmd.ExecuteScalar());
}
catch (Exception e)
{
throw new Exception(e.Message);
}
finally
{
con.Close();
}
}
public void Inserir(Usuario obj)
{
//cria um objeto de conexão
SqlConnection con = new SqlConnection();
con.ConnectionString = connString.ToString();
SqlCommand cmd = new SqlCommand();
try
{
cmd.Connection = con;
cmd.CommandText = "Insert into usuarios (nome, email, senha) values (@nome, @email, @senha);select @@IDENTITY;";
cmd.Parameters.AddWithValue("nome", obj.Nome);
cmd.Parameters.AddWithValue("email", obj.Email);
cmd.Parameters.AddWithValue("senha", obj.Senha);
con.Open();
obj.Id = Convert.ToInt32(cmd.ExecuteScalar());
}
catch (Exception e)
{
throw new Exception(e.Message);
}
finally
{
con.Close();
}
}
public ConexionBD()
{
System.Configuration.Configuration webConfig = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("/HousingU");
System.Configuration.ConnectionStringSettings conString = webConfig.ConnectionStrings.ConnectionStrings["BDHousingU"];
con = new OdbcConnection(conString.ToString());
con.Open();
}
public cDataBase()
{
System.Configuration.Configuration rootWebConfig = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("/MyWebSiteRoot");
if (rootWebConfig.ConnectionStrings.ConnectionStrings.Count > 0)
{
System.Configuration.ConnectionStringSettings connString = rootWebConfig.ConnectionStrings.ConnectionStrings["DBConnectionString"];
oleDbCnn = new OleDbConnection(connString.ToString().ToString());
System.Configuration.ConnectionStringSettings SqlconnStr = rootWebConfig.ConnectionStrings.ConnectionStrings["SQLConnectionString"];
sqlCnn = new SqlConnection(SqlconnStr.ToString());
}
}
