private void btnDelete_Click(object sender, EventArgs e)
{
var db = new DBGoMusicEntities();
if (MessageBox.Show("Do you want to delete this song?", "Confirm", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes)
{
for (int i = 0; i < this.lstSong.SelectedRows.Count; i++)
{
var row = this.lstSong.SelectedRows[i];
var item = (BaiHat)row.DataBoundItem;
try
{
BaiHat bh = db.BaiHats.Find(item.id);
db.BaiHats.Remove(bh);
db.SaveChanges(); //Do it
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
this.ShowBaiHat();
}
}
// lấy ra 1 bài hát
public BaiHat layra1BH(int mabh)
{
string sql = "select *from baihat where mabaihat=@mabaihat";
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("mabaihat", mabh);
SqlDataReader rd = cmd.ExecuteReader();
BaiHat bh = null;
if (rd.Read())
{
bh = new BaiHat();
bh.mabaihat = (int)rd["mabaihat"];
bh.tenbaihat = (string)rd["tenbaihat"];
bh.hinhanh = (string)rd["hinhanh"];
bh.loibaihat = (string)rd["loibaihat"];
bh.tacgia = (string)rd["tacgia"];
bh.matheloai = (int)rd["matheloai"];
bh.maalbum = (int)rd["maalbum"];
bh.machude = (int)rd["machude"];
bh.linkbaihat = (string)rd["linkbaihat"];
}
con.Close();
return(bh);
}
// GET: BaiHat
public ActionResult Index(int id)
{
BaiHat baiHat = data.BaiHats.SingleOrDefault(n => n.MaBaiHat == id);
ViewBag.thumuc = baiHat.MaBaiHat.ToString() + ".wav";
User user = (User)Session["TaiKhoan"];
if (user == null)
{
Download("", baiHat, false);
}
else
{
var download_user = data.DownloadBaiHats.Where(n => (n.MaBaiHat == id) && (n.MaUser == user.MaUser)).SingleOrDefault();
if (download_user == null)
{
download_user = new DownloadBaiHat();
download_user.MaBaiHat = id;
download_user.MaUser = user.MaUser;
string s = user.MaUser + "-" + user.TaiKhoanUser + "-" + baiHat.MaBaiHat + "-" + baiHat.TenBaiHat;
Download(s, baiHat, true);
string name_upload = baiHat.MaBaiHat.ToString() + "-" + user.MaUser.ToString() + ".wav";
string id_drive = Upload(name_upload, baiHat);
download_user.link = id_drive;
data.DownloadBaiHats.Add(download_user);
}
else
{
}
}
return(View(baiHat));
}
public ActionResult LoiBaiHat(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BaiHat baiHat = db.BaiHats.Find(id);
if (baiHat == null)
{
return(HttpNotFound());
}
var baihats = db.BaiHats.Include(a => a.Album);
var BaiHatList = baihats.Where(x => x.BaiHatID != baiHat.BaiHatID && x.AlbumID == baiHat.AlbumID);
var albums = db.Albums.Include(a => a.TacGia).Include(a => a.TheLoai);
var AlbumList = albums.Where(x => x.AlbumID != baiHat.AlbumID).Take(6);
BaiHatDetailAndListBaiHat all = new BaiHatDetailAndListBaiHat
{
baiHat = baiHat,
ListBaiHat = BaiHatList.ToList(),
albums = AlbumList.ToList()
};
return(View(all));
}
public BaiHat Add(BaiHat bh)
{
var baihat = _bhRepository.Add(bh);
_unitOfWork.Commit(); //cap nhat vao database
return(baihat);
}
// code lay ra BaiHat trong bang va dua vao List
public List <BaiHat> dsBaiHat()
{
List <BaiHat> ds = new List <BaiHat>();
string sql = "select * from BaiHat";
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
BaiHat bh = new BaiHat();
bh.mabaihat = (int)rd["mabaihat"];
bh.tenbaihat = (string)rd["tenbaihat"];
bh.hinhanh = (string)rd["hinhanh"];
bh.loibaihat = (string)rd["loibaihat"];
bh.tacgia = (string)rd["tacgia"];
bh.matheloai = (int)rd["matheloai"];
bh.maalbum = (int)rd["maalbum"];
bh.machude = (int)rd["machude"];
bh.linkbaihat = (string)rd["linkbaihat"];
ds.Add(bh);
}
con.Close();
return(ds);
}
protected void btnSua_Click(object sender, EventArgs e)
{
try
{
BaiHat bh = new BaiHat();
bh.mabaihat = int.Parse(txtmabaihat.Text);
bh.tenbaihat = txtten.Text;
if (anh.FileName != oldAvt)
{
string path = Server.MapPath("~/images/baihat/");
anh.PostedFile.SaveAs(path + anh.FileName);
img.ImageUrl = "~/images/baihat/" + anh.FileName;
}
bh.hinhanh = anh.FileName;
bh.loibaihat = txtloibh.Text;
bh.tacgia = txttacgia.Text;
bh.matheloai = int.Parse(txtmatl.Text);
bh.maalbum = int.Parse(txtmaalbum.Text);
bh.machude = int.Parse(txtmacd.Text);
if (linkbh.FileName != oldAudio)
{
string path1 = Server.MapPath("~/audio/");
linkbh.PostedFile.SaveAs(path1 + linkbh.FileName);
}
bh.linkbaihat = linkbh.FileName;
data.capNhatBH(bh);
msg.Text = "Cập nhật thành công";
}
catch (Exception e1)
{
msg.Text = "Có lỗi khi sửa " + e1.Message;
}
}
//Lay Bai Hat Theo ID
public BaiHat GetBaiHatById(int id)
{
context.Configuration.ProxyCreationEnabled = false;
BaiHat bh = new BaiHat();
bh = context.BaiHats.SingleOrDefault(n => n.IdBaiHat == id);
return(bh);
}
public ActionResult DeleteConfirmed(int id)
{
BaiHat baiHat = db.BaiHats.Find(id);
db.BaiHats.Remove(baiHat);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: Music
public ActionResult Index()
{
BaiHat viewModel = new BaiHat();
viewModel = _bhService.GetSingleById(1);
return(View(viewModel));
}
public ActionResult Update(BaiHat obj, HttpPostedFileBase file, FormCollection f)
{
BaiHatDAO dao = new BaiHatDAO();
try
{
if (file != null && file.ContentLength > 0)
{
string fileName = Path.GetFileNameWithoutExtension(file.FileName);
fileName += "_" + obj.IdBaiHat;
fileName += Path.GetExtension(file.FileName);
string folderPath = Server.MapPath("~") + @"\Areas\Admin\Asset\ImagesOutSource\imgsong";
string folderPath2 = Server.MapPath("~") + @"/Assets/images/ImagesOutSource/ImagesSong";
if (!Directory.Exists(folderPath))
{
Directory.CreateDirectory(folderPath);
}
string path = Path.Combine(folderPath, fileName);
string path2 = Path.Combine(folderPath2, fileName);
file.SaveAs(path);
file.SaveAs(path2);
obj.AnhBaiHat = fileName;
obj.IdNgheSi = Convert.ToInt32(f["getNgheSi"]);
if (dao.Update(obj))
{
return(RedirectToAction("Index", "AdBaiHat"));
}
else
{
ModelState.AddModelError("", "Error");
return(View(obj.IdBaiHat));
}
}
else
{
ModelState.AddModelError("", "Bạn phải nhập vào trường này");
}
}
catch
{
}
TheLoaiDAO tldao = new TheLoaiDAO();
var category = tldao.ListOf();
NgheSiDAO nsdao = new NgheSiDAO();
var nghesi = nsdao.Listof();
AlbumDAO abdao = new AlbumDAO();
var album = abdao.Listof();
ViewBag.category = category;
ViewBag.nghesi = nghesi;
ViewBag.album = album;
return(View());
}
public ActionResult CreateBH(BaiHat bh)
{
if (ModelState.IsValid)
{
db.BaiHats.InsertOnSubmit(bh);
db.SubmitChanges();
}
return(RedirectToAction("BaiHat"));
}
public IActionResult Cau01(BaiHat bh)
{
if (bh != null && bh.MaBaiHat != null)
{
StoreContext storeContext = HttpContext.RequestServices.GetService(typeof(StoreContext)) as StoreContext;
int result = storeContext.ThemBaiHat(bh);
ViewData["result"] = result;
}
return(View());
}
protected void sua_Click(object sender, CommandEventArgs e)
{
if (e.CommandName == "sua")
{
int m = Convert.ToInt16(e.CommandArgument);
BaiHat bh = data.layra1BH(m);
Session["bh"] = bh;
Response.Redirect("SuaBaiHat.aspx");
}
}
public ActionResult Edit([Bind(Include = "MaBH,TenBH,Nhac,Loi,Ma_CD")] BaiHat baiHat)
{
if (ModelState.IsValid)
{
db.Entry(baiHat).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Ma_CD = new SelectList(db.ChuDes, "MaCD", "TenCD", baiHat.Ma_CD);
return(View(baiHat));
}
public ActionResult Edit([Bind(Include = "BaiHatID,TenBaiHat,LoiBaiHat,ThoiLuong,AlbumID")] BaiHat baiHat)
{
if (ModelState.IsValid)
{
db.Entry(baiHat).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.AlbumID = new SelectList(db.Albums, "AlbumID", "TenAlbum", baiHat.AlbumID);
return(View(baiHat));
}
public ActionResult Edit([Bind(Include = "MaBH,TenBH,url,img,NoiDung,NamSX,HangSX,MaCS,MaTG")] BaiHat baiHat)
{
if (ModelState.IsValid)
{
db.Entry(baiHat).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaCS = new SelectList(db.CaSis, "MaCS", "TenCS", baiHat.MaCS);
ViewBag.MaTG = new SelectList(db.TacGias, "MaTG", "TenTG", baiHat.MaTG);
return(View(baiHat));
}
public ActionResult DeleteBH(int id)
{
BaiHat bh = db.BaiHats.SingleOrDefault(n => n.MaBH == id);
ViewBag.MaBH = bh.MaBH;
if (bh == null)
{
Response.StatusCode = 404;
return(null);
}
return(View(bh));
}
public ActionResult Create([Bind(Include = "BaiHatID,TenBaiHat,LoiBaiHat,ThoiLuong,AlbumID")] BaiHat baiHat)
{
if (ModelState.IsValid)
{
db.BaiHats.Add(baiHat);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.AlbumID = new SelectList(db.Albums, "AlbumID", "TenAlbum", baiHat.AlbumID);
return(View(baiHat));
}
public ActionResult Create([Bind(Include = "MaBH,TenBH,Nhac,Loi,Ma_CD")] BaiHat baiHat)
{
if (ModelState.IsValid)
{
db.BaiHats.Add(baiHat);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Ma_CD = new SelectList(db.ChuDes, "MaCD", "TenCD", baiHat.Ma_CD);
return(View(baiHat));
}
public ActionResult EditBH(int id)
{
BaiHat bh = db.BaiHats.SingleOrDefault(n => n.MaBH == id);
ViewBag.Ma_CD = new SelectList(db.ChuDes.ToList().OrderBy(n => n.TenCD), "MaCD", "TenCD");
ViewBag.MaBH = bh.MaBH;
if (bh == null)
{
Response.StatusCode = 404;
return(null);
}
return(View(bh));
}
// GET: BaiHats/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BaiHat baiHat = db.BaiHats.Find(id);
if (baiHat == null)
{
return(HttpNotFound());
}
return(View(baiHat));
}
public ActionResult DeleteBHConfirm(int id)
{
BaiHat bh = db.BaiHats.SingleOrDefault(n => n.MaBH == id);
ViewBag.MaBH = bh.MaBH;
if (bh == null)
{
Response.StatusCode = 404;
return(null);
}
db.BaiHats.DeleteOnSubmit(bh);
db.SubmitChanges();
return(RedirectToAction("BaiHat"));
}
// GET: Admin/BaiHat/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BaiHat baiHat = db.BaiHats.Find(id);
if (baiHat == null)
{
return(HttpNotFound());
}
ViewBag.AlbumID = new SelectList(db.Albums, "AlbumID", "TenAlbum", baiHat.AlbumID);
return(View(baiHat));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BaiHat bh = (BaiHat)Session["bh"];
txtmabaihat.Text = bh.mabaihat.ToString();
txtten.Text = bh.tenbaihat;
img.ImageUrl = "~/images/baihat/" + bh.hinhanh;
txtloibh.Text = bh.loibaihat;
txttacgia.Text = bh.tacgia;
txtmatl.Text = bh.matheloai.ToString();
txtmaalbum.Text = bh.maalbum.ToString();
txtmacd.Text = bh.machude.ToString();
}
}
// GET: BaiHats/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BaiHat baiHat = db.BaiHats.Find(id);
if (baiHat == null)
{
return(HttpNotFound());
}
ViewBag.Ma_CD = new SelectList(db.ChuDes, "MaCD", "TenCD", baiHat.Ma_CD);
return(View(baiHat));
}
public int AddNew(BaiHat obj)
{
obj.LuotNghe = 0;
obj.LuotThich = 0;
obj.LuotTai = 0;
obj.Top100 = false;
var result = context.BaiHats.Add(obj);
if (result != null)
{
context.SaveChanges();
return(result.IdBaiHat);
}
return(-1);
}
public ActionResult EditBH(BaiHat bh)
{
var b = db.BaiHats.SingleOrDefault(n => n.MaBH == bh.MaBH);
if (ModelState.IsValid)
{
b.TenBH = bh.TenBH;
b.Nhac = bh.Nhac;
b.Loi = bh.Loi;
b.Ma_CD = bh.Ma_CD;
db.SubmitChanges();
}
return(RedirectToAction("BaiHat"));
}
public ActionResult OneArtist(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BaiHat baiHat = db.BaiHats.Find(id);
if (baiHat == null)
{
return(HttpNotFound());
}
TacGia tacgia = db.TacGias.Find(id);
return(View(tacgia));
}
// GET: BaiHat/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BaiHat baiHat = db.BaiHats.Find(id);
if (baiHat == null)
{
return(HttpNotFound());
}
ViewBag.MaCS = new SelectList(db.CaSis, "MaCS", "TenCS", baiHat.MaCS);
ViewBag.MaTG = new SelectList(db.TacGias, "MaTG", "TenTG", baiHat.MaTG);
return(View(baiHat));
}
protected void Page_Load(object sender, EventArgs e)
{
var logged = Security.IsAuthenticated();
var Id = Request["Id"];
var PDVDV_Id = Request["PDVDV_Id"];
var IdNull = string.IsNullOrEmpty(Id);
var PDV_ID = Request["BH_PDV_ID"];
var BH_ID = Request["BH_ID"];
var STT = Request["STT"];
var Ten = Request["Ten"];
var refUrl = Request["refUrl"];
if (!string.IsNullOrEmpty(refUrl))
refUrl = Server.UrlDecode(refUrl);
switch (subAct)
{
case "save":
#region save Bai hat
if (!string.IsNullOrEmpty(PDV_ID))
{
var item = new BaiHat();
item.ID = Guid.NewGuid();
item.PDV_ID = new Guid(PDV_ID);
item.NgayTao = DateTime.Now;
item.NgayCapNhat = DateTime.Now;
item.NguoiTao = Security.UserId;
item.Ten = Ten;
if (!string.IsNullOrEmpty(STT))
{
item.STT = Convert.ToInt32(STT);
}
item = BaiHatDal.Insert(item);
ItemEdit.Item = item;
ItemEdit.Visible = true;
}
break;
#endregion
case "update":
#region update Bai hat
if (!string.IsNullOrEmpty(BH_ID))
{
var item = BaiHatDal.SelectById(new Guid(BH_ID));
if (!string.IsNullOrEmpty(STT))
{
item.STT = Convert.ToInt32(STT);
}
item.Ten = Ten;
item.NgayCapNhat = DateTime.Now;
item = BaiHatDal.Update(item);
rendertext(item.ID.ToString());
}
break;
#endregion
case "remove":
#region Xóa Bai hat
if (logged && !IdNull)
{
var item = BaiHatDal.SelectById(new Guid(Id));
if (item.NguoiTao == Security.UserId)
{
BaiHatDal.DeleteById(new Guid(Id));
TimKiemDal.DeleteByPRowId(DAL.con(), item.ID);
#region log
LogDal.log(item, new Log()
{
Checked = false
,
Info =
string.Format("{1} xóa bài hát {0}", item.Ten,
Security.Username)
,
NgayTao = DateTime.Now
,
Username = Security.Username
,
PRowId = item.ID
,
PTen = item.Ten
,
RequestIp = Request.UserHostAddress
,
RawUrl = refUrl
,
LLOG_ID = 3
,
Ten = "Xóa"
});
#endregion
rendertext("1");
}
else
{
rendertext("0");
}
}
break;
#endregion
default:
break;
}
}
