public int ThemChiTietPhieuMuon(List <ThongTinMuonTra_DTO> lstThongTin)
{
try
{
string query = "INSERT dbo.ThongTinMuonTra (MaCuonSach, SoPhieuMuon, NgayTra, TinhTrangSach, MaViPham ) VALUES ";
for (int i = 0; i < lstThongTin.Count; i++)
{
ThongTinMuonTra_DTO tt = lstThongTin[i];
if (i < lstThongTin.Count - 1)
{
query += "('" + tt.MaCuonSach + "','" + tt.SoPhieuMuon + "', NULL, 100, NULL),";
}
else
{
query += "('" + tt.MaCuonSach + "','" + tt.SoPhieuMuon + "', NULL, 100, NULL)";
}
}
int kq = DataProvider.Instance.ExecuteNonQuery(query);
return(kq);
}
catch (Exception ex)
{
return(0);
}
}
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 List <ThongTinMuonTra_DTO> LoadTatCaThongTinMuonTra()
{
try
{
List <ThongTinMuonTra_DTO> lstThongTinMuonTra = new List <ThongTinMuonTra_DTO>();
string query = "SELECT tt.*, ds.TenDauSach FROM ThongTinMuonTra tt INNER JOIN CuonSach cs ON tt.MaCuonSach = cs.MaCuonSach" +
" INNER JOIN DauSach ds ON cs.MaDauSach = ds.MaDauSach";
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
ThongTinMuonTra_DTO thongTin = new ThongTinMuonTra_DTO(item);
lstThongTinMuonTra.Add(thongTin);
}
return(lstThongTinMuonTra);
}
catch (Exception ex)
{
return(null);
}
}
