/// <summary>
/// Gets the user place tag subscription.
/// </summary>
/// <param name="userId">The user id.</param>
/// <param name="number">The number.</param>
/// <param name="page">The page.</param>
/// <returns>List of Tag Places</returns>
public List <Model.TagPlace.TagPlace> GetUserPlaceTagSubscription(long userId, int number, int page)
{
List <Model.TagPlace.TagPlace> tagPlacesList = new List <XareuServices.Model.TagPlace.TagPlace>();
var query = (from tagPlaces in data.place_tag_users_subscriptions
where tagPlaces.user_id == userId
select tagPlaces).Skip <place_tag_users_subscription>(number * page).Take <place_tag_users_subscription>(number);
foreach (place_tag_users_subscription placeTag in query)
{
Model.TagPlace.TagPlace newTagPlace = new XareuServices.Model.TagPlace.TagPlace();
newTagPlace.Id = placeTag.place_tag_id;
newTagPlace.Name = placeTag.place_tag.place_tag_name;
try
{
newTagPlace.ParentId = (long)placeTag.place_tag.place_tag_parent;
}
catch { newTagPlace.ParentId = 0; }
tagPlacesList.Add(newTagPlace);
}
return(tagPlacesList);
}
/// <summary>
/// Gets the place tag.
/// </summary>
/// <param name="placeTag">The place tag.</param>
/// <returns></returns>
private Model.TagPlace.TagPlace getPlaceTag(place_tag_in_publication placeTag)
{
Model.TagPlace.TagPlace newTagPlace = new XareuServices.Model.TagPlace.TagPlace();
newTagPlace.Id = placeTag.place_tag_id;
newTagPlace.Name = placeTag.place_tag.place_tag_name;
try
{
newTagPlace.ParentId = (long)placeTag.place_tag.place_tag_parent;
}
catch { newTagPlace.ParentId = 0; }
return(newTagPlace);
}
/// <summary>
/// Gets the tag place.
/// </summary>
/// <param name="tagPlace">The tag place.</param>
/// <returns></returns>
private Model.TagPlace.TagPlace getTagPlace(place_tag tagPlace)
{
Model.TagPlace.TagPlace newTagPlace = new XareuServices.Model.TagPlace.TagPlace();
newTagPlace.Id = tagPlace.place_tag_id;
newTagPlace.Name = tagPlace.place_tag_name;
try
{
newTagPlace.ParentId = (long)tagPlace.place_tag_parent;
}
catch { newTagPlace.ParentId = 1; }
return(newTagPlace);
}
/// <summary>
/// Adds the tag place.
/// </summary>
/// <param name="userID">The user ID.</param>
/// <param name="token">The token.</param>
/// <param name="newToken">The new token.</param>
/// <param name="tagPlace">The tag place.</param>
/// <returns>True if it was OK, false otherwise</returns>
public bool AddTagPlace(long userID, Guid token, out Guid newToken, XareuServices.Model.TagPlace.TagPlace tagPlace)
{
if (loginService.UseToken(userID, token, out newToken))
{
try
{
long tagPlaceID;
return(placeTagDAO.AddTagPlace(tagPlace, out tagPlaceID));
}
catch
{
throw new Exception("Adding tag place error");
}
}
throw new Exception("Login error");
}
/// <summary>
/// Añade una etiqueta de lugar
/// </summary>
/// <param name="tagPlace">Etiqueta de lugar que queremos añadir</param>
/// <param name="tagPlaceID"></param>
/// <returns>
/// True si la pudo añadir, false en caso contrario
/// </returns>
public bool AddTagPlace(XareuServices.Model.TagPlace.TagPlace tagPlace, out long tagPlaceID)
{
tagPlaceID = 0;
try
{
place_tag newPlaceTag = this.convertToLinqPlaceTag(tagPlace);
data.place_tags.InsertOnSubmit(newPlaceTag);
data.SubmitChanges();
tagPlaceID = this.getLastInsertedTagPlaceID();
return(true);
}
catch
{
return(false);
}
}
/// <summary>
/// Gets the sons.
/// </summary>
/// <param name="tagPlaceID">The tag place ID.</param>
/// <returns>List of tag places</returns>
public List <Model.TagPlace.TagPlace> GetSons(long tagPlaceID)
{
List <Model.TagPlace.TagPlace> sons = new List <XareuServices.Model.TagPlace.TagPlace>();
IEnumerable <place_tag> tagPlaces = from places in data.place_tags
where places.place_tag_parent == tagPlaceID
select places;
foreach (place_tag place in tagPlaces)
{
Model.TagPlace.TagPlace newPlace = new XareuServices.Model.TagPlace.TagPlace();
newPlace.Id = place.place_tag_id;
newPlace.Name = place.place_tag_name;
newPlace.ParentId = (long)place.place_tag_parent;
sons.Add(newPlace);
}
return(sons);
}
/// <summary>
/// Edita los datos de una etiqueta de lugar determinada por los que indicamos
/// </summary>
/// <param name="tagPlace">Nuevos datos de la etiqueta que queremos editar (conservando el Id)</param>
/// <returns></returns>
public bool EditTagPlace(XareuServices.Model.TagPlace.TagPlace tagPlace)
{
place_tag actualTagPlaceValues;
IEnumerable <place_tag> query = from tagPlaces in data.place_tags
where tagPlaces.place_tag_id == tagPlace.Id
select tagPlaces;
actualTagPlaceValues = query.First <place_tag>();
try
{
actualTagPlaceValues.place_tag_name = tagPlace.Name;
actualTagPlaceValues.place_tag_parent = tagPlace.ParentId;
this.data.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
/// <summary>
/// Adds the tag place.
/// </summary>
/// <param name="userID">The user ID.</param>
/// <param name="token">The token.</param>
/// <param name="newToken">The new token.</param>
/// <param name="tagPlace">The tag place.</param>
/// <returns>True if it was OK, false otherwise</returns>
public bool AddTagPlace(long userID, Guid token, out Guid newToken, XareuServices.Model.TagPlace.TagPlace tagPlace)
{
return(tagPlaceService.AddTagPlace(userID, token, out newToken, tagPlace));
}
