private void QuangCao()
{
string sql = "select top 3 * from QUANGCAO order by NgayBatDau desc ";
gvQC.DataSource = x.GetDaTa(sql);
gvQC.DataBind();
}
private void Nhacmoi()
{
String sql = "select top 10 * from BAIHAT order by LuotXemBaiHat desc";
dlDSbaihatmoi.DataSource = x.GetDaTa(sql);
dlDSbaihatmoi.DataBind();
}
private void VideoCaNhac()
{
string sql = "select top 6 * from VIDEO order by NgayCapNhat desc";
dlVideoHot.DataSource = x.GetDaTa(sql);
dlVideoHot.DataBind();
}
private void XuatChiTietNhac()
{
string sql = "select * from VIDEO where MaTL= '" + Request.QueryString["MaTL"].ToString() + "'";
dlVideoTL.DataSource = x.GetDaTa(sql);
dlVideoTL.DataBind();
}
private void XuatTheLoai()
{
string sql = "select * from THELOAI";
Dltheloai.DataSource = x.GetDaTa(sql);
Dltheloai.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["UserAdmin"] == null)
{
Response.Redirect("~/Dangnhap.aspx");
}
else
{
string sql = "select *from THELOAI";
DataTable dt = new DataTable();
dt = x.GetDaTa(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
ddlThemTL.Items.Add(i.ToString());
ddlThemTL.Items[i].Text = dt.Rows[i]["TenTL"].ToString();
ddlThemTL.Items[i].Value = dt.Rows[i]["MaTL"].ToString();
}
Calendar1.SelectedDate = DateTime.Today;
}
// CKFinder.FileBrowser _FileBrowser = new CKFinder.FileBrowser();
//_FileBrowser.BasePath = "CK/ckfinder";
// _FileBrowser.SetupCKEditor(txtLoiBaiHat);
}
}
private void NhacTheoTheLoai()
{
string sql = "select * from THELOAI";
dlTheloai.DataSource = x.GetDaTa(sql);
dlTheloai.DataBind();
}
private void XuatVideochitiet()
{
string sql = "select * from VIDEO where MAVD= '" + Request.QueryString["MAVD"].ToString() + "'";
dlChitietvideo.DataSource = x.GetDaTa(sql);
dlChitietvideo.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
int stt = Convert.ToInt32(Request.QueryString["STT"]);
if (!IsPostBack)
{
if (Session["UserAdmin"] == null)
{
Response.Redirect("~/Dangnhap.aspx");
}
else
{
string sql1 = "select * from QUANGCAO where STT=" + stt;
DataTable dt1 = new DataTable();
dt1 = x.GetDaTa(sql1);
if (dt1.Rows.Count != 0)
{
txtSuaTenCty.Text = dt1.Rows[0][1].ToString();
txtHref.Text = dt1.Rows[0][3].ToString();
txtNgaybatdau.Text = dt1.Rows[0][4].ToString();
txtNgayhethan.Text = dt1.Rows[0][5].ToString();
}
}
}
}
protected void btDongy_Click(object sender, EventArgs e)
{
string TenDN = txtTenDN.Text;
string MatKhau = txtMatkhau.Text;
string Matkhaumoi = txtMatkhaumoi.Text;
string LenhSql = "select * from THANHVIEN where TenDN=N'" + TenDN + "'and MatKhau='" + MatKhau + "'";
try
{
DataTable dt = new DataTable();
dt = x.GetDaTa(LenhSql);
if (dt.Rows.Count != 0)
{
string LenhCapNhat = "UPDATE THANHVIEN Set MatKhau='" + Matkhaumoi + "'where TenDN=N'" + TenDN + "'";
x.thuchienlenh(LenhCapNhat);
Response.Redirect("~/Dangnhap.aspx");
}
else
{
lbBaoloi.Text = "Tên đăng nhập hoặc mật khẩu không đúng";
}
}
catch
{
lbBaoloi.Text = "Thất Bại!";
}
}
private void NhacMP3()
{
String sql = "select top 22 * from BAIHAT order by NgayCapNhat desc ";
dlNhacMp3.DataSource = x.GetDaTa(sql);
dlNhacMp3.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
int Id = Convert.ToInt32(Request.QueryString["Id"]);
if (!IsPostBack)
{
if (Session["UserAdmin"] == null)
{
Response.Redirect("~/Dangnhap.aspx");
}
else
{
string sql = "select *from THELOAI";
DataTable dt = new DataTable();
dt = x.GetDaTa(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
ddlSuaTL.Items.Add(i.ToString());
ddlSuaTL.Items[i].Text = dt.Rows[i]["TenTL"].ToString();
ddlSuaTL.Items[i].Value = dt.Rows[i]["MaTL"].ToString();
}
Calendar1.SelectedDate = DateTime.Today;
string sql1 = "select * from BAIHAT where Id=" + Id;
DataTable dt1 = new DataTable();
dt1 = x.GetDaTa(sql1);
if (dt1.Rows.Count != 0)
{
txtSuaTenBH.Text = dt1.Rows[0][2].ToString();
txtSuaURLBH.Text = dt1.Rows[0][1].ToString();
txtSuaCaSi.Text = dt1.Rows[0][3].ToString();
ddlSuaTL.Text = dt1.Rows[0][4].ToString();
txtNgaycapnhat.Text = dt1.Rows[0][6].ToString();
txtSuaTG.Text = dt1.Rows[0][5].ToString();
txtSuaLoiBH.Text = dt1.Rows[0][7].ToString().Replace("\n", "<br>");
}
}
}
}
private void XuatDSVideo()
{
try
{
string sql = "select * From VIDEO";
gvDSVideo.DataSource = x.GetDaTa(sql).DefaultView;
gvDSVideo.DataBind();
}
catch
{
lbBaoLoiDSVideo.Text = "Thất bại!";
}
}
private void Search()
{
string sql = "select * from BAIHAT where TenBH COLLATE SQL_Latin1_General_Cp1_CI_AI like N'%" + Request.QueryString["TenBH"].ToString() + "%' COLLATE SQL_Latin1_General_Cp1_CI_AI";
DataTable all = x.GetDaTa(sql);
DataColumn col = new DataColumn();
col.DataType = Type.GetType("System.String");
col.ColumnName = "TimKiem";
all.Columns.Add(col);
//contruct null for timkiem
int n = all.Rows.Count;
if (n > 0)
{
isFound = true;
for (int i = 0; i < n; i++)
{
all.Rows[i]["TimKiem"] = "";
}
}
dlSearch.DataSource = all;
dlSearch.DataBind();
}
private void XuatDSBaiHat()
{
try
{
string sql = "select * From BAIHAT";
gvDSBHat.DataSource = x.GetDaTa(sql).DefaultView;
gvDSBHat.DataBind();
/*DataTable dt = x.Docbang("Select *from BAIHAT");
* gvDSBHat.DataSource = dt;
* gvDSBHat.DataBind();*/
}
catch
{
lbBaoLoiBaiHat.Text = "Thất bại!";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["UserName"] == null)
{
Response.Redirect("~/Dangnhap.aspx");
}
else
{
string sql = "select * from THELOAI";
DataTable dt = new DataTable();
dt = x.GetDaTa(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
ddlTheloai.Items.Add(i.ToString());
ddlTheloai.Items[i].Text = dt.Rows[i]["TenTL"].ToString();
ddlTheloai.Items[i].Value = dt.Rows[i]["MaTL"].ToString();
}
}
}
}
private void XuatNhacchitiet()
{
string id = Request.QueryString["Id"].ToString();
string sql = "select * from BAIHAT where Id= '" + id + "'";
//dlChiTietNhac.DataSource = x.GetDaTa(sql);
//dlChiTietNhac.DataBind();
DataTable tb = x.GetDaTa(sql);
dlChiTietNhac.DataSource = tb;
dlChiTietNhac.DataBind();
string link = "<canvas id='canvas' width=500 height=150></canvas><br/><audio id=audio Controls><Source src=/api/Audio/" + id + " type=audio/mpeg></video>";
//(dlChiTietNhac.Items[0].FindControl("plPlay") as Literal).Text = link;
foreach (DataListItem item in dlChiTietNhac.Items)
{
Literal myLiteral = (Literal)item.FindControl("plPlay");
myLiteral.Text = link;
}
}
