protected void btnSua_Click(object sender, EventArgs e)
{
try
{
CaSi s = new CaSi();
s.macasi = int.Parse(txtmacs.Text);
s.tencasi = txtten.Text;
s.namsinh = int.Parse(txtnamsinh.Text);
if (anh.FileName != oldAvt)
{
string path = Server.MapPath("~/images/casi/");
anh.PostedFile.SaveAs(path + anh.FileName);
img.ImageUrl = "~/images/casi/" + anh.FileName;
}
s.hinhanh = anh.FileName;
s.quequan = txtque.Text;
s.motathem = txtmota.Text;
data.capNhatCS(s);
msg.Text = "Cập nhật thành công";
}
catch (Exception e2)
{
msg.Text = "Cập nhật thất bại " + e2.Message;
}
}
public ActionResult DeleteConfirmed(int id)
{
CaSi caSi = db.CaSis.Find(id);
db.CaSis.Remove(caSi);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public static Track ReadTrack(string _location)
{
if (string.IsNullOrWhiteSpace(_location) || !System.IO.File.Exists(_location))
{
return(null);
}
try
{
Track _track = new Track();
Album _album = new Album();
CaSi _casi = new CaSi();
TheLoai _theloai = new TheLoai();
using (var f = TagLib.File.Create(_location))
{
_track.Tua = string.IsNullOrWhiteSpace(f.Tag.Title) ? Path.GetFileNameWithoutExtension(_track.Url) : f.Tag.Title.Replace("\0", "");
_casi.TenCaSi = string.IsNullOrWhiteSpace(f.Tag.FirstPerformer) ? UNKNOW : f.Tag.FirstPerformer.Replace("\0", "");
_album.AlbumName = string.IsNullOrWhiteSpace(f.Tag.Album) ? UNKNOW : f.Tag.Album.Replace("\0", "");
_theloai.TenTheLoai = string.IsNullOrWhiteSpace(f.Tag.FirstGenre) ? UNKNOW : f.Tag.FirstGenre.Replace("\0", "");
_track.ThoiLuong = f.Properties.Duration;
_track.IsLove = false;
_track.NgayThemVao = DateTime.Now;
_track.Url = _location;
}
if (!dbcontext.Albums.Any(x => x.AlbumName == _album.AlbumName))
{
dbcontext.Albums.Add(_album);
}
if (!dbcontext.CaSis.Any(x => x.TenCaSi == _casi.TenCaSi))
{
dbcontext.CaSis.Add(_casi);
}
if (!dbcontext.TheLoais.Any(x => x.TenTheLoai == _theloai.TenTheLoai))
{
dbcontext.TheLoais.Add(_theloai);
}
dbcontext.SaveChanges();
_track.AlbumId = dbcontext.Albums.Where(x => x.AlbumName == _album.AlbumName).FirstOrDefault().Id;
_track.CaSiId = dbcontext.CaSis.Where(x => x.TenCaSi == _casi.TenCaSi).FirstOrDefault().Id;
_track.TheLoaiId = dbcontext.TheLoais.Where(x => x.TenTheLoai == _theloai.TenTheLoai).FirstOrDefault().Id;
dbcontext.Tracks.Add(_track);
dbcontext.SaveChanges();
return(_track);
}
catch (Exception e)
{
return(null);
throw e;
}
}
public ActionResult Edit([Bind(Include = "MaCS,TenCS,MaTo")] CaSi caSi)
{
if (ModelState.IsValid)
{
db.Entry(caSi).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(caSi));
}
protected void sua_Click(object sender, CommandEventArgs e)
{
if (e.CommandName == "sua")
{
int m = Convert.ToInt16(e.CommandArgument);
CaSi cs = data.layra1CS(m);
Session["cs"] = cs;
Response.Redirect("SuaCaSi.aspx");
}
}
public ActionResult Create([Bind(Include = "MaCS,TenCS,MaTo")] CaSi caSi)
{
if (ModelState.IsValid)
{
db.CaSis.Add(caSi);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(caSi));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
CaSi cs = (CaSi)Session["cs"];
txtmacs.Text = cs.macasi.ToString();
txtten.Text = cs.tencasi;
txtnamsinh.Text = cs.namsinh.ToString();
img.ImageUrl = "~/images/casi/" + cs.hinhanh;
txtque.Text = cs.quequan;
txtmota.Text = cs.motathem;
}
}
// thêm ca sĩ
public void ThemCaSi(CaSi cs)
{
con.Open();
string sql = "insert into casi values(@ht,@namsinh,@anh,@que,@mota)";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("ht", cs.tencasi);
cmd.Parameters.AddWithValue("namsinh", cs.namsinh);
cmd.Parameters.AddWithValue("anh", cs.hinhanh);
cmd.Parameters.AddWithValue("que", cs.quequan);
cmd.Parameters.AddWithValue("mota", cs.motathem);
cmd.ExecuteNonQuery();
con.Close();
}
// GET: CaSi/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CaSi caSi = db.CaSis.Find(id);
if (caSi == null)
{
return(HttpNotFound());
}
return(View(caSi));
}
// cập nhật
public void capNhatCS(CaSi cs)
{
con.Open();
string sql = "update casi set tencasi=@ten,namsinh=@namsinh,hinhanh=@anh,quequan=@que,motathem=@mota where macasi=@macs";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("ten", cs.tencasi);
cmd.Parameters.AddWithValue("namsinh", cs.namsinh);
cmd.Parameters.AddWithValue("anh", cs.hinhanh);
cmd.Parameters.AddWithValue("que", cs.quequan);
cmd.Parameters.AddWithValue("mota", cs.motathem);
cmd.Parameters.AddWithValue("macs", cs.macasi);
cmd.ExecuteNonQuery();
con.Close();
}
public List <CaSi> DanhSach()
{
List <CaSi> dsCS = new List <CaSi>();
getConnection();
string sqlString = "SELECT * FROM Artist";
SqlCommand cmd = new SqlCommand(sqlString, conn);
SqlDataReader data = cmd.ExecuteReader();
while (data.Read())
{
CaSi cs = new CaSi(data["ArtistID"].ToString(),
data["ArtistName"].ToString());
dsCS.Add(cs);
}
data.Close();
closeConnection();
return(dsCS);
}
protected void btnThem_Click(object sender, EventArgs e)
{
try
{
CaSi cs = new CaSi();
cs.tencasi = txthoten.Text;
cs.namsinh = int.Parse(txtnamsinh.Text);
string path = Server.MapPath("~/images/casi/");
anh.PostedFile.SaveAs(path + anh.FileName);
img.ImageUrl = "~/images/casi/" + anh.FileName;
cs.hinhanh = anh.FileName;
cs.quequan = txtquequan.Text;
cs.motathem = txtmotathem.Text;
data.ThemCaSi(cs);
msg.Text = "Thêm thành công";
}
catch (Exception e1)
{
msg.Text = "Có lỗi khi thêm" + e1.Message;
}
}
// code lay ra CaSi trong bang va dua vao List
public List <CaSi> dsCaSi()
{
List <CaSi> ds = new List <CaSi>();
string sql = "select * from casi";
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
CaSi cs = new CaSi();
cs.macasi = (int)rd["macasi"];
cs.tencasi = (string)rd["tencasi"];
cs.namsinh = (int)rd["namsinh"];
cs.hinhanh = (string)rd["hinhanh"];
cs.quequan = (string)rd["quequan"];
cs.motathem = (string)rd["motathem"];
ds.Add(cs);
}
con.Close();
return(ds);
}
// lấy ra 1 ca sĩ
public CaSi layra1CS(int macs)
{
string sql = "select *from casi where macasi=@macasi";
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("macasi", macs);
SqlDataReader rd = cmd.ExecuteReader();
CaSi cs = null;
if (rd.Read())
{
cs = new CaSi();
cs.macasi = (int)rd["macasi"];
cs.tencasi = (string)rd["tencasi"];
cs.namsinh = (int)rd["namsinh"];
cs.hinhanh = (string)rd["hinhanh"];
cs.quequan = (string)rd["quequan"];
cs.motathem = (string)rd["motathem"];
}
con.Close();
return(cs);
}
