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