//get chuyen de duoc mo public List <CHUYENDE> ChuyenDeMo(string maN) { List <CHUYENDE> chuyendes = new List <CHUYENDE>(); string query = "select * from CHUYENDE cd where cd.MaNganh = @maN and cd.MaChuyenDe in ( " + "select ttm.MaChuyenDe from THONGTINMOCHUYENDE ttm where ttm.TrangThai = 1 )"; object[] para = new object[] { maN }; DataTable data = DataProvider.Instance.ExecuteQuery(query, para); foreach (DataRow item in data.Rows) { string MaCD = item["MaChuyenDe"].ToString(); string TenCD = item["TenChuyenDe"].ToString(); int SoSVMax = (int)item["SoSinhVienToiDa"]; string MaN = item["MaNganh"].ToString(); CHUYENDE CD = new CHUYENDE(MaCD, TenCD, SoSVMax, MaN); chuyendes.Add(CD); } return(chuyendes); }
private void frmSuaChuyenDe_Load(object sender, EventArgs e) { foreach (var item in NganhBUS.Instance.GetAll()) { cmbNganh.Items.Add(new Item(item.tenNganh, item.maNganh)); } CHUYENDE cd = ChuyenDeBUS.Instance.GetByID(_maCD); // string maNganh = int vitri = int.Parse(cd.maNganh.Substring(1, 1)); cmbNganh.SelectedIndex = vitri - 1; txtTenChuyenDe.Text = cd.tenCDe; txtSVToiDa.Text = cd.soSV.ToString(); }
public bool Update(string maCD, CHUYENDE cd) { string query = "Update CHUYENDE SET TenChuyenDe = @tecd , SoSinhVienToiDa = @svMAX , MaNganh = @maN WHERE MaChuyenDe = @maCD "; object[] para = new object[] { cd.tenCDe, cd.soSV, cd.maNganh, maCD }; if (DataProvider.Instance.ExecuteNonQuery(query, para) > 0) { return(true); } return(false); }
public bool Insert(CHUYENDE cd) { string query = "Insert into CHUYENDE(MaChuyenDe, TenChuyenDe, SoSinhVienToiDa, MaNganh) values( @maCD , @tenCD , @svMAX , @maN )"; object[] para = new object[] { cd.maCDe, cd.tenCDe, cd.soSV, cd.maNganh }; if (DataProvider.Instance.ExecuteNonQuery(query, para) > 0) { return(true); } return(false); }
public List <CHUYENDE> GetAll() { List <CHUYENDE> chuyendes = new List <CHUYENDE>(); string query = "select * from CHUYENDE"; DataTable data = DataProvider.Instance.ExecuteQuery(query); foreach (DataRow item in data.Rows) { string MaCD = item["MaChuyenDe"].ToString(); string TenCD = item["TenChuyenDe"].ToString(); int SoSVMax = (int)item["SoSinhVienToiDa"]; string MaN = item["MaNganh"].ToString(); CHUYENDE CD = new CHUYENDE(MaCD, TenCD, SoSVMax, MaN); chuyendes.Add(CD); } return(chuyendes); }
public CHUYENDE GetByID(string id) { string query = "SELECT * FROM CHUYENDE WHERE MaChuyenDe = @maCD "; object[] para = new object[] { id }; DataTable data = DataProvider.Instance.ExecuteQuery(query, para); DataRow item = data.Rows[0]; string MaCD = item["MaChuyenDe"].ToString(); string TenCD = item["TenChuyenDe"].ToString(); int SoSVMax = (int)item["SoSinhVienToiDa"]; string MaN = item["MaNganh"].ToString(); CHUYENDE CD = new CHUYENDE(MaCD, TenCD, SoSVMax, MaN); return(CD); }
private void btnCapNhat_Click(object sender, EventArgs e) { string tenCD = txtTenChuyenDe.Text; int soSVMAX = int.Parse(txtSVToiDa.Text); Item nganh = (Item)cmbNganh.SelectedItem; string maNganh = nganh.Value.Trim(); string maCD = _maCD; CHUYENDE cd = new CHUYENDE(maCD, tenCD, soSVMAX, maNganh); if (ChuyenDeBUS.Instance.Update(maCD, cd)) { MessageBox.Show("Cập nhật chuyên đề thành công"); } else { MessageBox.Show("Cập nhật chuyên đề không thành công"); } }
private void btnTaoChuyenDe_Click(object sender, EventArgs e) { string tenCD = txtTenChuyenDe.Text; int soSVMAX = int.Parse(txtSVToiDa.Text); Item nganh = (Item)cmbNganh.SelectedItem; string maNganh = nganh.Value.Trim(); string maCD = ChuyenDeBUS.Instance.CreateMaCD(); MessageBox.Show(tenCD + "\n" + soSVMAX + "\n" + maNganh + "\n" + maCD); CHUYENDE cd = new CHUYENDE(maCD, tenCD, soSVMAX, maNganh); if (ChuyenDeBUS.Instance.Insert(cd)) { MessageBox.Show("Thêm chuyên đề thành công"); } else { MessageBox.Show("Thêm chuyên đề không thành công"); } }
public bool Update(string maCD, CHUYENDE cd) { return(ChuyenDeDAO.Instance.Update(maCD, cd)); }
public bool Insert(CHUYENDE cd) { return(ChuyenDeDAO.Instance.Insert(cd)); }