Example #1
0
        public static Modulo GetModuloById(int IdModulo)
        {
            ModuloTableAdapter localAdapter = new ModuloTableAdapter();

            if (IdModulo <= 0)
            {
                return(null);
            }

            Modulo theUser = null;

            try
            {
                ModuloDS.ModuloIdDataTable table = localAdapter.GetModuloById(IdModulo);

                if (table != null && table.Rows.Count > 0)
                {
                    ModuloDS.ModuloIdRow row = table[0];
                    theUser = FillUserRecord(row);
                }
            }
            catch (Exception q)
            {
                log.Error("Un error ocurrio mientras obtenia el modulo de la base de dato", q);
                return(null);
            }

            return(theUser);
        }
Example #2
0
        public static List <Modulo> GetModuloListForSearch(string whereSql)
        {
            if (string.IsNullOrEmpty(whereSql))
            {
                whereSql = "1 = 1";
            }

            List <Modulo>      theList    = new List <Modulo>();
            Modulo             theUser    = null;
            ModuloTableAdapter theAdapter = new ModuloTableAdapter();

            try
            {
                ModuloDS.ModuloIdDataTable table = theAdapter.GetModuloForSearch(whereSql);

                if (table != null && table.Rows.Count > 0)
                {
                    foreach (ModuloDS.ModuloIdRow row in table.Rows)
                    {
                        theUser = FillUserRecord(row);
                        theList.Add(theUser);
                    }
                }
            }
            catch (Exception q)
            {
                log.Error("el error ocurrio mientras obtenia la lista de los usuarios de la base de datos", q);
                return(null);
            }
            return(theList);
        }