private void tsbEdit_Click(object sender, EventArgs e)
{
if (txtTendausach.Text == "" || txtMadausach.Text == "")
{
MessageBox.Show("Chưa nhập đủ thông tin!");
return;
}
DauSach ds = new DauSach();
ds.maSach = txtMadausach.Text;
ds.tenSach = txtTendausach.Text;
ds.maNXB = cbxManxb.Text;
ds.vitri = cbxVitri.Text;
if (MessageBox.Show(string.Format("Bạn có muốn chỉnh sửa đầu sách {0} tên đầu sách {1}", ds.maSach, ds.tenSach),
"", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
if (Bus.UpdateDausach(ds) > 0)
{
MessageBox.Show("Chỉnh sửa thành công!");
frmDauSach_Load(sender, e);
}
else
{
MessageBox.Show("Lỗi");
}
}
}
public DauSach getDauSachbyMaSach(string masach)
{
DataTable table = DataProvider.Instance.executeQuery("select DAUSACH.MADAUSACH,TENDAUSACH, GIATIEN, TENNXB, TENTACGIA, DONGTACGIA, THELOAI from DAUSACH, SACH where DAUSACH.MADAUSACH = SACH.MADAUSACH and MASACH = '" + masach + "'");
DauSach ds = new DauSach(table.Rows[0]);
return(ds);
}
public bool XoaThacDauSach(string MaSach)
{
QLThuVienEntities qltvEntity = new QLThuVienEntities();
DauSach ds = new DauSach();
ds.MaSach = MaSach;
qltvEntity.DauSaches.Attach(ds);
qltvEntity.DauSaches.Remove(ds);
foreach (TacGia tg in qltvEntity.TacGias)
{
if (tg.MaSach == MaSach)
{
qltvEntity.TacGias.Attach(tg);
qltvEntity.TacGias.Remove(tg);
}
}
foreach (CuonSach cs in qltvEntity.CuonSaches)
{
if (cs.MaSach == MaSach)
{
qltvEntity.CuonSaches.Attach(cs);
qltvEntity.CuonSaches.Remove(cs);
foreach (MuonTra mt in qltvEntity.MuonTras)
{
if (mt.MaCuon == cs.MaCuon)
{
qltvEntity.MuonTras.Attach(mt);
qltvEntity.MuonTras.Remove(mt);
}
}
}
}
qltvEntity.SaveChanges();
return(true);
}
private void tsbSave_Click(object sender, EventArgs e)
{
if (txttendausach.Text == "" || txtmadausach.Text == "")
{
MessageBox.Show("Chưa nhập đủ thông tin!");
return;
}
DauSach ds = new DauSach();
ds.maSach = txtmadausach.Text;
ds.tenSach = txttendausach.Text;
ds.giabia = txtgiabia.Text;
ds.manxb = cbxmaxb.Text;
ds.nganhhoc = cbxnganhhoc.Text;
ds.ngonngu = cbxngonngu.Text;
ds.sotrang = txtsotrang.Text;
ds.namxuatban = datenamxb.Value;
ds.matg = cbxmatg.Text;
ds.tinhtrang = txttinhtrang.Text;
ds.soluongtaiban = txttaiban.Text;
if (MessageBox.Show(string.Format("Bạn có muốn thêm đầu sách {0} tên đầu sách {1}", ds.maSach, ds.tenSach),
"", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
if (Bus.InsertDausach(ds) > 0)
{
MessageBox.Show("Thêm thành công!");
frmDauSach_Load(sender, e);
}
else
{
MessageBox.Show("Lỗi");
}
}
}
private void txbMaS_TextChanged(object sender, EventArgs e)
{
try
{
if (dtgvS.SelectedCells.Count > 0)
{
string madausach = Convert.ToString(dtgvS.SelectedCells[0].OwningRow.Cells["MaDauSach"].Value);
DauSach dausach = DauSachDAO.Instance.GetDauSachByMaDauSach(madausach);
cbDauS.SelectedItem = dausach;
int index = -1;
int i = 0;
foreach (DauSach item in cbDauS.Items)
{
if (item.MaDauSach == dausach.MaDauSach)
{
index = i;
break;
}
i++;
}
cbDauS.SelectedIndex = index;
}
}
catch
{
}
}
private void btnThem_Click(object sender, EventArgs e)
{
if (SachDAO.Instance.ttSach(txtMaSach.Text) && SachDAO.Instance.kiemtraTrasach(txtMaSach.Text))
{
if (SachDAO.Instance.ktDGtraSach(txtMaThe.Text))
{
DauSach ds = DauSachDAO.Instance.getDauSachbyMaSach(txtMaSach.Text);
Sach s = SachDAO.Instance.getSachbyMaSach(txtMaSach.Text);
txtTenSach.Text = ds.TenDauSach;
ListViewItem listItem = new ListViewItem(txtMaSach.Text);
listItem.SubItems.Add(ds.TenDauSach);
listItem.SubItems.Add(ds.TheLoai);
listItem.SubItems.Add(ds.TenTacGia);
lsvSachMuon.Items.Add(listItem);
}
else
{
MessageBox.Show("Độc giả chưa trả hết sách");
}
}
else
{
MessageBox.Show("Mã sách không tồn tại hoặc sách chưa được trả. Vui lòng nhập lại!");
}
}
private void xóaToolStripMenuItem2_Click(object sender, EventArgs e)
{
if (lvDauSach.SelectedItems.Count > 0)
{
ListViewItem lvi = lvDauSach.SelectedItems[0];
DauSach s = lvi.Tag as DauSach;
DialogResult result = MessageBox.Show("Khi bạn xóa đầu sách này thì toàn bộ cuốn sách thuộc đầu sách này sẽ bị xóa. \n Bạn có chắc là muốn xóa đầu sách này?", "Xác nhận lần nữa", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == System.Windows.Forms.DialogResult.Yes)
{
if (SBLL.XoaDauSach(s.MaDauSach))
{
MessageBox.Show("Xóa thành công");
HienThiSach();
}
else
{
MessageBox.Show("Xóa thất bại");
}
}
}
else
{
MessageBox.Show("Bạn phải chọn 1 cuốn sách");
}
}
//loi
private void tsbDelete_Click(object sender, EventArgs e)
{
if (txtMadausach.Text == "")
{
MessageBox.Show("Chưa nhập thông tin đầy đủ");
return;
}
DauSach ds = new DauSach();
ds.maSach = txtMadausach.Text;
ds.tenSach = txtTendausach.Text;
ds.maNXB = cbxManxb.Text;
ds.vitri = cbxVitri.Text;
if (MessageBox.Show(string.Format("Bạn có muốn xóa mã đầu sách {0} ", ds.maSach),
"", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
if (Bus.DeleteDausach(ds) > 0)
{
MessageBox.Show("Xóa thành công!");
frmDauSach_Load(sender, e);
}
else
{
MessageBox.Show("Xóa thất bại");
}
}
}
private void Button_Click_5(object sender, RoutedEventArgs e)
{
DauSach dauSach = (DauSach)dataGrid.SelectedItem;
BtCapNhat.IsEnabled = true;
textBoxMaDauSach.Text = dauSach.MaDauSach.ToString();
textBoxTenDauSach.Text = dauSach.TenDauSach;
}
//con loi
public static int DeleteDausach(DauSach ds)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@madausach", ds.maSach)
};
return(DataProvider.ExecuteNonQuery("Xoadausach", para));
}
private void comboBoxMaDauSach_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (comboBoxMaDauSach.SelectedIndex >= 0)
{
DauSach dauSach = (DauSach)comboBoxMaDauSach.SelectedItem;
textBoxTenSach.Text = dauSach.TenDauSach;
textBoxTheLoai.Text = dauSach.TenTheLoai;
textBoxTenTacGia.Text = dauSach.TacGia;
}
}
private void SuaDauSach_Load(object sender, EventArgs e)
{
DauSach temp = SBLL.LayThongTinDauSach(MaDauSach);
lbMaDauSach.Text = temp.MaDauSach;
txbTenDauSach.Text = temp.TenDauSach;
txbTacGia.Text = temp.TacGia;
txbTheLoai.Text = temp.TheLoai;
txbNgonNgu.Text = temp.NgonNgu;
txbNhaXuatBan.Text = temp.NhaXuatBan;
}
public bool XoaDauSach(string MaSach)
{
QLThuVienEntities qltvEntity = new QLThuVienEntities();
DauSach ds = new DauSach();
ds.MaSach = MaSach;
qltvEntity.DauSaches.Attach(ds);
qltvEntity.DauSaches.Remove(ds);
qltvEntity.SaveChanges();
return(true);
}
public static int UpdateDausach(DauSach ds)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@madausach", ds.maSach),
new SqlParameter("@tendausach", ds.tenSach),
new SqlParameter("@manxb", ds.maNXB),
new SqlParameter("@vitri", ds.vitri)
};
return(DataProvider.ExecuteNonQuery("Suadausach", para));
}
public static int InsertDausach(DauSach ds)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@madausach", ds.maSach),
new SqlParameter("@tendausach", ds.tenSach),
new SqlParameter("@manxb", ds.maNXB),
new SqlParameter("@mahoadon", ds.maHoadon),
new SqlParameter("@vitri", ds.vitri)
};
return(DataProvider.ExecuteNonQuery("Themdausach", para));
}
public List <DauSach> GetListDauSach()
{
List <DauSach> list = new List <DauSach>();
DataTable data = DataProvider.Instance.executeQuery("USP_GetDauSachList ");
foreach (DataRow item in data.Rows)
{
DauSach ds = new DauSach(item);
list.Add(ds);
}
return(list);
}
public bool ThemDauSach(string MaSach, string Tua, string MaNXB)
{
QLThuVienEntities qltvEntity = new QLThuVienEntities();
DauSach ds = new DauSach();
ds.MaSach = MaSach;
ds.Tua = Tua;
ds.MaNXB = MaNXB;
qltvEntity.DauSaches.Add(ds);
qltvEntity.SaveChanges();
return(true);
}
void Load_CsDangMuon(string MaCS)
{
using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien())
{
txbMaSach.Text = MaCS;
CuonSach CS = qltv.CuonSaches.Where(p => p.MaSach == MaCS).FirstOrDefault();
DauSach DS = qltv.DauSaches.Where(p => p.MaDauSach == CS.MaDauSach).FirstOrDefault();
txbTenSach.Text = DS.TenDauSach;
txbGiaTien.Text = DS.GiaTien.ToString();
ptbAnhCS.Image = ByteToImage((byte[])DS.HinhAnh);
}
}
private void cbSach_SelectedIndexChanged(object sender, EventArgs e)
{
ComboBox cb = sender as ComboBox;
if (cb.SelectedItem == null)
{
return;
}
DauSach selected = cb.SelectedItem as DauSach;
maSach = selected.maDS;
tbTacGia.Text = BUS_Sach.Instance.layTenTacGiaBangMaSach(maSach);
}
private void btn_add_Click(object sender, EventArgs e)
{
try
{
var dausach = new DauSach();
dausach.Ten = txt_name.Text;
dausach.TheLoaiID = Convert.ToInt32(cbb_category.SelectedValue);
dausach.TacGiaID = Convert.ToInt32(cbb_author.SelectedValue);
dausach.TomTat = txt_summary.Text;
dausach.TaiBan = Convert.ToInt32(txt_republish.Text);
dausach.NhaSanXuatID = Convert.ToInt32(cbb_producer.SelectedValue);
dausach.SoLuongTong = Convert.ToInt32(txt_sumnumber.Text);
dausach.TinhTrang = Convert.ToByte(cbb_state.SelectedValue);
_context.DauSach.Add(dausach);
_context.SaveChanges();
for (int i = 1; i <= Convert.ToInt32(txt_sumnumber.Text); i++)
{
var cuonsach = new CuonSach();
cuonsach.MaVach = "MV" + dausach.ID + i;
cuonsach.DauSachID = dausach.ID;
cuonsach.TinhTrang = 2;
_context.CuonSach.Add(cuonsach);
}
var phieunhap = new PhieuNhapDauSach();
phieunhap.DauSachID = dausach.ID;
phieunhap.NgayNhap = DateTime.Now;
phieunhap.SoLuongCuonSach = dausach.SoLuongTong;
_context.PhieuNhapDauSach.Add(phieunhap);
_context.SaveChanges();
txt_name.Text = null;
txt_republish.Text = null;
txt_summary.Text = null;
txt_sumnumber.Text = null;
form_qlds = new QuanLyDauSach();
form_qlds.Refresh();
form_qlds.Refresh_DataGridView();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public List <DauSach> layDanhSachSach()
{
List <DauSach> listSach = new List <DauSach>();
string query = "select * from DAUSACH ";
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
DauSach info = new DauSach(item);
listSach.Add(info);
}
return(listSach);
}
public DauSach GetDauSachByMaDauSach(string madausach)
{
DauSach dausach = null;
string query = "select * from DAUSACH where MADAUSACH = " + madausach;
DataTable data = DataProvider.Instance.executeQuery(query);
foreach (DataRow item in data.Rows)
{
dausach = new DauSach(item);
return(dausach);
}
return(dausach);
}
public bool XoaDauSach(string maDauSach)
{
try
{
DauSach dauSach = data.DauSaches.SingleOrDefault
(u => u.MaDauSach == maDauSach && u.TrangThai == true);
dauSach.TrangThai = false;
data.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public List <DauSach> SearchDauSachByName(string name)
{
List <DauSach> list = new List <DauSach>();
string query = string.Format($"SELECT * FROM TimKiemDS2(N'{name}')");
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
DauSach dausach = new DauSach(item);
list.Add(dausach);
}
return(list);
}
public List <DauSach> GetListDauSach()
{
List <DauSach> list = new List <DauSach>();
string query = "select * from DAUSACH_View";
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
DauSach dausach = new DauSach(item);
list.Add(dausach);
}
return(list);
}
public DauSachViewModel(DauSach obj)
{
ID = obj.ID;
Ten = obj.Ten;
TheLoaiID = obj.TheLoaiID;
TheLoai = obj.TheLoai.Ten;
TacGiaID = obj.TacGiaID;
TacGia = obj.TacGia.Ten;
TomTat = obj.TomTat;
TaiBan = obj.TaiBan;
NhaSanXuatID = obj.NhaSanXuatID;
NhaSanXuat = obj.NhaSanXuat.Ten;
SoLuongTong = obj.SoLuongTong;
SoLuongTon = obj.SoLuongTon;
TinhTrangID = obj.TinhTrang;
TinhTrang = obj.TinhTrang != null?CommonHandler.GetEnumDescription((ConstantHandler.TinhTrang_DauSach) TinhTrangID) : string.Empty;
}
//Tim kiem
public List <DauSach> SearchDS(string tendausach, string madausach, string tennxb, string tentacgia, string theloai)
{
List <DauSach> list = new List <DauSach>();
string query = string.Format("select * from DAUSACH where (TENDAUSACH like N'{0}') OR " +
"(MADAUSACH like N'{1}') OR " +
"(TENNXB like N'{2}') OR " +
"(TENTACGIA like N'{3}') OR " +
"(THELOAI like N'{4}')", tendausach, madausach, tennxb, tentacgia, theloai);
DataTable data = DataProvider.Instance.executeQuery(query);
foreach (DataRow item in data.Rows)
{
DauSach ds = new DauSach(item);
list.Add(ds);
}
return(list);
}
private void BtThem_Click(object sender, RoutedEventArgs e)
{
if (isDigits(textBoxNamXuatBan.Text))
{
DauSach dauSach = (DauSach)comboBoxMaDauSach.SelectedItem;
string query = "EXEC spInsertIntoSACH " + dauSach.MaDauSach + ", '" + textBoxNhaXuatBan.Text + "', " + textBoxNamXuatBan.Text;
using (SqlCommand cmd = new SqlCommand(query, MainWindow.sqlConnection))
{
cmd.ExecuteNonQuery();
}
LoadBookList();
MessageBox.Show("Đã thêm sách vào cơ sở dữ liệu");
}
else
{
MessageBox.Show("Giá trị năm xuất bản không hợp lệ");
}
}
private void xemChiTiếtToolStripMenuItem_Click(object sender, EventArgs e)
{
if (lvDauSach.SelectedItems.Count > 0)
{
ListViewItem lvi = lvDauSach.SelectedItems[0];
DauSach s = lvi.Tag as DauSach;
SuaDauSach temp = new SuaDauSach();
temp.MaDauSach = s.MaDauSach;
temp.ShowDialog();
if (temp.SuaThanhCong)
{
HienThiGiaoDienDauSach();
}
}
else
{
MessageBox.Show("Bạn phải chọn 1 cuốn sách");
}
}
public bool SuaDauSach(DauSach_DTO dauSach_DTO)
{
try
{
DauSach dauSach = data.DauSaches.SingleOrDefault(u => u.MaDauSach == dauSach_DTO.MaDauSach);
dauSach.MaDauSach = dauSach_DTO.MaDauSach;
dauSach.TenDauSach = dauSach_DTO.TenDauSach;
dauSach.MaTheLoai = dauSach_DTO.MaTheLoai;
dauSach.TrangThai = true;
data.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
