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