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 object loadCategoryReturn(CategoryEntitiesTable table)
{
var listItem = (object)null;
using (var context = new QL_HOIVIEN_KTEntities())
{
switch (table)
{
case CategoryEntitiesTable.DM_NHA_TAI_TRO:
listItem = (from p in context.DM_NHA_TAI_TRO select p).ToList();
break;
default:
break;
}
}
return(listItem);
}
public static void loadCategoryByName(CategoryEntitiesTable table, LookUpEdit lue, Boolean itemIndexFirst = true)
{
using (var context = new QL_HOIVIEN_KTEntities())
{
var listItem = (object)null;
switch (table)
{
case CategoryEntitiesTable.DM_GIOITINH:
listItem = loadDMGioiTinh();
break;
case CategoryEntitiesTable.DM_NGHE_NGHIEP:
listItem = (from p in context.DM_NGHE_NGHIEP orderby p.NN_STT select p).ToList();
break;
case CategoryEntitiesTable.DM_TINH:
listItem = (from p in context.DM_TINH orderby p.TINH_STT select p).ToList();
break;
case CategoryEntitiesTable.DM_DANTOC:
listItem = (from p in context.DM_DANTOC orderby p.DT_STT select p).ToList();
break;
case CategoryEntitiesTable.DM_TONGIAO:
listItem = (from p in context.DM_TONGIAO orderby p.TG_STT select p).ToList();
break;
case CategoryEntitiesTable.DM_CHUCVU_HOI:
listItem = (from p in context.DM_CHUCVU_HOI orderby p.CV_STT select p).ToList();
break;
case CategoryEntitiesTable.DM_TRINH_DO_CHUYEN_MON:
listItem = (from p in context.DM_TRINH_DO_CHUYEN_MON orderby p.CM_STT select p).ToList();
break;
case CategoryEntitiesTable.DM_TRINH_DO_HOC_VAN:
listItem = (from p in context.DM_TRINH_DO_HOC_VAN orderby p.HV_STT select p).ToList();
break;
case CategoryEntitiesTable.DM_KHUYETTAT_MUCDO:
listItem = (from p in context.DM_KHUYETTAT_MUCDO orderby p.MDKT_STT select p).ToList();
break;
case CategoryEntitiesTable.DM_KHUYETTAT_NGUYENNHAN:
listItem = (from p in context.DM_KHUYETTAT_NGUYENNHAN orderby p.NNKT_STT select p).ToList();
break;
case CategoryEntitiesTable.DM_KHUYETTAT_TINHTRANG:
listItem = (from p in context.DM_KHUYETTAT_TINHTRANG orderby p.TTKT_STT select p).ToList();
break;
case CategoryEntitiesTable.DM_PHUONGTIEN_DILAI:
listItem = (from p in context.DM_PHUONGTIEN_DILAI orderby p.PT_STT select p).ToList();
break;
case CategoryEntitiesTable.DM_TINHTRANG_HONNHAN:
listItem = (from p in context.DM_TINHTRANG_HONNHAN orderby p.TTHN_STT select p).ToList();
break;
case CategoryEntitiesTable.DM_DUNGCU_HOTRO:
listItem = (from p in context.DM_DUNGCU_HOTRO orderby p.DCHT_STT select p).ToList();
break;
case CategoryEntitiesTable.DM_NOI_SINH_SONG:
listItem = (from p in context.DM_NOI_SINH_SONG orderby p.NSS_STT select p).ToList();
break;
case CategoryEntitiesTable.DM_NGOAINGU:
listItem = (from p in context.DM_NGOAINGU orderby p.NN_STT select p).ToList();
break;
case CategoryEntitiesTable.DM_NHA_TAI_TRO_LOAI:
listItem = (from p in context.DM_NHA_TAI_TRO_LOAI orderby p.LOAI_NTT_STT select p).ToList();
break;
case CategoryEntitiesTable.DM_NHA_TAI_TRO:
listItem = (from p in context.DM_NHA_TAI_TRO select p).ToList();
break;
case CategoryEntitiesTable.DM_DONVI_PHUTRACH:
listItem = (from p in context.DM_DONVI_PHUTRACH orderby p.DV_STT select p).ToList();
break;
case CategoryEntitiesTable.DM_LOAI_HOATDONG:
listItem = (from p in context.DM_LOAI_HOATDONG orderby p.LOAIHD_STT select p).ToList();
break;
case CategoryEntitiesTable.DM_TCXH_HANG_THANG:
listItem = loadDMTCXH();
break;
case CategoryEntitiesTable.DM_DOITUONG:
listItem = loadDMDoiTuong();
break;
case CategoryEntitiesTable.DM_DOITUONG2:
listItem = loadDMDoiTuong2();
break;
default:
break;
}
if (listItem == null)
{
return;
}
lue.Properties.DataSource = listItem;
if (itemIndexFirst)
{
lue.ItemIndex = 0;
}
}
}
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;
}
}
}
