예제 #1
0
        /// <summary>
        /// Devolver nit
        /// </summary>
        /// <param name="idnit">identificador del nit</param>
        /// <returns>nit respectivo al identificador</returns>
        public maenits DevolverNit(string nit)
        {
            maenits nits = new maenits();

            using (siimnEntities bd = new siimnEntities())
            {
                try
                {
                    var query = bd.maenits.Include("tiponit").Include("ciudad")
                                .Include("ciudad.departamento.pais").Include("ciudad.departamento")
                                .Where(mae => mae.nit == nit);
                    if (query.Count() > 0)
                    {
                        nits = query.First();
                    }
                    else
                    {
                        nits = null;
                    }
                }
                catch (Exception ex)
                {
                    throw ex;
                }
            }

            return(nits);
        }
예제 #2
0
 /// <summary>
 /// Guardar nits
 /// </summary>
 /// <param name="nits">nit a guardar</param>
 public bool GuardarNits(maenits nits)
 {
     using (siimnEntities bd = new siimnEntities())
     {
         try
         {
             maenits nit = new maenits();
             nit.nit         = nits.nit;
             nit.digito      = nits.digito;
             nit.idtiponit   = nits.idtiponit;
             nit.nombrenit   = nits.nombrenit;
             nit.acteconomic = nits.acteconomic;
             nit.idciudad    = nits.idciudad;
             nit.direccion   = nits.direccion;
             nit.telefono    = nits.telefono;
             nit.celular     = nits.celular;
             nit.email       = nits.email;
             bd.maenits.Add(nit);
             bd.SaveChanges();
             return(true);
         }
         catch (Exception ex)
         {
             throw ex;
         }
     }
 }
예제 #3
0
        /// <summary>
        /// Actualizar nit
        /// </summary>
        /// <param name="nit">nit a actualizar</param>
        public bool ActualizarNit(maenits nit)
        {
            bool result = false;

            using (siimnEntities bd = new siimnEntities())
            {
                try
                {
                    var query = bd.maenits.Where(mae => mae.nit == nit.nit);
                    if (query.Count() > 0)
                    {
                        query.First().digito      = nit.digito;
                        query.First().nombrenit   = nit.nombrenit;
                        query.First().acteconomic = nit.acteconomic;
                        query.First().idciudad    = nit.idciudad;
                        query.First().direccion   = nit.direccion;
                        query.First().telefono    = nit.telefono;
                        query.First().celular     = nit.celular;
                        query.First().email       = nit.email;
                        bd.SaveChanges();
                        result = true;
                    }
                    else
                    {
                        result = false;
                    }
                }
                catch (Exception ex)
                {
                    throw ex;
                }
            }

            return(result);
        }
예제 #4
0
        /// <summary>
        /// Actualiza nits.
        /// </summary>
        /// <param name="nits">Nit a actualizar</param>
        public bool ActualizarNits(NitsDataSource nits)
        {
            maenits nit = new maenits();

            nit = this.ConvertirDatatoBd(nits);
            try
            {
                return(this.persistencia.ActualizarNit(nit));
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
예제 #5
0
        private NitsDataSource ConvertirBdtoData(maenits nites)
        {
            NitsDataSource nits = new NitsDataSource();

            nits.Idnit              = nites.idnit;
            nits.Nit                = nites.nit;
            nits.Digito             = nites.digito;
            nits.Tiponit            = nites.tiponit.codigtiponit;
            nits.ActividadEconomica = nites.acteconomic;
            nits.Idciudad           = nites.idciudad;
            nits.Nombrenit          = nites.nombrenit;
            nits.Direccion          = nites.direccion;
            nits.Telefono           = nites.telefono;
            nits.Celular            = nites.celular;
            nits.Email              = nites.email;
            return(nits);
        }
예제 #6
0
        private maenits ConvertirDatatoBd(NitsDataSource nits)
        {
            maenits nit = new maenits();

            nit.idnit       = nits.Idnit;
            nit.nit         = nits.Nit;
            nit.digito      = nits.Digito;
            nit.nombrenit   = nits.Nombrenit;
            nit.idtiponit   = this.persistencia.DevolverIdTipo(nits.Tiponit);
            nit.acteconomic = nits.ActividadEconomica;
            nit.idciudad    = nits.Idciudad;
            nit.direccion   = nits.Direccion;
            nit.telefono    = nits.Telefono;
            nit.celular     = nits.Celular;
            nit.email       = nits.Email;
            return(nit);
        }