//Sua
public bool SuaCTMuon(CTMuon_DTO ctm)
{
if (KiemTraTruocKhiLuu(ctm))
{
string sql = string.Format("UPDATE CHITIET_MUON SET MaSach=N'{1}'WHERE id_CTMuon='{0}'",
ctm.id_CTMuon, ctm.MaSach);
string h = "Chưa đươc mượn";
string j = "select MaSach from CHITIET_MUON where id_CTMuon='" + ctm.id_CTMuon + "'";
DataTable jj = connData.getdata(j);
CuonSach_DTO cs = new CuonSach_DTO();
DataRow rowTTNV = jj.Rows[0];
// string f=cs.MaSach=rowTTNV["MaSach"].ToString();
string g = string.Format("UPDATE CUONSACH SET TinhTrangSach=N'{1}' WHERE MaSach='{0}'", rowTTNV["MaSach"].ToString(), h);
connData.ThucThiSQL(g);
if (connData.ThucThiSQL(sql))
{
string tt = "Đã được mượn";
string fg = string.Format("UPDATE CUONSACH SET TinhTrangSach=N'{1}' WHERE MaSach='{0}'", ctm.MaSach, tt);
connData.ThucThiSQL(fg);
MessageBox.Show("Sửa thông tin chi tiết phiếu mượn thành công !", "Thông tin", MessageBoxButtons.OK, MessageBoxIcon.Information);
return(true);
}
}
return(false);
}
private void simpleButton1_Click(object sender, EventArgs e)
{
CuonSach_DTO cs = LayTT();
csBUS.SuaCS(cs);
ttCuonSach_Load(sender, e);
}
public bool Delete(CuonSach_DTO cuonSach)
{
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd;
string sqlQuyery1 = " select count(*) from CUONSACH where MaSach = '" + cuonSach.MaSach + "'";
cmd = new SqlCommand(sqlQuyery1, con);
var i = cmd.ExecuteScalar();
if (int.Parse(i.ToString()) == 0)
{
return(false);
}
{
string sqlQuery = @"Delete CUONSACH where MaSach = '" + cuonSach.MaSach + "'";
cmd = new SqlCommand(sqlQuery, con);
cmd.ExecuteNonQuery();
con.Close();
return(true);
}
}
catch
{
return(false);
}
}
public bool Update(CuonSach_DTO cuonsach)
{
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd;
string sqlQuyery1 = " select count(*) from CUONSACH where MaSach = '" + cuonsach.MaSach + "'";
cmd = new SqlCommand(sqlQuyery1, con);
var i = cmd.ExecuteScalar();
if (int.Parse(i.ToString()) == 0)
{
return(false);
}
else
{
string sqlQuery = @" Update CUONSACH set MaDauSach = '" + cuonsach.MaDauSach + "',ChuThich = N'" + cuonsach.ChuThich + "',NgayNhap = '" + cuonsach.NgayNhap + "' where MaSach = '" + cuonsach.MaSach + "'";
cmd = new SqlCommand(sqlQuery, con);
cmd.ExecuteNonQuery();
return(true);
}
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
return(false);
}
}
public frm_CuonSach()
{
InitializeComponent();
cuonSachBUS = new CuonSach_BUS();
cuonSachDTO = new CuonSach_DTO();
KhoiTaoCmbTimKiem();
KhoiTaoCmbMaDauSach();
}
private CuonSach_DTO LayTT()
{
CuonSach_DTO cs = new CuonSach_DTO();
cs.MaSach = txtMaSach.Text;
cs.TinhTrangSach = cboTinhTrang.Text;
return(cs);
}
public bool KiemTra(CuonSach_DTO cs)
{
if (cs.MaSach == "" || cs.MaDauSach == "" || cs.TinhTrang == "" || cs.NgayNhap == "")
{
return(false);
}
return(true);
}
public bool SuaCS(CuonSach_DTO cs)
{
string sql = string.Format("UPDATE CUONSACH SET TinhTrangSach=N'{1}' WHERE MaSach='{0}'",
cs.MaSach, cs.TinhTrangSach);
connData.ThucThiSQL(sql);
MessageBox.Show("Sửa tình trạng Sách thành công !", "Thông tin", MessageBoxButtons.OK, MessageBoxIcon.Information);
return(true);
}
private void SetCheckedListBox()
{
if (lstCuonSachTrongPhieuMuon != null)
{
for (int i = 0; i < chklstCuonSach.Items.Count; i++)
{
CuonSach_DTO cs = chklstCuonSach.Items[i] as CuonSach_DTO;
foreach (CuonSach_DTO obj in lstCuonSachTrongPhieuMuon)
{
if (cs.MaCuonSach == obj.MaCuonSach)
{
chklstCuonSach.SetItemChecked(i, true);
}
}
}
}
}
public bool Insert(CuonSach_DTO cuonSach)
{
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
string sqlQuery = @"insert into CUONSACH (MaSach, MaDauSach, TinhTrang, NgayNhap, ChuThich) values(N'" + cuonSach.MaSach + "',N'" + cuonSach.MaDauSach + "',N'" + cuonSach.TinhTrang + "',N'" + cuonSach.NgayNhap + "',N'" + cuonSach.ChuThich + "') ";
SqlCommand cmd = new SqlCommand(sqlQuery, con);
cmd.ExecuteNonQuery();
con.Close();
return(true);
}
catch
{
return(false);
}
}
public List <CuonSach_DTO> LoadTatCaCuonSachCheckBoxList()
{
try
{
List <CuonSach_DTO> lstCuonSach = new List <CuonSach_DTO>();
string query = "SELECT cs.*, ds.TenDauSach FROM CuonSach cs INNER JOIN DauSach ds ON cs.MaDauSach = ds.MaDauSach WHERE cs.TinhTrangSach = 1";
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
CuonSach_DTO cs = new CuonSach_DTO(item);
lstCuonSach.Add(cs);
}
return(lstCuonSach);
}
catch (Exception ex)
{
return(null);
}
}
internal List <CuonSach_DTO> LoadCuonSachCuaPhieuMuon(string soPhieuMuon)
{
try
{
List <CuonSach_DTO> lstCuonSach = new List <CuonSach_DTO>();
string query = "SELECT cs.* FROM dbo.CuonSach cs INNER JOIN dbo.ThongTinMuonTra tt ON tt.MaCuonSach = cs.MaCuonSach WHERE tt.SoPhieuMuon = '" + soPhieuMuon + "'";
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
CuonSach_DTO cs = new CuonSach_DTO(item);
lstCuonSach.Add(cs);
}
return(lstCuonSach);
}
catch (Exception ex)
{
return(null);
}
}
private void btnThem_Click(object sender, EventArgs e)
{
List <ThongTinMuonTra_DTO> lstThongTin = new List <ThongTinMuonTra_DTO>();
for (int i = 0; i < chklstCuonSach.CheckedItems.Count; i++)
{
ThongTinMuonTra_DTO tt = new ThongTinMuonTra_DTO();
CuonSach_DTO cs = chklstCuonSach.CheckedItems[i] as CuonSach_DTO;
tt.MaCuonSach = cs.MaCuonSach;
tt.SoPhieuMuon = txtSoPhieuMuon.Text;
lstThongTin.Add(tt);
}
int kq = ThongTinMuonTra_DAO.Instance.ThemChiTietPhieuMuon(lstThongTin);
if (kq > 0)
{
MessageBox.Show("Đã thêm chi tiết phiếu mượn");
this.Close();
}
else
{
MessageBox.Show("Thêm chi tiết phiếu mượn thất bại");
}
}
public bool Update(CuonSach_DTO cs)
{
return(cuonsach.Update(cs));
}
public bool Delete(CuonSach_DTO cs)
{
return(cuonsach.Delete(cs));
}
public bool Insert(CuonSach_DTO cs)
{
return(cuonsach.Insert(cs));
}
