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

            using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "ls_PayrollDOWS_RBVH_Search", SearchFilterManager.SqlSearchParamNoCompany(SearchKey)))
            {
                while (reader.Read())
                {
                    ls_PayrollDOWS_RBVH obj = new ls_PayrollDOWS_RBVH();
                    obj = GetItemFromReader(reader);
                    collection.Add(obj);
                }
            }
            return(collection);
        }
        public static ls_PayrollDOWS_RBVHCollection GetbyUser(string CreatedUser)
        {
            ls_PayrollDOWS_RBVHCollection collection = new ls_PayrollDOWS_RBVHCollection();
            ls_PayrollDOWS_RBVH           obj;

            using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "ls_PayrollDOWS_RBVH_GetAll_byUser", new SqlParameter("@CreatedUser", CreatedUser)))
            {
                while (reader.Read())
                {
                    obj = GetItemFromReader(reader);
                    collection.Add(obj);
                }
            }
            return(collection);
        }
        public static ls_PayrollDOWS_RBVHCollection GetAllItemByEntity(int EntityID)
        {
            ls_PayrollDOWS_RBVHCollection collection = new ls_PayrollDOWS_RBVHCollection();

            using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "ls_PayrollDOWS_RBVH_GetAll_ByEntity", new SqlParameter("@EntityID", EntityID)))
            {
                while (reader.Read())
                {
                    ls_PayrollDOWS_RBVH obj = new ls_PayrollDOWS_RBVH();
                    obj = GetItemFromReader(reader);
                    collection.Add(obj);
                }
            }
            return(collection);
        }