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 rdTenSach_CheckedChanged(object sender, EventArgs e)
{
DauSach_DTO ds = new DauSach_DTO();
ds.TenDauSach = txtThongTinSach.Text;
dgvSach.DataSource = Sach_BUS.SelectSachLikeNameDanhSachSach(ds);
}
public bool UpDate(DauSach_DTO dausach)
{
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd;
string sqlQuyery1 = "select count(*) from DAUSACh where MaDauSach = '" + dausach.MaDauSach + "'";
cmd = new SqlCommand(sqlQuyery1, con);
var i = cmd.ExecuteScalar();
if (int.Parse(i.ToString()) == 0)
{
return(false);
}
else
{
string sqlQuery = @"Update DAUSACH set TenDauSach = N'" + dausach.TenDauSach + "',TacGia = N'" + dausach.TacGia + "',TenTheLoai = N'" + dausach.TenTheLoai
+ "',NamSanXuat = " + dausach.NamSanXuat + ",NhaSanXuat = N'" + dausach.NhaSanXuat + "',Gia = " + dausach.Gia + ",SoLuong = " + dausach.SoLuong + " where MaDauSach = '" + dausach.MaDauSach + "'";
cmd = new SqlCommand(sqlQuery, con);
cmd.ExecuteNonQuery();
con.Close();
return(true);
}
}
catch
{
return(false);
}
}
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 bool KiemTra(DauSach_DTO dausach)
{
if (dausach.MaDauSach == "" || dausach.TenDauSach == "" || dausach.TacGia == "" || dausach.TenTheLoai == "" || dausach.NamSanXuat == 0 || dausach.NhaSanXuat == "" || dausach.Gia == 0 || dausach.TenDauSach.Length < 0)
{
return(false);
}
return(true);
}
//Thêm đầu sách vào cơ sở dữ liệu
public static string ThemDauSach(DauSach_DTO ds)
{
if (DauSach_DAO.SelectDauSachByName(ds.TenDauSach) == null)
{
return(DauSach_DAO.Insert(ds));
}
else
{
return("Đầu sách đã tồn tại trong CSDL");
}
}
//Cập nhật đầu sách
public static string CapNhatDauSach(DauSach_DTO ds)
{
if (DauSach_DAO.SelectDauSachTheoMa(ds.MaDauSach) != null)
{
return(DauSach_DAO.Update(ds));
}
else
{
return("Mã đầu sách không tồn tại trong CSDL");
}
}
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;
}
//Xóa 1 đầu sách theo mã đầu sách
public static bool Delete(DauSach_DTO ds)
{
try
{
string sql = "delete from DAUSACH where MaDauSach= " + ds.MaDauSach + "";
DataAccess.ThucThiNonQuery(sql);
return(true);
}
catch
{
return(false);
}
}
public List <DauSach_DTO> LayTatCaDauSach()
{
List <DauSach_DTO> DanhSachDauSach = new List <DauSach_DTO>();
DataTable data = DataProvider.Instance.ExecuteQuery("LayTatCaDauSach");
foreach (DataRow item in data.Rows)
{
DauSach_DTO DauSach = new DauSach_DTO(item);
DanhSachDauSach.Add(DauSach);
}
return(DanhSachDauSach);
}
public List <DauSach_DTO> TimKiemDauSach(string ten)
{
List <DauSach_DTO> DanhSachDauSach = new List <DauSach_DTO>();
DataTable data = DataProvider.Instance.ExecuteQuery("TimKiemDauSach @param", new object[] { ten });
foreach (DataRow item in data.Rows)
{
DauSach_DTO DauSach = new DauSach_DTO(item);
DanhSachDauSach.Add(DauSach);
}
return(DanhSachDauSach);
}
//Trả về đối tượng DauSach_DTO với thuộc tính mã đầu sách
static public DauSach_DTO SelectDauSachTheoMa(int ma)
{
string sql = "select * from DAUSACH where MaDauSach=" + ma + "";
DataTable dt = DataAccess.ThucThiQuery(sql);
if (dt.Rows.Count == 0)
{
return(null);
}
else
{
DauSach_DTO s = new DauSach_DTO();
s.MaDauSach = int.Parse(dt.Rows[0].ItemArray[0].ToString());
return(s);
}
}
//Trả về tên đối tượng đầu sách đầu tiên trùng với tên
static public DauSach_DTO SelectDauSachByName(string name)
{
string sql = "select * from DAUSACH where TenDauSach=N'" + name + "'";
DataTable dt = DataAccess.ThucThiQuery(sql);
if (dt.Rows.Count == 0)
{
return(null);
}
else
{
DauSach_DTO s = new DauSach_DTO();
s.TenDauSach = dt.Rows[0].ItemArray[0].ToString();
return(s);
}
}
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 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 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 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");
}
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);
}
}
public bool Insert(DauSach_DTO dausach)
{
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
string sqlQuery = @"INSERT INTO DAUSACH(MaDauSach, TenDauSach, TacGia, TenTheLoai, NamSanXuat, NhaSanXuat, Gia, SoLuong) VALUES (N'" + dausach.MaDauSach + "', N'" + dausach.TenDauSach + "', N'" + dausach.TacGia + "',N'" + dausach.TenTheLoai + "', " + dausach.NamSanXuat + ",N'" + dausach.NhaSanXuat + "'," + dausach.Gia + "," + dausach.SoLuong + ")";
SqlCommand cmd = new SqlCommand(sqlQuery, con);
cmd.ExecuteNonQuery();
con.Close();
return(true);
}
catch
{
return(false);
}
}
public bool Delete(DauSach_DTO dausach)
{
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
string sqlQuery = "delete from DAUSACH where MaDauSach= '" + dausach.MaDauSach + "'";
SqlCommand cmd = new SqlCommand(sqlQuery, con);
cmd.ExecuteNonQuery();
con.Close();
return(true);
}
catch
{
return(false);
}
}
public bool ThemDauSach(DauSach_DTO dauSach_DTO)
{
try
{
DauSach dauSach = new DauSach();
dauSach.MaDauSach = dauSach_DTO.MaDauSach;
dauSach.TenDauSach = dauSach_DTO.TenDauSach;
dauSach.MaTheLoai = dauSach_DTO.MaTheLoai;
dauSach.TrangThai = true;
data.DauSaches.Add(dauSach);
data.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
//Chọn ra đầu sách theo mã thể loại
static public DataTable SelectDauSachLikeMaTheLoaiDanhSachDauSach(DauSach_DTO ds)
{
return(DauSach_DAO.SelectDauSachLikeMaTheLoaiDanhSachDauSach(ds));
}
//Trả về bảng chứa thông tin theo MaTheLoai
public static DataTable SelectSachLikeMaTheLoaiDanhSachSach(DauSach_DTO s)
{
string sql = "select MaSach,ds.MaDauSach,TacGia,MaTheLoai,NhaXuatBan,NamXuatBan,DonGiaBan,SoLuongTon from DAUSACH ds, CT_TACGIA ct,SACH s where ds.MaDauSach=ct.MaDauSach and ds.MaDauSach=s.MaDauSach and MaTheLoai=" + s.MaTheLoai + "";
return(DataAccess.ThucThiQuery(sql));
}
//Cập nhật 1 đầu sách theo mã đầu sách
static public string Update(DauSach_DTO ds)
{
string sql = "update DAUSACH set TenDauSach=(N'" + ds.TenDauSach + "'),MaTheLoai=(" + ds.MaTheLoai + ") where MaDauSach = " + ds.MaDauSach + "";
return(DataAccess.ThucThiNonQuery(sql));
}
//Chọn ra đầu sách giống với tên đầu sách cần tìm trong danh sách đầu sách
static public DataTable SelectDauSachLikeNameDanhSachDauSach(DauSach_DTO ds)
{
string sql = "select * from DAUSACH where TenDauSach like N'%" + ds.TenDauSach + "%'";
return(DataAccess.ThucThiQuery(sql));
}
//Trả về bảng chứa thông tin theo MaTheLoai
public static DataTable SelectSachLikeMaTheLoaiDanhSachSach(DauSach_DTO s)
{
return(Sach_DAO.SelectSachLikeMaTheLoaiDanhSachSach(s));
}
//Trả về bảng chứa thông tin theo TenDauSach trong form DanhSachSach
static public DataTable SelectSachLikeNameDanhSachSach(DauSach_DTO ds)
{
return(Sach_DAO.SelectSachLikeNameDanhSachSach(ds));
}
//Chọn ra đầu sách giống tên tác giả cần tìm trong danh sách đầu sách
static public DataTable SelectDauSachLikeTacGiaDanhSachDauSach(DauSach_DTO ds)
{
return(DauSach_DAO.SelectDauSachLikeTacGiaDanhSachDauSach(ds));
}
static public DataTable SelectDauSachLikeMaTheLoaiDanhSachDauSach(DauSach_DTO ds)
{
string sql = "select * from DAUSACH where MaTheLoai like '%" + ds.MaTheLoai + "%'";
return(DataAccess.ThucThiQuery(sql));
}
//Thêm đầu sách vào bảng DAUSACH
static public string Insert(DauSach_DTO s)
{
string sql = "insert into DAUSACH(TenDauSach,MaTheLoai) values(N'" + s.TenDauSach + "'," + s.MaTheLoai + ")";
return(DataAccess.ThucThiNonQuery(sql));
}
