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