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();
}