public void Create(CreateRankingViewModel model) { using (var db = new DBEntitiesProxy()) { var userId = db.User.Where(x => x.Email == model.UserEmail).Select(x => x.UserId).Single(); db.Ranking.Add(new Ranking { Score = model.Score, PlaceId = model.PlaceId, UserId = userId }); var list = db.Ranking.Where(x => x.PlaceId == model.PlaceId).Select(x => x.Score).ToList(); double avg = model.Score; if (list.Count>0) { avg = list.Average(); } var place = db.Place.Where(x => x.PlaceId == model.PlaceId).SingleOrDefault(); if (place != null) { place.Ranking = Convert.ToInt32(avg); } db.SaveChanges(); } }
public void Create(CountryModel model) { using (var db = new DBEntitiesProxy()) { db.Country.Add(new Country() { Name = model.Name, Code = model.Code, }); db.SaveChanges(); } }
public void RemoveVisit(int placeId, string userEmail) { using (var db = new DBEntitiesProxy()) { var visits = db.Travels .Where(x => x.PlaceId == placeId && x.User.Email.Trim() == userEmail).ToList(); foreach (var v in visits) { db.Travels.Remove(v); } db.SaveChanges(); } }
public void Accept(int id) { using (var db = new DBEntitiesProxy()) { var place = db.Place.Where(x => x.PlaceId == id).SingleOrDefault(); if (place != null) { place.IsAccepted = true; } db.SaveChanges(); } }
public void Create(CreateTravelViewModel model) { using (var db = new DBEntitiesProxy()) { var userId = db.User.Where(x => x.Email == model.UserEmail).Select(x => x.UserId).Single(); db.Travels.Add(new Travels { Date = model.Date, PlaceId = model.PlaceId, UserId = userId }); db.SaveChanges(); } }
public void Create(CreateCommentViewModel model) { var userModel = new UserModel(); using (var db = new DBEntitiesProxy()) { db.COMMENT.Add(new COMMENT() { Content = model.Content, PlaceId = model.PlaceId, Date = System.DateTime.Now, UserId = userModel.GetUserID(model.UserEmail) }); db.SaveChanges(); } }
public void UpdateRanking(CreateRankingViewModel model) { using (var db = new DBEntitiesProxy()) { var userId = db.User.Where(x => x.Email == model.UserEmail).Select(x => x.UserId).Single(); var score = db.Ranking.Where(x => x.PlaceId == model.PlaceId && x.UserId == userId) .SingleOrDefault(); score.Score = model.Score; var avg = db.Ranking.Where(x => x.PlaceId == model.PlaceId).Select(x => x.Score).ToList().Average(); var place = db.Place.Where(x => x.PlaceId == model.PlaceId).SingleOrDefault(); if (place != null) { place.Ranking = Convert.ToInt32(avg); } db.SaveChanges(); } }
public void EditPlace(EditPlaceViewModel model) { using (var db = new DBEntitiesProxy()) { var place = db.Place.Where(x => x.PlaceId == model.PlaceId).Single(); place.Name = model.Name; place.Content = model.Content; place.Photo_URI = model.Photo_URI; place.CountryId = model.CountryId; place.ContentPL = model.ContentPL; place.ContentPT = model.ContentPT; db.Entry(place).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } }
public void Create(CreatePlaceViewModel model) { var userModel = new UserModel(); using (var db = new DBEntitiesProxy()) { var userid = userModel.GetUserID(model.UserEmail); db.Place.Add(new Place() { Name = model.Name, Content = model.Content, Photo_URI = model.Photo_URI, CountryId = model.CountryId, IsAccepted = false, UserId = userid, AddDate = System.DateTime.Now, Ranking = 1, ContentPL = model.ContentPL, ContentPT = model.ContentPT, }); db.SaveChanges(); } }