Ejemplo n.º 1
0
        protected void btnGrabar_Click(object sender, EventArgs e)
        {
            IgvDTO obj = new IgvDTO();

            if (this.txtId.Text == "")
            {
                obj.Igv = Convert.ToDecimal(this.txtIGV.Text);
                obj.Descripcion = this.txtDescripcion.Text;

                if (this.txtFechaInicial.Text != "")
                    obj.FechaInicio = AppUtilidad.stringToDateTime(this.txtFechaInicial.Text,"DD/MM/YYYY");

                if (this.txtFechaFinal.Text != "")
                    obj.FechaFin = AppUtilidad.stringToDateTime(this.txtFechaFinal.Text, "DD/MM/YYYY");

                int id = objIgvDAO.Agregar(obj);

                this.txtId.Text = id.ToString();

                this.panRegistro.Visible = true;
                this.panLista.Visible = false;

                this.btnGrabar.Visible = false;
                this.btnActualizar.Visible = true;
                this.btnEliminar.Visible = true;
                this.btnCancelar.Visible = true;

            }
        }
Ejemplo n.º 2
0
        protected void btnEliminar_Click(object sender, EventArgs e)
        {
            IgvDTO obj = new IgvDTO();

            if (this.txtId.Text != "")
            {
                objIgvDAO.Eliminar(Convert.ToInt32(this.txtId.Text));

                this.txtId.Text = "";
                this.txtIGV.Text = "";
                this.txtDescripcion.Text = "";
                this.txtFechaInicial.Text = "";
                this.txtFechaFinal.Text = "";

            }
            this.panRegistro.Visible = false;
            this.panLista.Visible = true;

            this.btnGrabar.Visible = false;
            this.btnActualizar.Visible = false;
            this.btnEliminar.Visible = false;
            this.btnCancelar.Visible = false;

            Listar();
        }
Ejemplo n.º 3
0
        protected void btnActualizar_Click(object sender, EventArgs e)
        {
            IgvDTO obj = new IgvDTO();

            obj = objIgvDAO.ListarPorClave(Convert.ToInt32(this.txtId.Text));

            obj.Igv = Convert.ToDecimal(this.txtIGV.Text);
            obj.Descripcion = this.txtDescripcion.Text;

            if (this.txtFechaInicial.Text != "")
                obj.FechaInicio = AppUtilidad.stringToDateTime(this.txtFechaInicial.Text, "DD/MM/YYYY");

            if (this.txtFechaFinal.Text != "")
                obj.FechaFin = AppUtilidad.stringToDateTime(this.txtFechaFinal.Text, "DD/MM/YYYY");

            objIgvDAO.Actualizar(obj);
        }
Ejemplo n.º 4
0
        public void Actualizar(IgvDTO obj)
        {
            Database db = DatabaseFactory.CreateDatabase("ApplicationConnectionString");
              DbCommand dbCommand = db.GetStoredProcCommand(C_ACTUALIZAR);
              db.AddInParameter(dbCommand, "@id_registro", DbType.Int32, obj.IdRegistro);
              db.AddInParameter(dbCommand, "@igv", DbType.Decimal, obj.Igv);
              db.AddInParameter(dbCommand, "@descripcion", DbType.String, obj.Descripcion);

              if (obj.FechaInicio.Year == 1)
              db.AddInParameter(dbCommand, "@fecha_inicio", DbType.DateTime, null);
              else
              db.AddInParameter(dbCommand, "@fecha_inicio", DbType.DateTime, obj.FechaInicio);

              if (obj.FechaFin.Year == 1)
              db.AddInParameter(dbCommand, "@fecha_fin", DbType.DateTime, null);
              else
              db.AddInParameter(dbCommand, "@fecha_fin", DbType.DateTime, obj.FechaFin);

              db.ExecuteNonQuery(dbCommand);
        }
Ejemplo n.º 5
0
        public int Agregar(IgvDTO obj)
        {
            Database db = DatabaseFactory.CreateDatabase("ApplicationConnectionString");
              DbCommand dbCommand = db.GetStoredProcCommand(C_AGREGAR);
              db.AddInParameter(dbCommand, "@igv", DbType.Decimal, obj.Igv);
              db.AddInParameter(dbCommand, "@descripcion", DbType.String, obj.Descripcion);

              if (obj.FechaInicio.Year == 1)
              db.AddInParameter(dbCommand, "@fecha_inicio", DbType.DateTime, null);
              else
              db.AddInParameter(dbCommand, "@fecha_inicio", DbType.DateTime, obj.FechaInicio);

              if (obj.FechaFin.Year == 1)
              db.AddInParameter(dbCommand, "@fecha_fin", DbType.DateTime, null);
              else
              db.AddInParameter(dbCommand, "@fecha_fin", DbType.DateTime, obj.FechaFin);

              int id = Convert.ToInt32(db.ExecuteScalar(dbCommand));

              return id;
        }
Ejemplo n.º 6
0
        protected void gvLista_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            if (e.CommandName == "Seleccionar")
            {

                IgvDTO obj = new IgvDTO();

                try
                {

                    int Id = int.Parse(e.CommandArgument.ToString());

                    this.txtId.Text = Id.ToString();
                    obj = objIgvDAO.ListarPorClave(Convert.ToInt32(this.txtId.Text));

                    this.txtIGV.Text = obj.Igv.ToString();
                    this.txtDescripcion.Text = obj.Descripcion;

                    if (obj.FechaInicio.Year == 1)
                        this.txtFechaInicial.Text = "";
                    else
                        this.txtFechaInicial.Text = obj.FechaInicio.ToString("dd/MM/yyyy");

                    if (obj.FechaFin.Year == 1)
                        this.txtFechaFinal.Text = "";
                    else
                        this.txtFechaFinal.Text = obj.FechaInicio.ToString("dd/MM/yyyy");

                    this.panRegistro.Visible = true;
                    this.panLista.Visible = false;

                    this.btnGrabar.Visible = false;
                    this.btnActualizar.Visible = true;
                    this.btnEliminar.Visible = true;
                    this.btnCancelar.Visible = true;

                }
                catch (Exception err)
                {
                    // this.lblMensaje.Text = err.Message.ToString();
                }

            }
        }
Ejemplo n.º 7
0
        public List<IgvDTO> Listar()
        {
            List<IgvDTO> Lista = new List<IgvDTO>();
              Database db = DatabaseFactory.CreateDatabase("ApplicationConnectionString");
              DbCommand dbCommand = db.GetStoredProcCommand(C_LISTAR);
              using (IDataReader dr = db.ExecuteReader(dbCommand))
              {
              while (dr.Read())
              {
                  IgvDTO obj = new IgvDTO();
                  if (dr["id_registro"] != System.DBNull.Value)
                      obj.IdRegistro = (int)dr["id_registro"];
                  if (dr["igv"] != System.DBNull.Value)
                      obj.Igv = (Decimal)dr["igv"];
                  if (dr["descripcion"] != System.DBNull.Value)
                      obj.Descripcion = (string)dr["descripcion"];
                  if (dr["fecha_inicio"] != System.DBNull.Value)
                      obj.FechaInicio = (DateTime)dr["fecha_inicio"];
                  if (dr["fecha_fin"] != System.DBNull.Value)
                      obj.FechaFin = (DateTime)dr["fecha_fin"];

                  Lista.Add(obj);
              }
              }
              return Lista;
        }
Ejemplo n.º 8
0
        public IgvDTO ListarPorClave(int IdRegistro)
        {
            IgvDTO obj = null;
              Database db = DatabaseFactory.CreateDatabase("ApplicationConnectionString");
              DbCommand dbCommand = db.GetStoredProcCommand(C_LISTAR_POR_CLAVE);
              db.AddInParameter(dbCommand, "@id_registro", DbType.Int32, IdRegistro);

              using (IDataReader dr = db.ExecuteReader(dbCommand))
              {
              if (dr.Read())
              {
                  obj = new IgvDTO();
                  if (dr["id_registro"] != System.DBNull.Value)
                      obj.IdRegistro = (int)dr["id_registro"];
                  if (dr["igv"] != System.DBNull.Value)
                      obj.Igv = (Decimal)dr["igv"];
                  if (dr["descripcion"] != System.DBNull.Value)
                      obj.Descripcion = (string)dr["descripcion"];
                  if (dr["fecha_inicio"] != System.DBNull.Value)
                      obj.FechaInicio = (DateTime)dr["fecha_inicio"];
                  if (dr["fecha_fin"] != System.DBNull.Value)
                      obj.FechaFin = (DateTime)dr["fecha_fin"];

              }
              }
              return obj;
        }
Ejemplo n.º 9
0
        public IgvDTO ListarIGVVigente(DateTime dtmFecha)
        {
            IgvDTO obj = null;
              Database db = DatabaseFactory.CreateDatabase("ApplicationConnectionString");
              DbCommand dbCommand = db.GetSqlStringCommand(C_LISTAR_IGV_VIGENTE_FECHA);
              string strFecha = dtmFecha.ToShortTimeString();
              db.AddInParameter(dbCommand, "@fecha", DbType.DateTime, dtmFecha);
              using (IDataReader dr = db.ExecuteReader(dbCommand))
              {
              while (dr.Read())
              {
                  obj = new IgvDTO();
                  obj.Igv = (decimal)dr["igv"];

              }
              }

              return obj;
        }
Ejemplo n.º 10
0
        public IgvDTO ListarIGVVigente()
        {
            IgvDTO obj = null;
              Database db = DatabaseFactory.CreateDatabase("ApplicationConnectionString");
              DbCommand dbCommand = db.GetSqlStringCommand(C_LISTAR_IGV_VIGENTE);
              using (IDataReader dr = db.ExecuteReader(dbCommand))
              {
              while (dr.Read())
              {
                  obj = new IgvDTO();
                  obj.Igv = (decimal)dr["igv"];

              }
              }

              return obj;
        }