Пример #1
0
        public int Sua(Audio_DTO Audio)
        {
            DataAccess data = new DataAccess();

            string cmd = @"UPDATE AudioBook SET TenSach=@TenSach, MaTG=@MaTG ,MaTL=@MaTL, MaNXB=@MaNXB, NamXB=@NamXB, FileAudio=@FileAudio, HinhAnh=@HinhAnh, DinhDang=@DinhDang, DungLuong=@DungLuong,ThoiLuong=@ThoiLuong,MCAudio=@MCAudio
                           
                           WHERE MaAudio=@MaAudio
                           ";

            SqlParameter[] parameter = new SqlParameter[]
            {
                new SqlParameter("@MaAudio", Audio.MaAudio),
                new SqlParameter("@TenSach", Audio.TenSach),
                new SqlParameter("@MaTG", Audio.MaTG),
                new SqlParameter("@MaTL", Audio.MaTL),
                new SqlParameter("@MaNXB", Audio.MaNXB),
                new SqlParameter("@NamXB", Audio.NamXB),
                new SqlParameter("@FileAudio", Audio.FileAudio),
                new SqlParameter("@HinhAnh", Audio.HinhAnh),
                new SqlParameter("@DinhDang", Audio.DinhDang),
                new SqlParameter("@DungLuong", Audio.DungLuong),
                new SqlParameter("@ThoiLuong", Audio.ThoiLuong),
                new SqlParameter("@MCAudio", Audio.MCAudio)
            };
            return(data.AddData(cmd, parameter));
        }
Пример #2
0
        private void btnThemA_Click(object sender, EventArgs e)
        {
            Audio_DTO audioDTO = new Audio_DTO();

            audioDTO.MaAudio   = txtMaAudio.Text;
            audioDTO.TenSach   = txtTenSachA.Text;
            audioDTO.MaTG      = txtMaTGAbook.Text;
            audioDTO.MaTL      = txtMaTLAbook.Text;
            audioDTO.MaNXB     = txtMaNXBAbook.Text;
            audioDTO.NamXB     = txtNamXBAbook.Text;
            audioDTO.FileAudio = txtMP3Abook.Text;
            audioDTO.HinhAnh   = txtImageAbook.Text;
            audioDTO.DinhDang  = txtDinhDangA.Text;
            audioDTO.DungLuong = txtDungLuongA.Text;
            audioDTO.ThoiLuong = txtThoiLuongAbook.Text;
            audioDTO.MCAudio   = txtMCAbook.Text;

            Audio_BO audioBO = new Audio_BO();
            int      result  = 0;

            result = audioBO.Them(audioDTO);
            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!");
            }
        }
Пример #3
0
        public int Them(Audio_DTO Audio)
        {
            DataAccess data = new DataAccess();

            string cmd = @"INSERT INTO  AudioBook(MaAudio,TenSach, MaTG ,MaTL, MaNXB, NamXB, FileAudio, HinhAnh, DinhDang, DungLuong,ThoiLuong,MCAudio
                                        )
                                        VALUES(@MaAudio,@TenSach ,@MaTG, @MaTL,@MaNXB,@NamXB,@FileAudio,@HinhAnh,@DinhDang,@DungLuong,@ThoiLuong,@MCAudio) ";

            SqlParameter[] parameter = new SqlParameter[]
            {
                new SqlParameter("@MaAudio", Audio.MaAudio),
                new SqlParameter("@TenSach", Audio.TenSach),
                new SqlParameter("@MaTG", Audio.MaTG),
                new SqlParameter("@MaTL", Audio.MaTL),
                new SqlParameter("@MaNXB", Audio.MaNXB),
                new SqlParameter("@NamXB", Audio.NamXB),
                new SqlParameter("@FileAudio", Audio.FileAudio),
                new SqlParameter("@HinhAnh", Audio.HinhAnh),
                new SqlParameter("@DinhDang", Audio.DinhDang),
                new SqlParameter("@DungLuong", Audio.DungLuong),
                new SqlParameter("@ThoiLuong", Audio.ThoiLuong),
                new SqlParameter("@MCAudio", Audio.MCAudio)
            };
            int result = data.AddData(cmd, parameter);

            return(result);
        }