public IActionResult LinkWithUser_Rating(int User_id, int Rating_id) { var session = HttpContext.Get <LoggableEntities>(_context); var current_User = session == null ? null : session.User; var current_Admin = session == null ? null : session.Admin; var allowed_sources = _context.User; var source = allowed_sources.FirstOrDefault(s => s.Id == User_id); var allowed_targets = _context.Rating; var target = allowed_targets.FirstOrDefault(s => s.Id == Rating_id); var can_edit_source_by_token = ApiTokenValid || true; var can_edit_target_by_token = ApiTokenValid || true; var can_link_by_token = ApiTokenValid || true; if (!CanAdd_User_User_Ratings(source) || !can_link_by_token || !can_edit_source_by_token || !can_edit_target_by_token) { return(BadRequest()); } // throw new Exception("Cannot add item to relation User_Ratings"); if (!CanAdd_Rating_User_Ratings(target)) { return(BadRequest()); } // throw new Exception("Cannot add item to relation User_Ratings"); var link = new User_Rating() { Id = _context.User_Rating.Max(i => i.Id) + 1, UserId = source.Id, RatingId = target.Id }; _context.User_Rating.Add(link); _context.SaveChanges(); return(Ok()); }
public string DeleteRating(int id) { User_Rating Student = context.User_Ratings.Find(id); context.User_Ratings.Remove(Student); context.SaveChanges(); return("Ratings Deleted SuccessFully"); }
public string UpdateRating(int id, RatinDto Student) { User_Rating rate = context.User_Ratings.Find(id); rate.StudentName = Student.StudentName; rate.User_Provided_Rating = Student.User_Provided_Rating; context.SaveChanges(); return("Ratings Updated"); }
public void UserRating(int rating, int recipe_id, int user_id) { var stored_rating = (from recipe_rating in _context.Recipe_Rating where (recipe_rating.RecipeId == recipe_id) from user_rating in _context.User_Rating where (user_rating.UserId == user_id) && (recipe_rating.RatingId == user_rating.RatingId) from Rating in _context.Rating where (Rating.Id == user_rating.RatingId && Rating.Id == recipe_rating.RatingId) select Rating).FirstOrDefault(); if (stored_rating == null) { System.Console.WriteLine("did not found one!"); Rating newRating = new Rating() { rating = rating, Id = _context.Rating.Max(elem => elem.Id) + 1 }; _context.Rating.Add(newRating); User_Rating newUser_Rating = new User_Rating() { UserId = user_id, RatingId = newRating.Id }; _context.User_Rating.Add(newUser_Rating); Recipe_Rating newRecipe_Rating = new Recipe_Rating() { RecipeId = recipe_id, RatingId = newRating.Id }; _context.Recipe_Rating.Add(newRecipe_Rating); } else { System.Console.WriteLine("found one!"); stored_rating.rating = rating; } _context.SaveChanges(); }
public IActionResult /*IEnumerable<Rating>*/ CreateNewUser_Rating_Rating(int User_id) { var session = HttpContext.Get <LoggableEntities>(_context); var current_User = session == null ? null : session.User; var current_Admin = session == null ? null : session.Admin; var allowed_sources = ApiTokenValid ? _context.User : _context.User; var source = allowed_sources.FirstOrDefault(s => s.Id == User_id); var can_create_by_token = ApiTokenValid || true; if (source == null || !can_create_by_token) { return(Unauthorized()); } // throw new Exception("Cannot create item in relation User_Ratings"); var can_link_by_token = ApiTokenValid || true; if (!CanAdd_User_User_Ratings(source) || !can_link_by_token) { return(Unauthorized()); } //throw new Exception("Cannot add item to relation User_Ratings"); var new_target = new Rating() { CreatedDate = DateTime.Now, Id = _context.Rating.Max(i => i.Id) + 1 }; _context.Rating.Add(new_target); _context.SaveChanges(); var link = new User_Rating() { Id = _context.User_Rating.Max(l => l.Id) + 1, UserId = source.Id, RatingId = new_target.Id }; _context.User_Rating.Add(link); _context.SaveChanges(); return(Ok(new Rating[] { new_target })); }
//private async void getLocation() //{ // try // { // CheckConnectionInternet.checkConnectivity(); // queryLocation = await App.MobileService.GetTable<Activity_Location>().Where(p => p.Nameplace == SelectedLocation.Nameplace).ToListAsync(); // if (queryLocation.Count == 0) // { // await Application.Current.MainPage.DisplayAlert("Warning", "The location was not found ", "Ok"); // return; // } // this.LocationNick = queryLocation[0].Nameplace; // } // catch (Exception ex) // { // await Application.Current.MainPage.DisplayAlert("Error ", ex.Message, "Ok"); // } //} public async void sendFeedback() { this.IsUserRunning = true; this.IsUserEnable = false; if (string.IsNullOrEmpty(this.UserNick)) { await Application.Current.MainPage.DisplayAlert( "Error", "You must enter a real User.", "Accept"); this.IsUserRunning = false; this.IsUserEnable = true; return; } if (string.IsNullOrEmpty(this.Usertxt)) { await Application.Current.MainPage.DisplayAlert( "Error", "You must enter an User in Search Bar.", "Accept"); this.IsUserRunning = false; this.IsUserEnable = true; return; } if (string.IsNullOrEmpty(this.UserDescription)) { await Application.Current.MainPage.DisplayAlert( "Error", "You must enter a Description.", "Accept"); this.IsUserRunning = false; this.IsUserEnable = true; return; } if (SelectedUserRating == null) { await Application.Current.MainPage.DisplayAlert( "Error", "You must select a Rating.", "Accept"); this.IsUserRunning = false; this.IsUserEnable = true; return; } int len = RandomId.length.Next(5, 10); User_Rating feedback = new User_Rating() { Id = RandomId.RandomString(len), Comment = this.UserDescription.TrimEnd(), Rating = this.SelectedUserRating.FeedbackName, User_IdReporter_FK1 = user[0].Id, User_IdReported_FK2 = query[0].Id }; try { await App.MobileService.GetTable <User_Rating>().InsertAsync(feedback); await Application.Current.MainPage.DisplayAlert("Exito", "Done!", "Ok"); this.IsUserVisible = true; } catch (Exception ex) { await Application.Current.MainPage.DisplayAlert("Error ", ex.Message, "Ok"); } this.IsUserRunning = false; }
//########################################################################## Ratings public string AddRating(User_Rating rate) { context.User_Ratings.Add(rate); context.SaveChanges(); return("Ratings Added"); }