public void UpdateSach_DAL(Sach sach, ThongTinXuatBan thongTin)
{
string query_updateSach = string.Format("update Sach set TenSach = '{0}', GiaMua = {1}, TenLoaiSach = '{2}', TenTacGia = '{3}', TenLinhVuc = '{4}' where MaSach = {5}",
sach.TenSach, sach.GiaMua, sach.TenLoaiSach, sach.TenTacGia, sach.TenLinhVuc, sach.MaSach);
DBHelper.Instance.ExecuteDB(query_updateSach);
string query_UpdateTTXB = string.Format("update ThongTinXuatBan set LanTaiBan = '{0}', NamXuatBan = '{1}', NhaXuatBan = '{2}', GiaBia = {3} where MaSach = {4}",
thongTin.LanTaiBan, thongTin.NamXuatBan, thongTin.NhaXuatBan, thongTin.GiaBia, thongTin.MaSach);
DBHelper.Instance.ExecuteDB(query_UpdateTTXB);
}
private ThongTinXuatBan GetThongTinXuatBan()
{
try
{
ThongTinXuatBan thongTin = new ThongTinXuatBan();
if (txtBookID.Text != "")
{
thongTin.MaSach = Convert.ToInt32(txtBookID.Text);
}
thongTin.LanTaiBan = numLanTaiBan.Value.ToString();
thongTin.NamXuatBan = numNamXuatBan.Value.ToString();
thongTin.NhaXuatBan = txtNXB.Text;
thongTin.GiaBia = Convert.ToInt32(numGiaBan.Value);
return(thongTin);
}
catch
{
MessageBox.Show("entered wrong format");
return(null);
}
}
public void ExecuteSach(Sach sach, ThongTinXuatBan thongTin)
{
bool check = false;
foreach (DataRow i in DAL_Sach.Instance.getAllSach_DAL().Rows)
{
if (Convert.ToInt32(i["MaSach"]) == sach.MaSach)
{
check = true;
break;
}
}
if (check)
{
UpdateBook_BLL(sach, thongTin);
}
else
{
AddBook_BLL(sach, thongTin);
}
}
public void AddSach_DAL(Sach sach, ThongTinXuatBan thongTin)
{
string query_insertSach = string.Format("insert into Sach values ('{0}', {1}, '{2}', '{3}', '{4}')",
sach.TenSach, sach.GiaMua, sach.TenLoaiSach, sach.TenTacGia, sach.TenLinhVuc);
DBHelper.Instance.ExecuteDB(query_insertSach);
string query = "SELECT TOP 1 MaSach FROM Sach ORDER BY MaSach DESC";
int masach = -1;
foreach (DataRow i in DBHelper.Instance.GetRecord(query).Rows)
{
masach = Convert.ToInt32(i[0]);
}
string query_insertTTXB = string.Format("insert into ThongTinXuatBan values ({0}, '{1}', '{2}', '{3}', {4})",
masach, thongTin.LanTaiBan, thongTin.NamXuatBan, thongTin.NhaXuatBan, thongTin.GiaBia);
DBHelper.Instance.ExecuteDB(query_insertTTXB);
}
public void UpdateBook_BLL(Sach sach, ThongTinXuatBan thongTin)
{
DAL_Sach.Instance.UpdateSach_DAL(sach, thongTin);
}
public void AddBook_BLL(Sach sach, ThongTinXuatBan thongTin)
{
DAL_Sach.Instance.AddSach_DAL(sach, thongTin);
}
