public void SaveTourist(NewTouristModel newTourist) { using (var db = new SitesEntities()) { var searchedTourist = (from t in db.Tourists where t.AndroidID.Equals(newTourist.AndroidID) == true select t).FirstOrDefault(); if (searchedTourist == null) { Tourist addTourist = new Tourist(); addTourist.AndroidID = newTourist.AndroidID; addTourist.Username = newTourist.Username; addTourist.VisitedSites = 0; db.Tourists.Add(addTourist); db.SaveChanges(); } if (searchedTourist != null) { var updateTourist = db.Tourists.Find(searchedTourist.ID); updateTourist.VisitedSites = newTourist.VisitedSites; updateTourist.Username = newTourist.Username; db.SaveChanges(); } } }
public void SaveComment(PostCommentModel postedComment) { using (var db = new SitesEntities()) { SiteComment newComment = new SiteComment(); newComment.UserName = postedComment.UserName; newComment.Comment = postedComment.Comment; newComment.SiteID = postedComment.SiteID; db.SiteComments.Add(newComment); db.SaveChanges(); } }
public void SaveEvent(PostedEventModel postedEvent) { using (var db = new SitesEntities()) { SiteEvent newEvent = new SiteEvent(); newEvent.DateOfEvent = postedEvent.DateOfEvent; newEvent.EventDescription = postedEvent.EventDescription; newEvent.SiteID = postedEvent.SiteID; db.SiteEvents.Add(newEvent); db.SaveChanges(); } }
public bool CheckIfUsernameExists(string userName) { using (var db = new SitesEntities()) { var usernameExists = (from t in db.Tourists where t.Username.Equals(userName) == true select t).FirstOrDefault(); if (usernameExists != null) { return(true); } } return(false); }
public void FindComments(int siteId) { using (var db = new SitesEntities()) { 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; Comments.Add(commentModel); } } }
public void FindEvents(int siteId) { using (var db = new SitesEntities()) { var events = (from e in db.SiteEvents where e.SiteID == siteId select e); foreach (var singleEvent in events) { var eventModel = new EventModel(); eventModel.Description = singleEvent.EventDescription; eventModel.SiteID = singleEvent.SiteID; eventModel.DateOfEvent = singleEvent.DateOfEvent; Events.Add(eventModel); } } }
public ProgressAndMessageModel ReturnTouristPlace(string androidId) { ProgressAndMessageModel progress = new ProgressAndMessageModel(); using (var db = new SitesEntities()) { var searchedTourist = (from tourist in db.Tourists where tourist.AndroidID.Equals(androidId) == true select tourist).FirstOrDefault(); if (searchedTourist != null) { var listOfTourists = db.Tourists.OrderBy(v => v.VisitedSites).ToList(); listOfTourists.Reverse(); int place = listOfTourists.IndexOf(searchedTourist); progress.ProgressNumber = place; if (!String.IsNullOrWhiteSpace(searchedTourist.MessageToUser)) { progress.Message = searchedTourist.MessageToUser; } return(progress); } } return(progress); }