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