public List <SpGetAllMaterialForCategoreyResult> GetAllMaterialForCategory(string catagoryName) { try { OiiOHaatDCDataContext dbContext = DatabaseHelper.GetDataModelDataContext(); var listdata = dbContext.SpGetAllMaterialForCategorey(catagoryName).ToList(); return(listdata); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }