private void btnDel_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { int SelectedRow = gridItemDetail.FocusedRowHandle; if (SelectedRow >= 0) { DataRow drow = gridItemDetail.GetDataRow(SelectedRow); string _value = drow["DegreeCode"].ToString(); if (Class.App.ConfirmDeletion() == DialogResult.No) { return; } Class.DanhMuc_BangCap dmbc = new Class.DanhMuc_BangCap(); dmbc.DegreeCode = _value; if (dmbc.Delete()) { Class.App.DeleteSuccessfully(); Loadbangcap(); } else { Class.App.DeleteNotSuccessfully(); } } }
private void Update_BangCap() { Class.DanhMuc_BangCap dm = new Class.DanhMuc_BangCap(); dm.DegreeCode = txtCode.Text; dm.DegreeName = txtName.Text; dm.Description = txtDescription.Text; dm.Active = checkActive.Checked; if (txtCode.Enabled == true) { if (dm.Insert()) { Class.App.SaveSuccessfully(); } else { Class.App.SaveNotSuccessfully(); } } else { if (dm.Update()) { Class.App.SaveSuccessfully(); } else { Class.App.SaveNotSuccessfully(); } } if (_reCallFunction == "frmDanhmuc_Bangcap") { (this.Owner as frmDanhmuc_Bangcap).Loadbangcap(); } }
public void Loadbangcap() { Class.DanhMuc_BangCap dmbc = new Class.DanhMuc_BangCap(); gridItem.DataSource = dmbc.Loadbangcap(); }
private void call_info(string Form_Name, string code) { switch (Form_Name) { case "TH": Class.DanhMuc_TinHoc dmth = new Class.DanhMuc_TinHoc(); DataTable dtth = dmth.GetInformaticByCode(code); txtCode.Text = dtth.Rows[0]["InformaticCode"].ToString(); txtName.Text = dtth.Rows[0]["InformaticName"].ToString(); txtDescription.Text = dtth.Rows[0]["Description"].ToString(); checkActive.Checked = (bool)dtth.Rows[0]["Active"]; break; case "NN": Class.DanhMuc_NgoaiNgu dmnn = new Class.DanhMuc_NgoaiNgu(); DataTable dtnn = dmnn.GetLanguageByCode(code); txtCode.Text = dtnn.Rows[0]["LanguageCode"].ToString(); txtName.Text = dtnn.Rows[0]["LanguageName"].ToString(); txtDescription.Text = dtnn.Rows[0]["Description"].ToString(); checkActive.Checked = (bool)dtnn.Rows[0]["Active"]; break; case "KN": Class.DanhMuc_KyNang dmkn = new Class.DanhMuc_KyNang(); DataTable dtkn = dmkn.GetSkillByCode(code); txtCode.Text = dtkn.Rows[0]["SkillCode"].ToString(); txtName.Text = dtkn.Rows[0]["SkillName"].ToString(); txtDescription.Text = dtkn.Rows[0]["Description"].ToString(); checkActive.Checked = (bool)dtkn.Rows[0]["Active"]; break; case "TT": Class.CT_Provice dmtt = new Class.CT_Provice(); DataTable dttt = dmtt.GetProvinceByCode(code); txtCode.Text = dttt.Rows[0]["ProvinceCode"].ToString(); txtName.Text = dttt.Rows[0]["ProvinceName"].ToString(); txtDescription.Text = dttt.Rows[0]["Description"].ToString(); checkActive.Checked = (bool)dttt.Rows[0]["Active"]; break; case "HV": Class.Danhmuc_Hocvan dmhv = new Class.Danhmuc_Hocvan(); DataTable dthv = dmhv.GetEducationByCode(code); txtCode.Text = dthv.Rows[0]["EducationCode"].ToString(); txtName.Text = dthv.Rows[0]["EducationName"].ToString(); txtDescription.Text = dthv.Rows[0]["Description"].ToString(); checkActive.Checked = (bool)dthv.Rows[0]["Active"]; break; case "BC": Class.DanhMuc_BangCap dmbc = new Class.DanhMuc_BangCap(); DataTable dtbc = dmbc.GetDegreeByCode(code); txtCode.Text = dtbc.Rows[0]["DegreeCode"].ToString(); txtName.Text = dtbc.Rows[0]["DegreeName"].ToString(); txtDescription.Text = dtbc.Rows[0]["Description"].ToString(); checkActive.Checked = (bool)dtbc.Rows[0]["Active"]; break; case "CV": Class.Danhmuc_Chucvu dmcv = new Class.Danhmuc_Chucvu(); DataTable dtcv = dmcv.GetPositionByCode(code); txtCode.Text = dtcv.Rows[0]["PositionCode"].ToString(); txtName.Text = dtcv.Rows[0]["PositionName"].ToString(); txtDescription.Text = dtcv.Rows[0]["Description"].ToString(); checkActive.Checked = (bool)dtcv.Rows[0]["Active"]; break; case "CM": Class.DanhMuc_ChuyenMon dmcm = new Class.DanhMuc_ChuyenMon(); DataTable dtcm = dmcm.GetProfessionalByCode(code); txtCode.Text = dtcm.Rows[0]["ProfessionalCode"].ToString(); txtName.Text = dtcm.Rows[0]["ProfessionalName"].ToString(); txtDescription.Text = dtcm.Rows[0]["Description"].ToString(); checkActive.Checked = (bool)dtcm.Rows[0]["Active"]; break; case "QG": Class.DanhMuc_QuocGia dmqg = new Class.DanhMuc_QuocGia(); DataTable dtqg = dmqg.GetNationalityByCode(code); txtCode.Text = dtqg.Rows[0]["NationalityCode"].ToString(); txtName.Text = dtqg.Rows[0]["NationalityName"].ToString(); txtDescription.Text = dtqg.Rows[0]["Description"].ToString(); checkActive.Checked = (bool)dtqg.Rows[0]["Active"]; break; case "DT": Class.DanhMuc_DanToc dmdt = new Class.DanhMuc_DanToc(); DataTable dtdt = dmdt.GetEthnicByCode(code); txtCode.Text = dtdt.Rows[0]["EthnicCode"].ToString(); txtName.Text = dtdt.Rows[0]["EthnicName"].ToString(); txtDescription.Text = dtdt.Rows[0]["Description"].ToString(); checkActive.Checked = (bool)dtdt.Rows[0]["Active"]; break; case "TG": Class.DanhMuc_TonGiao dmtg = new Class.DanhMuc_TonGiao(); DataTable dttg = dmtg.GetReligionByCode(code); txtCode.Text = dttg.Rows[0]["ReligionCode"].ToString(); txtDescription.Text = dttg.Rows[0]["ReligionName"].ToString(); txtName.Text = dttg.Rows[0]["Description"].ToString(); checkActive.Checked = (bool)dttg.Rows[0]["Active"]; break; case "QHGD": Class.DanhMuc_GiaDinh dmgd = new Class.DanhMuc_GiaDinh(); DataTable dtgd = dmgd.GetRelativeByCode(code); txtCode.Text = dtgd.Rows[0]["RelativeCode"].ToString(); txtDescription.Text = dtgd.Rows[0]["RelativeName"].ToString(); txtName.Text = dtgd.Rows[0]["Description"].ToString(); checkActive.Checked = (bool)dtgd.Rows[0]["Active"]; break; } }