public IHttpActionResult AddOrUpdate(UserReviewDto user)
{
user.ApplicationUserId = RequestContext.Principal.Identity.GetUserId();
service = DIContainerST.GetInstance().Resolve <IReviewService>();
service.AddOrUpdateReview(user);
return(Ok());
}
public void AddOrUpdateReview(UserReviewDto user)
{
var entity = new UserReview();
var document = user.ToTextAnalyticsDocuments();
user.TextAnalyticRespons = GetTextAnalyticsSentiment(document);
entity.FromUserReviewDto(user);
userReviewRepository.Insert(entity);
userReviewRepository.Save();
}
public ActionResult SaveUserReview(string review, string rating, int itemId)
{
UserReviewDal userReviewDal = new UserReviewDal();
UserReviewDto userReviewDto = new UserReviewDto();
userReviewDto.UserId = Convert.ToInt32(Session["UserId"]);
userReviewDto.ItemId = itemId;
userReviewDto.Review = review;
userReviewDto.Rating = rating;
userReviewDto.IsActive = 1;
int i = userReviewDal.SaveUsersReview(userReviewDto);
return(Json(i, JsonRequestBehavior.AllowGet));
}
public int SaveUsersReview(UserReviewDto userReviewDto)
{
try
{
SqlCommand cmd = new SqlCommand("SaveUsersReview", connectionRepository.con);
cmd.Parameters.AddWithValue("@UserId", userReviewDto.UserId);
cmd.Parameters.AddWithValue("@ItemId", userReviewDto.ItemId);
cmd.Parameters.AddWithValue("@Review", userReviewDto.Review);
cmd.Parameters.AddWithValue("@Rating", userReviewDto.Rating);
cmd.Parameters.AddWithValue("@IsActive", userReviewDto.IsActive);
cmd.CommandType = CommandType.StoredProcedure;
connectionRepository.con.Open();
int i = cmd.ExecuteNonQuery();
connectionRepository.con.Close();
return(i);
}
catch (Exception ex)
{
throw ex;
}
}
public List <UserReviewDto> GetReviewsByUserId(int id)
{
List <ReviewUser> res = getAll().Where(i => i.UserId == id).ToList();
List <UserReviewDto> xlist = new List <UserReviewDto>();
UserReviewDto x;
foreach (ReviewUser i in res)
{
x = new UserReviewDto();
x.UserId = i.UserId;
x.UserId = i.UserId;
x.Content = i.Content;
x.Rate = i.Rate;
xlist.Add(x);
}
return(xlist);
}
public List <UserReviewDto> GetAllReviewList(int ItemId)
{
List <UserReviewDto> lstUserReviewDto = new List <UserReviewDto>();
SqlCommand cmd = new SqlCommand("GetAllReviewList", connectionRepository.con);
cmd.Parameters.AddWithValue("@ItemId", ItemId);
cmd.CommandType = CommandType.StoredProcedure;
connectionRepository.con.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
UserReviewDto userReviewDto = new UserReviewDto();
userReviewDto.RatingId = Convert.ToInt32(dr["RatingId"]);
userReviewDto.UserId = Convert.ToInt32(dr["UserId"]);
userReviewDto.Name = Convert.ToString(dr["Name"]);
userReviewDto.Review = Convert.ToString(dr["Review"]);
userReviewDto.Rating = Convert.ToString(dr["Rating"]);
userReviewDto.CreatedDate = Convert.ToString(dr["CreatedDate"]);
lstUserReviewDto.Add(userReviewDto);
}
connectionRepository.con.Close();
return(lstUserReviewDto);
}
