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