public DTTenantInfo GetTenantInfo(String movimiento)
{
DTTenantInfo info = new DTTenantInfo();
var db = new IndignadoDBDataContext();
var movInfo = db.Movimientos.SingleOrDefault(m => m.url == movimiento);
if (movInfo == null)
{
// si no lo encontro
throw new FaultException("No existe un movimiento con ese nombre!");
}
if (!movInfo.habilitado)
{
// si no lo encontro
throw new FaultException("El movimiento fue deshabilitado!");
}
info.name = movInfo.nombre;
info.habilitado = movInfo.habilitado;
info.id = movInfo.id;
info.logo = movInfo.logo;
info.layoutFile = movInfo.Layout.layoutFile;
return info;
}
// returns all theme categories.
public Collection<CategoriasTematica> getThemeCategoriesList()
{
// only get theme categories from this movement.
IndignadoDBDataContext indignadoContext = new IndignadoDBDataContext();
IEnumerable<CategoriasTematica> themeCategoriesEnum = indignadoContext.ExecuteQuery<CategoriasTematica>("SELECT id, idMovimiento, titulo, descripcion FROM CategoriasTematicas WHERE idMovimiento = {0}", IdMovement);
Collection<CategoriasTematica> themeCategoriesCol = new Collection<CategoriasTematica>();
foreach (CategoriasTematica themeCategory in themeCategoriesEnum)
{
// get own interest
if (UserInfo != null)
{
IEnumerable<int> myInterests = indignadoContext.ExecuteQuery<int>("SELECT COUNT(*) FROM Intereses WHERE (idCategoriaTematica = {0}) AND (idUsuario = {1})", themeCategory.id, UserInfo.Id);
foreach (int myInterest in myInterests)
{
themeCategory.miInteres = myInterest;
}
}
// add item to the collection
themeCategoriesCol.Add(themeCategory);
}
// return the collection
return themeCategoriesCol;
}
// adds a new rss resource.
public void addRssSource(RssFeed rssSource)
{
IndignadoDBDataContext indignadoContext = new IndignadoDBDataContext();
rssSource.idMovimiento = IdMovement;
indignadoContext.RssFeeds.InsertOnSubmit(rssSource);
indignadoContext.SubmitChanges();
}
// ******************
// controller methods
// ******************
// creates a movement.
public void createMovement(Movimiento movement)
{
// fixes the movement settings
movement.habilitado = true;
movement.url.Replace(' ', '_');
if (movement.maxMarcasInadecuadasRecursoX < 1)
{
movement.maxMarcasInadecuadasRecursoX = 5;
}
if (movement.maxRecursosInadecuadosUsuarioZ < 1)
{
movement.maxRecursosInadecuadosUsuarioZ = 5;
}
if (movement.maxRecursosPopularesN < 1)
{
movement.maxRecursosPopularesN = 5;
}
if (movement.maxUltimosRecursosM < 1)
{
movement.maxUltimosRecursosM = 5;
}
// creates the movement.
IndignadoDBDataContext indignadoContext = new IndignadoDBDataContext();
indignadoContext.Movimientos.InsertOnSubmit(movement);
indignadoContext.SubmitChanges();
// get the movement's id.
IEnumerable<Movimiento> movementsEnum = indignadoContext.ExecuteQuery<Movimiento> ("SELECT id FROM Movimiento WHERE nombre = {0}", movement.nombre);
int idMov = -1;
foreach (Movimiento mov in movementsEnum)
{
if (mov.nombre == movement.nombre)
{
idMov = mov.id;
}
}
// creates the movement admin.
DTRegisterModel user = new DTRegisterModel();
user.nombre = "movadmin";
user.apodo = "movadmin";
user.contraseña = "1234";
user.idMovimiento = idMov;
user.latitud = (float)movement.latitud;
user.longitud = (float)movement.longitud;
user.mail = movement.nombre + "@tsi1.com.uy";
Usuario userDb = DTToClass.DTToUsuario(user);
userDb.banned = false;
userDb.privilegio = (short) Roles.MovAdminMask;
userDb.fechaRegistro = new DateTime(DateTime.UtcNow.Year, DateTime.UtcNow.Month, DateTime.UtcNow.Day, DateTime.UtcNow.Hour, DateTime.UtcNow.Minute, 0);
indignadoContext.Usuarios.InsertOnSubmit(userDb);
// submit changes to the database
indignadoContext.SubmitChanges();
}
public void disableMovement(int id)
{
var db = new IndignadoDBDataContext();
var mov = db.Movimientos.SingleOrDefault(m => (m.id == id));
if (mov != null)
{
mov.habilitado = false;
db.SubmitChanges();
}
}
public static void RefreshNewsList(object o)
{
try
{
var controller = o as NewsResourcesController;
IndignadoDBDataContext indignadoContext = new IndignadoDBDataContext();
List<Movimiento> movimientos = indignadoContext.Movimientos.ToList();
foreach (Movimiento mov in movimientos)
{
IEnumerable<RssFeed> fuentesEnum = indignadoContext.ExecuteQuery<RssFeed>
("SELECT * FROM RssFeeds WHERE idMovimiento = {0}", mov.id);
// get items from the sources.
Collection<List<RssItem>> ColRssLists = new Collection<List<RssItem>>();
Collection<String> colRssSourceTitle = new Collection<String>();
Collection<String> colRssSourceUrl = new Collection<String>();
foreach (RssFeed source in fuentesEnum)
{
List<RssItem> rssItemsList = RssDocument.Load(new System.Uri(source.url)).Channel.Items;
ColRssLists.Add(rssItemsList);
colRssSourceTitle.Add(source.titulo);
colRssSourceUrl.Add(source.url);
if (ColRssLists.Count > 10)
{
break;
}
}
// add items to the collection.
Collection<DTRssItem> rssItemsCol = new Collection<DTRssItem>();
if (ColRssLists.Count > 0)
{
for (int j = 0; j < 10; j++)
{
List<RssItem> rssItemsList = ColRssLists[j % ColRssLists.Count];
if (rssItemsList.Count > (j / ColRssLists.Count))
{
DTRssItem dtRssItem = ClassToDT.RssItemToDT(rssItemsList[j / ColRssLists.Count]);
dtRssItem.sourceTitle = colRssSourceTitle[j % colRssSourceTitle.Count];
dtRssItem.sourceUrl = colRssSourceUrl[j % colRssSourceTitle.Count];
rssItemsCol.Add(dtRssItem);
}
}
controller._rssItemsCol[mov.id] = rssItemsCol;
}
}
}
catch (Exception error) {
}
}
// returns a list of available layouts
public List<DTLayout> getLayouts()
{
var db = new IndignadoDBDataContext();
var layouts = db.Layouts.ToList();
var dtList = new List<DTLayout>();
foreach (var layout in layouts)
{
dtList.Add(ClassToDT.LayoutToDT(layout));
}
return dtList;
}
public DTLoginInfo Login(int idMovimiento, String userName, String password)
{
if (null == userName || null == password)
{
throw new ArgumentNullException();
}
// calculo el hash del password
HashAlgorithm sha = new SHA1CryptoServiceProvider();
byte[] passwordHash = sha.ComputeHash(ASCIIEncoding.ASCII.GetBytes(password));
byte[] noPass = new byte[1];
noPass[0] = 0;
// busco el usuario en la base de datos
var db = new IndignadoDBDataContext();
var user = db.Usuarios.SingleOrDefault(u => (u.idMovimiento == idMovimiento &&
u.apodo == userName &&
u.contraseña == passwordHash &&
u.contraseña != noPass) ||
(u.apodo == userName &&
u.contraseña == passwordHash &&
u.contraseña != noPass &&
(u.privilegio & IndignadoServer.Roles.SysAdminMask) == IndignadoServer.Roles.SysAdminMask));
// usuario inexistente o contraseña incorrecta.
if (user == null)
{
throw new FaultException("Unknown username or incorrect password");
}
// usuario deshabilitado.
bool isRegUser = true;
bool isMovAdmin = (user.privilegio & IndignadoServer.Roles.MovAdminMask) == IndignadoServer.Roles.MovAdminMask;
bool isSysAdmin = (user.privilegio & IndignadoServer.Roles.SysAdminMask) == IndignadoServer.Roles.SysAdminMask;
if (user.banned && !isMovAdmin && !isSysAdmin)
{
Usuario movAdmin = db.Usuarios.SingleOrDefault(u => (u.idMovimiento == idMovimiento) && ((u.privilegio & IndignadoServer.Roles.MovAdminMask) == IndignadoServer.Roles.MovAdminMask));
throw new FaultException("The user is banned, please contact the movement administrator at " + movAdmin.mail + ".");
}
String token = GenerateToken();
_usersOnline[token] = new UserOnlineInfo(user.id, user.apodo, user.privilegio, idMovimiento, token);
return new DTLoginInfo(user.apodo, user.id, token, isRegUser, isMovAdmin, isSysAdmin);
}
// ******************
// controller methods
// ******************
// gets the user's movement.
public Movimiento getMovement()
{
// get movement from database
Movimiento movement;
IndignadoDBDataContext indignadoContext = new IndignadoDBDataContext();
try
{
movement = indignadoContext.Movimientos.Single(x => x.id == IdMovement);
}
catch
{
movement = null;
}
return movement;
}
// adds a new theme category.
public void addThemeCategory(CategoriasTematica themeCategory)
{
// set foreign ids
themeCategory.idMovimiento = IdMovement;
// add the theme category to the database
try
{
IndignadoDBDataContext indignadoContext = new IndignadoDBDataContext();
indignadoContext.CategoriasTematicas.InsertOnSubmit(themeCategory);
indignadoContext.SubmitChanges();
}
catch (Exception error)
{
}
}
// get interested in a theme category.
public void getInterestedThemeCategory(CategoriasTematica themeCategory)
{
// create an interest
Interese interest = new Interese();
interest.idCategoriaTematica = themeCategory.id;
interest.idUsuario = UserInfo.Id;
// add interest to the database.
try
{
IndignadoDBDataContext indignadoContext = new IndignadoDBDataContext();
indignadoContext.Intereses.InsertOnSubmit(interest);
indignadoContext.SubmitChanges();
}
catch (Exception error)
{
}
}
public DTUserCreateStatus RegisterUser(DTRegisterModel user)
{
DTUserCreateStatus status;
status = DTUserCreateStatus.Success;
IndignadoDBDataContext indignadoContext = new IndignadoDBDataContext();
Usuario userDb = DTToClass.DTToUsuario(user);
userDb.banned = false;
userDb.privilegio = 0;
userDb.fechaRegistro = new DateTime(DateTime.UtcNow.Year, DateTime.UtcNow.Month, DateTime.UtcNow.Day, DateTime.UtcNow.Hour, DateTime.UtcNow.Minute, 0);
try
{
indignadoContext.Usuarios.InsertOnSubmit(userDb);
indignadoContext.SubmitChanges();
}
catch (Exception ex)
{
status = DTUserCreateStatus.GenericError;
}
return status;
}
// converts a resources enumerable to a collection.
private DTResourcesCol_NewsResources toResourcesCol(IEnumerable<Recurso> recursosEnum, int itemsNumber, int pageNumber)
{
IndignadoDBDataContext indignadoContext = new IndignadoDBDataContext();
// create new resources datatypes collection.
DTResourcesCol_NewsResources dtResourcesCol = new DTResourcesCol_NewsResources();
dtResourcesCol.items = new Collection<DTResource_NewsResources>();
Collection<Recurso> colecciontrucha = new Collection<Recurso>();
foreach (Recurso resource in recursosEnum)
{
colecciontrucha.Add(resource);
}
// get page number
int itemsCount = colecciontrucha.Count();
int maxpag = (itemsCount / itemsNumber);
if (itemsCount % itemsNumber != 0){
maxpag++;
}
if (pageNumber > maxpag) {
pageNumber = maxpag;
}
dtResourcesCol.currentPage = pageNumber;
dtResourcesCol.maxPage = maxpag;
//recursosEnum = recursosEnum.Skip((pageNumber-1)*itemsNumber);
// for each resource, ...
int counter = 0;
foreach (Recurso resource in colecciontrucha)
{
counter++;
if (counter <= (pageNumber - 1) * itemsNumber)
{
continue;
}
// get own like
if (UserInfo != null)
{
IEnumerable<int> iLikesIt = indignadoContext.ExecuteQuery<int>("SELECT COUNT(*) FROM Aprobaciones WHERE (idRecurso = {0}) AND (idUsuario = {1})", resource.id, UserInfo.Id);
foreach (int iLikeIt in iLikesIt)
{
resource.meGusta = iLikeIt;
}
}
// get own mark as inappropriate
if (UserInfo != null)
{
IEnumerable<int> myMarksInappr = indignadoContext.ExecuteQuery<int>("SELECT COUNT(*) FROM MarcasInadecuados WHERE (idRecurso = {0}) AND (idUsuario = {1})", resource.id, UserInfo.Id);
foreach (int myMarkInappr in myMarksInappr)
{
resource.yoMarqueInadecuado = myMarkInappr;
}
}
// add item to the collection
dtResourcesCol.items.Add(ClassToDT.ResourceToDT_NewsResources(resource));
// stop at the desired number of items.
if (dtResourcesCol.items.Count >= itemsNumber)
{
break;
}
}
return dtResourcesCol;
}
public DTLoginInfo LoginFB(int idMovimiento, String accesToken)
{
if (null == accesToken)
{
throw new ArgumentNullException();
}
FacebookUser fbUser = Facebook.GetInfo(accesToken);
// busco el usuario en la base de datos
var db = new IndignadoDBDataContext();
var fbUserDB = db.UsuarioFacebooks.SingleOrDefault(u => (u.idMovimiento == idMovimiento &&
u.idFacebook == fbUser.id));
if (fbUserDB == null)
{
throw new FaultException<LoginFault>(new LoginFault("El usuario logueado por facebook no se encuentra registrado", DTLoginFaultType.FB_NOT_REGISTERED));
}
var userDB = db.Usuarios.SingleOrDefault(u => (u.id == fbUserDB.idUsuario));
if (userDB.banned)
{
Usuario movAdmin = db.Usuarios.SingleOrDefault(u => (u.idMovimiento == idMovimiento) && ((u.privilegio & IndignadoServer.Roles.MovAdminMask) == IndignadoServer.Roles.MovAdminMask));
throw new FaultException("The user is banned, please contact the movement administrator at " + movAdmin.mail + ".");
}
String token = GenerateToken();
_usersOnline[token] = new UserOnlineInfo(userDB.id, userDB.apodo, userDB.privilegio, idMovimiento, token);
bool isRegUser = true;
bool isMovAdmin = (userDB.privilegio & IndignadoServer.Roles.MovAdminMask) == IndignadoServer.Roles.MovAdminMask;
bool isSysAdmin = (userDB.privilegio & IndignadoServer.Roles.SysAdminMask) == IndignadoServer.Roles.SysAdminMask;
return new DTLoginInfo(userDB.apodo, userDB.id, token, isRegUser, isMovAdmin, isSysAdmin);
}
public DTUserCreateStatus RegisterFBUser(DTRegisterFBModel user)
{
DTUserCreateStatus status;
status = DTUserCreateStatus.Success;
FacebookUser fbUser = Facebook.GetInfo(user.token);
IndignadoDBDataContext indignadoContext = new IndignadoDBDataContext();
Usuario userDb = new Usuario();
userDb.nombre = fbUser.name;
userDb.apodo = fbUser.first_name;
userDb.mail = fbUser.email;
userDb.idMovimiento = user.idMovimiento;
userDb.latitud = user.latitud;
userDb.longitud = user.longitud;
byte[] noPass = new byte[1];
noPass[0] = 0;
userDb.contraseña = noPass;
userDb.banned = false;
userDb.privilegio = 0;
userDb.fechaRegistro = new DateTime(DateTime.UtcNow.Year, DateTime.UtcNow.Month, DateTime.UtcNow.Day, DateTime.UtcNow.Hour, DateTime.UtcNow.Minute, 0);
try
{
indignadoContext.Usuarios.InsertOnSubmit(userDb);
indignadoContext.SubmitChanges();
}
catch (Exception ex)
{
status = DTUserCreateStatus.GenericError;
}
if (status == DTUserCreateStatus.Success)
{
UsuarioFacebook fbUserDb = new UsuarioFacebook();
fbUserDb.idUsuario = userDb.id;
fbUserDb.idFacebook = (int) fbUser.id;
fbUserDb.idMovimiento = user.idMovimiento;
indignadoContext.UsuarioFacebooks.InsertOnSubmit(fbUserDb);
indignadoContext.SubmitChanges();
}
return status;
}
// 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)
{
}
}
// returns all resources published by the movement admin.
public DTResourcesCol_NewsResources getResourcesListMovAdmin(int pageNumber)
{
IndignadoDBDataContext indignadoContext = new IndignadoDBDataContext();
Usuario movAdmin = indignadoContext.Usuarios.SingleOrDefault(u => (u.idMovimiento == IdMovement) && ((u.privilegio & IndignadoServer.Roles.MovAdminMask) == IndignadoServer.Roles.MovAdminMask));
IEnumerable<Recurso> resourcesEnum = indignadoContext.ExecuteQuery<Recurso>
("SELECT Recursos.id, Recursos.idUsuario, Usuarios.apodo AS apodoUsuario, titulo, descripcion, fecha, tipo, urlLink, urlImage, urlVideo, urlThumb, CantAprobaciones.cantAprobaciones FROM Recursos LEFT JOIN Usuarios ON (Usuarios.id = Recursos.idUsuario) LEFT JOIN (SELECT idRecurso, COUNT (idUsuario) AS cantAprobaciones FROM Aprobaciones GROUP BY idRecurso) CantAprobaciones ON (CantAprobaciones.idRecurso = Recursos.id) WHERE (Usuarios.idMovimiento = {0}) AND (Usuarios.id = {1}) ORDER BY Recursos.id DESC", IdMovement, movAdmin.id);
Movimiento movement = indignadoContext.Movimientos.Single(x => x.id == IdMovement);
return toResourcesCol(resourcesEnum, movement.maxUltimosRecursosM, pageNumber);
}
// 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);
}
}
// returns all the data of the user.
public Usuario getUser(Usuario user)
{
IndignadoDBDataContext indignadoContext = new IndignadoDBDataContext();
Usuario fullUser = indignadoContext.Usuarios.SingleOrDefault(u => (u.id == user.id));
if (fullUser.idMovimiento != IdMovement)
{
throw new FaultException ("The user doesn't belong to the movement");
}
else {
return fullUser;
}
}
// mark a resource as inappropriate.
public void markResourceInappropriate(Recurso resource)
{
// create a markInappropriate
MarcasInadecuado markInappropriate = new MarcasInadecuado();
markInappropriate.idRecurso = resource.id;
markInappropriate.idUsuario = UserInfo.Id;
try
{
// get database context.
IndignadoDBDataContext indignadoContext = new IndignadoDBDataContext();
// get the movement.
Movimiento movement = indignadoContext.Movimientos.Single(x => x.id == IdMovement);
// add markInappropriate to the database.
indignadoContext.MarcasInadecuados.InsertOnSubmit(markInappropriate);
indignadoContext.SubmitChanges();
indignadoContext = new IndignadoDBDataContext();
// get number of marks of the resource.
int numberMarksResource = 0;
IEnumerable<int> numbersMarksR = indignadoContext.ExecuteQuery<int>("SELECT COUNT(*) FROM MarcasInadecuados WHERE (idRecurso = {0})", resource.id);
foreach (int numberMarksR in numbersMarksR)
{
numberMarksResource = numberMarksR;
}
// if number of marks matches X, disable the resource.
if (numberMarksResource >= movement.maxMarcasInadecuadasRecursoX)
{
indignadoContext.ExecuteQuery<int>("UPDATE Recursos SET deshabilitado = {0} WHERE id = {1}", 1, resource.id);
}
// get this resources's user id.
int thisUserId = -1;
IEnumerable<int> thisUsersID = indignadoContext.ExecuteQuery<int>("SELECT idUsuario FROM Recursos WHERE (id = {0})", resource.id);
foreach (int thisUserID in thisUsersID)
{
thisUserId = thisUserID;
}
// get number of disabled resources published by this resources's user.
int numberMarksUser = 0;
IEnumerable<int> numbersMarksU = indignadoContext.ExecuteQuery<int>
("SELECT COUNT(*) FROM Recursos WHERE (idUsuario = {0}) AND (deshabilitado = {1})", thisUserId, 1);
foreach (int numberMarksU in numbersMarksU)
{
numberMarksUser = numberMarksU;
}
// if number of marks matches Z, ban the user.
if (numberMarksUser >= movement.maxRecursosInadecuadosUsuarioZ)
{
indignadoContext.ExecuteQuery<int>("UPDATE Usuarios SET banned = {0} WHERE id = {1}", true, thisUserId);
}
// commit changes to the database.
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)
{
}
}
// likes a resource.
public void likeResource(Recurso resource)
{
// create a likeResource
Aprobacione likeResource = new Aprobacione();
likeResource.idRecurso = resource.id;
likeResource.idUsuario = UserInfo.Id;
// add likeResource to the database.
try
{
IndignadoDBDataContext indignadoContext = new IndignadoDBDataContext();
indignadoContext.Aprobaciones.InsertOnSubmit(likeResource);
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)
{
}
}
}
// creates a resource.
public void createResource(Recurso resource)
{
IndignadoDBDataContext indignadoContext = new IndignadoDBDataContext();
// set internal and foreign ids
resource.idUsuario = UserInfo.Id;
resource.fecha = new DateTime(DateTime.UtcNow.Year, DateTime.UtcNow.Month, DateTime.UtcNow.Day, DateTime.UtcNow.Hour, DateTime.UtcNow.Minute, 0);
resource.deshabilitado = 0;
indignadoContext.Recursos.InsertOnSubmit(resource);
indignadoContext.SubmitChanges();
}
// 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)
{
}
}
// returns all resources.
public DTResourcesCol_NewsResources getResourcesList(int pageNumber)
{
// get all resources from this movement.
IndignadoDBDataContext indignadoContext = new IndignadoDBDataContext();
IEnumerable<Recurso> recursosEnum = indignadoContext.ExecuteQuery<Recurso>
("SELECT Recursos.id, Recursos.idUsuario, Usuarios.apodo AS apodoUsuario, titulo, descripcion, fecha, tipo, urlLink, urlImage, urlVideo, urlThumb, CantAprobaciones.cantAprobaciones FROM Recursos LEFT JOIN Usuarios ON (Usuarios.id = Recursos.idUsuario) LEFT JOIN (SELECT idRecurso, COUNT (idUsuario) AS cantAprobaciones FROM Aprobaciones GROUP BY idRecurso) CantAprobaciones ON (CantAprobaciones.idRecurso = Recursos.id) WHERE (Usuarios.idMovimiento = {0}) AND (Recursos.deshabilitado = {1}) ORDER BY Recursos.id DESC", IdMovement, 0);
Movimiento movement = indignadoContext.Movimientos.Single(x => x.id == IdMovement);
return toResourcesCol(recursosEnum, movement.maxUltimosRecursosM, pageNumber);
}
// 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);
}
private ChatUser GetChatUser(int userId)
{
var db = new IndignadoDBDataContext();
var user = db.Usuarios.SingleOrDefault(u => (u.id == userId));
if (user == null)
throw new FaultException("Ese usuario no existe!");
ChatUser chatUser = new ChatUser();
chatUser.id = user.id;
chatUser.nick = user.nombre;
return chatUser;
}
// returns the data of the user.
public Usuario getUser()
{
IndignadoDBDataContext indignadoContext = new IndignadoDBDataContext();
IEnumerable<Usuario> usersEnum = indignadoContext.ExecuteQuery<Usuario>
("SELECT * FROM Usuarios WHERE (id = {0})", UserInfo.Id);
return usersEnum.First();
}
// returns all movements
public Collection<Movimiento> getMovementsList()
{
// create new movements datatype collection
Collection<Movimiento> movementsCol = new Collection<Movimiento>();
IndignadoDBDataContext indignadoContext = new IndignadoDBDataContext();
foreach (Movimiento movement in indignadoContext.Movimientos)
{
movementsCol.Add(movement);
}
// return the collection
return movementsCol;
}
