public string Edit(DMoneda Entity)
        {
            result = "";
            using (SqlConnection connect = Dconexion.Getconectar())
            {
                connect.Open();
                try
                {
                    using (cmd = new SqlCommand())
                    {
                        cmd.Connection  = connect;
                        cmd.CommandText = "manto.SP_EditMoneda";
                        cmd.CommandType = CommandType.StoredProcedure;

                        cmd.Parameters.AddWithValue("@idmoneda", Entity.Idmoneda);
                        cmd.Parameters.AddWithValue("@codigo", Entity.Nom_moneda);
                        cmd.Parameters.AddWithValue("@nom_moneda", Entity.Abrev);
                        cmd.Parameters.AddWithValue("@simbolo", Entity.Simbolo);
                        cmd.Parameters.AddWithValue("@descripcion", Entity.Descripcion);


                        result = cmd.ExecuteNonQuery() == 1 ? "Se Modifico Correctamente!" : "Error al Modificar";

                        cmd.Parameters.Clear();
                    }
                }
                catch (Exception ex)
                {
                    result = ex.Message;
                }
            }
            return(result);
        }
        public List <DMoneda> Getdata(DMoneda Entity)
        {
            using (SqlConnection connect = Dconexion.Getconectar())
            {
                connect.Open();
                using (cmd = new SqlCommand())
                {
                    cmd.Connection  = connect;
                    cmd.CommandText = "manto.SP_ShowMon";
                    cmd.CommandType = CommandType.StoredProcedure;

                    SqlDataReader dtr = cmd.ExecuteReader();
                    using (DataTable dt = new DataTable())
                    {
                        dt.Load(dtr);
                        dtr.Dispose();

                        listmoneda = new List <DMoneda>();
                        foreach (DataRow item in dt.Rows)
                        {
                            listmoneda.Add(new DMoneda()
                            {
                                Idmoneda    = Convert.ToInt32(item[0]),
                                Codigo      = item[1].ToString(),
                                Nom_moneda  = item[2].ToString(),
                                Abrev       = item[3].ToString(),
                                Simbolo     = item[4].ToString(),
                                Descripcion = item[5].ToString()
                            });
                        }
                    }
                }
            }
            return(listmoneda);
        }
        private void button3_Click(object sender, EventArgs e)
        {
            try
            {
                var c = new DMoneda();
                c.idmoneda = Convert.ToInt32(textBox1.Text);

                if (NMoneda.Eliminar(c))
                {
                    MessageBox.Show("Se elimino correctamente", "Aviso");
                    id();
                    limpiar();
                    listado();
                    button1.Enabled = true;
                    button2.Enabled = false;
                    button3.Enabled = false;
                    button4.Enabled = false;
                }
                else
                {
                    MessageBox.Show("Error", "Aviso");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                if (textBox2.Text != "")
                {
                    var c = new DMoneda();
                    c.idmoneda = Convert.ToInt32(textBox1.Text);
                    c.nombre   = textBox2.Text.ToUpper();

                    if (NMoneda.Guardar(c))
                    {
                        MessageBox.Show("Datos guardados correctamente", "Aviso");
                        id();
                        limpiar();
                        listado();
                    }
                    else
                    {
                        MessageBox.Show("Error", "Aviso");
                    }
                }

                else
                {
                    MessageBox.Show("Debe ingresar Datos", "Aviso");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
        public static DMoneda EntidadMoneda(MySqlDataReader entidad)
        {
            var e = new DMoneda();

            e.idmoneda = Convert.ToInt32(entidad["Id_Moneda"]);
            e.nombre   = Convert.ToString(entidad["Nombre"]);
            return(e);
        }
 public FrmMoneda()
 {
     InitializeComponent();
     dMoneda = new DMoneda();
     rMoneda = new RMoneda();
     Show_moneda();
     Tabla();
     Dgv_moneda.AutoGenerateColumns = false;
 }
        public static bool Eliminar(DMoneda c)
        {
            try
            {
                MySqlConnection cn  = new MySqlConnection(Conexion.Cadena);
                var             cmd = new MySqlCommand();

                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Connection  = cn;
                cmd.CommandText = "EliminarMoneda";

                cmd.Parameters.AddWithValue("@id", c.idmoneda);
                cn.Open();
                return(Convert.ToBoolean(cmd.ExecuteNonQuery()));
            }
            catch (Exception)
            {
                return(false);
            }
        }
        public string Delete(DMoneda Entity)
        {
            using (SqlConnection conn = Dconexion.Getconectar())
            {
                conn.Open();
                cmd = null;
                using (cmd = new SqlCommand())
                {
                    cmd.Connection  = conn;
                    cmd.CommandText = "manto.SP_DeleteMoneda";
                    cmd.CommandType = CommandType.StoredProcedure;

                    cmd.Parameters.AddWithValue("@idmoneda", Entity.Idmoneda);


                    result = cmd.ExecuteNonQuery() == 1 ? "Se Elimino Correctamente!" : "Error al Eliminar";

                    cmd.Parameters.Clear();
                }
            }
            return(result);
        }
        public string Add(DMoneda Entity)
        {
            using (SqlConnection connect = Dconexion.Getconectar())
            {
                connect.Open();
                try
                {
                    using (cmd = new SqlCommand())
                    {
                        cmd.Connection  = connect;
                        cmd.CommandText = "manto.SP_AddMoneda";
                        cmd.CommandType = CommandType.StoredProcedure;

                        cmd.Parameters.AddWithValue("@codigo", Entity.Codigo);
                        cmd.Parameters.AddWithValue("@nom_moneda", Entity.Nom_moneda);
                        cmd.Parameters.AddWithValue("@abrev", Entity.Abrev);
                        cmd.Parameters.AddWithValue("@simbolo", Entity.Simbolo);
                        cmd.Parameters.AddWithValue("@descripcion", Entity.Descripcion);

                        result = cmd.ExecuteNonQuery() == 1 ? "Registrado Correctamente!" : "Error al Regsitrar";

                        cmd.Parameters.Clear();
                    }
                }
                catch (Exception ex)
                {
                    SqlException sqlex = ex as SqlException;
                    if (sqlex != null && sqlex.Number == 2627)
                    {
                        result = "EL CODIGO INGRESADO YA SE ENCUENTRA REGISTRADO";
                    }
                    else
                    {
                        result = ex.Message;
                    }
                }
            } //aqui esta cerrando la conexion.
            return(result);
        }
Exemple #10
0
 public static bool Eliminar(DMoneda e)
 {
     return(AdMoneda.Eliminar(e));
 }
Exemple #11
0
 public static bool Actualizar(DMoneda e)
 {
     return(AdMoneda.Actualizar(e));
 }
Exemple #12
0
 public static bool Guardar(DMoneda e)
 {
     return(AdMoneda.Agregar(e));
 }
Exemple #13
0
        /// <summary>
        /// Consulta de catálogo : Author JUVA
        /// </summary>
        /// <returns>Monedas</returns>
        public List <OMoneda> ObtenerLista(string zonaMoneda)
        {
            DMoneda moneda = new DMoneda();

            return(moneda.ObtenerLista(zonaMoneda));
        }
 public FrmV_Moneda()
 {
     InitializeComponent();
     dMoneda = new DMoneda();
     rMoneda = new RMoneda();
 }