public int CountAllRecentMaterialForCategoryIID(Int64 categoryID) { try { OiiOHaatDCDataContext dbContext = DatabaseHelper.GetDataModelDataContext(); var listdata = dbContext.SP_GetAllRecentMaterialAdsForCategoreyIID(categoryID).ToList(); return(listdata.Count); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }