/// <summary>
        /// Hasan Add 2015.03.16 For Getting AllAds 10 rows data into listview in Everytime
        /// </summary>
        /// <param name="categoryIID"></param>
        /// <param name="startRow"></param>
        /// <returns></returns>
        public List <SP_GetSortedMaterialAccordingToCategoreyIIDResult> GetSortedMaterialAccordingToCategoreyIIDnRowNumber(Int64 categoryID, int startRowIndex, int maxRowNumber)
        {
            try
            {
                OiiOHaatDCDataContext dbContext = DatabaseHelper.GetDataModelDataContext();
                var listdata = dbContext.SP_GetSortedMaterialAccordingToCategoreyIID(categoryID, startRowIndex, maxRowNumber).ToList();
                return(listdata);
            }

            catch (Exception ex)
            {
                throw new Exception(ex.Message, ex);
            }
        }