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