public async Task <IHttpActionResult> Putreview(int id, review review)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != review.movieid)
{
return(BadRequest());
}
db.Entry(review).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!reviewExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult createfeedback()
{
foreach (var transaction in db.transactions)
{
if (transaction.order.status == OrderStatus.SHIPPED.ToString())
{
var fb = new review
{
created = DateTime.UtcNow,
rating_overall = 3,
rating_willshopagain = 3,
rating_delivery = 3,
rating_support = 3,
pending = true,
subdomainid = transaction.order.user1.organisation1.subdomain
};
repository.AddReview(fb);
// update transaction
transaction.reviewid = fb.id;
}
}
db.SubmitChanges();
return(Content("DONE"));
}
public ActionResult Update(review rev)
{
var crud = new DataAccess();
// crud.Update(rev);
return(RedirectToAction("Index", "Review"));
}
public async Task <IActionResult> Putreview(long id, review review)
{
if (id != review.Id)
{
return(BadRequest());
}
_context.Entry(review).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!reviewExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public IActionResult request(string number, string male, string female, string fare)
{
if (HttpContext.Session.GetString("user") != null)
{
ViewData["av"] = "Available Male seat : " + male.ToString() + " Female Seat : " + female.ToString();
HttpContext.Session.SetString("requestInfo", number.ToString() + "," + male.ToString() + "," + female.ToString() + "," + fare.ToString());
string connectionString = configuration.GetConnectionString("DefaultConnectionString");
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();
string query = "Select * from review where dri_id in(select dri_id from bus where number_plate = '" + number.ToString() + "')";
SqlCommand com = new SqlCommand(query, connection);
com.CommandType = System.Data.CommandType.Text;
SqlDataReader reader = com.ExecuteReader();
var model = new List <review>();
while (reader.Read())
{
review rv = new review();
rv.cusid = reader["cusId"].ToString();
rv.driId = reader["dri_id"].ToString();
rv.rev = reader["rev"].ToString();
model.Add(rv);
}
return(View(model));
}
else
{
return(RedirectToAction("notAccess", "Admin"));
}
}
public async Task <ActionResult <review> > Postreview(review review)
{
_context.review.Add(review);
await _context.SaveChangesAsync();
return(CreatedAtAction("Getreview", new { id = review.Id }, review));
}
public IHttpActionResult Postreview(review review)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.reviews.Add(review);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (reviewExists(review.UserId))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = review.UserId }, review));
}
public IHttpActionResult Putreview(string id, review review)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != review.UserId)
{
return(BadRequest());
}
db.Entry(review).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!reviewExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public static void insertReview(int productId, String name, String review, int stars)
{
using (DB_entities db = new DB_entities())
{
using (TransactionScope scope = new TransactionScope())
{
review rev = new review();
rev.name = name;
rev.product_id = productId;
rev.stars = stars;
rev.comment = review;
try
{
db.reviews.Add(rev);
db.SaveChanges();
}
catch (Exception ex)
{
Log.error("insertReview - Insert.cs", DateTime.Now, ex);
}
scope.Complete();
}
}
}
// DELETE: api/Reviews/5
public string DeleteReview(string id)
{
review selRev = null;
using (var ctx = new Assignment2Entities())
{
//finds review
selRev = ctx.reviews
.Where(s => (s.reviewId).ToString() == id)
.FirstOrDefault();
//return error if review not found
if (selRev == null)
{
return("Not a valid song");
}
else
{
//deletes review
ctx.reviews.Remove(selRev);
ctx.SaveChanges();
return("Success");
}
}
}
public ActionResult DeleteConfirmed(int id)
{
review review = db.reviews.Find(id);
db.reviews.Remove(review);
db.SaveChanges();
return(RedirectToAction("Index"));
}
/// <summary>
/// Add review to the table
/// </summary>
/// <param name="toAdd"></param>
protected void addReview(review toAdd)
{
TableRow fRow = new TableRow();
TableRow tRow = new TableRow();
TableCell cell1 = new TableCell();
cell1.BorderStyle = border;
cell1.BorderWidth = width;
TableCell cell2 = new TableCell();
TableCell cell3 = new TableCell();
cell3.BorderStyle = border;
cell3.BorderWidth = width;
if (Session["User"] is customer)
{
cell1.Text = toAdd.rCustomer.getFullName; //Customer name
}
else
{
LinkButton newBTN = new LinkButton();
newBTN.Text = toAdd.rCustomer.getFullName;
newBTN.Click += (e, a) =>
{
Session["Customer"] = toAdd.rCustomer;
Response.Redirect("~//custPGE.aspx");
};
cell1.Controls.Add(newBTN);
}
double r = toAdd.getRating;
Color t;
if (r < 3)
{
t = Color.PaleVioletRed;
}
else
{
t = Color.LightGreen;
}
//cell2.ForeColor = Color.White;
cell2.BackColor = t;
cell2.BorderStyle = border;
cell2.BorderWidth = width;
cell2.HorizontalAlign = HorizontalAlign.Center;
cell2.Font.Bold = true;
cell2.Text = string.Format("{0:0.0}", r.ToString());
fRow.Cells.Add(cell1);
fRow.Cells.Add(cell2);
reviewTBL.Rows.Add(fRow);
cell3.Text = toAdd.getComments;
cell3.ColumnSpan = 2; //Span 2 columns
tRow.Cells.Add(cell3);
reviewTBL.Rows.Add(tRow);
TableRow paddRow = new TableRow();
paddRow.Cells.Add(new TableCell());
reviewTBL.Rows.Add(paddRow);
}
public IActionResult submit(review Review)
{
_context.users.Add(Review);
_context.SaveChanges();
return(RedirectToAction("reviews"));
}
public ActionResult Edit([Bind(Include = "developerId,Name,Subject,Description,number_of_Stars")] review review)
{
if (ModelState.IsValid)
{
db.Entry(review).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(review));
}
public ActionResult Create(review rev)
{
//string _name, int _score, string _message, int _rest_id
var crud = new DataAccess();
crud.AddReview(rev.name, rev.score, rev.message, rev.rest_id);
// do this see if it crashes
//var temp = crud.GetReviews(3);
return(RedirectToAction("Index", "Review"));
}
public ActionResult Create([Bind(Include = "developerId,Name,Subject,Description,number_of_Stars")] review review)
{
if (ModelState.IsValid)
{
db.reviews.Add(review);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(review));
}
public async Task <IHttpActionResult> Getreview(int id)
{
review review = await db.reviews.FindAsync(id);
if (review == null)
{
return(NotFound());
}
return(Ok(review));
}
public static review ToDataLayer(Review reviewLib, restaurant restaurantData)
{
review reviewData = new review();
reviewData.id = reviewLib.id;
reviewData.reviewerName = reviewLib.name;
reviewData.comment = reviewLib.comment;
reviewData.rating = (float)reviewLib.rating;
reviewData.date = reviewLib.dateTime;
reviewData.restaurant = restaurantData;
return(reviewData);
}
// GET: reviews/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
review review = db.reviews.Find(id);
if (review == null)
{
return(HttpNotFound());
}
return(View(review));
}
public IHttpActionResult Deletereview(string id)
{
review review = db.reviews.Find(id);
if (review == null)
{
return(NotFound());
}
db.reviews.Remove(review);
db.SaveChanges();
return(Ok(review));
}
// POST: api/Reviews
public string PostReview(review revPost)
{
using (var ctx = new Assignment2Entities())
{
if (!ModelState.IsValid)
{
return("Post Failed");
}
//inserts review
ctx.reviews.Add(revPost);
ctx.SaveChanges();
return("Success");
}
}
public async Task <IHttpActionResult> Deletereview(int id)
{
review review = await db.reviews.FindAsync(id);
if (review == null)
{
return(NotFound());
}
db.reviews.Remove(review);
await db.SaveChangesAsync();
return(Ok(review));
}
// PUT: api/Reviews/5
public string PutReview(review revPut)
{
using (var ctx = new Assignment2Entities())
{
if (!ModelState.IsValid)
{
return("Put Failed");
}
//edits review
ctx.Entry(revPut).State = EntityState.Modified;
ctx.SaveChanges();
return("Success");
}
}
public ActionResult Add_review(FormCollection collection)
{
if (ModelState.IsValid)
{
review revie = new review();
if (Session["UserAccount"] == null)
{
return(new HttpNotFoundResult()); // 404
}
else
{
userr users = (userr)Session["UserAccount"];
int film_id = int.Parse(collection["film"]);
revie.created = DateTime.Now;
revie.user_id = users.id;
revie.film_id = film_id;
revie.comment = collection["comment"];
revie.title = collection["title"];
revie.point = int.Parse(collection["point"]);
data.reviews.InsertOnSubmit(revie);
data.SubmitChanges();
// cap nhat diem cua phim
var review = data.reviews.Where(or => or.film_id == film_id).ToList();
if (review.Count() > 0)
{
int sum = 0;
foreach (var item in review)
{
sum += int.Parse((item.point).ToString());
}
float point = sum / (review.Count());
film fil = data.films.Where(or => or.id == film_id).FirstOrDefault();
fil.rate = int.Parse((Math.Ceiling(point)).ToString());
UpdateModel(fil);
data.SubmitChanges();
}
else
{
;
}
return(RedirectToAction("Film_single", "Home", new { id = film_id }));
}
}
else
{
return(HttpNotFound());
}
}
public ActionResult Review([Bind(Include = "Id,rating,comment,user_id,paper_id")] review review)
{
string current = User.Identity.GetUserId();
review.user_id = current;
review.paper_id = reserved;
if (ModelState.IsValid)
{
db.review.Add(review);
db.SaveChanges();
if (User.IsInRole("Admin"))
{
return(RedirectToAction("IndexAdmin"));
}
return(RedirectToAction("IndexRev"));
}
return(View(review));
}
//Executes a command parsed at the db and returns relevant reviews
public List <review> getReviewsFromDB(string commandText)
{
List <review> qryReviews = new List <review>();
var connString = settings.ItemReviews;
MySqlConnection conn = new MySqlConnection(connString);
MySqlCommand command = conn.CreateCommand();
try
{
conn.Open();
command.CommandText = commandText;
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
review r = new review();
try
{
r.ItemName = reader.GetString(0);
r.ReviewersOfReview = reader.GetInt16(1);
r.ReviewersOfReviewFoundHelpful = reader.GetInt16(2);
r.StarsGiven = reader.GetInt16(3);
r.ShortReview = reader.GetString(4);
r.ReviewerId = reader.GetString(5);
r.ReviewLocation = reader.GetString(6);
r.IsAmazonVerifiedPurchase = reader.GetBoolean(7);
r.LongReview = reader.GetString(8);
qryReviews.Add(r);
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
}
}
}
catch (MySqlException ex)
{
Debug.WriteLine(ex.Message);
}
return(qryReviews);
}
public ActionResult Create(int id, Decimal gameId, FormCollection form)
{
bool check = form["id"] != null;
Decimal gId = Decimal.Parse(form["gameId"]);
review review = db.reviews.Find(id);
if (review == null)
{
return(HttpNotFound());
}
review.approve = check;
db.SaveChanges();
var reviewList = db.reviews
.Where(c => c.gameId == gId);
return(View("Index", reviewList.ToList()));
}
public ActionResult Review(int id)
{
reserved = id;
review review = new review();
string current = User.Identity.GetUserId();
// Make sure a paper can't be reviewed twice by the same person
// Check if <= deadline
var deadpaper = db.paper.FirstOrDefault(p => p.Id == id);
var deadconf = db.Conf.FirstOrDefault(c => c.Id == deadpaper.conf_id);
DateTime?deadline = deadconf.rev_deadline;
if (db.review.Any(r => r.paper_id == reserved && r.user_id == current) || deadline <= DateTime.Now)
{
if (User.IsInRole("Admin"))
{
return(RedirectToAction("IndexAdmin"));
}
return(RedirectToAction("IndexRev"));
}
return(View(review));
}
public static int addReview(String name, String text, int productId, int stars)
{
using (DB_entities db = new DB_entities())
{
review prodReview = new review();
prodReview.name = name;
prodReview.comment = text;
prodReview.product_id = productId;
prodReview.stars = stars;
try
{
db.reviews.Add(prodReview);
db.SaveChanges();
return(prodReview.id);
}
catch (Exception ex)
{
Log.error("addReview - Insert.cs", DateTime.Now, ex);
return(0);
}
}
}
public ActionResult Index(Decimal id, String txtAreaReview, FormCollection form)
{
if (id != null && txtAreaReview != null)
{
String rate = form["rate"];
review review = new review();
var username = Session["User"].ToString();
review.gameId = id;
review.review1 = txtAreaReview;
review.username = username;
review.rating = Int32.Parse(rate);
review p = db.reviews.OrderByDescending(c => c.id).FirstOrDefault();
int newId = (null == p ? 0 : p.id) + 1;
review.id = newId;
db.reviews.Add(review);
db.SaveChanges();
}
var reviewList = db.reviews
.Where(c => c.gameId == id);
return(View(reviewList.ToList()));
}
