public async Task <bool> RateTitleAsync(int titleId, bool score)
{
var user = await _userManager.FindByNameAsync(
_httpContext.User.FindFirst(ClaimTypes.NameIdentifier)?.Value);
var profile = await _profileContext.FirstOrDefaultAsync(x => x.User == user);
var currentRating = await _ratingContext.FirstOrDefaultAsync(x => x.ProfileId == profile.Id && x.TitleId == titleId);
if (currentRating != null)
{
if (currentRating.Liked == score)
{
_ratingContext.Remove(currentRating);
}
else
{
currentRating.Liked = score;
_ratingContext.Update(currentRating);
}
return(await SaveCangesAsync());
}
var rating = new Models.Rating
{
ProfileId = profile.Id,
TitleId = titleId,
Liked = score
};
await _ratingContext.AddAsync(rating);
return(await SaveCangesAsync());
}
public void PostRatings(RatingInformationDTO RatingToAdd)
{
var user = RequestContext.Principal;
//try
//{
foreach (RatingDTO rating in RatingToAdd.Ratings)
{
Models.Rating newRating = new Models.Rating();
newRating.ProductID = RatingToAdd.ProductID;
newRating.userID = user.Identity.Name;
newRating.RatingCategory = rating.RatedArea;
newRating.rating = rating.Score;
//db.RatingDetails.Add(newRating);
db.SaveChanges();
}
// do stuff to store the rating here
//catch (Exception ex)
//{
// throw new Exception("Cannot add a rating", ex);
//}
}
public ActionResult RateUser(int?id, ShowsViewModel model)
{
User_Show show = db.User_Show.Where(s => s.ShowID == id).FirstOrDefault();
ShowsViewModel viewModel = new ShowsViewModel(show);
// Converting string into int
int numStars = getRating(model.RatingValue);
string comment = model.Comment;
Models.Rating userRating = new Models.Rating();
if (User.IsInRole("VenueOwner"))
{
User user = db.Users.Where(u => u.ID == viewModel.MusicianID).FirstOrDefault();
userRating.UserID = viewModel.MusicianID;
userRating.Value = numStars;
userRating.Comment = comment;
show.VenueRated = true;
user.AveRating = CalcAveRating(user.ID, numStars);
}
else if (User.IsInRole("Musician"))
{
User user = db.Users.Where(u => u.ID == viewModel.VenueID).FirstOrDefault();
userRating.UserID = viewModel.VenueID;
userRating.Value = numStars;
userRating.Comment = comment;
show.MusicianRated = true;
user.AveRating = CalcAveRating(user.ID, numStars);
}
db.Ratings.Add(userRating);
db.SaveChanges();
return(RedirectToAction("MyShows"));
}
private void CreateQualifyClientFromInputData()
{
rating = new Models.Rating();
rating.comment = TextBoxComment.Text;
rating.isClient = 1;
rating.idRequest = Request.idRequest;
rating.rating = RatingBarQualify.Value;
}
public int Create(Models.Rating rating)
{
Data.Rating newRating = new Data.Rating {
Description = rating.Description
};
db.Ratings.Add(newRating);
db.SaveChanges();
return(newRating.Id);
}
public IHttpActionResult PostRating(RatingInformationDTO RatingToAdd)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var user = RequestContext.Principal;
//try
//{
foreach (RatingDTO rating in RatingToAdd.Ratings)
{
Models.Rating newRating = new Models.Rating();
newRating.ProductID = RatingToAdd.ProductID;
newRating.userID = user.Identity.Name;
newRating.RatingCategory = rating.RatedArea;
newRating.rating = rating.Score;
if (db.Ratings.Any(x => x.ProductID == newRating.ProductID && x.userID == newRating.userID && x.RatingCategory == newRating.RatingCategory))
{
db.Ratings.Single(x => x.ProductID == newRating.ProductID && x.userID == newRating.userID && x.RatingCategory == newRating.RatingCategory).rating = newRating.rating;
}
else
{
db.Ratings.Add(newRating);
}
db.SaveChanges();
}
//db.Ratings.Add(rating);
//try
//{
// db.SaveChanges();
// }
//catch (DbUpdateException)
// {
// if (RatingExists(rating.userID))
// {
// return Conflict();
// }
// else
// {
// throw;
// }
// }
return(CreatedAtRoute("DefaultApi", new { id = RatingToAdd.ProductID }, RatingToAdd));
}
public void Checkrating(Models.Rating rating, Project project)
{
if (rating == null)
{
project.UserRating = 0;
}
else
{
project.UserRating = rating.Value;
}
}
public Models.Rating Update(Models.Rating rating)
{
var exsiting = db.Ratings.SingleOrDefault(x => x.Id == rating.Id);
if (exsiting != null)
{
exsiting.Description = rating.Description;
db.SaveChanges();
}
return(null);
}
// GET: Ratings/Details/5
public ActionResult Details(int id)
{
var curRatingRaw = clientRating.GetRatingAsync(id).Result;
var allRatingTypesRaw = clientRatingType.GetRatingTypeAllAsync().Result;
var curRating = new Models.Rating();
curRating.FromClient(curRatingRaw, allRatingTypesRaw);
return(View(curRating));
}
private void RegisterQualify()
{
RestClient client = new RestClient(urlBase);
client.Timeout = -1;
var request = new RestRequest("ratings", Method.POST);
foreach (RestResponseCookie cookie in Login.cookies)
{
request.AddCookie(cookie.Name, cookie.Value);
}
var json = JsonConvert.SerializeObject(rating);
request.AddHeader("Token", Login.tokenAccount.token);
request.AddParameter("application/json", json, ParameterType.RequestBody);
System.Net.ServicePointManager.ServerCertificateValidationCallback = (senderX, certificate, chain, sslPolicyErrors) => { return(true); };
try
{
IRestResponse response = client.Execute(request);
if (response.StatusCode == System.Net.HttpStatusCode.Created || response.StatusCode == System.Net.HttpStatusCode.OK)
{
rating = JsonConvert.DeserializeObject <Models.Rating>(response.Content);
MessageBox.Show("La calificación se registró exitosamente", "Registro exitoso", MessageBoxButton.OK, MessageBoxImage.Information);
Close();
}
else
{
Models.Error responseError = JsonConvert.DeserializeObject <Models.Error>(response.Content);
MessageBox.Show(responseError.error, "Error", MessageBoxButton.OK, MessageBoxImage.Error);
if (response.StatusCode == System.Net.HttpStatusCode.Forbidden || response.StatusCode == System.Net.HttpStatusCode.Unauthorized ||
response.StatusCode == System.Net.HttpStatusCode.RequestTimeout)
{
Login login = new Login();
login.Show();
Close();
}
else
{
if (response.StatusCode != System.Net.HttpStatusCode.Conflict && response.StatusCode != System.Net.HttpStatusCode.BadRequest)
{
Close();
}
}
}
}
catch (Exception exception)
{
TelegramBot.SendToTelegram(exception);
LogException.Log(this, exception);
MessageBox.Show("No hay conexión. Por favor intente más tarde", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
Close();
}
}
public Models.Rating GetById(int id)
{
var existing = db.Ratings.SingleOrDefault(x => x.Id == id);
if (existing == null)
{
return(null);
}
Models.Rating r = new Models.Rating {
Id = existing.Id, Description = existing.Description
};
return(r);
}
public int Rating(Models.Rating Rating)
{
int status = 0;
try
{
status = repo.Rating(Rating.Email, Rating.SongId, Rating.rating);
}
catch (Exception)
{
status = -99;
}
return(status);
}
public void Rate(short rating, int game_id)
{
Models.GameShopContext gameShopContext = new Models.GameShopContext();
if (Session["user"] != null)
{
var rate = new Models.Rating();
string username = Session["user"].ToString();
rate.game_id = game_id;
rate.user_id = gameShopContext.Users.Single(x => x.username == username).id;
rate.rating1 = rating;
gameShopContext.Ratings.Add(rate);
gameShopContext.SaveChanges();
}
}
public async Task <IActionResult> OnGetAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
Rating = await _context.Ratings
.Include(r => r.Department).FirstOrDefaultAsync(m => m.Id == id);
if (Rating == null)
{
return(NotFound());
}
return(Page());
}
// GET: Ratings/Create
public ActionResult Create()
{
var newRating = new Models.Rating();
var allRatingTypesRaw = clientRatingType.GetRatingTypeAllAsync().Result;
foreach (var curType in allRatingTypesRaw)
{
newRating.RatingTypeNames.Add(new SelectListItem()
{
Value = curType.Id.ToString(), Text = curType.Name
});
}
return(View(newRating));
}
private async void frmSuppliersFeedbacks_Load(object sender, System.EventArgs e)
{
var user = await _authService.GetById(_userId);
lblTitle.Text = "Feedbacks for " + user.Company;
var ratingRequest = new RatingSearchRequest
{
SupplierId = _userId
};
var ratingList = await _ratingService.GetAll <List <Rating> >(ratingRequest);
foreach (var rating in ratingList)
{
var request = await _requestService.GetById <Request>((int)rating.RequestId);
var ratingGivenBy = await _authService.GetById(request.ClientId);
var newRatingModel = new Models.Rating
{
Description = rating.Description,
RatingTypeId = (int)rating.RatingTypeId
};
string ratingType;
if (rating.RatingTypeId == (int)ERatingType.Positive)
{
ratingType = "Postive";
}
else if (rating.RatingTypeId == (int)ERatingType.Negative)
{
ratingType = "Negative";
}
else
{
ratingType = "Neutral";
}
newRatingModel.Details = $"{ratingType} feedback from " + ratingGivenBy.FirstName + " " + ratingGivenBy.LastName;
RatingList.Add(newRatingModel);
}
InitCounters();
dgvRating.DataSource = RatingList;
}
public async Task <IActionResult> OnGetAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
Rating = await _context.Ratings
.Include(r => r.Department).FirstOrDefaultAsync(m => m.Id == id);
if (Rating == null)
{
return(NotFound());
}
ViewData["DepartmentId"] = new SelectList(_context.Departments, "Id", "DepartmentName");
return(Page());
}
public async Task <IActionResult> OnPostAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
Rating = await _context.Ratings.FindAsync(id);
if (Rating != null)
{
_context.Ratings.Remove(Rating);
await _context.SaveChangesAsync();
}
return(RedirectToPage("./Index"));
}
// GET: Ratings
public ActionResult Index()
{
var allRatingsRaw = clientRating.GetRatingAllAsync().Result;
var lstAllRatings = new List <Models.Rating>();
var allRatingTypesRaw = clientRatingType.GetRatingTypeAllAsync().Result;
foreach (var rating in allRatingsRaw)
{
var curRating = new Models.Rating();
curRating.FromClient(rating, allRatingTypesRaw);
lstAllRatings.Add(curRating);
}
return(View(lstAllRatings));
}
public IEnumerable <Models.RatingSummary> LoadRatings()
{
var dict = new Dictionary <string, Models.RatingSummary>();
foreach (var line in ReadLines("ratings.csv"))
{
var fields = Data.CsvParser.Instance.ParseLine(line);
if (fields.Count < 4)
{
continue;
}
var item = new Models.Rating();
int num;
if (!int.TryParse(fields[0], out num))
{
continue;
}
item.UserId = num;
if (!int.TryParse(fields[1], out num))
{
continue;
}
item.MovieId = num;
float num2;
if (!float.TryParse(fields[2], out num2))
{
continue;
}
item.Value = num2;
item.Created = Data.DateTimeUtils.ParseFromJava(fields[3], 1000);
var dictId = string.Format("{0}-{1}", item.MovieId, item.Created.Year);
if (!dict.ContainsKey(dictId))
{
dict[dictId] = new Models.RatingSummary();
}
var record = dict[dictId];
record.MovieId = item.MovieId;
record.CreatedYear = item.Created.Year;
record.Value += item.Value;
record.Count++;
}
return(dict.Values);
}
public static Tuple <string, bool> Insert(int eventId, int userId, int ratingValue)
{
using (var db = new Models.ModelContext())
{
var currEvent = db.Events.Where(e => e.Id.Equals(eventId));
var currUser = db.Users.Where(u => u.Id.Equals(userId));
// If any of the elements are not present in db
if (!(currEvent.Any() && currUser.Any()))
{
return(new Tuple <string, bool>("Atleiskite, įvyko klaida", false));
}
var rating = db.Ratings.Where(s => (s.Event_id == eventId) && (s.User_id == userId));
if (!Validate(ratingValue))
{
return(new Tuple <string, bool>("Jūsų įvertinimas yra netinkamas", false));
}
else if (rating.Any())
{
foreach (var score in rating)
{
score.Score = ratingValue;
}
db.SaveChanges();
return(new Tuple <string, bool>("Jūsų įvertinimas pakeistas", false));
}
else
{
var newRating = new Models.Rating();
newRating.Event_id = eventId;
newRating.User_id = userId;
newRating.Score = ratingValue;
db.Ratings.Add(newRating);
db.SaveChanges();
return(new Tuple <string, bool>("Renginys sėkmingai įvertintas.", true));
}
}
}
public IActionResult AddRating([FromBody] ViewModels.Rating model)
{
var project = _db.Project.FirstOrDefault(p => p.Id == model.ProjectId);
if (model.Value > 5 && model.Value < 0)
{
return(BadRequest("Pashel nahuy pidor, naebat on reshil"));
}
var rating = new Models.Rating
{
ProjectId = model.ProjectId,
UserId = model.UserPofileId,
Value = model.Value
};
var usersCount = _db.Rating.ToList().FindAll(p => p.ProjectId == model.ProjectId).Count + 1;
project.Rating = (int)(((float)project.Rating + (float)model.Value) / (float)usersCount);
_db.Rating.Add(rating);
_db.Project.Update(project);
_db.SaveChanges();
return(new ObjectResult(project.Rating));
}
public IHttpActionResult PostRating(RatingInformationDTO RatingToAdd)
{
if (!ModelState.IsValid)
{
return BadRequest(ModelState);
}
var user = RequestContext.Principal;
//try
//{
foreach (RatingDTO rating in RatingToAdd.Ratings)
{
Models.Rating newRating = new Models.Rating();
newRating.ProductID = RatingToAdd.ProductID;
newRating.userID = user.Identity.Name;
newRating.RatingCategory = rating.RatedArea;
newRating.rating = rating.Score;
if (db.Ratings.Any(x => x.ProductID == newRating.ProductID && x.userID == newRating.userID && x.RatingCategory == newRating.RatingCategory))
{
db.Ratings.Single(x => x.ProductID == newRating.ProductID && x.userID == newRating.userID && x.RatingCategory == newRating.RatingCategory).rating = newRating.rating;
}
else
{
db.Ratings.Add(newRating);
}
db.SaveChanges();
}
//db.Ratings.Add(rating);
//try
//{
// db.SaveChanges();
// }
//catch (DbUpdateException)
// {
// if (RatingExists(rating.userID))
// {
// return Conflict();
// }
// else
// {
// throw;
// }
// }
return CreatedAtRoute("DefaultApi", new { id = RatingToAdd.ProductID }, RatingToAdd);
}
public System.Threading.Tasks.Task <bool> AddRatingAsync(Models.Rating rating)
{
return(base.Channel.AddRatingAsync(rating));
}
public bool AddRating(Models.Rating rating)
{
return(base.Channel.AddRating(rating));
}
public void PostRatings(RatingInformationDTO RatingToAdd)
{
var user = RequestContext.Principal;
//try
//{
foreach (RatingDTO rating in RatingToAdd.Ratings)
{
Models.Rating newRating = new Models.Rating();
newRating.ProductID = RatingToAdd.ProductID;
newRating.userID = user.Identity.Name;
newRating.RatingCategory = rating.RatedArea;
newRating.rating = rating.Score;
//db.RatingDetails.Add(newRating);
db.SaveChanges();
}
// do stuff to store the rating here
//catch (Exception ex)
//{
// throw new Exception("Cannot add a rating", ex);
//}
}
public bool DeleteRating(Models.Rating rating)
{
return(base.Channel.DeleteRating(rating));
}
