public void sendMessageToUser(string androidID, string message)
{
using (var db = new SitesDB.SitesDBEntities())
{
var specificUser = (from t in db.Tourists where t.AndroidID == androidID select t).FirstOrDefault();
if (specificUser != null)
{
specificUser.MessageToUser = message;
db.SaveChanges();
}
}
}
public void DeleteComment(int commentID)
{
using (var db = new SitesDB.SitesDBEntities())
{
var comment = (from com in db.SiteComments
where com.ID == commentID
select com).FirstOrDefault();
if (comment != null)
{
db.SiteComments.Remove(comment);
db.SaveChanges();
}
}
}
public void loadTourists()
{
using (var db = new SitesDB.SitesDBEntities())
{
var tourists = (from t in db.Tourists select t);
foreach (var tourist in tourists)
{
TouristModel user = new TouristModel();
user.AndroidID = tourist.AndroidID;
user.MessageToUser = tourist.MessageToUser;
user.VisitedSites = tourist.VisitedSites;
this.TouristInfo.Add(user);
}
TouristInfo.OrderByDescending(x => x.VisitedSites);
}
}
public void FindComments(int siteId)
{
using (var db = new SitesDB.SitesDBEntities())
{
var comments = (from c in db.SiteComments
where c.SiteID == siteId
select c);
foreach (var comment in comments)
{
var commentModel = new CommentModel();
commentModel.Comment = comment.Comment;
commentModel.SiteID = comment.SiteID;
commentModel.UserName = comment.UserName;
commentModel.CommentId = comment.ID;
Comments.Add(commentModel);
}
}
}
