protected void btnThem_Click(object sender, EventArgs e)
{
try
{
//lay thong tin tu textbox
BAIHAT lpDTO = new BAIHAT();
//lpDTO.MaBaiHat = Convert.ToInt32(this.txtmabaihat.Text);
lpDTO.TenBaiHat = this.txttenbaihat.Text;
lpDTO.LinkBaiHat = this.txtlinkbaihat.Text;
//Goi ham cap nhat
BUSBaiHat BUSBaiHat = new BUSBaiHat();
if (BUSBaiHat.Them(lpDTO) != 0)
{
//Thong bao
lbThongBao.Text = "Thêm Thành Công";
lbThongBao.Visible = true;
//Response.Redirect("BaiHat.aspx");
}
else
{
lbThongBao.Text = "Thêm Không Thành Công";
lbThongBao.Visible = true;
}
}
catch
{
lbThongBao.Text = "Thêm Không Thành Công";
lbThongBao.Visible = true;
}
}
public List<BAIHAT> SelectBAIHATsAll()
{
List<BAIHAT> list = new List<BAIHAT>();
using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString))
{
ISingleResult<BAIHAT_getallResult> lp = db.BAIHAT_getall();
foreach (BAIHAT_getallResult BAIHAT in lp)
{
BAIHAT var1 = new BAIHAT();
var1.MaBaiHat = BAIHAT.MaBaiHat ;
var1.TenBaiHat = BAIHAT.TenBaiHat ;
var1.LinkBaiHat = BAIHAT.LinkBaiHat ;
list.Add(var1);
}
try
{
// Save the changes.
db.SubmitChanges();
}
// Detect concurrency conflicts.
catch (ChangeConflictException)
{
// Resolve conflicts.
db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges);
}
}
return list;
}
private void btnSua_Click(object sender, EventArgs e)
{
if (!CheckLuaChon())
{
return;
}
if (btnSua.Text == "Sửa")
{
btnSua.Text = "Lưu";
btnXoa.Text = "Hủy";
btnThem.Enabled = false;
UnlockControl();
return;
}
if (btnSua.Text == "Lưu")
{
if (Check())
{
btnSua.Text = "Sửa";
btnXoa.Text = "Xóa";
LockControl();
BAIHAT cu = getBAIHATByID();
BAIHAT moi = getBAIHATByForm();
CapNhat(ref cu, moi);
try
{
db.SaveChanges();
MessageBox.Show("Sưa thông tin Bài hát thành công",
"Thông báo",
MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show("Sửa thông tin Bài hát thất bại\n" + ex.Message,
"Thông báo",
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
LoadDgvBaiHat();
}
return;
}
}
/// <summary>
/// Push other details to CHITIETBAIHAT
/// </summary>
/// <param name="_track"></param>
/// <param name="bh"></param>
/// <param name="dc"></param>
public static void Write2_CHITIETBAIHAT(Track _track, MusicDBDataContext dc, BAIHAT bh)
{
CHITIETBAIHAT chitiet = new CHITIETBAIHAT();
chitiet.Ma_BaiHat = bh.Ma_BaiHat;
chitiet.ThoiLuong = _track.Duration;
chitiet.CoAnhBia = _track.HasCoverArt;
chitiet.NgayThemVaoCSDL = _track.DateAdded;
chitiet.NamPhatHanh = _track.Year.ToString();
dc.CHITIETBAIHATs.InsertOnSubmit(chitiet);
dc.SubmitChanges();
}
private void btnXoa_Click(object sender, EventArgs e)
{
if (btnXoa.Text == "Xóa")
{
if (!CheckLuaChon())
{
return;
}
BAIHAT cu = getBAIHATByID();
DialogResult rs = MessageBox.Show("Bạn có chắc chắn xóa Bài hát " + cu.TEN + "?",
"Thông báo",
MessageBoxButtons.OKCancel,
MessageBoxIcon.Warning);
if (rs == DialogResult.Cancel)
{
return;
}
try
{
db.BAIHATs.Remove(cu);
db.SaveChanges();
MessageBox.Show("Xóa thông tin Bài hát thành công",
"Thông báo",
MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show("Xóa thông tin Bài hát thất bại\n" + ex.Message,
"Thông báo",
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
LoadDgvBaiHat();
return;
}
if (btnXoa.Text == "Hủy")
{
btnSua.Text = "Sửa";
btnThem.Text = "Thêm";
btnXoa.Text = "Xóa";
LockControl();
UpdateDetail();
return;
}
}
private BAIHAT getBAIHATByForm()
{
BAIHAT ans = new BAIHAT();
try
{
ans.TEN = txtTenBai.Text;
ans.CASIID = (int)cbxCaSi.SelectedValue;
ans.NAMPHATHANH = Int32.Parse(txtNamPhatHanh.Text);
}
catch { }
return(ans);
}
private bool CheckLuaChon()
{
BAIHAT tg = getBAIHATByID();
if (tg.ID == 0)
{
MessageBox.Show("Chưa có bài hát nào được chọn",
"Thông báo",
MessageBoxButtons.OK,
MessageBoxIcon.Error);
return(false);
}
return(true);
}
public int Them(BAIHAT lpDTO)
{
try
{
LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString);
db.BAIHAT_add(
lpDTO.TenBaiHat ,
lpDTO.LinkBaiHat
);
return 1;
}
catch
{
return 0;
}
}
public int CapNhat(BAIHAT lpDTO)
{
try
{
LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString);
return db.BAIHAT_update(
lpDTO.MaBaiHat,
lpDTO.TenBaiHat,
lpDTO.LinkBaiHat
);
}
catch (Exception ex)
{
throw (ex);
}
}
private void btnThem_Click(object sender, EventArgs e)
{
if (btnThem.Text == "Thêm")
{
btnSua.Enabled = false;
btnThem.Text = "Lưu";
btnXoa.Text = "Hủy";
ClearControl();
UnlockControl();
return;
}
if (btnThem.Text == "Lưu")
{
if (Check())
{
btnThem.Text = "Thêm";
btnXoa.Text = "Xóa";
LockControl();
BAIHAT moi = getBAIHATByForm();
db.BAIHATs.Add(moi);
try
{
db.SaveChanges();
MessageBox.Show("Thêm thông tin Bài hát thành công",
"Thông báo",
MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show("Thêm thông tin Bài hát thất bại\n" + ex.Message,
"Thông báo",
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
LoadDgvBaiHat();
}
return;
}
}
private BAIHAT getBAIHATByID()
{
try
{
int id = (int)dgvBAIHAT.SelectedRows[0].Cells["ID"].Value;
BAIHAT ans = db.BAIHATs.Where(p => p.ID == id).FirstOrDefault();
if (ans == null)
{
return(new BAIHAT());
}
return(ans);
}
catch
{
return(new BAIHAT());
}
}
/// <summary>
/// Import basic information of a track to database
/// </summary>
/// <param name="_track"></param>
public static void ImportTrack2Database(MusicDBDataContext dc, Track _track)
{
if (_track == null)
{
return;
}
BAIHAT bh = new BAIHAT();
CHITIETBAIHAT ctbh = new CHITIETBAIHAT();
// If the file path has exist in database so that file has added. Return!
if (dc.BAIHATs.Any(s => s.DuongDan == _track.Location))
{
return;
}
// FILL TABLE BAIHAT, CASI, TUA, THELOAI, ALBUM:
// 1: Checking and FILL information to Tables: CASI, TUA, THELOAI, ALBUM
// 2: Fill table BAIHAT by getting the ID from those tables.
bh.DuongDan = _track.Location;
bh.Ma_BaiHat = Utils.GenerateID("BAIHAT");
// Check exist and add a new Artist in table
bh.Ma_CaSi = Write2_CASI1(_track, dc);
// Check exist and add a new Title in table TUA
bh.Ma_Tua = Write2_TUA(_track, dc);
// Check exist and add a new Album in table ALBUM
bh.Ma_Album = Write2_ALBUM(_track, dc);
// Check exist and add a new Genre in table THELOAI
bh.Ma_TheLoai = Write2_THELOAI(_track, dc);
// Check exist and add a new AlbumArtist in table CASI
bh.Ma_CaSiAlbum = Write2_CASI2(_track, dc);
dc.BAIHATs.InsertOnSubmit(bh);
dc.SubmitChanges();
// FILL TABLE CHITIETBAIHAT
Write2_CHITIETBAIHAT(_track, dc, bh);
//}
}
private void UpdateDetail()
{
try
{
BAIHAT tg = getBAIHATByID();
if (tg.ID == 0)
{
return;
}
txtTenBai.Text = tg.TEN;
cbxCaSi.SelectedValue = tg.CASIID;
txtNamPhatHanh.Text = tg.NAMPHATHANH.ToString();
}
catch
{
}
}
private void CapNhat(ref BAIHAT cu, BAIHAT moi)
{
cu.TEN = moi.TEN;
cu.CASIID = moi.CASIID;
cu.NAMPHATHANH = moi.NAMPHATHANH;
}
public int Them(BAIHAT lpDTO)
{
DAOBaiHat BAIHAT = new DAOBaiHat();
return BAIHAT.Them(lpDTO);
}
public int CapNhat(BAIHAT lpDTO)
{
DAOBaiHat BAIHAT = new DAOBaiHat();
return BAIHAT.CapNhat(lpDTO);
}
