private void btnBookUpdate_Update_Click(object sender, EventArgs e) { Sach_DTO sach_DTO = new Sach_DTO { MaSach = lblBookUpdate_ID.Text, TenSach = txtBookUpdate_TitleOfBook.Text, MaDauSach = lblBookUpdate_TitleID.Text, TenTacGia = txtBookUpdate_Author.Text, TenNhaXuatBan = txtBookUpdate_Publisher.Text, SoLuong = int.Parse(numBookUpdate_NumberOfBooks.Value.ToString()), NamXuatBan = int.Parse(txtBookUpdate_PublicDate.Text), DonGia = decimal.Parse(txtBookUpdate_Prices.Text), TrangThai = true }; DauSach_DTO dauSach_DTO = new DauSach_DTO { MaDauSach = lblBookUpdate_TitleID.Text, TenDauSach = txtBookUpdate_TitleOfBook.Text, MaTheLoai = comBookUpdate_Category.SelectedValue.ToString(), TrangThai = true }; DauSach_BUS dauSach_BUS = new DauSach_BUS(); if (dauSach_BUS.SuaDauSach(dauSach_DTO) == true) { Sach_BUS sach_BUS = new Sach_BUS(); if (sach_BUS.SuaSach(sach_DTO) == true) { CTNhapSach_BUS cTNhapSach_BUS = new CTNhapSach_BUS(); CTNhapSach_DTO cTNhapSach_DTO = cTNhapSach_BUS.TimCTNhapSachTheoMaSach(lblBookUpdate_ID.Text); cTNhapSach_DTO.SoLuong = int.Parse(numBookUpdate_NumberOfBooks.Value.ToString()); cTNhapSach_DTO.DonGia = double.Parse(txtBookUpdate_Prices.Text); if (cTNhapSach_BUS.SuaCTNhapSach(cTNhapSach_DTO) == true) { NhapSach_BUS nhapSach_BUS = new NhapSach_BUS(); NhapSach_DTO nhapSach_DTO = nhapSach_BUS.TimNhapSachTheoMaNhap(cTNhapSach_DTO.MaNhap); nhapSach_DTO.ThanhTien = double.Parse(txtBookUpdate_Prices.Text) * int.Parse(numBookUpdate_NumberOfBooks.Value.ToString()); if (nhapSach_BUS.SuaNhapSach(nhapSach_DTO) == true) { frmSuccess frm_Success = new frmSuccess(2); frm_Success.ShowDialog(); this.Hide(); } } } } else { frmFailed frm_Failed = new frmFailed(2); frm_Failed.Show(); } }
private void rdTenSach_CheckedChanged(object sender, EventArgs e) { DauSach_DTO ds = new DauSach_DTO(); ds.TenDauSach = txtThongTinSach.Text; dgvSach.DataSource = Sach_BUS.SelectSachLikeNameDanhSachSach(ds); }
public bool UpDate(DauSach_DTO dausach) { try { if (con.State == ConnectionState.Closed) { con.Open(); } SqlCommand cmd; string sqlQuyery1 = "select count(*) from DAUSACh where MaDauSach = '" + dausach.MaDauSach + "'"; cmd = new SqlCommand(sqlQuyery1, con); var i = cmd.ExecuteScalar(); if (int.Parse(i.ToString()) == 0) { return(false); } else { string sqlQuery = @"Update DAUSACH set TenDauSach = N'" + dausach.TenDauSach + "',TacGia = N'" + dausach.TacGia + "',TenTheLoai = N'" + dausach.TenTheLoai + "',NamSanXuat = " + dausach.NamSanXuat + ",NhaSanXuat = N'" + dausach.NhaSanXuat + "',Gia = " + dausach.Gia + ",SoLuong = " + dausach.SoLuong + " where MaDauSach = '" + dausach.MaDauSach + "'"; cmd = new SqlCommand(sqlQuery, con); cmd.ExecuteNonQuery(); con.Close(); return(true); } } catch { return(false); } }
private void btnBookAdd_Add_Click(object sender, EventArgs e) { Sach_DTO sachDTO = new Sach_DTO(); sachDTO.MaSach = lblBook_ID.Text; sachDTO.TenSach = txtBookAdd_TitleOfBook.Text; sachDTO.MaDauSach = lblBook_SeriesOfBook.Text; sachDTO.TenTacGia = txtBookAdd_Author.Text; sachDTO.TenNhaXuatBan = txtBookAdd_Publisher.Text; sachDTO.SoLuong = int.Parse(numBookAdd_NumberOfBooks.Value.ToString()); sachDTO.NamXuatBan = int.Parse(txtBookAdd_PublicDate.Text); sachDTO.DonGia = decimal.Parse(txtBookAdd_Prices.Text); sachDTO.TrangThai = true; DauSach_DTO dauSachDTO = new DauSach_DTO(); dauSachDTO.MaDauSach = lblBook_SeriesOfBook.Text; dauSachDTO.TenDauSach = txtBookAdd_TitleOfBook.Text; dauSachDTO.MaTheLoai = comBook_Category.SelectedValue.ToString(); dauSachDTO.TrangThai = true; CTNhapSach_DTO cTNhapSach_DTO = new CTNhapSach_DTO(); cTNhapSach_DTO.MaNhap = nhapSach_BUS.PhatSinhMaNhapSach(); cTNhapSach_DTO.MaSach = lblBook_ID.Text; cTNhapSach_DTO.SoLuong = int.Parse(numBookAdd_NumberOfBooks.Value.ToString()); cTNhapSach_DTO.DonGia = double.Parse(txtBookAdd_Prices.Text); cTNhapSach_DTO.TrangThai = true; NhapSach_DTO nhapSach_DTO = new NhapSach_DTO(); nhapSach_DTO.MaNhap = nhapSach_BUS.PhatSinhMaNhapSach(); nhapSach_DTO.MaNV = DoAn.frmLOGIN.MaNV; nhapSach_DTO.NgayNhap = DateTime.Now; nhapSach_DTO.ThanhTien = int.Parse(numBookAdd_NumberOfBooks.Value.ToString()) * double.Parse(txtBookAdd_Prices.Text); nhapSach_DTO.TrangThai = true; if (dauSach_BUS.ThemDauSach(dauSachDTO) == true) { if (sach_BUS.ThemSachMotDongSach(sachDTO) == true) { if (nhapSach_BUS.ThemNhapSach(nhapSach_DTO) == true) { if (cTNhapSach_BUS.ThemCTNhapSach(cTNhapSach_DTO) == true) { frmSuccess frmSuccess = new frmSuccess(1); frmSuccess.ShowDialog(); this.Hide(); } } } else { frmFailed frmFailed = new frmFailed(1); frmFailed.ShowDialog(); } } }
public bool KiemTra(DauSach_DTO dausach) { if (dausach.MaDauSach == "" || dausach.TenDauSach == "" || dausach.TacGia == "" || dausach.TenTheLoai == "" || dausach.NamSanXuat == 0 || dausach.NhaSanXuat == "" || dausach.Gia == 0 || dausach.TenDauSach.Length < 0) { return(false); } return(true); }
//Thêm đầu sách vào cơ sở dữ liệu public static string ThemDauSach(DauSach_DTO ds) { if (DauSach_DAO.SelectDauSachByName(ds.TenDauSach) == null) { return(DauSach_DAO.Insert(ds)); } else { return("Đầu sách đã tồn tại trong CSDL"); } }
//Cập nhật đầu sách public static string CapNhatDauSach(DauSach_DTO ds) { if (DauSach_DAO.SelectDauSachTheoMa(ds.MaDauSach) != null) { return(DauSach_DAO.Update(ds)); } else { return("Mã đầu sách không tồn tại trong CSDL"); } }
public void HienThiDanhSachDauSachTheoMaTheLoai(string ma) { DauSach_DTO s = new DauSach_DTO(); s.MaTheLoai = int.Parse(ma); DataTable dt = DauSach_BUS.SelectDauSachLikeMaTheLoaiDanhSachDauSach(s); if (dt.Rows.Count == 0) { dgvCTTacGia.DataSource = DauSach_BUS.SelectCTTacGiaNull(); } dgvDauSach.DataSource = dt; }
//Xóa 1 đầu sách theo mã đầu sách public static bool Delete(DauSach_DTO ds) { try { string sql = "delete from DAUSACH where MaDauSach= " + ds.MaDauSach + ""; DataAccess.ThucThiNonQuery(sql); return(true); } catch { return(false); } }
public List <DauSach_DTO> LayTatCaDauSach() { List <DauSach_DTO> DanhSachDauSach = new List <DauSach_DTO>(); DataTable data = DataProvider.Instance.ExecuteQuery("LayTatCaDauSach"); foreach (DataRow item in data.Rows) { DauSach_DTO DauSach = new DauSach_DTO(item); DanhSachDauSach.Add(DauSach); } return(DanhSachDauSach); }
public List <DauSach_DTO> TimKiemDauSach(string ten) { List <DauSach_DTO> DanhSachDauSach = new List <DauSach_DTO>(); DataTable data = DataProvider.Instance.ExecuteQuery("TimKiemDauSach @param", new object[] { ten }); foreach (DataRow item in data.Rows) { DauSach_DTO DauSach = new DauSach_DTO(item); DanhSachDauSach.Add(DauSach); } return(DanhSachDauSach); }
//Trả về đối tượng DauSach_DTO với thuộc tính mã đầu sách static public DauSach_DTO SelectDauSachTheoMa(int ma) { string sql = "select * from DAUSACH where MaDauSach=" + ma + ""; DataTable dt = DataAccess.ThucThiQuery(sql); if (dt.Rows.Count == 0) { return(null); } else { DauSach_DTO s = new DauSach_DTO(); s.MaDauSach = int.Parse(dt.Rows[0].ItemArray[0].ToString()); return(s); } }
//Trả về tên đối tượng đầu sách đầu tiên trùng với tên static public DauSach_DTO SelectDauSachByName(string name) { string sql = "select * from DAUSACH where TenDauSach=N'" + name + "'"; DataTable dt = DataAccess.ThucThiQuery(sql); if (dt.Rows.Count == 0) { return(null); } else { DauSach_DTO s = new DauSach_DTO(); s.TenDauSach = dt.Rows[0].ItemArray[0].ToString(); return(s); } }
public frm_DauSach() { InitializeComponent(); dausachBUS = new DauSach_BUS(); dausachDTO = new DauSach_DTO(); theLoai = new TheLoai_BUS(); qd2 = new QuyDinh2_BUS(); KhoiTaoCmdLoai(); KhoiTaoCmbTiemKiem(); DataTable table = new DataTable(); table = qd2.Select(); var i = table.Rows[0].ItemArray; HanNhanSach = int.Parse(i[1].ToString()); }
public void Them() { DauSach_DTO ds = new DauSach_DTO(); ds.MaTheLoai = int.Parse(cboTheLoai.SelectedValue.ToString()); ds.TenDauSach = txtTenDauSach.Text; string ketQua = DauSach_BUS.ThemDauSach(ds); if (ketQua != "Success") { MessageBox.Show(ketQua); return; } HienThiDauSach(); MessageBox.Show("Thêm đầu sách thành công"); this.Size = new Size(1248, 615); }
public void HienThiDanhSachDauSachTheoMaTheLoai(string ma) { DauSach_DTO s = new DauSach_DTO(); s.MaTheLoai = int.Parse(ma); DataTable dt = Sach_BUS.SelectSachLikeMaTheLoaiDanhSachSach(s); colTenSach.ValueMember = "MaDauSach"; colTenSach.DisplayMember = "TenDauSach"; colTenSach.DataSource = DauSach_BUS.SelectDauSachAll(); if (dt.Rows.Count == 0) { dgvSach.DataSource = Sach_BUS.SelectSachNull(); } dgvSach.DataSource = dt; }
public void CapNhat() { DauSach_DTO ds = new DauSach_DTO(); ds.MaDauSach = int.Parse(txtMaDauSach.Text); ds.MaTheLoai = int.Parse(cboTheLoai.SelectedValue.ToString()); ds.TenDauSach = txtTenDauSach.Text; string ketQua = DauSach_BUS.CapNhatDauSach(ds); if (ketQua != "Success") { MessageBox.Show(ketQua); return; } HienThiDauSach(); MessageBox.Show("Cập nhật thành công"); }
public bool SuaDauSach(DauSach_DTO dauSach_DTO) { try { DauSach dauSach = data.DauSaches.SingleOrDefault(u => u.MaDauSach == dauSach_DTO.MaDauSach); dauSach.MaDauSach = dauSach_DTO.MaDauSach; dauSach.TenDauSach = dauSach_DTO.TenDauSach; dauSach.MaTheLoai = dauSach_DTO.MaTheLoai; dauSach.TrangThai = true; data.SaveChanges(); return(true); } catch (Exception) { return(false); } }
public bool Insert(DauSach_DTO dausach) { try { if (con.State == ConnectionState.Closed) { con.Open(); } string sqlQuery = @"INSERT INTO DAUSACH(MaDauSach, TenDauSach, TacGia, TenTheLoai, NamSanXuat, NhaSanXuat, Gia, SoLuong) VALUES (N'" + dausach.MaDauSach + "', N'" + dausach.TenDauSach + "', N'" + dausach.TacGia + "',N'" + dausach.TenTheLoai + "', " + dausach.NamSanXuat + ",N'" + dausach.NhaSanXuat + "'," + dausach.Gia + "," + dausach.SoLuong + ")"; SqlCommand cmd = new SqlCommand(sqlQuery, con); cmd.ExecuteNonQuery(); con.Close(); return(true); } catch { return(false); } }
public bool Delete(DauSach_DTO dausach) { try { if (con.State == ConnectionState.Closed) { con.Open(); } string sqlQuery = "delete from DAUSACH where MaDauSach= '" + dausach.MaDauSach + "'"; SqlCommand cmd = new SqlCommand(sqlQuery, con); cmd.ExecuteNonQuery(); con.Close(); return(true); } catch { return(false); } }
public bool ThemDauSach(DauSach_DTO dauSach_DTO) { try { DauSach dauSach = new DauSach(); dauSach.MaDauSach = dauSach_DTO.MaDauSach; dauSach.TenDauSach = dauSach_DTO.TenDauSach; dauSach.MaTheLoai = dauSach_DTO.MaTheLoai; dauSach.TrangThai = true; data.DauSaches.Add(dauSach); data.SaveChanges(); return(true); } catch (Exception) { return(false); } }
//Chọn ra đầu sách theo mã thể loại static public DataTable SelectDauSachLikeMaTheLoaiDanhSachDauSach(DauSach_DTO ds) { return(DauSach_DAO.SelectDauSachLikeMaTheLoaiDanhSachDauSach(ds)); }
//Trả về bảng chứa thông tin theo MaTheLoai public static DataTable SelectSachLikeMaTheLoaiDanhSachSach(DauSach_DTO s) { string sql = "select MaSach,ds.MaDauSach,TacGia,MaTheLoai,NhaXuatBan,NamXuatBan,DonGiaBan,SoLuongTon from DAUSACH ds, CT_TACGIA ct,SACH s where ds.MaDauSach=ct.MaDauSach and ds.MaDauSach=s.MaDauSach and MaTheLoai=" + s.MaTheLoai + ""; return(DataAccess.ThucThiQuery(sql)); }
//Cập nhật 1 đầu sách theo mã đầu sách static public string Update(DauSach_DTO ds) { string sql = "update DAUSACH set TenDauSach=(N'" + ds.TenDauSach + "'),MaTheLoai=(" + ds.MaTheLoai + ") where MaDauSach = " + ds.MaDauSach + ""; return(DataAccess.ThucThiNonQuery(sql)); }
//Chọn ra đầu sách giống với tên đầu sách cần tìm trong danh sách đầu sách static public DataTable SelectDauSachLikeNameDanhSachDauSach(DauSach_DTO ds) { string sql = "select * from DAUSACH where TenDauSach like N'%" + ds.TenDauSach + "%'"; return(DataAccess.ThucThiQuery(sql)); }
//Trả về bảng chứa thông tin theo MaTheLoai public static DataTable SelectSachLikeMaTheLoaiDanhSachSach(DauSach_DTO s) { return(Sach_DAO.SelectSachLikeMaTheLoaiDanhSachSach(s)); }
//Trả về bảng chứa thông tin theo TenDauSach trong form DanhSachSach static public DataTable SelectSachLikeNameDanhSachSach(DauSach_DTO ds) { return(Sach_DAO.SelectSachLikeNameDanhSachSach(ds)); }
//Chọn ra đầu sách giống tên tác giả cần tìm trong danh sách đầu sách static public DataTable SelectDauSachLikeTacGiaDanhSachDauSach(DauSach_DTO ds) { return(DauSach_DAO.SelectDauSachLikeTacGiaDanhSachDauSach(ds)); }
static public DataTable SelectDauSachLikeMaTheLoaiDanhSachDauSach(DauSach_DTO ds) { string sql = "select * from DAUSACH where MaTheLoai like '%" + ds.MaTheLoai + "%'"; return(DataAccess.ThucThiQuery(sql)); }
//Thêm đầu sách vào bảng DAUSACH static public string Insert(DauSach_DTO s) { string sql = "insert into DAUSACH(TenDauSach,MaTheLoai) values(N'" + s.TenDauSach + "'," + s.MaTheLoai + ")"; return(DataAccess.ThucThiNonQuery(sql)); }