Exemplo n.º 1
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.entradaTableAdapter ta = new dsGimnasioTableAdapters.entradaTableAdapter();
                ta.remove(id);

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

            return(exito);
        }
Exemplo n.º 2
0
        public override bool changeState(int newState, int id)
        {
            clear();
            bool exito = false;

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

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

            return(exito);
        }
Exemplo n.º 3
0
        public override bool add()
        {
            clear();
            bool exito = false;

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

                int?idEntrada = 0;   //utilizada pa ultimo id insertado de entrada
                //dar de alta entradas
                try
                {
                    foreach (clsDetalleEntrada de in lDetalleEmtrada)
                    {
                        dsGimnasioTableAdapters.QueriesTableAdapter query = new dsGimnasioTableAdapters.QueriesTableAdapter();
                        idEntrada = query.getLastIdEntrada();

                        de.idEntrada = idEntrada.Value;
                        de.add();
                    }
                }
                catch (Exception ex)
                {
                    this.changeState(3, idEntrada.Value);    //se elimina la ultima entrada
                    error.Add(ex.Message);
                }

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

            return(exito);
        }
Exemplo n.º 4
0
        public override bool getDatos(int id)
        {
            clear();
            bool exito = false;

            try
            {
                dsGimnasioTableAdapters.entradaTableAdapter ta = new dsGimnasioTableAdapters.entradaTableAdapter();
                dsGimnasio.entradaDataTable dt = ta.GetDataById(id);

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

            return(exito);
        }
Exemplo n.º 5
0
        public override bool getDatos(int id)
        {
            clear();
            bool exito = false;
            try
            {
                dsGimnasioTableAdapters.entradaTableAdapter ta = new dsGimnasioTableAdapters.entradaTableAdapter();
                dsGimnasio.entradaDataTable dt = ta.GetDataById(id);

                if (dt.Rows.Count > 0)
                {
                    datos = (dsGimnasio.entradaRow)dt.Rows[0];
                    exito = true;
                }


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

            return exito;
        }
Exemplo n.º 6
0
        public override bool add()
        {
              clear();
                bool exito = false;
                try
                {
                    dsGimnasioTableAdapters.entradaTableAdapter ta = new dsGimnasioTableAdapters.entradaTableAdapter();
                    ta.add(idUsuarioLog,Total);

                    int? idEntrada=0;//utilizada pa ultimo id insertado de entrada
                    //dar de alta entradas
                    try
                    {
                        foreach (clsDetalleEntrada de in lDetalleEmtrada)
                        {
                            dsGimnasioTableAdapters.QueriesTableAdapter query = new dsGimnasioTableAdapters.QueriesTableAdapter();
                           idEntrada = query.getLastIdEntrada();

                            de.idEntrada = idEntrada.Value;
                            de.add();
                        }
                    }
                    catch (Exception ex)
                    {
                        this.changeState(3, idEntrada.Value);//se elimina la ultima entrada
                        error.Add(ex.Message);
                    }

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

                return exito;
        }
Exemplo n.º 7
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.entradaTableAdapter ta = new dsGimnasioTableAdapters.entradaTableAdapter();
                ta.remove(id);

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

            return exito;
        }
Exemplo n.º 8
0
        public override bool changeState(int newState, int id)
        {
            clear();
            bool exito = false;
            try
            {
                dsGimnasioTableAdapters.entradaTableAdapter ta = new dsGimnasioTableAdapters.entradaTableAdapter();
                ta.cambiaEstado(newState, id);

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

            return exito;
        }