public ActionResult UpdateComentario(int id_comentario, int id_tema)
{
Session["user_name"] = Session["user_name"];
Session["IDG"] = Session["IDG"];
Session["ID"] = Session["ID"];
Tema tema = new Tema();
string mensaje = Microsoft.VisualBasic.Interaction.InputBox("Editar Mensaje:");
String sql = "Update Comentario set mensaje = '" + mensaje + "' where id_comentario = '" + id_comentario + "'";
int retorno = 0;
using (SqlConnection connection = Conexion.getConnection())
{
SqlCommand Comando = new SqlCommand(string.Format(sql, id_comentario), connection);
retorno = Comando.ExecuteNonQuery();
connection.Close();
}
if (retorno > 0)
{
return(RedirectToAction("Tema", new { nombreTema = tema.ObtenerNombreTemaPorID(id_tema) }));
}
return(View());
}
public ActionResult CrearComentario()
{
Session["IDtema"] = Session["IDtema"];
Session["ID"] = Session["ID"];
Session["IdCategoria"] = Session["IdCategoria"];
int id_tema = int.Parse(Session["IDtema"].ToString());
int id_usuario = int.Parse(Session["ID"].ToString());
string mensaje = Request["mensaje"];
Tema tema = new Tema();
String sql = "Insert into Comentario (id_tema,id_usuario,mensaje) "
+ "values ('{0}','{1}','{2}')";
int retorno = 0;
using (SqlConnection connection = Conexion.getConnection())
{
SqlCommand Comando = new SqlCommand(string.Format(sql, id_tema, id_usuario, mensaje), connection);
retorno = Comando.ExecuteNonQuery();
connection.Close();
}
if (retorno > 0)
{
return(RedirectToAction("Tema", new { nombreTema = tema.ObtenerNombreTemaPorID(id_tema) }));
}
else
{
MessageBox.Show("No se pudo agregar comentario", "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return(Redirect("CrearCategoria"));
}
}
public ActionResult EliminarComentarioPorID(int id_comentario, int id_tema)
{
Session["user_name"] = Session["user_name"];
Session["IDG"] = Session["IDG"];
Session["ID"] = Session["ID"];
Tema tema = new Tema();
String sql = "Delete from Comentario where id_comentario = '" + id_comentario + "'";
int retorno = 0;
using (SqlConnection connection = Conexion.getConnection())
{
SqlCommand Comando = new SqlCommand(string.Format(sql, id_comentario), connection);
retorno = Comando.ExecuteNonQuery();
connection.Close();
}
if (retorno > 0)
{
return(RedirectToAction("Tema", new { nombreTema = tema.ObtenerNombreTemaPorID(id_tema) }));
}
return(View());
}
