private void rdTenSach_CheckedChanged(object sender, EventArgs e)
{
DauSach_DTO ds = new DauSach_DTO();
ds.TenDauSach = txtThongTinSach.Text;
dgvDauSach.DataSource = DauSach_BUS.SelectDauSachLikeNameDanhSachDauSach(ds);
}
private void btnBookUpdate_Update_Click(object sender, EventArgs e)
{
Sach_DTO sach_DTO = new Sach_DTO
{
MaSach = lblBookUpdate_ID.Text,
TenSach = txtBookUpdate_TitleOfBook.Text,
MaDauSach = lblBookUpdate_TitleID.Text,
TenTacGia = txtBookUpdate_Author.Text,
TenNhaXuatBan = txtBookUpdate_Publisher.Text,
SoLuong = int.Parse(numBookUpdate_NumberOfBooks.Value.ToString()),
NamXuatBan = int.Parse(txtBookUpdate_PublicDate.Text),
DonGia = decimal.Parse(txtBookUpdate_Prices.Text),
TrangThai = true
};
DauSach_DTO dauSach_DTO = new DauSach_DTO
{
MaDauSach = lblBookUpdate_TitleID.Text,
TenDauSach = txtBookUpdate_TitleOfBook.Text,
MaTheLoai = comBookUpdate_Category.SelectedValue.ToString(),
TrangThai = true
};
DauSach_BUS dauSach_BUS = new DauSach_BUS();
if (dauSach_BUS.SuaDauSach(dauSach_DTO) == true)
{
Sach_BUS sach_BUS = new Sach_BUS();
if (sach_BUS.SuaSach(sach_DTO) == true)
{
CTNhapSach_BUS cTNhapSach_BUS = new CTNhapSach_BUS();
CTNhapSach_DTO cTNhapSach_DTO = cTNhapSach_BUS.TimCTNhapSachTheoMaSach(lblBookUpdate_ID.Text);
cTNhapSach_DTO.SoLuong = int.Parse(numBookUpdate_NumberOfBooks.Value.ToString());
cTNhapSach_DTO.DonGia = double.Parse(txtBookUpdate_Prices.Text);
if (cTNhapSach_BUS.SuaCTNhapSach(cTNhapSach_DTO) == true)
{
NhapSach_BUS nhapSach_BUS = new NhapSach_BUS();
NhapSach_DTO nhapSach_DTO = nhapSach_BUS.TimNhapSachTheoMaNhap(cTNhapSach_DTO.MaNhap);
nhapSach_DTO.ThanhTien = double.Parse(txtBookUpdate_Prices.Text) *
int.Parse(numBookUpdate_NumberOfBooks.Value.ToString());
if (nhapSach_BUS.SuaNhapSach(nhapSach_DTO) == true)
{
frmSuccess frm_Success = new frmSuccess(2);
frm_Success.ShowDialog();
this.Hide();
}
}
}
}
else
{
frmFailed frm_Failed = new frmFailed(2);
frm_Failed.Show();
}
}
public void HienThiDauSach()
{
Enable(false);
btnThem.Enabled = true;
btnCapNhat.Enabled = true;
dgvDauSach.DataSource = DauSach_BUS.SelectDauSachAll();
}
public void LoadBangDauSach()
{
dgvDSSach.DataSource = null;
dgvDSSach.DataSource = DauSach_BUS.LoadDauSach();
var vtSeXoa = new List <int>();
if (cuaFrmPhieuMuon.Rows.Count > 1)
{
for (var i = 0; i < dgvDSSach.Rows.Count - 1; i++)
{
for (var j = 0; j < cuaFrmPhieuMuon.Rows.Count - 1; j++)
{
var meMaDauSach = dgvDSSach.Rows[i].Cells["MaDauSach"].Value.ToString();
var meMaSach = dgvDSSach.Rows[i].Cells["STT"].Value.ToString();
var youMaDauSach = cuaFrmPhieuMuon.Rows[j].Cells["MaDauSach"].Value.ToString();
var youMaSach = cuaFrmPhieuMuon.Rows[j].Cells["MaSach"].Value.ToString();
if (youMaDauSach == meMaDauSach && youMaSach == meMaSach)
{
vtSeXoa.Add(i);
break;
}
}
}
}
foreach (var i in vtSeXoa.ToArray().Reverse())
{
dgvDSSach.Rows.RemoveAt(i);
}
}
private void btnThem_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (them)
{
tbTenDS.Clear();
tbTacGia.Clear();
tbNXB.Clear();
tbSoLuong.Clear();
tbGiaSach.Clear();
//mã đầu sách tự tăng
string maDS = nextMa(DauSach_BUS.LastMaDS());
them = false;
DSbindingSource.AddNew();
//GÁN vào textbox và gridview
gvDauSach.SetFocusedRowCellValue(colMaDS, maDS);
tbMaDS.Text = maDS;
//trỏ tới dòng cuối cùng trong gridview
gvDauSach.FocusedRowHandle = gvDauSach.RowCount - 1;
tbTenDS.Focus();
}
else
{
gvDauSach.FocusedRowHandle = gvDauSach.RowCount - 1;
tbTenDS.Focus();
}
}
private void dgvDauSach_RowEnter(object sender, DataGridViewCellEventArgs e)
{
int dong = e.RowIndex;
ds.MaDauSach = int.Parse(dgvDauSach.Rows[dong].Cells[0].Value.ToString());
ds.TenDauSach = dgvDauSach.Rows[dong].Cells[1].Value.ToString();
ds.MaTheLoai = (int)dgvDauSach.Rows[dong].Cells[2].Value;
dgvCTTacGia.DataSource = DauSach_BUS.SelectCTTacGiaByMa(ds.MaDauSach);
}
private void btnXoa_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (MessageBox.Show("Bạn có chắc muốn xóa không?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
//TheLoai_BUS.xoaTL(gvDauSach.GetFocusedRowCellValue(colMaTL).ToString());
DauSach_BUS.xoaDS(gvDauSach.GetFocusedRowCellValue(colMaDS).ToString());
DSbindingSource.RemoveAt(gvDauSach.FocusedRowHandle);
MessageBox.Show("Xóa thành công!");
}
}
private void frmQuanLySach_Load(object sender, EventArgs e)
{
colMaTheLoai.ValueMember = "MaTheLoai";
colMaTheLoai.DisplayMember = "TenTheLoai";
colMaTheLoai.DataSource = TheLoai_BUS.GetTheLoaiAll();
colTenDauSach.ValueMember = "MaDauSach";
colTenDauSach.DisplayMember = "TenDauSach";
colTenDauSach.DataSource = DauSach_BUS.SelectDauSachAll();
HienThiThongTinSach();
}
private void dgvDauSach_RowEnter(object sender, DataGridViewCellEventArgs e)
{
int dong = e.RowIndex;
txtMaDauSach.Text = dgvDauSach.Rows[dong].Cells[0].Value.ToString();
txtMaSachCT.Text = dgvDauSach.Rows[dong].Cells[0].Value.ToString();
txtTenDauSach.Text = dgvDauSach.Rows[dong].Cells[1].Value.ToString();
cboTheLoai.SelectedValue = (int)(dgvDauSach.Rows[dong].Cells[2].Value);
TheLoai_DTO tl = TheLoai_BUS.GetTheLoaiByMa((int)(dgvDauSach.Rows[dong].Cells[2].Value));
cboTheLoai.Text = tl.TenTheLoai;
dgvCT_TacGia.DataSource = DauSach_BUS.SelectCTTacGiaByMa(int.Parse(dgvDauSach.Rows[dong].Cells[0].Value.ToString()));
}
public void HienThiDanhSachDauSachTheoMaTheLoai(string ma)
{
DauSach_DTO s = new DauSach_DTO();
s.MaTheLoai = int.Parse(ma);
DataTable dt = DauSach_BUS.SelectDauSachLikeMaTheLoaiDanhSachDauSach(s);
if (dt.Rows.Count == 0)
{
dgvCTTacGia.DataSource = DauSach_BUS.SelectCTTacGiaNull();
}
dgvDauSach.DataSource = dt;
}
public frm_DauSach()
{
InitializeComponent();
dausachBUS = new DauSach_BUS();
dausachDTO = new DauSach_DTO();
theLoai = new TheLoai_BUS();
qd2 = new QuyDinh2_BUS();
KhoiTaoCmdLoai();
KhoiTaoCmbTiemKiem();
DataTable table = new DataTable();
table = qd2.Select();
var i = table.Rows[0].ItemArray;
HanNhanSach = int.Parse(i[1].ToString());
}
public void HienThiDanhSachDauSachTheoMaTheLoai(string ma)
{
DauSach_DTO s = new DauSach_DTO();
s.MaTheLoai = int.Parse(ma);
DataTable dt = Sach_BUS.SelectSachLikeMaTheLoaiDanhSachSach(s);
colTenSach.ValueMember = "MaDauSach";
colTenSach.DisplayMember = "TenDauSach";
colTenSach.DataSource = DauSach_BUS.SelectDauSachAll();
if (dt.Rows.Count == 0)
{
dgvSach.DataSource = Sach_BUS.SelectSachNull();
}
dgvSach.DataSource = dt;
}
public void Them()
{
DauSach_DTO ds = new DauSach_DTO();
ds.MaTheLoai = int.Parse(cboTheLoai.SelectedValue.ToString());
ds.TenDauSach = txtTenDauSach.Text;
string ketQua = DauSach_BUS.ThemDauSach(ds);
if (ketQua != "Success")
{
MessageBox.Show(ketQua);
return;
}
HienThiDauSach();
MessageBox.Show("Thêm đầu sách thành công");
this.Size = new Size(1248, 615);
}
public void CapNhat()
{
DauSach_DTO ds = new DauSach_DTO();
ds.MaDauSach = int.Parse(txtMaDauSach.Text);
ds.MaTheLoai = int.Parse(cboTheLoai.SelectedValue.ToString());
ds.TenDauSach = txtTenDauSach.Text;
string ketQua = DauSach_BUS.CapNhatDauSach(ds);
if (ketQua != "Success")
{
MessageBox.Show(ketQua);
return;
}
HienThiDauSach();
MessageBox.Show("Cập nhật thành công");
}
private void btnThemTacGia_Click(object sender, EventArgs e)
{
CT_TacGia_DTO ct = new CT_TacGia_DTO();
ct.MaDauSach = int.Parse(txtMaSachCT.Text);
if (txtTacGia.Text == "")
{
MessageBox.Show("Tên tác giả không được để trống");
return;
}
ct.TacGia = txtTacGia.Text;
if (DauSach_BUS.ThemCTTacGia(ct) == false)
{
MessageBox.Show("Mã sách và Tác giả đã tồn tại trong CSDL");
return;
}
HienThiCTTacGia();
MessageBox.Show("Thêm tác giả thành công");
}
private void Load()
{
try
{
DSbindingSource.DataSource = DauSach_BUS.LoadDSDauSach();
gcDauSach.DataSource = DSbindingSource;
int soTL = cboTheLoai.Items.Count;
for (int i = 0; i < soTL; i++)
{
repositoryItemComboBox1.Items.RemoveAt(0);
cboTheLoai.Items.RemoveAt(0);
}
// gcTheLoai.DataSource = TLbindingSource;
}
catch
{
MessageBox.Show("Load bị lỗi!");
}
}
private void btnXoaTacGia_Click(object sender, EventArgs e)
{
CT_TacGia_DTO ct = new CT_TacGia_DTO();
try
{
ct.MaDauSach = c.MaDauSach;
ct.TacGia = c.TacGia;
}
catch
{
MessageBox.Show("Mã sách và Tác giả không được rỗng chọn từ danh sách bên dưới để cập nhật");
}
string ketQua = DauSach_BUS.XoaDauSach(ct);
if (ketQua != "Success")
{
MessageBox.Show(ketQua, "Đã có lỗi");
return;
}
HienThiCTTacGia();
MessageBox.Show("Xóa thành công");
}
public void loadInfo()
{
chkNgayTra.Checked = false;
dtpNgayT.Enabled = false;
tbMaMT.Text = maMT;
cboTenDS.Text = tenDS;
cboMaDG.Text = maDG;
cboNV.Text = maNV;
tbGhiChu.Text = ghiChu;
cboMaSach.Text = maSach;
if (ngayM != DateTime.MinValue)
{
dtpNgayM.Value = ngayM;
}
if (ngayT != DateTime.MinValue)
{
//checkT = true;
chkNgayTra.Checked = true;
dtpNgayT.Value = ngayT;
dtpNgayT.Enabled = true;
}
if (hanTra != DateTime.MinValue)
{
dtpNgayHH.Value = hanTra;
}
int sl = cboTenDS.Items.Count;
for (int i = 0; i < sl; i++)
{
cboTenDS.Items.RemoveAt(0);
}
DataTable dtb = DauSach_BUS.dsTenDS();
for (int i = 0; i < dtb.Rows.Count; i++)
{
// string name = dtb.Rows[i][0].ToString().ToUpper();
string name = dtb.Rows[i][0].ToString();
cboTenDS.Items.Add(name);
}
sl = cboMaDG.Items.Count;
for (int i = 0; i < sl; i++)
{
cboMaDG.Items.RemoveAt(0);
}
dtb = DocGia_BUS.dsMaDG();
for (int i = 0; i < dtb.Rows.Count; i++)
{
// string name = dtb.Rows[i][0].ToString().ToUpper();
string name = dtb.Rows[i][0].ToString();
cboMaDG.Items.Add(name);
}
sl = cboMaSach.Items.Count;
for (int i = 0; i < sl; i++)
{
cboMaSach.Items.RemoveAt(0);
}
dtb = Sach_BUS.dsmaSach(tenDS);
for (int i = 0; i < dtb.Rows.Count; i++)
{
// string name = dtb.Rows[i][0].ToString().ToUpper();
string name = dtb.Rows[i][0].ToString();
cboMaSach.Items.Add(name);
}
sl = cboNV.Items.Count;
for (int i = 0; i < sl; i++)
{
cboNV.Items.RemoveAt(0);
}
dtb = NhanVien_BUS.dsMaNV();
for (int i = 0; i < dtb.Rows.Count; i++)
{
// string name = dtb.Rows[i][0].ToString().ToUpper();
string name = dtb.Rows[i][0].ToString();
cboNV.Items.Add(name);
}
if (maDG != "")
{
tbTenDG.Text = DocGia_BUS.TenDG(maDG);
}
}
public void HienThiCTTacGia()
{
dgvCT_TacGia.DataSource = DauSach_BUS.SelectCTTacGiaAll();
}
private void btnLuu_Click(object sender, EventArgs e)
{
try
{
if (!them && gvDauSach.FocusedRowHandle == gvDauSach.RowCount - 1)
{
if (tbTenDS.Text != "" && cboTheLoai.Text != "")
{
//chuẩn hóa tên
string maDS = tbMaDS.Text;
string tenDS = ChuanHoa(tbTenDS.Text.ToLower());
string maTL = TheLoai_BUS.MaTL(cboTheLoai.Text.Trim());
string tenTG = ChuanHoa(tbTacGia.Text.ToLower());
string nxb = ChuanHoa(tbNXB.Text.ToLower());
string giaSach = tbGiaSach.Text;
DauSach_BUS.themDS(maDS, tenDS, maTL, tenTG, nxb, giaSach, 0, 0);
// TheLoai_BUS.themTL(tbMaTL.Text, tenTL);
MessageBox.Show("Thêm thành công");
// this.SinhVienbindingSource.EndEdit();
//thêm trực tiếp sinh viên vào gridview mà không load lại danh sách
//gvDauSach.SetFocusedRowCellValue(colTenTL, tenTL);
gvDauSach.SetFocusedRowCellValue(colMaDS, maDS);
gvDauSach.SetFocusedRowCellValue(colTenDS, tenDS);
gvDauSach.SetFocusedRowCellValue(colTheLoai, cboTheLoai.Text);
gvDauSach.SetFocusedRowCellValue(colTacGia, tenTG);
gvDauSach.SetFocusedRowCellValue(colNXB, nxb);
gvDauSach.SetFocusedRowCellValue(colGiaSach, giaSach);
gvDauSach.SetFocusedRowCellValue(colSL, " 0/ 0");
//load_DS();
//chuẩn hóa ở textbox
//tbTenTL.Text = tenTL;
tbTenDS.Text = tenDS;
tbTacGia.Text = tenTG;
tbNXB.Text = nxb;
tbGiaSach.Text = giaSach.ToString();
tbSoLuong.Text = " 0/ 0";
//
them = true;
}
else
{
MessageBox.Show("Nhập tên đầu sách");
}
}
else
{
if (MessageBox.Show("Bạn có chắc muốn sửa không?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
try
{
string maDS = tbMaDS.Text.Trim();
string tenDS = ChuanHoa(tbTenDS.Text.Trim().ToLower());
string tenTL = cboTheLoai.Text;
string maTL = TheLoai_BUS.MaTL(tenTL);
string tenTG = ChuanHoa(tbTacGia.Text.ToLower());
string nxb = ChuanHoa(tbNXB.Text.ToLower());
string sl = tbSoLuong.Text;
string giaSach = tbGiaSach.Text;
if (tenDS != gvDauSach.GetFocusedRowCellValue(colTenDS).ToString().Trim())
{
//TheLoai_BUS.suaTL(tbMaTL.Text.Trim(), tenTL);
DauSach_BUS.suaDS_ten(maDS, tenDS);
gvDauSach.SetFocusedRowCellValue(colTenDS, tenDS);
tbTenDS.Text = tenDS;
}
else
{
tbTenDS.Text = tenDS;
}
if (tenTL != gvDauSach.GetFocusedRowCellValue(colTheLoai).ToString())
{
DauSach_BUS.suaDS_tl(maDS, maTL);
gvDauSach.SetFocusedRowCellValue(colTheLoai, tenTL);
}
if (tenTG != gvDauSach.GetFocusedRowCellValue(colTacGia).ToString())
{
DauSach_BUS.suaDS_tg(maDS, tenTG);
gvDauSach.SetFocusedRowCellValue(colTacGia, tenTG);
tbTacGia.Text = tenTG;
}
else
{
tbTacGia.Text = tenTG;
}
if (nxb != gvDauSach.GetFocusedRowCellValue(colNXB).ToString())
{
DauSach_BUS.suaDS_nxb(maDS, nxb);
gvDauSach.SetFocusedRowCellValue(colNXB, nxb);
tbNXB.Text = nxb;
}
else
{
tbNXB.Text = nxb;
}
if (sl != gvDauSach.GetFocusedRowCellValue(colSL).ToString())
{
gvDauSach.SetFocusedRowCellValue(colSL, sl);
tbSoLuong.Text = sl;
}
if (giaSach != gvDauSach.GetFocusedRowCellValue(colGiaSach).ToString())
{
DauSach_BUS.suaDS_giasach(maDS, giaSach);
gvDauSach.SetFocusedRowCellValue(colGiaSach, giaSach);
tbGiaSach.Text = giaSach;
}
else
{
tbGiaSach.Text = giaSach;
}
MessageBox.Show("Sửa thành công!");
sua = true;
}
catch
{
MessageBox.Show("Sửa không thành công");
}
}
else
{
tbTenDS.Text = gvDauSach.GetFocusedRowCellValue(colTenDS).ToString();
cboTheLoai.Text = gvDauSach.GetFocusedRowCellValue(colTheLoai).ToString();
tbTacGia.Text = gvDauSach.GetFocusedRowCellValue(colTacGia).ToString();
tbNXB.Text = gvDauSach.GetFocusedRowCellValue(colNXB).ToString();
tbSoLuong.Text = gvDauSach.GetFocusedRowCellValue(colSL).ToString();
tbGiaSach.Text = gvDauSach.GetFocusedRowCellValue(colGiaSach).ToString();
}
}
}
catch
{
MessageBox.Show("Lưu thất bại");
}
}
private void txtTimSachMuon_TextChanged(object sender, EventArgs e)
{
var s = cbxMucTim.SelectedItem.ToString();
dgvDSSach.DataSource = DauSach_BUS.TimSach(s, txtTimSachMuon.Text);
}
private void gvDauSach_ValidateRow(object sender, DevExpress.XtraGrid.Views.Base.ValidateRowEventArgs e)
{
if (!them)
{
if (gvDauSach.FocusedRowHandle != gvDauSach.RowCount - 1)
{
}
else
{
if (MessageBox.Show("Bạn có chắc muốn lưu không?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
try
{
if (gvDauSach.GetFocusedRowCellValue(colTenDS).ToString() != "" && gvDauSach.GetFocusedRowCellValue(colTheLoai).ToString() != "")
{
//chuẩn hóa tên
string maDS = gvDauSach.GetFocusedRowCellValue(colMaDS).ToString();
string tenDS = ChuanHoa(gvDauSach.GetFocusedRowCellValue(colTenDS).ToString().ToLower());
string tenTL = gvDauSach.GetFocusedRowCellValue(colTheLoai).ToString();
string maTL = TheLoai_BUS.MaTL(tenTL);
string tenTG = ChuanHoa(gvDauSach.GetFocusedRowCellValue(colTacGia).ToString().ToLower());
string nxb = ChuanHoa(gvDauSach.GetFocusedRowCellValue(colNXB).ToString().ToLower());
string giaSach = ChuanHoa(gvDauSach.GetFocusedRowCellValue(colGiaSach).ToString().ToLower());
DauSach_BUS.themDS(maDS, tenDS, maTL, tenTG, nxb, giaSach, 0, 0);
MessageBox.Show("Thêm thành công");
// this.SinhVienbindingSource.EndEdit();
//chuẩn hóa trực tiếp sinh viên vào gridview mà không load lại danh sách
gvDauSach.SetFocusedRowCellValue(colTenDS, tenDS);
gvDauSach.SetFocusedRowCellValue(colTacGia, tenTG);
gvDauSach.SetFocusedRowCellValue(colNXB, nxb);
gvDauSach.SetFocusedRowCellValue(colSL, " 0/ 0");
gvDauSach.SetFocusedRowCellValue(colGiaSach, giaSach);
//load_DS();
//chuẩn hóa ở textbox
tbTenDS.Text = tenDS;
tbTacGia.Text = tenTG;
cboTheLoai.Text = tenTL;
tbNXB.Text = nxb;
tbGiaSach.Text = giaSach;
tbSoLuong.Text = " 0/ 0";
//
them = true;
}
else
{
MessageBox.Show("Nhập tên tên đầu sách");
}
}
catch
{
MessageBox.Show("Lưu không thành công!");
}
}
else
{
them = true;
DSbindingSource.RemoveAt(gvDauSach.RowCount - 1);
}
}
}
else if (daChuanhoa)
{
daChuanhoa = false;
}
else if (sua)
{
sua = false;
}
else
{
string maDS = gvDauSach.GetFocusedRowCellValue(colMaDS).ToString();
string tenDS = ChuanHoa(gvDauSach.GetFocusedRowCellValue(colTenDS).ToString().ToLower());
string tenTL = gvDauSach.GetFocusedRowCellValue(colTheLoai).ToString();
string maTL = TheLoai_BUS.MaTL(tenTL);
string tenTG = ChuanHoa(gvDauSach.GetFocusedRowCellValue(colTacGia).ToString().ToLower());
string nxb = ChuanHoa(gvDauSach.GetFocusedRowCellValue(colNXB).ToString().ToLower());
string giaSach = ChuanHoa(gvDauSach.GetFocusedRowCellValue(colGiaSach).ToString().ToLower());
//khi vừa mới thêm xong
if (tbTenDS.Text == tenDS &&
tbTacGia.Text == tenTG &&
cboTheLoai.Text == tenTL &&
tbNXB.Text == nxb &&
tbGiaSach.Text == giaSach)
{
}
else
{
if (MessageBox.Show("Bạn có chắc muốn sửa không?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
try
{
if (tenDS != tbTenDS.Text)
{
//TheLoai_BUS.suaTL(tbMaTL.Text.Trim(), tenTL);
DauSach_BUS.suaDS_ten(maDS, tenDS);
gvDauSach.SetFocusedRowCellValue(colTenDS, tenDS);
tbTenDS.Text = tenDS;
}
else
{
gvDauSach.SetFocusedRowCellValue(colTenDS, tenDS);
}
if (tenTL != cboTheLoai.Text)
{
DauSach_BUS.suaDS_tl(maDS, maTL);
cboTheLoai.Text = tenTL;
}
if (tenTG != tbTacGia.Text)
{
DauSach_BUS.suaDS_tg(maDS, tenTG);
gvDauSach.SetFocusedRowCellValue(colTacGia, tenTG);
tbTacGia.Text = tenTG;
}
else
{
gvDauSach.SetFocusedRowCellValue(colTacGia, tenTG);
}
if (nxb != tbNXB.Text)
{
DauSach_BUS.suaDS_nxb(maDS, nxb);
gvDauSach.SetFocusedRowCellValue(colNXB, nxb);
tbNXB.Text = nxb;
}
else
{
gvDauSach.SetFocusedRowCellValue(colNXB, nxb);
}
if (giaSach != tbGiaSach.Text)
{
DauSach_BUS.suaDS_giasach(maDS, giaSach);
gvDauSach.SetFocusedRowCellValue(colGiaSach, giaSach);
tbGiaSach.Text = giaSach;
}
else
{
gvDauSach.SetFocusedRowCellValue(colGiaSach, giaSach);
}
// string maLop = Lop_BUS.maLop(cboLop.Text);
// sv = new SinhVien_DTO(tbHoSV.Text, tbTenSV.Text, cboGioiTinh.Text, dtpNgaySinh.Value, tbDiaChi.Text, tbNoiSinh.Text, maLop);
// SinhVien_BUS.suaSV(sv);
//TheLoai_BUS.suaTL(maTL, tenTL);
//gvDauSach.SetFocusedRowCellValue(colTenTL, tenTL);
//tbTenTL.Text = tenTL;
MessageBox.Show("Sửa thành công!");
}
catch
{
MessageBox.Show("Sửa không thành công!");
}
}
else
{
gvDauSach.SetFocusedRowCellValue(colTenDS, tbTenDS.Text);
gvDauSach.SetFocusedRowCellValue(colTheLoai, cboTheLoai.Text);
gvDauSach.SetFocusedRowCellValue(colTacGia, tbTacGia.Text);
gvDauSach.SetFocusedRowCellValue(colNXB, tbNXB.Text);
gvDauSach.SetFocusedRowCellValue(colGiaSach, tbGiaSach.Text);
//gvDauSach.SetFocusedRowCellValue(colTenDS, tbTenDS.Text);
}
}
}
}
public void LoadDauSach()
{
dgvDSDauSach.DataSource = DauSach_BUS.LoadDauSach();
}
public void HienThiDanhSachDauSach()
{
dgvDauSach.DataSource = DauSach_BUS.SelectDauSachAll();
}
