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();
}
}
private void btnBookAdd_Add_Click(object sender, EventArgs e)
{
Sach_DTO sachDTO = new Sach_DTO();
sachDTO.MaSach = lblBook_ID.Text;
sachDTO.TenSach = txtBookAdd_TitleOfBook.Text;
sachDTO.MaDauSach = lblBook_SeriesOfBook.Text;
sachDTO.TenTacGia = txtBookAdd_Author.Text;
sachDTO.TenNhaXuatBan = txtBookAdd_Publisher.Text;
sachDTO.SoLuong = int.Parse(numBookAdd_NumberOfBooks.Value.ToString());
sachDTO.NamXuatBan = int.Parse(txtBookAdd_PublicDate.Text);
sachDTO.DonGia = decimal.Parse(txtBookAdd_Prices.Text);
sachDTO.TrangThai = true;
DauSach_DTO dauSachDTO = new DauSach_DTO();
dauSachDTO.MaDauSach = lblBook_SeriesOfBook.Text;
dauSachDTO.TenDauSach = txtBookAdd_TitleOfBook.Text;
dauSachDTO.MaTheLoai = comBook_Category.SelectedValue.ToString();
dauSachDTO.TrangThai = true;
CTNhapSach_DTO cTNhapSach_DTO = new CTNhapSach_DTO();
cTNhapSach_DTO.MaNhap = nhapSach_BUS.PhatSinhMaNhapSach();
cTNhapSach_DTO.MaSach = lblBook_ID.Text;
cTNhapSach_DTO.SoLuong = int.Parse(numBookAdd_NumberOfBooks.Value.ToString());
cTNhapSach_DTO.DonGia = double.Parse(txtBookAdd_Prices.Text);
cTNhapSach_DTO.TrangThai = true;
NhapSach_DTO nhapSach_DTO = new NhapSach_DTO();
nhapSach_DTO.MaNhap = nhapSach_BUS.PhatSinhMaNhapSach();
nhapSach_DTO.MaNV = DoAn.frmLOGIN.MaNV;
nhapSach_DTO.NgayNhap = DateTime.Now;
nhapSach_DTO.ThanhTien = int.Parse(numBookAdd_NumberOfBooks.Value.ToString()) *
double.Parse(txtBookAdd_Prices.Text);
nhapSach_DTO.TrangThai = true;
if (dauSach_BUS.ThemDauSach(dauSachDTO) == true)
{
if (sach_BUS.ThemSachMotDongSach(sachDTO) == true)
{
if (nhapSach_BUS.ThemNhapSach(nhapSach_DTO) == true)
{
if (cTNhapSach_BUS.ThemCTNhapSach(cTNhapSach_DTO) == true)
{
frmSuccess frmSuccess = new frmSuccess(1);
frmSuccess.ShowDialog();
this.Hide();
}
}
}
else
{
frmFailed frmFailed = new frmFailed(1);
frmFailed.ShowDialog();
}
}
}
public NhapSach_DTO TimNhapSachTheoMaNhap(string MaNhap)
{
NhapSach_DTO nhapSach_DTO = new NhapSach_DTO();
//tim 1 nhan vien theo ma nhan vien
NhapSach nhapSach = data.NhapSaches.SingleOrDefault(
u => u.MaNhap == MaNhap && u.TrangThai.Value == true);
// đỗ dữ liệu từ nhân viên trong database sang nhân viên dto de chuyen di
nhapSach_DTO.MaNhap = nhapSach.MaNhap;
nhapSach_DTO.MaNV = nhapSach.MaNV;
nhapSach_DTO.NgayNhap = (DateTime)nhapSach.NgayNhap;
nhapSach_DTO.ThanhTien = double.Parse(nhapSach.ThanhTien.ToString());
return(nhapSach_DTO);
}
public bool SuaNhapSach(NhapSach_DTO nhapSach_DTO)
{
try
{
NhapSach nhapSach = data.NhapSaches.SingleOrDefault(u => u.MaNhap == nhapSach_DTO.MaNhap);
nhapSach.MaNhap = nhapSach_DTO.MaNhap;
nhapSach.MaNV = nhapSach_DTO.MaNV;
nhapSach.NgayNhap = nhapSach_DTO.NgayNhap;
nhapSach.ThanhTien = decimal.Parse(nhapSach_DTO.ThanhTien.ToString());
data.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool ThemNhapSach(NhapSach_DTO nhapSach_DTO)
{
try
{
NhapSach nhapSach = new NhapSach();
nhapSach.MaNhap = nhapSach_DTO.MaNhap;
nhapSach.MaNV = nhapSach_DTO.MaNV;
nhapSach.NgayNhap = nhapSach_DTO.NgayNhap;
nhapSach.ThanhTien = (decimal)nhapSach_DTO.ThanhTien;
nhapSach.TrangThai = true;
data.NhapSaches.Add(nhapSach);
data.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool SuaNhapSach(NhapSach_DTO nhapSach_DTO)
{
return(nhapSach_DAO.SuaNhapSach(nhapSach_DTO));
}
public bool ThemNhapSach(NhapSach_DTO nhapSach_DTO)
{
return(nhapSach_DAO.ThemNhapSach(nhapSach_DTO));
}
