internal GenericMusicItem(ALBUM s)
{
InnerType = MediaType.Album;
ContextualID = s.ID;
Title = s.Name;
var songs = s.Songs.Split(new string[] { "|" }, StringSplitOptions.RemoveEmptyEntries);
var ids = Array.ConvertAll(songs, (a) =>
{
return(int.Parse(a));
});
Description = SmartFormat.Smart.Format(Consts.Localizer.GetString("SmartSongs"), ids.Length);
Addtional = s.AlbumArtists.IsNullorEmpty() ? Consts.UnknownArtists : string.Join(Consts.CommaSeparator, s.AlbumArtists.Split(new string[] { Consts.ArraySeparator }, StringSplitOptions.RemoveEmptyEntries));
var songIDs = AsyncHelper.RunSync(async() => await SQLOperator.Current().GetSongsAsync(ids));
var s1 = songIDs.OrderBy(a => a.Track);
s1 = s1.OrderBy(a => a.Disc);
IDs = s1.Select(b => b.ID).ToArray();
var t = ThreadPool.RunAsync(async work =>
{
s.Songs = string.Join('|', songIDs.Select(x => x.ID.ToString()));
if (s.Songs.IsNullorEmpty())
{
await SQLOperator.Current().RemoveAlbumAsync(s.ID);
}
else
{
await SQLOperator.Current().UpdateAlbumAsync(s);
}
});
PicturePath = s.PicturePath;
}
// Albums -----------------------------------------
private List <ALBUM> AllAlbumList()
{
List <ALBUM> list = new List <ALBUM>();
try
{
var rows = DbHelper.Query("SELECT * FROM ALBUMS");
foreach (DataRow row in rows)
{
var albumList = new ALBUM();
albumList.ALBUM_ID = (int)row["ALBUM_ID"];
albumList.ALBUM_NAME = (string)row["ALBUM_NAME"];
albumList.ALBUM_ART = (string)row["ALBUM_ART"];
albumList.BAND_NAME = (string)row["BAND_NAME"];
albumList.RELEASE_YEAR = (int)row["RELEASE_YEAR"];
albumList.RECORD_LABEL = (string)row["RECORD_LABEL"];
list.Add(albumList);
}
return(list);
}
catch (Exception)
{
return(list);
}
}
public List<ALBUM> SelectALBUMsAll()
{
List<ALBUM> list = new List<ALBUM>();
using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString))
{
ISingleResult<ALBUM_getallResult> lp = db.ALBUM_getall();
foreach (ALBUM_getallResult ALBUM in lp)
{
ALBUM var1 = new ALBUM();
var1.MaAlbum = ALBUM.MaAlbum ;
var1.TenAlbum = ALBUM.TenAlbum ;
list.Add(var1);
}
try
{
// Save the changes.
db.SubmitChanges();
}
// Detect concurrency conflicts.
catch (ChangeConflictException)
{
// Resolve conflicts.
db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges);
}
}
return list;
}
// ---------- PRIVATE METHODS ------------ //
private ALBUM AlbumData(int albumId)
{
var album = new ALBUM();
var rows = DbHelper.Query("SELECT * FROM ALBUMS JOIN TRACKS ON TRACKS.ALBUM_ID = ALBUMS.ALBUM_ID JOIN ARTISTS ON TRACKS.ARTIST_ID = ARTISTS.ARTIST_ID WHERE ALBUMS.ALBUM_ID =" + albumId);
album.ALBUM_ART = (string)rows[0]["ALBUM_ART"];
album.ALBUM_NAME = (string)rows[0]["ALBUM_NAME"];
album.BAND_NAME = (string)rows[0]["BAND_NAME"];
album.RELEASE_YEAR = (int)rows[0]["RELEASE_YEAR"];
foreach (var row in rows)
{
var track = new TRACK
{
TRACK_FILE = (string)row["TRACK_FILE"],
TRACK_NAME = (string)row["TRACK_NAME"],
DURATION = (int)row["DURATION"],
TRACK_NUMBER = (int)row["TRACK_NUMBER"],
Artist = new ARTIST()
};
track.Artist.ARTIST_IMG = (string)row["ARTIST_IMG"];
track.Artist.ARTIST_NAME = (string)row["ARTIST_NAME"];
track.Artist.Tracks.Add(track);
track.Album = album;
album.Tracks.Add(track);
}
return(album);
}
protected void btnThem_Click(object sender, EventArgs e)
{
try
{
//lay thong tin tu textbox
ALBUM lpDTO = new ALBUM();
lpDTO.MaAlbum = Convert.ToInt32(this.txtmaalbum.Text);
lpDTO.TenAlbum = this.txttenalbum.Text;
//Goi ham cap nhat
BUSAlbum BUSAlbum = new BUSAlbum();
if (BUSAlbum.Them(lpDTO) == 0)
{
//Thong bao
lbThongBao.Text = "Thêm Thành Công";
lbThongBao.Visible = true;
//Response.Redirect("LoaiMatHang.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;
}
}
// POST: Admin/Album
public ActionResult Sua(ALBUM al)
{
using (Web_KTCKEntities db = new Web_KTCKEntities())
{
ALBUM album = db.ALBUMs.SingleOrDefault(n => n.IdAlbum == al.IdAlbum);
if (album != null)
{
album.TenAlbum = al.TenAlbum;
album.AnhDaiDien = al.AnhDaiDien;
db.SaveChanges();
}
}
return(RedirectToAction("Index"));
}
public int CapNhat(ALBUM lpDTO)
{
try
{
LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString);
return db.ALBUM_update(
lpDTO.MaAlbum,
lpDTO.TenAlbum
);
}
catch (Exception ex)
{
throw (ex);
}
}
public int Them(ALBUM lpDTO)
{
try
{
LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString);
db.ALBUM_add(
lpDTO.TenAlbum
);
return 1;
}
catch (Exception ex)
{
throw (ex);
//return 0;
}
}
// POST: Admin/Album
public ActionResult Xoa(int id)
{
using (Web_KTCKEntities db = new Web_KTCKEntities())
{
try
{
ALBUM al = db.ALBUMs.SingleOrDefault(n => n.IdAlbum == id);
db.ALBUMs.Remove(al);
db.SaveChanges();
}
catch
{
}
}
return(RedirectToAction("Index"));
}
// POST: Admin/Album/Them
public ActionResult Them(ALBUM al)
{
using (Web_KTCKEntities db = new Web_KTCKEntities())
{
var checkTenAlbum = db.ALBUMs.SingleOrDefault(n => n.TenAlbum == al.TenAlbum);
if (checkTenAlbum == null)
{
db.ALBUMs.Add(al);
db.SaveChanges();
}
else
{
}
return(RedirectToAction("Index"));
}
}
private void AddObjects()
{
NEWS n = new NEWS
{
TITLE = "aaa",
TIME = DateTime.Now,
CONTENT = "jfjjfjjjf"
};
Collections.News.Add(n);
ALBUM a = new ALBUM
{
NAME = "Танцы с бубном",
};
Collections.Albums.Add(a);
FISH f = new FISH
{
NAME = "Ерш",
DESCRIPTION = "blablalalbablalbalbalablalbala"
};
Collections.Fishes.Add(f);
STATE_INSPECTION i = new STATE_INSPECTION
{
PHONE = "+5255522",
ADDRESS = "HHCKFKVKFV",
REGION = "mINSK"
};
Collections.Inspectios.Add(i);
DIALOG d = new DIALOG
{
};
USER u = new USER
{
FIRSTNAME = "alb",
LASTNAME = "ert"
};
Collections.Friends.Add(u);
}
internal Album(ALBUM album)
{
ID = album.ID;
var songs = album.Songs.Split(new string[] { "|" }, StringSplitOptions.RemoveEmptyEntries);
Songs = Array.ConvertAll(songs, (a) =>
{
return(int.Parse(a));
});
Name = album.Name;
Genres = album.Genres.IsNullorEmpty() ? null : album.Genres.Split(new string[] { Consts.ArraySeparator }, StringSplitOptions.RemoveEmptyEntries);
Year = album.Year;
AlbumSort = album.AlbumSort;
TrackCount = album.TrackCount;
DiscCount = album.DiscCount;
AlbumArtists = album.AlbumArtists.IsNullorEmpty() ? null : album.AlbumArtists.Split(new string[] { Consts.ArraySeparator }, StringSplitOptions.RemoveEmptyEntries);
AlbumArtistsSort = album.AlbumArtistsSort.IsNullorEmpty() ? null : album.AlbumArtistsSort.Split(new string[] { Consts.ArraySeparator }, StringSplitOptions.RemoveEmptyEntries);
ReplayGainAlbumGain = album.ReplayGainAlbumGain;
ReplayGainAlbumPeak = album.ReplayGainAlbumPeak;
PicturePath = album.PicturePath;
}
/// <summary>
/// Push album name to ALBUM
/// </summary>
/// <param name="_track"></param>
/// <param name="dc"></param>
public static string Write2_ALBUM(Track _track, MusicDBDataContext dc)
{
if (dc.ALBUMs.Any(alb => alb.Ten_Album == _track.Album))
{
return((from alb in dc.ALBUMs
where alb.Ten_Album == _track.Album
select alb.Ma_Album).FirstOrDefault());
}
else
{
ALBUM album = new ALBUM();
album.Ma_Album = Utils.GenerateID("ALBUM");
album.Ten_Album = _track.Album;
dc.ALBUMs.InsertOnSubmit(album);
dc.SubmitChanges();
return(album.Ma_Album);
}
}
public static void TransToAlbumData()
{
ZoneManager.Instance.picArray = new AlbumPic[Info.items.Count];
for (int i = 0; i < Info.items.Count; i++)
{
ALBUM a = Info.items [i];
AlbumPic pic = new AlbumPic();
pic.id = a.pic_id;
pic.userId = a.user_id;
pic.picPath = a.pic_path;
pic.order = a.order;
List <AlbumData> albums;
if (ZoneManager.Instance.id2Album.TryGetValue(a.user_id, out albums))
{
}
else
{
albums = new List <AlbumData> ();
ZoneManager.Instance.id2Album.Add(a.user_id, albums);
}
AlbumData datas = null;
for (int m = 0; m < albums.Count; m++)
{
if (albums[m].albumName.Equals(a.album_name))
{
datas = albums[m];
}
}
if (datas == null)
{
datas = new AlbumData();
datas.isSecret = a.is_secret;
datas.albumName = a.album_name;
albums.Add(datas);
}
datas.pics.Add(pic);
ZoneManager.Instance.picArray [i] = pic;
}
}
public int Them(ALBUM lpDTO)
{
DAOAlbum ALBUM = new DAOAlbum();
return ALBUM.Them(lpDTO);
}
public int CapNhat(ALBUM lpDTO)
{
DAOAlbum ALBUM = new DAOAlbum();
return ALBUM.CapNhat(lpDTO);
}
