//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)); }