public List <SP_GetAllMaterialAccordingToCategoreyIIDResult> GetAllMaterialAccordingToCategoryIID(Int64 categoryIID) { try { OiiOHaatDCDataContext dbContext = DatabaseHelper.GetDataModelDataContext(); var listdata = dbContext.SP_GetAllMaterialAccordingToCategoreyIID(categoryIID).ToList(); return(listdata); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }