Example #1
0
        private void OpEliminar_Click(object sender, EventArgs e)
        {
            int i = bindingSource1.Position;

            if (i == -1)
            {
                MessageBox.Show("No hay registros activos para eliminar");
                return;
            }

            if (!SePuedeEliminar())
            {
                return;
            }

            DataGridViewRow row = this.dataGridView1.Rows[i];
            var             msg = string.Format("Desea Eliminar El Registro S/N\n\n\nTipoCuenta => {0}\n\nMontoMinimo => {1}", row.Cells["TipoCuenta"].Value.ToString(), row.Cells["MontoMinimo"].Value.ToString());

            if (MessageBox.Show(msg, "mensaje", MessageBoxButtons.YesNo) != DialogResult.Yes)
            {
                return;
            }

            var _TipoCuenta = (row.Cells["TipoCuenta"].Value.ToString());
            var _db         = new dbCAJA();



            CatCuentas result = (from u in _db.CatCuentas
                                 where u.TipoCuenta == _TipoCuenta
                                 select u).Single();

            _db.CatCuentas.DeleteOnSubmit(result);
            _db.SubmitChanges();

            var g = from x in new dbCAJA().CatCuentas select x;

            this.dataGridView1.DataSource = g.ToList();

            CancelaAccion();
            Carga_Grid();
        }
Example #2
0
        private void OpGuardar_Click(object sender, EventArgs e)
        {
            if (txtTipoCuenta.Text == "" || txtMontoMinimo.Text == "" || txtPlazoForsozo.Text == "")
            {
                MessageBox.Show("campos vacios revise su captura");
                return;
            }


            if (acc == Accion.Agregando)
            {
                var _db = new dbCAJA();
                var reg = new CatCuentas();


                reg.TipoCuenta   = this.txtTipoCuenta.Text;
                reg.MontoMinimo  = Convert.ToDecimal(this.txtMontoMinimo.Text);
                reg.TasaInteres  = Convert.ToDecimal(this.txtTasaInteres.Text);
                reg.PlazoForsozo = Convert.ToInt32(this.txtPlazoForsozo.Text);
                reg.Activo       = true;
                reg.NoUsuario    = this.NoUsuario;

                _db.CatCuentas.InsertOnSubmit(reg);
                _db.SubmitChanges();



                CancelaAccion();
                Carga_Grid();
            }

            if (acc == Accion.Modificando)
            {
                try
                {
                    var reg = new CatCuentas();
                    var _db = new dbCAJA();

                    DataGridViewRow row     = this.dataGridView2.Rows[bindingSource1.Position];
                    var             _IdCta  = Convert.ToInt32(row.Cells["IdCta"].Value.ToString());
                    var             _Activo = this.checkActivo.Checked;

                    CatCuentas result = (from u in _db.CatCuentas
                                         where u.IdCta == _IdCta
                                         select u).Single();

                    result.IdCta        = _IdCta;
                    result.TipoCuenta   = this.txtTipoCuenta.Text;
                    result.TasaInteres  = Convert.ToDecimal(this.txtTasaInteres.Text);
                    result.PlazoForsozo = Convert.ToInt32(this.txtPlazoForsozo.Text);
                    result.MontoMinimo  = Convert.ToDecimal(this.txtMontoMinimo.Text);

                    _db.CatCuentas.InsertOnSubmit(result);
                    _db.SubmitChanges();


                    CancelaAccion();
                    Carga_Grid();
                }
                catch (Exception ex)
                {
                    throw new Exception(ex.Message, ex);
                }
            }
        }