// Add Contato para o usuario
public void AddContato(string email, int idUser)
{
using (SignalRBDEntities db = new SignalRBDEntities())
{
User u = GetUserByEmail(email);
CONTATOS cont = new CONTATOS
{
id_usu = idUser,
id_cont = u.IdUser
};
CONTATOS otherCont = new CONTATOS
{
id_usu = u.IdUser,
id_cont = idUser
};
CONVERSAS conversa = new CONVERSAS
{
nome = null,
e_grupo = 0
};
db.CONTATOS.Add(cont);
db.CONTATOS.Add(otherCont);
db.CONVERSAS.Add(conversa);
db.SaveChanges();
db.Database.ExecuteSqlCommand("INSERT INTO INTEGRANTES(id_usu, id_conversa) VALUES(@idUser, @id_conversa)", new SqlParameter("@idUser", idUser), new SqlParameter("@id_conversa", conversa.id_conversa));
db.Database.ExecuteSqlCommand("INSERT INTO INTEGRANTES(id_usu, id_conversa) VALUES(@idUser, @id_conversa)", new SqlParameter("@idUser", u.IdUser), new SqlParameter("@id_conversa", conversa.id_conversa));
}
}
//Deleta contato do usuario
public void DelContato(int idCont, int idUser)
{
using (SignalRBDEntities db = new SignalRBDEntities())
{
CONTATOS cont = db.CONTATOS.Where(x => x.id_usu == idUser && x.id_cont == idCont).First();
CONTATOS otherCont = db.CONTATOS.Where(x => x.id_usu == idCont && x.id_cont == idUser).First();
db.CONTATOS.Remove(cont);
db.CONTATOS.Remove(otherCont);
db.SaveChanges();
}
}
