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");
}
