private void AddButton_Click(object sender, RoutedEventArgs e)
{
Model.Review review = new Model.Review()
{
CustomerID = Login.CustomerID,
ProductID = ShowCatalog.productid,
Description = Comment.Text,
Rating = Rating.Value,
Date = DateTime.Now
};
db.Reviews.Add(review);
db.SaveChanges();
var comment = from rev in db.Reviews
join customer in db.Customers on rev.CustomerID equals customer.CustomerID
join user in db.Users on customer.UserID equals user.UserID
where rev.ProductID == ShowCatalog.productid
select new { rev.Description, user.Username, rev.Rating };
ProductView.Comment.ItemsSource = comment.ToList();
try
{
var rating_out = new OracleParameter("rating_out", OracleDbType.Int32, ParameterDirection.Output);
var sql = "BEGIN RATINGPRODUCT(" + ShowCatalog.productid + ", :rating_out); END;";
var rating = db.Database.ExecuteSqlCommand(sql, rating_out);
ProductView.ProductRat.Value = Convert.ToInt32(rating_out.Value.ToString());
ProductView.Rating.Content = "(Rating: " + rating_out.Value.ToString() + ")";
}
catch { }
this.Close();
}
private void BtnSubmit_Click(object sender, EventArgs e)
{
Model.Verdict v = (Model.Verdict)CBVerdict.SelectedValue;
Model.Review review = new Model.Review(0, part, v, TBComments.Text);
cont.addReview(paperId, review);
this.Close();
}
public bool UpdateReview(Model.Review rev)
{
bool result = RemoveReview(rev.Id);
if (result)
{
AddReview(rev);
}
return(result);
}
protected async void HandleValidSubmit()
{
Review.RecipeId = RecipeId;
bool result = await Service.AddReview(Review);
if (result)
{
Review = new Model.Review();
StateHasChanged();
await OnReviewCreated.InvokeAsync(true);
}
}
public void LTDAddRevTest()
{
IDataManager dm = new LocalTestData();
var rev = new Model.Review(0, 3, "newRev", "newCom", 2);
int id = dm.AddReview(rev);
var getR = dm.GetReview(id);
Assert.AreEqual(rev.Score, getR.Score);
Assert.AreEqual(rev.Reviewer, getR.Reviewer);
Assert.AreEqual(rev.Comment, getR.Comment);
}
public int AddReview(Model.Review review)
{
using (var context = new RestaurantDBEntities())
{
Review newRev = context.Reviews.Add(new Review()
{
revscore = review.Score,
reviewer = review.Reviewer,
comment = review.Comment,
revsubject = review.Subject
});
context.SaveChanges();
log.Info("Added review: " + newRev.revid);
return(newRev.revid);
}
}
public int AddReview(Model.Review rev)
{
int[] restIds = restaurants.Select(x => x.Id).ToArray();
if (!restIds.Contains(rev.Subject))
{
throw new ArgumentException("Target Restaurant does not exist. Restaurant ID: " + rev.Subject);
}
int[] ids = reviews.Select(x => x.Id).ToArray();
int i = rev.Id;
while (ids.Contains(i))
{
i++;
}
reviews.Add(new Model.Review(i, rev.Score, rev.Reviewer, rev.Comment, rev.Subject));
return(i);
}
public bool UpdateReview(Model.Review rev)
{
using (var context = new RestaurantDBEntities())
{
var std = context.Reviews.Find(rev.Id);
if (std == null)
{
log.Error("Update failed to locate Review: " + rev.Id);
return(false);
}
std.revscore = rev.Score;
std.reviewer = rev.Reviewer;
std.comment = rev.Comment;
std.revsubject = rev.Subject;
context.SaveChanges();
log.Info("Updated review " + rev.Id);
return(true);
}
}
protected void btnSend_Click(object sender, EventArgs e)
{
if(txtComment.Text == "" && rblVote.SelectedItem == null)
{
lblInfo.Text = "You should at least either vote or make a review regarding your experience.";
}
else
{
Model.Review rev = new Model.Review()
{
RideId = r.Id,
Comment = txtComment.Text.Trim(),
Vote = Convert.ToInt32(rblVote.SelectedValue.ToString())
};
bool result = Model.ReviewDb.Save(rev);
if (result)
lblInfo.Text = "Your review is live now.";
else
lblInfo.Text = "An error has been occured when saving your review";
}
}
public ActionResult DeleteConfirmed(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
try
{
Model.Review rev = lib.GetReview((int)id);
bool result = lib.RemoveReview((int)id);
if (!result)
{
return(HttpNotFound());
}
return(RedirectToAction("Details", "Restaurant", new { id = rev.Subject }));
}
catch
{
return(View());
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
if (txtComment.Text == "" && rblVote.SelectedItem == null)
{
lblInfo.Text = "You should at least either vote or make a review regarding your experience.";
}
else
{
Model.Review rev = new Model.Review()
{
Id = userReview.Id,
// No need for RideId since they will never change.
Comment = txtComment.Text.Trim(),
Vote = Convert.ToInt32(rblVote.SelectedValue.ToString())
};
bool result = Model.ReviewDb.Update(rev);
if (result)
lblInfo.Text = "Your review has been updated.";
else
lblInfo.Text = "An error has been occured when updating your review.";
}
}
public void AddReview(Model.Review rev)
{
dm.AddReview(rev);
}
public System.Threading.Tasks.Task <Model.Review> UpdateReviewAsync(Model.Review Review)
{
return(base.Channel.UpdateReviewAsync(Review));
}
public Model.Review UpdateReview(Model.Review Review)
{
return(base.Channel.UpdateReview(Review));
}
public System.Threading.Tasks.Task <int> CreateReviewAsync(Model.Review Review)
{
return(base.Channel.CreateReviewAsync(Review));
}
public int CreateReview(Model.Review Review)
{
return(base.Channel.CreateReview(Review));
}
public bool EditReview(Model.Review rev)
{
return(dm.UpdateReview(rev));
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserKey"] != null)
{
u = Model.UserDb.GetUserById(Session["UserKey"]);
Master.LabelOnMasterPage.Text = u.FullName;
// If the userType is not Passenger, redirect to main page.
if (u.UserType != 1)
{
Response.Redirect("Default.aspx");
}
else
{
if (Request.QueryString["id"] != "")
{
int rideId = Convert.ToInt32(Request.QueryString["id"]);
r = Model.RideDb.GetRideById(rideId);
if(r == null)
Response.Redirect("Default.aspx");
lblDriverName.Text = Model.UserDb.GetUserById(r.DriverId).FullName;
lblModel.Text = Model.VehicleDb.getVehicleByUserId(r.DriverId).Model;
lblCost.Text = r.Charge.ToString();
lblStartDate.Text = r.StartDate.ToString("dd MMMM yyyy", new CultureInfo("en-US"));
lblEndDate.Text = r.EndDate.ToString("dd MMMM yyyy", new CultureInfo("en-US"));
userReview = Model.ReviewDb.GetReviewByRideId(r.Id);
if (userReview != null)
{
if (!IsPostBack) // This control is needed for update process.
{
rblVote.SelectedValue = userReview.Vote.ToString();
txtComment.Text = userReview.Comment;
}
btnSend.Visible = false;
btnUpdate.Visible = true;
}
else
{
btnSend.Visible = true;
btnUpdate.Visible = false;
}
}
else
{
Response.Redirect("Default.aspx");
}
}
}
else
{
Response.Redirect("Default.aspx");
}
}
