public IHttpActionResult UserProfileRating(int uid) { Users u = new UsersDAC().SelectById(uid); Rating r = new RatingDAC().SelectByUserId(uid); if (u != null) { UserProfileRatingModel uprm = new UserProfileRatingModel(); uprm.Id = u.Id; uprm.Student_EmployeeId = u.Student_EmployeeId; uprm.UserName = u.UserName; uprm.Phone = u.Phone; uprm.PhoneStatus = u.PhoneStatus; if (r != null) { uprm.OneStar = r.OneStar; uprm.TwoStar = r.TwoStar; uprm.ThreeStar = r.ThreeStar; uprm.FourStar = r.FourStar; uprm.FiveStar = r.FiveStar; } else { uprm.OneStar = null; uprm.TwoStar = null; uprm.ThreeStar = null; uprm.FourStar = null; uprm.FiveStar = null; } return(Ok(uprm)); } return(NotFound()); }
/// <summary> /// Find method. /// </summary> /// <param name="id"></param> /// <returns></returns> public Rating Find(int id) { var ratingDac = new RatingDAC(); var result = ratingDac.SelectById(id); return(result); }
/// <summary> /// FindAll method. /// </summary> /// <returns></returns> public List <Rating> All() { var ratingDac = new RatingDAC(); var result = ratingDac.Select(); return(result); }
public IHttpActionResult InsertRating(Rating r) { Rating rating = new RatingDAC().SelectByUserId(r.UserId); if (rating != null) { Rating rup = new Rating(); rup.UserId = r.UserId; if (r.OneStar == 1) { rup.OneStar = rating.OneStar + 1; } else { rup.OneStar = rating.OneStar; } if (r.TwoStar == 1) { rup.TwoStar = rating.TwoStar + 1; } else { rup.TwoStar = rating.TwoStar; } if (r.ThreeStar == 1) { rup.ThreeStar = rating.ThreeStar + 1; } else { rup.ThreeStar = rating.ThreeStar; } if (r.FourStar == 1) { rup.FourStar = rating.FourStar + 1; } else { rup.FourStar = rating.FourStar; } if (r.FiveStar == 1) { rup.FiveStar = rating.FiveStar + 1; } else { rup.FiveStar = rating.FiveStar; } new RatingDAC().RatingUpdate(rup); } else { Rating rins = new Rating(); rins.UserId = r.UserId; if (r.OneStar == 1) { rins.OneStar = 1; } if (r.TwoStar == 1) { rins.TwoStar = 2; } if (r.ThreeStar == 1) { rins.ThreeStar = 3; } if (r.FourStar == 1) { rins.FourStar = 4; } if (r.FiveStar == 1) { rins.FiveStar = 5; } new RatingDAC().Insert(rins); } return(Ok()); }
/// <summary> /// Update method. /// </summary> /// <param name="rating"></param> public void Edit(Rating rating) { var ratingDac = new RatingDAC(); ratingDac.UpdateById(rating); }
/// <summary> /// Delete method. /// </summary> /// <param name="id"></param> public void Remove(int id) { var ratingDac = new RatingDAC(); ratingDac.DeleteById(id); }
/// <summary> /// Add method. /// </summary> /// <param name="rating"></param> /// <returns></returns> public Rating Add(Rating rating) { var ratingDac = new RatingDAC(); return(ratingDac.Create(rating)); }