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