public List <Nhac> TimNhac(string maBH) { List <Nhac> dsNhac = new List <Nhac>(); getConnection(); string sqlString = "SELECT * FROM Music WHERE MusicID=@mabh"; SqlCommand cmd = new SqlCommand(sqlString, conn); cmd.Parameters.AddWithValue("mabh", maBH); SqlDataReader data = cmd.ExecuteReader(); while (data.Read()) { Nhac song = new Nhac(data["MusicID"].ToString(), data["MusicTitle"].ToString(), data["Album"].ToString(), DateTime.Parse(data["DatePublic"].ToString()), data["ArtistID"].ToString()); dsNhac.Add(song); } data.Close(); closeConnection(); return(dsNhac); }
protected void Page_Load(object sender, EventArgs e) { if (Session["dsnhac"] != null) { lst = (List <Nhac>)Session["dsnhac"]; } else { lst = new List <Nhac>(); } if (Request.QueryString["id"] != null) { string ma = Request.QueryString["id"].ToString(); Nhac x = lst.Where(t => t.MaBH == ma).FirstOrDefault(); if (x != null) { nhac.InnerHtml = "<h2>" + x.TuaBH + "</h2>" + "<p><embed src='" + x.FileNhac + "'><br/><br/>" + "<img src='" + x.AnhBia + "' class='x-bia'><br/><br/>" + "Ma bai hat: " + x.MaBH + "<br/>" + "Tua bai hat: " + x.TuaBH + "<br/>" + "Ca sy: " + x.CaSy + "<br/>" + "Gioi tinh ca sy: " + x.GioiTinh + "<br/>" + "Email ca sy: " + x.Email + "<br/>" + "The loai: " + x.TheLoai + "<br/>" + "</p>"; } } }
protected void BtnThem_Click(object sender, EventArgs e) { if (FileAnh.PostedFile != null && FileNhac.PostedFile != null) { try { string fileImg = Path.GetFileName(FileAnh.PostedFile.FileName); string fileAudio = Path.GetFileName(FileNhac.PostedFile.FileName); FileAnh.SaveAs(Server.MapPath("Imgs/" + fileImg)); FileNhac.SaveAs(Server.MapPath("Audios/" + fileAudio)); Nhac x = new Nhac(txtMa.Text.Trim() , txtTuaBH.Text.Trim() , txtCasy.Text.Trim() , txtGioiTinh.Text.Trim() , txtEmail.Text.Trim() , txtTheLoai.Text.Trim() , txtNam.Text.Trim() , "Imgs/" + fileImg , "Audios/" + fileAudio); lst.Add(x); thongbao.InnerHtml = "Them thanh cong!"; } catch (Exception ex) { Response.Write(ex.Message); } } else { thongbao.InnerHtml = "Them that bai!"; } }
public bool SuaNhac(Nhac song) { getConnection(); string sqlString = "UPDATE Music SET MusicTitle=@tenBH, Album=@album, DatePublic=@date, ArtistID=@maCS WHERE MusicID=@maBH"; SqlCommand cmd = new SqlCommand(sqlString, conn); cmd.Parameters.AddWithValue("maBH", song.MaBaiHat); cmd.Parameters.AddWithValue("tenBH", song.TenBaiHat); cmd.Parameters.AddWithValue("album", song.Album); cmd.Parameters.AddWithValue("date", song.NgayRaMat); cmd.Parameters.AddWithValue("maCS", song.MaCaSi); int check = cmd.ExecuteNonQuery(); closeConnection(); return(check > 0); }
public bool ThemNhac(Nhac song) { getConnection(); string sqlString = "INSERT INTO Music VALUES(@maBH, @tenBH, @album, @date, @maCS)"; SqlCommand cmd = new SqlCommand(sqlString, conn); cmd.Parameters.AddWithValue("maBH", song.MaBaiHat); cmd.Parameters.AddWithValue("tenBH", song.TenBaiHat); cmd.Parameters.AddWithValue("album", song.Album); cmd.Parameters.AddWithValue("date", song.NgayRaMat); cmd.Parameters.AddWithValue("maCS", song.MaCaSi); int check = cmd.ExecuteNonQuery(); closeConnection(); return(check > 0); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { if (Session["dsnhac"] != null) { lst = (List <Nhac>)Session["dsnhac"]; } else { lst = new List <Nhac>(); } if (Request.QueryString["id"] != null) { string ma = Request.QueryString["id"].ToString(); Nhac x = lst.Where(t => t.MaBH == ma).FirstOrDefault(); if (x != null) { lst.Remove(x); } Session["dsnhac"] = lst; } string s = "<table border=1" + " style='border-collapse: collapse;' width=800>" + "<tr><th>Ma bai hat</th><th>Tua bai hat</th>" + "<th>Ca sy</th><th>The loai</th>" + "<th></th><th></th></tr>"; foreach (var i in lst) { s += "<tr><td>" + i.MaBH + "</td>" + "<td>" + i.TuaBH + "</td>" + "<td>" + i.CaSy + "</td>" + "<td>" + i.TheLoai + "</td>" + "<td><a href='NgheNhac.aspx'>Nghe nhac</a></td>" + "<td><a href='DanhSach.aspx?id=" + i.MaBH + "'>Xoa</a></td>" + "</tr>"; } ds.InnerHtml = s + "</table>"; } }
private void btnThem_Click(object sender, EventArgs e) { string maBH = txtMaBH.Text; string tenBH = txtTenBH.Text; string album = txtAlbum.Text; DateTime date = dtpNgay.Value; string maCaSi = cboCaSi.SelectedValue.ToString(); Nhac song = new Nhac(maBH, tenBH, album, date, maCaSi); NhacBUL songBUL = new NhacBUL(); if (songBUL.ThemNhac(song)) { MessageBox.Show("Thêm thành công!"); ResetFields(); } else { MessageBox.Show("Thêm thất bại!"); } }
public List <Nhac> DanhSach() { List <Nhac> dsNhac = new List <Nhac>(); getConnection(); string sqlString = "SELECT * FROM Music"; SqlCommand cmd = new SqlCommand(sqlString, conn); SqlDataReader data = cmd.ExecuteReader(); while (data.Read()) { Nhac song = new Nhac(data["MusicID"].ToString(), data["MusicTitle"].ToString(), data["Album"].ToString(), DateTime.Parse(data["DatePublic"].ToString()), data["ArtistID"].ToString()); dsNhac.Add(song); } data.Close(); closeConnection(); return(dsNhac); }
public bool SuaNhac(Nhac song) { return(songDAL.SuaNhac(song)); }
public bool ThemNhac(Nhac song) { return(songDAL.ThemNhac(song)); }