internal async Task <bool> DeleteReviewAsync(string reviewID)
{
ReviewDetailsDataModel delRev = await db.Table <ReviewDetailsDataModel>().Where(x => x.ReviewID == reviewID).FirstOrDefaultAsync();
int res = await db.DeleteAsync(delRev);
return(res != -1);
}
private void ListOfReviews_ItemTapped(object sender, ItemTappedEventArgs e)
{
var item = BindingContext as ReviewsListViewModel;
if (item == null)
{
return;
}
var review = e.Item as ReviewDetailsDataModel;
if (currentProductId == null && currentProductId != review)
{
currentProductId = review;
}
else
{
currentProductId = null;
}
item.HideOrShowDetails(review);
}
internal async Task <bool> SaveReviewDetails(ReviewDetailsDataModel reviewDetail)
{
List <ReviewDetailsDataModel> reviewsDetails = await db.Table <ReviewDetailsDataModel>().Where(x => x.ReviewID == reviewDetail.ReviewID).ToListAsync();
if (reviewsDetails.Count > 1)
{
throw new Exception("Duplicated");
}
if (reviewsDetails.Count == 0)
{
int res = await db.InsertAsync(reviewDetail);
return(res != -1);
}
else
{
ReviewDetailsDataModel rd = reviewsDetails[0];
rd.CategoryName = reviewDetail.CategoryName;
rd.ProductName = reviewDetail.ProductName;
rd.ProductKey = reviewDetail.ProductKey;
rd.UserName = reviewDetail.UserName;
rd.ReviewStatus = reviewDetail.ReviewStatus;
rd.ScoreValue = reviewDetail.ScoreValue;
rd.DateTime = reviewDetail.DateTime;
rd.ReviewText = reviewDetail.ReviewText;
rd.ReviewUseful = reviewDetail.ReviewUseful;
rd.ReviewUnuseful = reviewDetail.ReviewUnuseful;
rd.ProductPros = reviewDetail.ProductPros;
rd.ProductCons = reviewDetail.ProductCons;
rd.ReviewsCount = reviewDetail.ReviewsCount;
rd.IsVisible = reviewDetail.IsVisible;
int res = await db.UpdateAsync(rd);
return(res != -1);
}
}
internal async Task <ReviewDetailsDataModel> GetReviewDetail(int id)
{
ReviewDetailsDataModel c = await db.Table <ReviewDetailsDataModel>().Where(x => x.ID == id).FirstOrDefaultAsync();
return(c);
}
