예제 #1
0
 public List <Usuarios_Tabla> GetUsuarios(ref string error)
 {
     try
     {
         using (workspaceEntities bd = new workspaceEntities())                 // workspaceEntities -> nombre de conexíón a bd
         {
             var query = (from item in bd.Usuarios_Tabla
                          select item).ToList();
             return(query);
         }
     }
     catch (Exception e)
     {
         error = e.Message;
         return(null);
     }
 }
예제 #2
0
        //insert// Códigos de error
        virtual public bool Insertar(ref string error, tEntity item)
        {
            error = string.Empty;

            try
            {
                using (workspaceEntities ctx = new workspaceEntities())
                {
                    ctx.Entry(item).State = EntityState.Added;
                    ctx.SaveChanges();

                    return(true);
                }
            }
            catch (Exception e)
            {
                error = e.Message;

                return(false);
            }
        }
예제 #3
0
        public static bool Truncate(ref string error, string nombreTabla)
        {
            error = string.Empty;

            try
            {
                using (workspaceEntities ctx = new workspaceEntities())
                {
                    ctx.Database.ExecuteSqlCommand(string.Format("TRUNCATE TABLE {0}", nombreTabla));
                    ctx.SaveChanges();

                    return(true);
                }
            }
            catch (Exception e)
            {
                error = e.Message;

                return(false);
            }
        }
예제 #4
0
        public Usuarios_Tabla ValidarUsuario(ref string error, string cedula)
        {
            try
            {
                Usuarios_Tabla resultado = null;

                using (workspaceEntities bd = new workspaceEntities())                 // workspaceEntities -> nombre de conexíón a bd
                {
                    var query = (from item in bd.Usuarios_Tabla
                                 where item.cedula == cedula
                                 select item);

                    resultado = query.FirstOrDefault <Usuarios_Tabla>();
                }

                return(resultado);
            }
            catch (Exception e)
            {
                error = e.Message;
                return(null);
            }
        }
예제 #5
0
        //select lista
        virtual public List <tEntity> GetAll(ref string error)
        {
            error = string.Empty;
            List <tEntity> emptyCollection = new List <tEntity>();

            try
            {
                List <tEntity> lstResult = new List <tEntity>();

                using (workspaceEntities ctx = new workspaceEntities())
                {
                    lstResult = ctx.Set <tEntity>().Select(item => item).ToList();
                }

                return(lstResult);
            }
            catch (Exception e)
            {
                error = e.Message;

                return(emptyCollection);
            }
        }
예제 #6
0
        // actualizar
        virtual public bool Actualizar(ref string error, tEntity item)
        {
            int result = -1;

            error = string.Empty;

            try
            {
                using (workspaceEntities ctx = new workspaceEntities())
                {
                    // puede insertar registros relacionados (no actualizarlos)
                    ctx.Entry(item).State = EntityState.Modified;
                    result = ctx.SaveChanges();

                    return(true);
                }
            }
            catch (Exception e)
            {
                error = e.Message;

                return(false);
            }
        }