コード例 #1
0
ファイル: Comments.cs プロジェクト: TareasJM/Tarea2BD
        public List<Comments> getAllCommentByIDTopic(int id)
        {
            String sql = "Select *From Comments where id_topic = '"+id.ToString()+"'";
            List<Comments> Comments = new List<Comments>();
            using (SqlConnection connection = BD.getConnection())
            {
                SqlCommand Comando = new SqlCommand(string.Format(sql), connection);

                SqlDataReader reader = Comando.ExecuteReader();
                while (reader.Read())
                {
                    Comments com = new Comments();
                    com.id = reader.GetInt32(0);
                    com.id_topic = reader.GetInt32(1);
                    com.id_user = reader.GetInt32(2);
                    com.msg = reader.GetString(3);
                    Comments.Add(com);
                }
            }
            return Comments;
        }
コード例 #2
0
        public ActionResult EliminarCa(int id)
        {
            Session["UserIDG"] = Session["UserIDG"];
            Session["UserID"] = Session["UserID"];
            Session["User"] = Session["User"];
            string texto = "Estas seguro de Eliminar la categoria?";
            string titulo = "Eliminar Categoria";
            MessageBoxButtons button = MessageBoxButtons.YesNoCancel;
            MessageBoxIcon icon = MessageBoxIcon.Question;
            DialogResult result = MessageBox.Show(texto, titulo, button, icon);
            List<Topics> topics = new List<Topics>();
            Comments comments = new Comments();
            Topics top = new Topics();
            topics = top.getAllTopicsByCatID(id);
            if (result.Equals(System.Windows.Forms.DialogResult.Yes))
            {

                for (int i = 0; i < topics.Count; i++)
                {
                    if (!comments.DeleteCommentsByIDTopic(topics[i].id_topic))
                    {

                        MessageBox.Show("Comentario de " + topics[i].id_topic + "no eliminado");
                    }
                }
                if (!top.DeleteTopicsByIDCat(id))
                {
                    MessageBox.Show("Topic de " + id + "no eliminado");
                }

                String sql = "Delete from Category where id_category = '" + id.ToString() + "'";
                int retorno = 0;
                using (SqlConnection connection = BD.getConnection())
                {
                    SqlCommand Comando = new SqlCommand(string.Format(sql), connection);
                    retorno = Comando.ExecuteNonQuery();
                    connection.Close();

                }
                if (retorno > 0)
                {
                    MessageBox.Show("Categoria Borrada Con Exito!!", "Eliminada", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                else
                {
                    MessageBox.Show("No se pudo borrar la Categoria", "Fallo!!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                }
            }
            return RedirectToAction("Categorias", "Home");
        }
コード例 #3
0
        public ActionResult EliminarTop(string name)
        {
            Session["UserIDG"] = Session["UserIDG"];
            Session["UserID"] = Session["UserID"];
            Session["User"] = Session["User"];
            string texto = "Estas seguro de Eliminar el topic?";
            string titulo = "Eliminar Topic";
            MessageBoxButtons button = MessageBoxButtons.YesNoCancel;
            MessageBoxIcon icon = MessageBoxIcon.Question;
            DialogResult result = MessageBox.Show(texto, titulo, button, icon);
            Comments comments = new Comments();
            Topics topic = new Topics();
            topic = topic.getTopicsByName(name);
            if (result.Equals(System.Windows.Forms.DialogResult.Yes))
            {
                if (!comments.DeleteCommentsByIDTopic(topic.id_topic))
                {
                    MessageBox.Show("Comentario de " + topic.id_topic + "no eliminado");
                    return Redirect("GeneralCat");
                }
                String sql = "Delete from Topic where nameTopic = '" + name + "'";
                int retorno = 0;
                using (SqlConnection connection = BD.getConnection())
                {
                    SqlCommand Comando = new SqlCommand(string.Format(sql), connection);
                    retorno = Comando.ExecuteNonQuery();
                    connection.Close();

                }
                if (retorno > 0)
                {
                    MessageBox.Show("Topic Borrado Con Exito!!", "Eliminado", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                else
                {
                    MessageBox.Show("No se pudo borrar el Topic", "Fallo!!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                }
            }
            return RedirectToAction("GeneralCat", new { name = Session["CatName"] });
        }