private void LoadComments() { div_comentarios_content.InnerHtml = ""; int id_menu = int.Parse(Request["id"].ToString()); DataTable dados = MenuComment.LoadComments(id_menu); // 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>"; } }
private void AtualizarGrid() { int id_restaurante = -1; if (Request["id"] == null || !int.TryParse(Request["id"].ToString(), out id_restaurante)) { Response.Redirect("~/index.aspx"); } DataTable dados = MenuComment.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(); }