public static List<cTinhNangNhomNhanVienDO> GetFunctionofGroupList() { List<cTinhNangNhomNhanVienDO> GroupList = new List<cTinhNangNhomNhanVienDO>(); using (DB_HMS_Entities lst = new DB_HMS_Entities()) { var query = from u in lst.tbTINHNANGNHOMNDs select u; foreach (var row in query) { cTinhNangNhomNhanVienDO ds = new cTinhNangNhomNhanVienDO(); ds.MATINHNANG = row.MATINHNANG; ds.MANHOMNHANVIEN = row.MANHOMND; ds.NGAYTAO = (DateTime) row.NGAYTAO; GroupList.Add(ds); } return GroupList; } }
public static List<cTinhNangNhomNhanVienDO> GetListOfFunctionByGroupID(string GroupID) { GroupID = GroupID.ToLower(); List<cTinhNangNhomNhanVienDO> lstFunction = new List<cTinhNangNhomNhanVienDO>(); using (DB_HMS_Entities lst = new DB_HMS_Entities()) { var query = from u in lst.tbTINHNANGNHOMNDs where u.MANHOMND == GroupID select u; foreach (var row in query) { cTinhNangNhomNhanVienDO ds = new cTinhNangNhomNhanVienDO(); ds.MATINHNANG = row.MATINHNANG; ds.MANHOMNHANVIEN = row.MANHOMND; ds.NGAYTAO = (DateTime)row.NGAYTAO; lstFunction.Add(ds); } return lstFunction; } }
private void SaveFunction() { using (DB_HMS_Entities lst = new DB_HMS_Entities()) { for (int i = 0; i < chklstTinhnang.CheckedItems.Count; i++) { cCheckedListBoxItem item = (cCheckedListBoxItem) chklstTinhnang.CheckedItems[i]; if (item != null) { objTinhnang = (cTinhNangDO)item.Tag; objTinhnangNhomnhanvien = new cTinhNangNhomNhanVienDO(); objTinhnangNhomnhanvien.MANHOMNHANVIEN = txtMaNhom.Text.Trim(); objTinhnangNhomnhanvien.MATINHNANG = objTinhnang.MATINHNANG; BUS.cTinhNangNhomNhanVienBUS.InsertFunctionofGroup(objTinhnangNhomnhanvien.MANHOMNHANVIEN, objTinhnangNhomnhanvien.MATINHNANG); } } } }