public string GetAlbumRankingID() { AlbumRanking albumranking = new AlbumRanking(); var mylist = this.ListAlbumRanking().ToList(); if (mylist.Count == 0) { albumranking.AlbumRankingID = "0000000001"; } else { string s = ((from a in mylist select new { a.AlbumRankingID }).Last()).AlbumRankingID.ToString(); int lastint = Int32.Parse(s.Substring(0, 10)) + 1; string myid = String.Format("{0:0000000000}", lastint); albumranking.AlbumRankingID = myid; } return(albumranking.AlbumRankingID); }
public void Add(AlbumRanking albumranking) { db.AlbumRankings.InsertOnSubmit(albumranking); }
public AlbumRanking SelectRankByCustomerID(Guid userid) { AlbumRanking albumranking = new AlbumRanking(); return(db.AlbumRankings.First(s => s.UserID == userid)); }