public static void Ex_SetDataSource(this CheckedComboBoxEdit chkList, string table)
{
chkList.Properties.SeparatorChar = clsParameter.separatorChar;
using (var context = new Models.QL_HOIVIEN_KTEntities())
{
chkList.Properties.Items.Clear();
CategoryEntitiesTable tableEnum = table.Ex_ToEnum <CategoryEntitiesTable>();
switch (tableEnum)
{
case CategoryEntitiesTable.DM_KHUYETTAT_TINHTRANG:
var listItem = (from p in context.DM_KHUYETTAT_TINHTRANG orderby p.TTKT_STT select p).ToArray();
foreach (DM_KHUYETTAT_TINHTRANG item in listItem)
{
chkList.Properties.Items.Add(item.TTKT_TEN, item.TTKT_TEN);
}
break;
case CategoryEntitiesTable.DM_NHA_TAI_TRO:
var listItem2 = (from p in context.DM_NHA_TAI_TRO select p).ToArray();
foreach (DM_NHA_TAI_TRO item in listItem2)
{
chkList.Properties.Items.Add(item.NTT_TEN, item.NTT_TEN);
}
break;
default:
break;
}
}
}
public static void Ex_SetDataSource(this RepositoryItemLookUpEdit repLue, string table)
{
using (var context = new Models.QL_HOIVIEN_KTEntities())
{
CategoryEntitiesTable tableEnum = table.Ex_ToEnum <CategoryEntitiesTable>();
switch (tableEnum)
{
case CategoryEntitiesTable.DM_THANHVIEN_HOI:
var listItem = (from p in context.DM_THANHVIEN_HOI select p).ToList();
repLue.DataSource = listItem;
break;
default:
break;
}
}
}
public static void Ex_SetDataSource(this CheckedListBoxControl chkList, string table)
{
chkList.Items.Clear();
using (var context = new Models.QL_HOIVIEN_KTEntities())
{
CategoryEntitiesTable tableEnum = table.Ex_ToEnum <CategoryEntitiesTable>();
switch (tableEnum)
{
case CategoryEntitiesTable.DM_NOI_O_NHA:
var listItem = (from p in context.DM_NOI_O_NHA orderby p.NO_NHA_STT select p).ToArray();
foreach (DM_NOI_O_NHA item in listItem)
{
chkList.Items.Add(item.NO_NHA_TEN, item.NO_NHA_TEN);
}
break;
case CategoryEntitiesTable.DM_NOI_O_SONG_VOI:
var listItem2 = (from p in context.DM_NOI_O_SONG_VOI orderby p.NOSV_STT select p).ToArray();
foreach (DM_NOI_O_SONG_VOI item in listItem2)
{
chkList.Items.Add(item.NOSV_TEN, item.NOSV_TEN);
}
break;
case CategoryEntitiesTable.DM_CHAMSOC_BANTHAN:
var listItem3 = (from p in context.DM_CHAMSOC_BANTHAN orderby p.CSBT_STT select p).ToArray();
foreach (DM_CHAMSOC_BANTHAN item in listItem3)
{
chkList.Items.Add(item.CSBT_TEN, item.CSBT_TEN);
}
break;
case CategoryEntitiesTable.DM_NHUCAU:
var listItem4 = (from p in context.DM_NHUCAU orderby p.NC_STT select p).ToArray();
foreach (DM_NHUCAU item in listItem4)
{
chkList.Items.Add(item.NC_TEN, item.NC_TEN);
}
break;
case CategoryEntitiesTable.DM_THANHVIEN_HOI:
var listItem5 = (from p in context.DM_THANHVIEN_HOI orderby p.TVH_STT select p).ToArray();
foreach (DM_THANHVIEN_HOI item in listItem5)
{
chkList.Items.Add(item.TVH_TEN, item.TVH_TEN);
}
break;
case CategoryEntitiesTable.DM_NHA_TAI_TRO_LOAI:
var listItem6 = (from p in context.DM_NHA_TAI_TRO_LOAI orderby p.LOAI_NTT_STT select p).ToArray();
foreach (DM_NHA_TAI_TRO_LOAI item in listItem6)
{
chkList.Items.Add(item.LOAI_NTT_TEN, item.LOAI_NTT_TEN);
}
break;
default:
break;
}
}
}
