public bool KiemTra(ChiTietMuonSach_DTO ctms)
{
if (ctms.MaPhieuMuon == "" || ctms.MaSach == "")
{
return(false);
}
return(true);
}
public frm_MuonSach()
{
// CheckForIllegalCrossThreadCalls = false;
InitializeComponent();
muonsachBUS = new PhieuMuon_BUS();
muonsachDTO = new PhieuMuon_DTO();
CTmuonsachBUS = new ChiTietMuonSach_BUS();
CTmuonsachDTO = new ChiTietMuonSach_DTO();
quydinh3BUS = new QuyDinh3_BUS();
quydinh3DTO = new QuyDinh3_DTO();
var qd = quydinh3BUS.Select().Rows[0].ItemArray;
dtNgayMuon.Value = DateTime.Now;
dtNgayDuKienTra.Value = dtNgayMuon.Value.AddDays(int.Parse(qd[1].ToString()));
lbSoLuong.Text = "0";
KhoiTaoCmbTiemKiem();
}
public bool UpdateTTSach(ChiTietMuonSach_DTO ct)
{
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
string sqlQuery = @"update CUONSACH SET TinhTrang = 'Y', 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 Delete(ChiTietMuonSach_DTO ctMuonSach)
{
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
string sqlQuery = @" Delete CHITIETMUON where MaPhieuMuon = '" + ctMuonSach.MaPhieuMuon + "' and MaSach = '" + ctMuonSach.MaSach + "'";
SqlCommand cmd = new SqlCommand(sqlQuery, con);
cmd.ExecuteNonQuery();
con.Close();
return(true);
}
catch
{
return(false);
}
}
public bool Insert(ChiTietMuonSach_DTO ctmuonsach)
{
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
string sqlQuery = @"insert into CHITIETMUON values ('" + ctmuonsach.MaPhieuMuon + "', '" + ctmuonsach.MaSach + "',N'" + ctmuonsach.ChuThich + "')";
SqlCommand cmd = new SqlCommand(sqlQuery, con);
cmd.ExecuteNonQuery();
con.Close();
return(true); // muon thanh cong
}
catch
{
return(false); // muon that bai;
}
}
public bool UpdateTTSach(ChiTietMuonSach_DTO ct)
{
return(CTMS.UpdateTTSach(ct));
}
public bool Delete(ChiTietMuonSach_DTO ctms)
{
return(CTMS.Delete(ctms));
}
public bool Insert(ChiTietMuonSach_DTO ctms)
{
return(CTMS.Insert(ctms));
}
