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);
            }
        }