public DataTable SelectTTSachTra(ChiTietTraSach_DTO ct)
{
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
DataTable table = new DataTable();
string sqlQuery = @" SELECT PHIEUMUON.MaPhieuMuon, CHITIETTRA.MaSach,.DAUSACH.TenDauSach, DAUSACH.TenTheLoai,DAUSACH.TacGia, PHIEUMUON.NgayMuon,CHITIETTRA.SoNgayTraMuon,CHITIETTRA.ChuThich
FROM CHITIETTRA INNER JOIN
CUONSACH ON CHITIETTRA.MaSach = CUONSACH.MaSach INNER JOIN
DAUSACH ON CUONSACH.MaDauSach = DAUSACH.MaDauSach INNER JOIN
PHIEUMUON ON CHITIETTRA.MaPhieuMuon = PHIEUMUON.MaPhieuMuon and CHITIETTRA.MaPhieuMuon = '" + ct.MaPhieuMuon + "' and CHITIETTRA.MaSach = '" + ct.MaSach + "'";
SqlDataAdapter aDapter = new SqlDataAdapter(sqlQuery, con);
aDapter.Fill(table);
con.Close();
return(table);
}
catch
{
return(null);
}
}
public bool KiemTra(ChiTietTraSach_DTO ctDTO)
{
if (ctDTO.MaPhieuMuon == "" || ctDTO.MaPhieuTra == "" || ctDTO.MaSach == "")
{
return(false);
}
return(true);
}
public frm_TraSach()
{
InitializeComponent();
phieuPhatDTO = new PhieuPhat_DTO();
phieuPhatBUS = new PhieuPhat_BUS();
phieuTraBUS = new PhieuTra_BUS();
phieuTraDTO = new PhieuTra_DTO();
ctTraSachBUS = new ChiTietTraSach_BUS();
ctTraSachDTO = new ChiTietTraSach_DTO();
}
public bool Updtate(ChiTietTraSach_DTO ct)
{
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
string sqlQuery = "Update CHITIETTRA Set GhiChu = N'" + ct.ChuThich + "' where MaPhieuMuon = '" + ct.MaPhieuMuon + "' and MaSach = '" + ct.MaSach + "'";
SqlCommand cmd = new SqlCommand(sqlQuery, con);
cmd.ExecuteNonQuery();
con.Close();
return(true);
}
catch
{
return(false);
}
}
public bool Delete(ChiTietTraSach_DTO ct)
{
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
string sqlQuery = "Delete from CHITIETTRA where MaPhieuTra = '" + ct.MaPhieuTra + "' and MaSach= '" + ct.MaSach + "'";
SqlCommand cmd = new SqlCommand(sqlQuery, con);
cmd.ExecuteNonQuery();
con.Close();
return(true);
}
catch
{
return(false);
}
}
public bool UpdateTTSach(ChiTietTraSach_DTO ct)
{
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
string sqlQuery = "Update CUONSACH Set TinhTrang ='N', ChuThich = N'" + ct.ChuThich + "'where MaSach = '" + ct.MaSach + "'";
SqlCommand cmd = new SqlCommand(sqlQuery, con);
cmd.ExecuteNonQuery();
con.Close();
return(true);
}
catch
{
return(false);
}
}
public bool Insert(ChiTietTraSach_DTO ct)
{
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
string sqlQuery = @"Insert into CHITIETTRA (MaPhieuTra,MaPhieuMuon,MaSach,SoNgayTraMuon,ChuThich) values
(N'" + ct.MaPhieuTra + "',N'" + ct.MaPhieuMuon + "',N'" + ct.MaSach + "'," + ct.SoNgayTraMuon + ", '" + ct.ChuThich + "')";
SqlCommand cmd = new SqlCommand(sqlQuery, con);
cmd.ExecuteNonQuery();
con.Close();
return(true);
}
catch
{
return(false);
}
}
public bool UpdateTTSach(ChiTietTraSach_DTO ct)
{
return(ctDAL.UpdateTTSach(ct));
}
public bool UpDate(ChiTietTraSach_DTO ct)
{
return(ctDAL.Updtate(ct));
}
public bool Delete(ChiTietTraSach_DTO ct)
{
return(ctDAL.Delete(ct));
}
public DataTable SelectTTTraSach(ChiTietTraSach_DTO ct)
{
return(ctDAL.SelectTTSachTra(ct));
}
public bool Insert(ChiTietTraSach_DTO ctDTO)
{
return(ctDAL.Insert(ctDTO));
}
