public void adicionarImovel(imovel imo)
{
using (ImobGentilEntities db = new ImobGentilEntities())
{
db.imovel.Add(imo);
db.SaveChanges();
}
}
public void adicionarImagemGaleria(imagem img)
{
using (ImobGentilEntities db = new ImobGentilEntities())
{
db.imagem.Add(img);
db.SaveChanges();
}
}
public void alterarCorretorVendasAluguel(corretor cor)
{
using (ImobGentilEntities db = new ImobGentilEntities())
{
db.Entry(cor).State = System.Data.EntityState.Modified;
db.SaveChanges();
}
}
public void adicionarRegistroPermissaoParaNovoUsuario(permissoes per)
{
using (ImobGentilEntities db = new ImobGentilEntities())
{
db.permissoes.Add(per);
db.SaveChanges();
}
}
public void adicionarPagamento(pagamentos pag)
{
using (ImobGentilEntities db = new ImobGentilEntities())
{
db.pagamentos.Add(pag);
db.SaveChanges();
}
}
public void adicionarVenda(vendas ven)
{
using (ImobGentilEntities db = new ImobGentilEntities())
{
db.vendas.Add(ven);
db.SaveChanges();
}
}
public void modificarPermissao(permissoes per)
{
using (ImobGentilEntities db = new ImobGentilEntities())
{
db.Entry(per).State = System.Data.EntityState.Modified;
db.SaveChanges();
}
}
public void adicionarImagemAoImovel(imovel imo)
{
using (ImobGentilEntities db = new ImobGentilEntities())
{
db.Entry(imo).State = System.Data.EntityState.Modified;
db.SaveChanges();
}
}
public int adicionarAluguelRetornaID(locacoes aluguel)
{
using (ImobGentilEntities db = new ImobGentilEntities())
{
db.locacoes.Add(aluguel);
db.SaveChanges();
db.Entry(aluguel).GetDatabaseValues();
return(aluguel.id);
}
}
public void modificarUsuario(usuario usu)
{
using (ImobGentilEntities db = new ImobGentilEntities())
{
try
{
db.Entry(usu).State = System.Data.EntityState.Modified;
db.SaveChanges();
}
catch (Exception)
{
//só para não dar erro
}
}
}
public void AdicionarCliente(cliente cli)
{
using (ImobGentilEntities db = new ImobGentilEntities())
{
try
{
db.cliente.Add(cli);
db.SaveChanges();
}
catch (Exception)
{
throw;
}
}
}
public void AdicionarEspecializacao(especializacao esp)
{
using (ImobGentilEntities db = new ImobGentilEntities())
{
try
{
db.especializacao.Add(esp);
db.SaveChanges();
}
catch (Exception)
{
throw;
}
}
}
public void AdicionarCorretor(corretor cor)
{
using (ImobGentilEntities db = new ImobGentilEntities())
{
try
{
db.corretor.Add(cor);
db.SaveChanges();
}
catch (Exception)
{
throw;
}
}
}
public void AdicionarUsuario(usuario usu)
{
using (ImobGentilEntities db = new ImobGentilEntities())
{
try
{
db.usuario.Add(usu);
db.SaveChanges();
}
catch (Exception)
{
throw;
}
}
}
public void AdicionarEnderecoIDUsuario(pessoa pes)//funciona para adicionar o ID em todos
{
using (ImobGentilEntities db = new ImobGentilEntities())
{
try
{
db.Entry(pes).State = System.Data.EntityState.Modified;
db.SaveChanges();
}
catch (Exception)
{
throw;
}
}
}
public void modificarStatusImovelPublicacao(imovel imo)
{
using (ImobGentilEntities db = new ImobGentilEntities())
{
try
{
db.Entry(imo).State = System.Data.EntityState.Modified;
db.SaveChanges();
}
catch (Exception)
{
throw;
}
}
}
public void modificarPessoa(pessoa pes)
{
using (ImobGentilEntities db = new ImobGentilEntities())
{
try
{
db.Entry(pes).State = System.Data.EntityState.Modified;
db.SaveChanges();
}
catch (Exception)
{
// throw;
}
}
}
public void modificarStatusInteresse(interesse inte)
{
using (ImobGentilEntities db = new ImobGentilEntities())
{
try
{
db.Entry(inte).State = System.Data.EntityState.Modified;
db.SaveChanges();
}
catch (Exception)
{
throw;
}
}
}
public void modificarCorretor(endereco end)
{
using (ImobGentilEntities db = new ImobGentilEntities())
{
try
{
db.Entry(end).State = System.Data.EntityState.Modified;
db.SaveChanges();
}
catch (Exception)
{
//throw;
}
}
}
public void modificarStatusVisita(visita vis)
{
using (ImobGentilEntities db = new ImobGentilEntities())
{
try
{
db.Entry(vis).State = System.Data.EntityState.Modified;
db.SaveChanges();
}
catch (Exception)
{
throw;
}
}
}
public void AdicionarAgendamento(visita vis)
{
try
{
using (ImobGentilEntities db = new ImobGentilEntities())
{
db.visita.Add(vis);
db.SaveChanges();
}
}
catch (Exception e)
{
throw e;
//MessageBox.Show(e.Message);
}
}
public void AdicionarInteresse(interesse inte)
{
try
{
using (ImobGentilEntities db = new ImobGentilEntities())
{
db.interesse.Add(inte);
db.SaveChanges();
}
}
catch (Exception e)
{
throw e;
//MessageBox.Show(e.Message);
}
}
public void AdicionarPessoa(pessoa pes)
{
try
{
using (ImobGentilEntities db = new ImobGentilEntities())
{//adicionar pessoa e vir com a opção, se a mesma vai ser usuario, cliente ou corretor
db.pessoa.Add(pes);
//é necessario adicionar no banco, depois fazer um select ou arranjar uma forma de pegar o ultimo adicionado e adicionar a chave estrangeira no usuario
db.SaveChanges();
}
}
catch (Exception e)
{
throw e;
//MessageBox.Show(e.Message);
}
}
public void alterarCorretor(pessoa pes, corretor cor, endereco end)//funciona para adicionar o ID em todos
{
using (ImobGentilEntities db = new ImobGentilEntities())
{
try
{
db.Entry(pes).State = System.Data.EntityState.Modified;
db.SaveChanges();
}
catch (Exception)
{
throw;
}
}
using (ImobGentilEntities db = new ImobGentilEntities())
{
try
{
db.Entry(cor).State = System.Data.EntityState.Modified;
db.SaveChanges();
}
catch (Exception)
{
throw;
}
}
using (ImobGentilEntities db = new ImobGentilEntities())
{
try
{
db.Entry(end).State = System.Data.EntityState.Modified;
db.SaveChanges();
}
catch (Exception)
{
throw;
}
}
}