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