public NgonNguDTO LayTenNgonNgu(int maNN) { NgonNguDTO nn = null; OleDbConnection connection = DataProvider.CreateConnection(); string cmdText = "Select * from NGONNGU where MaNgonNgu = ?"; OleDbCommand command = new OleDbCommand(cmdText, connection); command.Parameters.Add("@MaNgonNgu", OleDbType.Integer); command.Parameters["@MaNgonNgu"].Value = maNN; OleDbDataReader reader = command.ExecuteReader(); while (reader.Read()) { nn = new NgonNguDTO(); nn.MaNgonNgu = (int)reader["MaNgonNgu"]; nn.TenNgonNgu = (string)reader["TenNgonNgu"]; } reader.Close(); connection.Close(); return(nn); }
public NgonNguDTO LayTenNgonNgu(int maNN) { NgonNguDAO nnDAO = new NgonNguDAO(); NgonNguDTO nnDTO = null; nnDTO = nnDAO.LayTenNgonNgu(maNN); return(nnDTO); }
private void btnCapNhat_Click(object sender, EventArgs e) { NgonNguDTO ngonNgu = new NgonNguDTO(); ngonNgu.MaNgonNgu = ((NgonNguDTO)cmbNgonNgu.SelectedItem).MaNgonNgu; ngonNgu.TenNgonNgu = txtNgonNgu.Text; NgonNguBUS.Modify(ngonNgu); QuanLyNgonNgu_Load(sender, e); }
public static void Insert(NgonNguDTO NgonNgu) { OleDbConnection connection = DataProvider.CreateConnection(); string cmdText = "Insert into NGONNGU(TenNgonNgu) values(?)"; OleDbCommand command = new OleDbCommand(cmdText, connection); command.Parameters.Add("@TenNgonNgu", OleDbType.VarWChar); command.Parameters["@TenNgonNgu"].Value = NgonNgu.TenNgonNgu; command.ExecuteNonQuery(); command.CommandText = "select @@IDENTITY"; NgonNgu.MaNgonNgu = (int)command.ExecuteScalar(); connection.Close(); }
private void btnThem_Click_1(object sender, EventArgs e) { try { if (txtThemTenNgonNgu.Text.Length == 0) { MessageBox.Show("Bạn Chưa Nhập Tên Ngôn Ngữ!", "Cảnh báo!"); } else { NgonNguDTO ngonNgu = new NgonNguDTO(); ngonNgu.TenNgonNgu = txtThemTenNgonNgu.Text; NgonNguBUS.Insert(ngonNgu); MessageBox.Show("Thêm thành công!", "Thông báo!"); this.Close(); } } catch (System.Exception ex) { MessageBox.Show(ex.Message); } }
public static bool Modify(NgonNguDTO ngoNgu) { bool result = false; OleDbConnection connection = DataProvider.CreateConnection(); string cmdText = "Update NGONNGU set TenNgonNgu = ? where MaNgonNgu = ?"; OleDbCommand command = new OleDbCommand(cmdText, connection); command.Parameters.Add("@TenNgonNgu", OleDbType.VarWChar); command.Parameters.Add("@MaNgonNgu", OleDbType.Integer); command.Parameters["@TenNgonNgu"].Value = ngoNgu.TenNgonNgu; command.Parameters["@MaNgonNgu"].Value = ngoNgu.MaNgonNgu; int row = command.ExecuteNonQuery(); if (row > 0) { result = true; } return(result); }
public static IList GetList() { ArrayList arrList = new ArrayList(); NgonNguDTO NgonNgu = null; OleDbConnection connection = DataProvider.CreateConnection(); string cmdText = "Select * from NGONNGU"; OleDbCommand command = new OleDbCommand(cmdText, connection); OleDbDataReader reader = command.ExecuteReader(); while (reader.Read()) { NgonNgu = new NgonNguDTO(); NgonNgu.MaNgonNgu = (int)reader["MaNgonNgu"]; NgonNgu.TenNgonNgu = (string)reader["TenNgonNgu"]; arrList.Add(NgonNgu); } reader.Close(); connection.Close(); return(arrList); }
private void frmCapNhatSach_Load(object sender, EventArgs e) { try { cmbTenTG.DataSource = TacGiaBUS.GetList(); cmbTenTG.DisplayMember = "TenTG"; cmbTenTG.ValueMember = "MaTG"; cmbNhaXuatBan.DataSource = NhaXuatBanBUS.GetList(); cmbNhaXuatBan.DisplayMember = "TenNXB"; cmbNhaXuatBan.ValueMember = "MaNXB"; cmbLoaiSach.DataSource = TheLoaiBUS.GetList(); cmbLoaiSach.DisplayMember = "TenTheLoai"; cmbLoaiSach.ValueMember = "MaLoai"; cmbNgonNgu.DataSource = NgonNguBUS.GetList(); cmbNgonNgu.DisplayMember = "TenNgonNgu"; cmbNgonNgu.ValueMember = "MaNgonNgu"; int maSach = TimKiemSach.MaSach; SachBUS sachBUS = new SachBUS(); SachDTO sachDTO = null; sachDTO = sachBUS.Search_MaSach(maSach); tbxTenSach.Text = sachDTO.TenSach; txtSoTrang.Text = sachDTO.SoTrang.ToString(); TacGiaBUS tacgiaBUS = new TacGiaBUS(); TacGiaDTO tacgiaDTO = null; tacgiaDTO = tacgiaBUS.LayTenTacGia(sachDTO.MaTacGia); cmbTenTG.Text = tacgiaDTO.TenTG; NhaXuatBanBUS nxbBUS = new NhaXuatBanBUS(); NhaXuatBanDTO nxbDTO = null; nxbDTO = nxbBUS.LayTenNhaXuatBan(sachDTO.MaNXB); cmbNhaXuatBan.Text = nxbDTO.TenNXB; NgonNguBUS nnBUS = new NgonNguBUS(); NgonNguDTO nnDTO = null; nnDTO = nnBUS.LayTenNgonNgu(sachDTO.MaNgonNgu); cmbNgonNgu.Text = nnDTO.TenNgonNgu; TheLoaiBUS tlBUS = new TheLoaiBUS(); TheLoaiDTO tlDTO = null; tlDTO = tlBUS.LayTenTheLoai(sachDTO.MaTheLoai); cmbLoaiSach.Text = tlDTO.TenTheLoai; if (sachDTO.TrangThai == 0) { cmbTinhTrang.Text = "Chưa mượn"; } else { cmbTinhTrang.Text = "Đã mượn"; } } catch (System.Exception ex) { MessageBox.Show(ex.Message); } }
public static void Insert(NgonNguDTO ngonNgu) { NgonNguDAO.Insert(ngonNgu); }
public static void Modify(NgonNguDTO ngonNgu) { NgonNguDAO.Modify(ngonNgu); }