Exemplo n.º 1
0
        public static TimeLogCollection GetbyUser(string CreatedUser)
        {
            TimeLogCollection collection = new TimeLogCollection();
            TimeLog           obj;

            using (var reader = SqlHelper.ExecuteReader("TimeLog_GetAll_byUser", new SqlParameter("@CreatedUser", CreatedUser)))
            {
                while (reader.Read())
                {
                    obj = GetItemFromReader(reader);
                    collection.Add(obj);
                }
            }
            return(collection);
        }
Exemplo n.º 2
0
        //public static TimeLogCollection GetAllItem()
        //{
        //    TimeLogCollection collection = new TimeLogCollection();
        //    using (var reader = SqlHelper.ExecuteReader("TimeLog_GetAll", null))
        //    {
        //        while (reader.Read())
        //        {
        //            TimeLog obj = new TimeLog();
        //            obj = GetItemFromReader(reader);
        //            collection.Add(obj);
        //        }
        //    }
        //    return collection;
        //}

        public static TimeLogCollection Search(SearchFilter SearchKey)
        {
            TimeLogCollection collection = new TimeLogCollection();

            using (var reader = SqlHelper.ExecuteReader("TimeLog_Search", SearchFilterManager.SqlSearchParamNoCompany(SearchKey)))
            {
                while (reader.Read())
                {
                    TimeLog obj = new TimeLog();
                    obj = GetItemFromReader(reader);
                    collection.Add(obj);
                }
            }
            return(collection);
        }