public ModelListHiddenObjectIdAndDefaultValue GetListModelConfigAndDefaultValueByTableNameAndCompanyId(string tableName, int companyId, IEDEntities db) { ModelListHiddenObjectIdAndDefaultValue model; List <int> listHiddenObjectId = null; int defaultValue = 0; try { model = new ModelListHiddenObjectIdAndDefaultValue(); var listConfig = (from c in db.SConfigs where !c.IsDeleted && c.TableName == tableName && c.ConpanyId == companyId select new ModelConfig() { Id = c.Id, TableName = c.TableName, ObjectId = c.ObjectId, IsHidden = c.IsHidden, IsDefault = c.IsDefault }); if (listConfig != null) { var objDefault = listConfig.Where(x => x.IsDefault).FirstOrDefault(); listHiddenObjectId = listConfig.Where(x => x.IsHidden).Select(x => x.ObjectId ?? 0).ToList(); defaultValue = objDefault != null ? objDefault.ObjectId ?? 0 : 0; } model.listHiddenObjectId = listHiddenObjectId; model.defaultValue = defaultValue; return(model); } catch (Exception ex) { throw ex; } }
public ModelListSelectItemAndDefaultValue GetModelListSelectItemAndDefaultValueByCompanyId(int companyId) { using (var db = new IEDEntities()) { ModelListHiddenObjectIdAndDefaultValue modelListConfigAndDefault = null; List <ModelSelectItem> ListModelSelectItem = new List <ModelSelectItem>(); try { // khoi tao list selectItem ListModelSelectItem.Add(new ModelSelectItem() { Value = 0, Name = "--- Chọn Nhóm Danh Mục ----" }); // get listHiddenObjectId va default value modelListConfigAndDefault = BLLConfig.Instance.GetListModelConfigAndDefaultValueByTableNameAndCompanyId(eTableName.SCATEGORY, companyId, db); if (modelListConfigAndDefault.listHiddenObjectId != null && modelListConfigAndDefault.listHiddenObjectId.Count > 0) { ListModelSelectItem.AddRange((from x in db.SCategories where !x.IsDeleted && !modelListConfigAndDefault.listHiddenObjectId.Contains(x.Id) select new ModelSelectItem() { Value = x.Id, Name = x.Name })); } else { ListModelSelectItem.AddRange((from x in db.SCategories where !x.IsDeleted select new ModelSelectItem() { Value = x.Id, Name = x.Name })); } return(new ModelListSelectItemAndDefaultValue() { defaultValue = modelListConfigAndDefault.defaultValue, listModelSelectItem = ListModelSelectItem }); } catch (Exception ex) { throw ex; } } }