public ReviewsModel(reviews obj)
{
this.UsersId = obj.UsersId;
this.ProduitsId = obj.ProduitsId;
this.Content = obj.Content;
this.Rating = obj.Rating;
}
public IHttpActionResult Create(reviews review)
{
dynamic Response = new ExpandoObject();
try
{
if (!ModelState.IsValid)
{
Response.Status = Helpers.ResponseStatus.ERROR;
Response.Message = Helpers.ErrorMessage.BAD_REQUEST;
return(Content(HttpStatusCode.BadRequest, Response));
}
context.reviews.Add(review);
context.SaveChanges();
var reviewDTO = Mapper.Map <reviews, ReviewDTO>(review);
reviewDTO.review_id = review.review_id;
Response.Status = Helpers.ResponseStatus.OK;
Response.Reviews = reviewDTO;
return(Created(new Uri(Request.RequestUri + "/" + reviewDTO.review_id), Response));
}
catch (Exception)
{
Response.Status = Helpers.ResponseStatus.ERROR;
Response.Message = Helpers.ErrorMessage.INTERNAL_SERVER_ERROR;
return(Content(HttpStatusCode.InternalServerError, Response));
}
}
public ActionResult AddReview()
{
var rev = new reviews
{
id = Guid.NewGuid(),
albumID = Guid.Parse(Request.Form["id"]),
isActive = true,
date_created = DateTime.UtcNow,
name = Request.Form["name"],
review = Request.Form["review"]
};
db.reviews.Add(rev);
try
{
db.SaveChanges();
var result = new
{
review = "Review succesfully added"
};
return(Json(result));
}
catch (Exception e)
{
var result = new
{
review = e.ToString()
};
return(Json(result));
}
}
public async Task <IActionResult> Putreviews([FromRoute] string id, [FromBody] reviews reviews)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != reviews.reviewid)
{
return(BadRequest());
}
_context.Entry(reviews).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!reviewsExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <IActionResult> Postreviews([FromBody] reviews reviews)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.reviews.Add(reviews);
await _context.SaveChangesAsync();
return(CreatedAtAction("Getreviews", new { id = reviews.reviewid }, reviews));
}
//Gets Page reviews and returns next url for the chunk
//Needs to be refactored
private static ListAndUrl _PageChunk(string url, int numberOfPages)
{
var list = new ListAndUrl();
var rev = new List <reviews>();
var html = _RequestHandler(url).Result;
var htmlDoc = _HtmlDocToString(html);
//Find the write elements
var elements = htmlDoc.DocumentNode.Descendants("div")
.Where(node => node.GetAttributeValue("class", "")
.Equals("a-section celwidget")).ToList();
foreach (var element in elements)
{
var review = new reviews()
{
//Add all the attributes for the class
date = element.Descendants("span")
.Where(node => node.GetAttributeValue("data-hook", "")
.Equals("review-date")).FirstOrDefault().InnerHtml
};
rev.Add(review);
}
list.listOfReviews = rev;
//If last page is detected returns null
var last = htmlDoc.DocumentNode.Descendants("div")
.Where(node => node.GetAttributeValue("class", "")
.Equals("a-form-actions a-spacing-top-extra-large"))
.FirstOrDefault().LastChild.Descendants("li")
.Where(node => node.GetAttributeValue("class", "")
.Equals("a-disabled a-last")).Any();
if (last || numberOfPages == 0)
{
list.url = null;
return(list);
}
//filler for getting url for the next page
var newUrl = htmlDoc.DocumentNode.Descendants("div")
.Where(node => node.GetAttributeValue("class", "")
.Equals("a-form-actions a-spacing-top-extra-large"))
.FirstOrDefault().LastChild.Descendants("li")
.Where(node => node.GetAttributeValue("class", "")
.Equals("a-last")).First().FirstChild.Attributes["href"].Value;
//Decode the URL causing issues
var decodeString = System.Net.WebUtility.HtmlDecode(newUrl);
list.url = "https://www.amazon.com" + decodeString;
return(list);
}
public IActionResult CreateReview(int restaurantId)
{
var restaurant = _restaurantRepo.Read(restaurantId);
ViewData["RestInfo"] = restaurant;
reviews review = new reviews()
{
restaurant_id = restaurantId
};
return(View());
}
public ActionResult Index(reviews reviews)
{
if (ModelState.IsValid)
{
ctx.reviewBll.add(reviews);
return(Json(new { err = 0 }));
}
else
{
return(Json(new { err = 1, modelState = ModelState.Values.SelectMany(x => x.Errors).Select(y => y.ErrorMessage).ToList() }));
}
}
public int reviewDelete(int id)
{
reviews review = ctx.reviewBll.getOne(id);
bool resultDelete = ctx.reviewBll.deleteById(review.id);
if (resultDelete)
{
return(1);
}
else
{
return(0);
}
}
public IActionResult CreateReview(reviews review)
{
if (ModelState.IsValid && !string.IsNullOrEmpty(review.rating_text) && (!string.IsNullOrEmpty(review.rating.ToString()) || review.rating > 0))
{
review.review_time_friendly = DateTime.Now.ToString("MMM dd, yyyy");
if (string.IsNullOrEmpty(review.customer_name))
{
review.customer_name = "Anonymous Reviewer";
}
_restaurantRepo.CreateReview(review);
return(RedirectToAction("Reviews", "Home", new { id = review.restaurant_id }));
}
else
{
ModelState.AddModelError(string.Empty, "Your Review is missing the required fields. Please try again and ensure that all fields are filled out correctly.");
}
var restaurant = _restaurantRepo.Read(review.restaurant_id);
ViewData["RestInfo"] = restaurant;
return(View(review));
}
public reviews CreateReview(reviews review)
{
_db.Reviews.Add(review);
_db.SaveChanges();
return(review);
}
private void backgroundWorker_DoWork(object sender, DoWorkEventArgs e)
{
try
{
CommentCount = 1;
rp("Logging in into Crucible...");
Stream auth = getHttpStream(
String.Format(Properties.Settings.Default.CrucibleLoginUrl, Properties.Settings.Default.CrucibleUserName,
Properties.Settings.Default.CruciblePassword));
XmlSerializer asr = new XmlSerializer(typeof(loginResult));
loginResult lr = (loginResult)asr.Deserialize(auth);
rp("Login complete...");
rp("Fetching reviews...");
Stream rvs = getHttpStream(String.Format(Properties.Settings.Default.CrucibleReviewsUrl,
Properties.Settings.Default.CrucibleProject, lr.token));
XmlSerializer rsr = new XmlSerializer(typeof(reviews));
reviews reviews = (reviews)rsr.Deserialize(rvs);
rp("Opening Excel...");
Excel.Application oXL = new Excel.Application();
Excel.Workbook workBook = oXL.Workbooks.Add(System.Reflection.Missing.Value);
rp("Preparing the workbook...");
PrepareExcelWorkbook(workBook);
Excel.Worksheet workSheet = (Excel.Worksheet)workBook.Sheets[1];
rp("Logging in into Jira...");
JiraSoapServiceService jss = new JiraSoapServiceService();
string token = jss.login(Properties.Settings.Default.CrucibleUserName,
Properties.Settings.Default.CruciblePassword);
rp("Loading Jira versions");
foreach (RemoteVersion ver in jss.getVersions(token, Properties.Settings.Default.JiraProjectName))
{
revHash[ver.id] = ver.name;
log(String.Format("Adding [{0}] : [{1}] to hash", ver.name, ver.id));
}
rp("Populating data into workbook...");
int rowIndex = 2;
foreach (reviewData rv in reviews.reviewData)
{
if (
(Properties.Settings.Default.CrucibleFetchAllReviews == false) &&
(rv.state != state.Closed)
)
{
log("Incomplete review, skipping " + rv.permaId.id);
continue;
}
else
{
rp("Processing " + rv.permaId.id);
Stream cms = getHttpStream(String.Format(Properties.Settings.Default.CrucibleCommentUrl, rv.permaId.id, lr.token));
XmlSerializer cmr = new XmlSerializer(typeof(comments));
comments rcomments = (comments)cmr.Deserialize(cms);
if (rcomments.Any != null)
{
foreach (System.Xml.XmlElement elem in rcomments.Any)
{
XmlSerializer vlcdr = new XmlSerializer(typeof(versionedLineCommentData));
versionedLineCommentData vlcd = (versionedLineCommentData)vlcdr.Deserialize(new StringReader(
decorate(elem.InnerXml, "versionedLineCommentData")));
WriteExcelRow(workSheet, rowIndex, rv, vlcd, jss, token);
rowIndex++;
}
}
else
{
rp("Skipping " + rv.permaId.id + ". No review comments detected.");
}
}
}
oXL.Visible = true;
oXL.UserControl = true;
}
catch (Exception exp)
{
rp("Sorry, exception occured, after all this is software and there is no CI for this :)\r\n" +
exp.Message + "\r\n" + exp.StackTrace);
}
rp("Completed...");
}
public void Post([FromBody] reviews value)
{
_context.reviews.Add(value);
_context.SaveChanges();
}
public void AddReview(reviews review)
{
reviews.Add(review);
}
public bool update(reviews reviews)
{
return(_reviewDal.update(reviews));
}
public bool add(reviews reviews)
{
return(_reviewDal.add(reviews));
}
