public void Inserir([FromBody] string conteudo)
{
Models.WhatsappDataContext dataContext = new Models.WhatsappDataContext();
Models.GrupoUsuario novoMembro = JsonConvert.DeserializeObject <Models.GrupoUsuario>(conteudo);
dataContext.GrupoUsuarios.InsertOnSubmit(novoMembro);
dataContext.SubmitChanges();
}
public List <Models.Usuario> Listar()
{
Models.WhatsappDataContext dc = new Models.WhatsappDataContext();
var r = from u in dc.Usuarios select u;
return(r.ToList());
}
public void Inserir([FromBody] string conteudo)
{
Models.Usuario usuario = JsonConvert.DeserializeObject <Models.Usuario>(conteudo);
Models.WhatsappDataContext dc = new Models.WhatsappDataContext();
dc.Usuarios.InsertOnSubmit(usuario);
dc.SubmitChanges();
}
public void Criar([FromBody] string conteudo)
{
Models.WhatsappDataContext dataContext = new Models.WhatsappDataContext();
Models.Grupo grupo = JsonConvert.DeserializeObject <Models.Grupo>(conteudo);
dataContext.Grupos.InsertOnSubmit(grupo);
dataContext.SubmitChanges();
}
public Models.Usuario PuxarUsuario(string nome)
{
Models.WhatsappDataContext dataContext = new Models.WhatsappDataContext();
var r = (from u in dataContext.Usuarios
where u.nome == nome
select u).Single();
return(r);
}
public List <Models.GrupoUsuario> Listar(int grupo_id)
{
Models.WhatsappDataContext dc = new Models.WhatsappDataContext();
var r = from m in dc.GrupoUsuarios
where m.grupo_id == grupo_id
select m;
return(r.ToList());
}
public List <Models.Grupo> ListarMeuGrupos(int usuario_id)
{
Models.WhatsappDataContext dc = new Models.WhatsappDataContext();
List <Models.Grupo> grupos = (from g in dc.Grupos
where g.idAdm == usuario_id
select g).ToList();
return(grupos);
}
public void Deletar(string nome)
{
Models.WhatsappDataContext dc = new Models.WhatsappDataContext();
var r = (from u in dc.Usuarios
where u.nome == nome
select u).Single();
dc.Usuarios.DeleteOnSubmit(r);
dc.SubmitChanges();
}
public void AlterarUri(string nome, [FromBody] string conteudo)
{
Models.Usuario usuario = JsonConvert.DeserializeObject <Models.Usuario>(conteudo);
Models.WhatsappDataContext dc = new Models.WhatsappDataContext();
Models.Usuario r = (from u in dc.Usuarios
where u.nome == nome
select u).Single();
r.uri = usuario.uri;
dc.SubmitChanges();
}
public void Alterar(int id, [FromBody] string conteudo)
{
Models.WhatsappDataContext dataContext = new Models.WhatsappDataContext();
Models.Grupo grupo = JsonConvert.DeserializeObject <Models.Grupo>(conteudo);
Models.Grupo grupoBD = (from g in dataContext.Grupos
where g.id == id
select g).Single();
grupoBD.descricao = grupo.descricao;
dataContext.SubmitChanges();
}
public string ConsultarPorNome(string nome)
{
try
{
Models.WhatsappDataContext dc = new Models.WhatsappDataContext();
var r = (from u in dc.Usuarios
where u.nome == nome
select u.nome).Single();
return(r);
}
catch (Exception)
{
return("");
}
}
public void Deletar(int id)
{
Models.WhatsappDataContext dc = new Models.WhatsappDataContext();
var r = (from g in dc.Grupos
where g.id == id
select g).Single();
var membros = from m in dc.GrupoUsuarios
where m.grupo_id == r.id
select m;
dc.GrupoUsuarios.DeleteAllOnSubmit(membros);
dc.Grupos.DeleteOnSubmit(r);
dc.SubmitChanges();
}
public List <Models.Grupo> Listar(int usuario_id)
{
Models.WhatsappDataContext dc = new Models.WhatsappDataContext();
List <Models.Grupo> grupos = new List <Models.Grupo>();
List <Models.GrupoUsuario> grupoPart = (from gm in dc.GrupoUsuarios
where gm.usuario_id == usuario_id
select gm).ToList();
foreach (var item in grupoPart)
{
Models.Grupo r = (from g in dc.Grupos
where g.id == item.grupo_id
select g).Single();
grupos.Add(r);
}
return(grupos);
}
public void Enviar(string uri, [FromBody] string conteudo)
{
Models.Mensagem mensagem = JsonConvert.DeserializeObject <Models.Mensagem>(conteudo);
Models.WhatsappDataContext dc = new Models.WhatsappDataContext();
try
{
HttpWebRequest sendNotificationRequest = (HttpWebRequest)WebRequest.Create(uri);
sendNotificationRequest.Method = "POST";
string toastMessage = "<?xml version=\"1.0\" encoding=\"utf-8\"?>" +
"<wp:Notification xmlns:wp=\"WPNotification\">" +
"<wp:Toast>" +
"<wp:Text1>" + mensagem.Remetente + "</wp:Text1>" +
"<wp:Text2>" + mensagem.Conteudo + "</wp:Text2>" +
"<wp:Param>/Usuario/LerMsg.xaml?NavigatedFrom=Toast Notification</wp:Param>" +
"</wp:Toast> " +
"</wp:Notification>";
byte[] notificationMessage = Encoding.Default.GetBytes(toastMessage);
// Set the web request content length.
sendNotificationRequest.ContentLength = notificationMessage.Length;
sendNotificationRequest.ContentType = "text/xml";
sendNotificationRequest.Headers.Add("X-WindowsPhone-Target", "toast");
sendNotificationRequest.Headers.Add("X-NotificationClass", "2");
using (Stream requestStream = sendNotificationRequest.GetRequestStream())
{
requestStream.Write(notificationMessage, 0, notificationMessage.Length);
}
}
catch (Exception)
{
throw;
}
}
public void Deletar(Models.GrupoUsuario membro)
{
Models.WhatsappDataContext dataContext = new Models.WhatsappDataContext();
dataContext.GrupoUsuarios.DeleteOnSubmit(membro);
dataContext.SubmitChanges();
}