// 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{
}
}
