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