public ActionResult DeleteConfirmed(int id)
{
RestaurantComment restaurantComment = db.RestaurantComments.Find(id);
db.RestaurantComments.Remove(restaurantComment);
db.SaveChanges();
return(RedirectToAction("Index"));
}
protected void btn_comentar_Click(object sender, EventArgs e)
{
try
{
string comentario = txt_comentario.Text.Trim();
if (comentario.Length <= 3)
{
throw new Exception("Comentário inválido");
}
if (Request.Cookies["estrelas"] == null)
{
throw new Exception("Número de estrelas inválido");
}
if (int.Parse(Request.Cookies["estrelas"].Value) <= 0 || int.Parse(Request.Cookies["estrelas"].Value) > 5)
{
throw new Exception("Número de estrelas inválido");
}
int id_restaurante = int.Parse(Request["id"].ToString());
int id_user = int.Parse(Session["id_user"].ToString());
if (Session["id_user"] == null)
{
throw new Exception("Não estás logado.");
}
if (Restaurant.UserOwnsRestaurant(id_restaurante, id_user))
{
throw new Exception("Não podes comentar no teu próprio restaurante");
}
int estrelas = int.Parse(Request.Cookies["estrelas"].Value);
Request.Cookies["estrelas"].Expires = DateTime.Now.AddDays(-1);
RestaurantComment restaurantComment = new RestaurantComment();
restaurantComment.user = id_user;
restaurantComment.restaurant = id_restaurante;
restaurantComment.comment = comentario;
restaurantComment.stars = estrelas;
restaurantComment.Adicionar();
lb_erro_comentario.Visible = false;
txt_comentario.Text = "";
LoadComments();
}
catch (Exception erro)
{
/* lb_erro_comentario.Text = erro.Message;
* lb_erro_comentario.Visible = true;*/
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "MostrarNotificação", "ShowNotification('Erro','" + erro.Message + "', 'error',4000)", true);
return;
}
}
public JsonResult DeleteComment(int deleteid)
{
RestaurantComment delComment = db.RestaurantComments.Find(deleteid);
db.RestaurantComments.Remove(delComment);
db.SaveChanges();
return(Json(2));
}
public ActionResult Edit([Bind(Include = "CommentId,Content,UserId,RestaurantId")] RestaurantComment restaurantComment)
{
if (ModelState.IsValid)
{
db.Entry(restaurantComment).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.RestaurantId = new SelectList(db.Restaurants, "RestaurantId", "RestaurantName", restaurantComment.RestaurantId);
ViewBag.UserId = new SelectList(db.Users, "UserId", "NameSurname", restaurantComment.UserId);
return(View(restaurantComment));
}
// GET: Panel/RestaurantComments/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
RestaurantComment restaurantComment = db.RestaurantComments.Find(id);
if (restaurantComment == null)
{
return(HttpNotFound());
}
return(View(restaurantComment));
}
// GET: Panel/RestaurantComments/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
RestaurantComment restaurantComment = db.RestaurantComments.Find(id);
if (restaurantComment == null)
{
return(HttpNotFound());
}
ViewBag.RestaurantId = new SelectList(db.Restaurants, "RestaurantId", "RestaurantName", restaurantComment.RestaurantId);
ViewBag.UserId = new SelectList(db.Users, "UserId", "NameSurname", restaurantComment.UserId);
return(View(restaurantComment));
}
private void LoadComments()
{
div_comentarios_content.InnerHtml = "";
int id_restaurante = int.Parse(Request["id"].ToString());
DataTable dados = RestaurantComment.LoadComments(id_restaurante);
// comment
// stars
// name
// CreateDate
foreach (DataRow item in dados.Rows)
{
string comentario = item["comment"].ToString();
int estrelas = int.Parse(item["stars"].ToString());
string utilizador = item["name"].ToString();
DateTime data = DateTime.Parse(item["CreateDate"].ToString());
string estrelasHtml = "";
for (int i = 1; i < 6; i++)
{
if (i <= estrelas)
{
estrelasHtml += "<i class='fas fa-star text-warning'></i>";
}
else
{
estrelasHtml += "<i class='far fa-star text-warning'></i>";
}
}
div_comentarios_content.InnerHtml += $@"
<div class='comentario border p-3 bg-white mt-3'>
<div class='d-flex align-items-center justify-content-between'>
<span style= ""font-family: 'Roboto', sans-serif !important; font-weight: bold; font-size: 18px;""> {utilizador}</span>
<span>{estrelasHtml}</span>
</div>
<div>
<small class='text-muted'>{data}</small>
</div>
<div class='mt-3'>
<span>{comentario}</span>
</div>
</div>";
}
}
public ActionResult RestaurantDetail(string Content, int id)
{
RestaurantComment rComment = new RestaurantComment();
rComment.Content = Content;
rComment.RestaurantId = id;
int idUser = Convert.ToInt32(Session["EnterID"]);
rComment.User = db.Users.Find(idUser);
db.RestaurantComments.Add(rComment);
db.SaveChanges();
Restaurant rest = (from r in db.Restaurants where r.RestaurantId == id select r).FirstOrDefault();
ViewBag.Comment = db.RestaurantComments.Where(x => x.RestaurantId == id).ToList();
return(View(rest));
}
private void AtualizarGrid()
{
int id_restaurante = -1;
if (Request["restaurante"] == null || !int.TryParse(Request["restaurante"].ToString(), out id_restaurante))
{
Response.Redirect("~/index.aspx");
}
DataTable dados = RestaurantComment.LoadComments(id_restaurante);
dgv_comentarios.Columns.Clear();
dgv_comentarios.DataSource = null;
dgv_comentarios.DataBind();
dgv_comentarios.DataSource = dados;
dgv_comentarios.AutoGenerateColumns = false;
// id
// comment
// stars
// name
// CreateDate
BoundField bfID = new BoundField();
bfID.HeaderText = "ID";
bfID.DataField = "id";
dgv_comentarios.Columns.Add(bfID);
BoundField bfComentario = new BoundField();
bfComentario.HeaderText = "Comentário";
bfComentario.DataField = "comment";
dgv_comentarios.Columns.Add(bfComentario);
BoundField bfStars = new BoundField();
bfStars.HeaderText = "Estrelas";
bfStars.DataField = "stars";
dgv_comentarios.Columns.Add(bfStars);
BoundField bfUtilizador = new BoundField();
bfUtilizador.HeaderText = "Utilizador";
bfUtilizador.DataField = "name";
dgv_comentarios.Columns.Add(bfUtilizador);
BoundField bfCreateDate = new BoundField();
bfCreateDate.HeaderText = "Data";
bfCreateDate.DataField = "CreateDate";
dgv_comentarios.Columns.Add(bfCreateDate);
ButtonField dcOpcoes = new ButtonField();
dcOpcoes.HeaderText = "Opções";
dcOpcoes.ButtonType = ButtonType.Link;
dgv_comentarios.Columns.Add(dcOpcoes);
dgv_comentarios.DataBind();
}
