// updates the data of the user. public void setUser(Usuario user) { IndignadoDBDataContext indignadoContext = new IndignadoDBDataContext(); indignadoContext.ExecuteCommand("UPDATE Usuarios SET nombre = {0}, mail = {1}, latitud = {2}, longitud = {3} WHERE id = {4}", user.nombre, user.mail, user.latitud, user.longitud, UserInfo.Id); if (user.contraseña != null) { indignadoContext.ExecuteCommand("UPDATE Usuarios SET contraseña = {0} WHERE id = {1}", user.contraseña, UserInfo.Id); } }
// get uninterested in a theme category. public void getUninterestedThemeCategory(CategoriasTematica themeCategory) { // remove interest from the database. try { IndignadoDBDataContext indignadoContext = new IndignadoDBDataContext(); indignadoContext.ExecuteCommand("DELETE FROM Intereses WHERE (idCategoriaTematica = {0}) AND (idUsuario = {1})", themeCategory.id, UserInfo.Id); indignadoContext.SubmitChanges(); } catch (Exception error) { } }
// unlikes a resource. public void unlikeResource(Recurso resource) { // remove likeResource from the database. try { IndignadoDBDataContext indignadoContext = new IndignadoDBDataContext(); indignadoContext.ExecuteCommand("DELETE FROM Aprobaciones WHERE (idRecurso = {0}) AND (idUsuario = {1})", resource.id, UserInfo.Id); indignadoContext.SubmitChanges(); } catch (Exception error) { } }
// unmark a resource as inappropriate. public void unmarkResourceInappropriate(Recurso resource) { // remove markInappropriate from the database. try { IndignadoDBDataContext indignadoContext = new IndignadoDBDataContext(); indignadoContext.ExecuteCommand("DELETE FROM MarcasInadecuados WHERE (idRecurso = {0}) AND (idUsuario = {1})", resource.id, UserInfo.Id); indignadoContext.SubmitChanges(); } catch (Exception error) { } }
// removes a resource by the user. public void removeResource(Recurso resource) { IndignadoDBDataContext indignadoContext = new IndignadoDBDataContext(); Recurso fullResource = indignadoContext.Recursos.SingleOrDefault(res => (res.id == resource.id)); if ((fullResource != null) && (fullResource.idUsuario == UserInfo.Id)) { try { indignadoContext.ExecuteCommand("DELETE FROM Aprobaciones WHERE idRecurso = {0}", resource.id); indignadoContext.ExecuteCommand("DELETE FROM MarcasInadecuados WHERE idRecurso = {0}", resource.id); indignadoContext.SubmitChanges(); indignadoContext = new IndignadoDBDataContext(); indignadoContext.ExecuteCommand("DELETE FROM Recursos WHERE (id = {0}) AND (idUsuario = {1})", resource.id, UserInfo.Id); indignadoContext.SubmitChanges(); } catch (Exception error) { } } }
// reallows a resource. public void enableResource(Recurso resource) { IndignadoDBDataContext indignadoContext = new IndignadoDBDataContext(); indignadoContext.ExecuteCommand("UPDATE Recursos SET deshabilitado = {0} WHERE id = {1}", 0, resource.id); }
// bans a user. public void banUser(Usuario user) { IndignadoDBDataContext indignadoContext = new IndignadoDBDataContext(); indignadoContext.ExecuteCommand("UPDATE Usuarios SET banned = {0} WHERE id = {1}", 1, user.id); }
// removes a current theme category. public bool removeThemeCategory(CategoriasTematica themeCategory) { try { IndignadoDBDataContext indignadoContext = new IndignadoDBDataContext(); indignadoContext.ExecuteCommand("DELETE FROM CategoriasTematicas WHERE (id = {0})", themeCategory.id); return true; } catch { return false; } }
// removes a current rss resource. public void removeRssSource(RssFeed rssSource) { IndignadoDBDataContext indignadoContext = new IndignadoDBDataContext(); try { if (rssSource.tag == null) { indignadoContext.ExecuteCommand("DELETE FROM RssFeeds WHERE url = {0} AND idMovimiento = {1} ", rssSource.url, IdMovement); } else { indignadoContext.ExecuteCommand("DELETE FROM RssFeeds WHERE url = {0} AND tag = {1} AND idMovimiento = {2} ", rssSource.url, rssSource.tag, IdMovement); } } catch{ } }