Exemple #1
0
        public Inbox getInbox(int id)
        {
            Inbox inbox = new Inbox();
            String sql = "Select *From Inbox where id_user = '******'";
            using (SqlConnection connection = BD.getConnection())
            {
                SqlCommand Comando = new SqlCommand(string.Format(sql), connection);
                SqlDataReader reader = Comando.ExecuteReader();
                while (reader.Read())
                {

                    inbox.id = reader.GetInt32(0);
                    inbox.id_user= reader.GetInt32(1);
                    inbox.msg_in = reader.GetInt32(2);
                    inbox.msg_in = reader.GetInt32(3);

                }
            }
            return inbox;
        }
Exemple #2
0
        public ActionResult EnviarMP()
        {
            Session["UserIDG"] = Session["UserIDG"];
            Session["UserID"] = Session["UserID"];
            Session["User"] = Session["User"];
            ViewBag.Message = "Mensaje Privado";
            User user = new User();
            Inbox inbox = new Inbox();
            int retorno = 0;
            string message = (string)Request["Mensaje"];
            string title = (string)Request["title"];
            string destiny = (string)Request["Destinatario"];
            int origen = (int)Session["UserID"];
            if (!user.Checkuser(destiny))
            {
                MessageBox.Show("No Existe Usuario Destino", "Invalido", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                return Redirect("MP");
            }
            user = user.getUser(destiny);
            inbox = inbox.getInbox(user.id);
            DateTime thisDay = DateTime.Now;
            string date = thisDay.ToString();

            String sql = "Insert into mp (id_userfrom,id_inbox,title,check_read,messages,date_send)"
             + "values ('{0}','{1}','{2}','{3}','{4}','{5}')";

            using (SqlConnection connection = BD.getConnection())
            {
                SqlCommand Comando = new SqlCommand(string.Format(sql, origen, inbox.id, title, 0, message, date), connection);

                retorno = Comando.ExecuteNonQuery();
                connection.Close();

            }
            if (retorno > 0)
            {

                MessageBox.Show("Mensaje Enviado Con Exito!!", "Enviado", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return Redirect("UserIn");
            }
            else
            {
                MessageBox.Show("No se pudo enviar el Mensaje", "Fallo!!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);

            }
            return Redirect("MP"); ;
        }