public int Them(EBook_DTO Ebook) { DataAccess data = new DataAccess(); string cmd = @"INSERT INTO EBook(MaEbook,TenSach, MaTG ,MaTL, MaNXB, NamXB, FilePDF, HinhAnh, DinhDang, DungLuong ) VALUES(@MaEbook,@TenSach ,@MaTG, @MaTL,@MaNXB,@NamXB,@FilePDF,@HinhAnh,@DinhDang,@DungLuong) "; SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@MaEbook", Ebook.MaEbook), new SqlParameter("@TenSach", Ebook.TenSach), new SqlParameter("@MaTG", Ebook.MaTG), new SqlParameter("@MaTL", Ebook.MaTL), new SqlParameter("@MaNXB", Ebook.MaNXB), new SqlParameter("@NamXB", Ebook.NamXB), new SqlParameter("@FilePDF", Ebook.FilePDF), new SqlParameter("@HinhAnh", Ebook.HinhAnh), new SqlParameter("@DinhDang", Ebook.DinhDang), new SqlParameter("@DungLuong", Ebook.DungLuong) }; int result = data.AddData(cmd, parameter); return(result); }
private void btnThemE_Click(object sender, EventArgs e) { EBook_DTO ebookDTO = new EBook_DTO(); ebookDTO.MaEbook = txtMaEbook.Text; ebookDTO.TenSach = txtTenSach.Text; ebookDTO.MaTG = txtMaTGEbook.Text; ebookDTO.MaTL = txtMaTLEbook.Text; ebookDTO.MaNXB = txtMaNXBEbook.Text; ebookDTO.NamXB = txtNamXBEbook.Text; ebookDTO.FilePDF = txtPDFEbook.Text; ebookDTO.HinhAnh = txtImageEbook.Text; ebookDTO.DinhDang = txtDinhDang.Text; ebookDTO.DungLuong = txtDungLuong.Text; EBook_BO ebookBO = new EBook_BO(); int result = 0; result = ebookBO.Them(ebookDTO); if (result > 0) { MessageBox.Show("Thêm thông tin thành công"); } else { MessageBox.Show("Thông tin này đã tồn tại!"); } }
public int Sua(EBook_DTO Ebook) { DataAccess data = new DataAccess(); string cmd = @"UPDATE EBook SET TenSach=@TenSach, MaTG=@MaTG ,MaTL=@MaTL, MaNXB=@MaNXB, NamXB=@NamXB, FilePDF=@FilePDF, HinhAnh=@HinhAnh, DinhDang=@DinhDang, DungLuong=@DungLuong WHERE MaEbook=@MaEbook "; SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@MaEbook", Ebook.MaEbook), new SqlParameter("@TenSach", Ebook.TenSach), new SqlParameter("@MaTG", Ebook.MaTG), new SqlParameter("@MaTL", Ebook.MaTL), new SqlParameter("@MaNXB", Ebook.MaNXB), new SqlParameter("@NamXB", Ebook.NamXB), new SqlParameter("@FilePDF", Ebook.FilePDF), new SqlParameter("@HinhAnh", Ebook.HinhAnh), new SqlParameter("@DinhDang", Ebook.DinhDang), new SqlParameter("@DungLuong", Ebook.DungLuong) }; return(data.AddData(cmd, parameter)); }