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