Example #1
0
        public override bool add()
        {
            clear();
            bool exito = false;

            try
            {
                dsGimnasioTableAdapters.salidaTableAdapter ta = new dsGimnasioTableAdapters.salidaTableAdapter();
                ta.add(Total, idUsuarioLog);

                //dar de alta salida

                int?idSalida = 0;     //utilizado para ver ultima salida
                try
                {
                    foreach (clsDetalleSalida de in lDetalle)
                    {
                        dsGimnasioTableAdapters.QueriesTableAdapter query = new dsGimnasioTableAdapters.QueriesTableAdapter();
                        idSalida = (int?)query.getLastIdSalida();

                        de.idSalida = idSalida.Value;
                        de.add();

                        //asigna el detalle salida a el detalle entrada
                        int?idDetalleSalida = query.getLastIdDetalleSalida();
                        dsGimnasioTableAdapters.detalleentradaTableAdapter taDE = new dsGimnasioTableAdapters.detalleentradaTableAdapter();
                        taDE.asignaSalida(idDetalleSalida.Value, de.idProducto);
                    }
                }
                catch (Exception ex)
                {
                    this.changeState(3, idSalida.Value);    //se elimina la ultima salida
                    error.Add(ex.Message);
                }

                exito = true;
            }
            catch (Exception ex)
            {
                error.Add(ex.Message);
            }

            return(exito);
        }
Example #2
0
        /// <summary>
        /// elimina utilizando delete
        /// </summary>
        /// <param name="id">id del registro</param>
        /// <returns></returns>
        public bool remove(int id)
        {
            clear();
            bool exito = false;

            try
            {
                dsGimnasioTableAdapters.salidaTableAdapter ta = new dsGimnasioTableAdapters.salidaTableAdapter();
                ta.remove(id);

                exito = true;
            }
            catch (Exception ex)
            {
                error.Add(ex.Message);
            }

            return(exito);
        }
Example #3
0
        public override bool changeState(int newState, int id)
        {
            clear();
            bool exito = false;

            try
            {
                dsGimnasioTableAdapters.salidaTableAdapter ta = new dsGimnasioTableAdapters.salidaTableAdapter();
                ta.cambiaEstado(newState, id);

                exito = true;
            }
            catch (Exception ex)
            {
                error.Add(ex.Message);
            }

            return(exito);
        }
Example #4
0
        public override bool getDatos(int id)
        {
            clear();
            bool exito = false;

            try
            {
                dsGimnasioTableAdapters.salidaTableAdapter ta = new dsGimnasioTableAdapters.salidaTableAdapter();
                dsGimnasio.salidaDataTable dt = ta.GetDataById(id);

                if (dt.Rows.Count > 0)
                {
                    datos = (dsGimnasio.salidaRow)dt.Rows[0];
                    exito = true;
                }
            }
            catch (Exception ex)
            {
                error.Add(ex.Message);
            }

            return(exito);
        }