public void Add(NewsRanking newsranking)
{
var mylist = this.ListNewsRanking().ToList();
if (mylist.Count == 0)
{
newsranking.NewsRankingID = "N000000001";
}
else
{
string s = ((from c in mylist
select new { c.NewsRankingID }).Last()).NewsRankingID.ToString();
int lastint = Int32.Parse(s.Substring(1, 9)) + 1;
string myid = String.Format("{0:000000000}", lastint);
string autoid = "N" + myid.ToString();
newsranking.NewsRankingID = autoid;
}
db.NewsRankings.InsertOnSubmit(newsranking);
}
public NewsRanking SelectByUserID(Guid userid)
{
NewsRanking newsranking = new NewsRanking();
return(db.NewsRankings.First(s => s.UserID == userid));
}
