public DetailsViewModel(string username) { RecordShackCMSEntities context = new RecordShackCMSEntities(); User = context.tblUsers.Where(x => x.UserName.ToLower() == username.ToLower()).FirstOrDefault(); RatingsList = context.tblRatings.Where(x => x.UserID == User.UserID).ToList(); }
public DetailsViewModel(int?id) { RecordShackCMSEntities context = new RecordShackCMSEntities(); User = context.tblUsers.Find(id); RatingsList = context.tblRatings.Where(x => x.UserID == User.UserID).ToList(); }
public EditViewModel() { RecordShackCMSEntities context = new RecordShackCMSEntities(); List <SelectListItem> glist = new List <SelectListItem>(); foreach (var item in context.tblGenres.ToList()) { glist.Add(new SelectListItem() { Text = item.GenreName, Value = item.GenreID.ToString() }); } Genre = glist; List <SelectListItem> alist = new List <SelectListItem>(); foreach (var item in context.tblArtists.ToList()) { alist.Add(new SelectListItem() { Text = item.ArtistName, Value = item.ArtistID.ToString() }); } Artist = alist; }
public GlobalSearchViewModel(string searchterm) { SearchTerm = searchterm; RecordShackCMSEntities context = new RecordShackCMSEntities(); ArtistList = context.tblArtists.Where(x => x.ArtistName.Contains(SearchTerm)).ToList(); GenreList = context.tblGenres.Where(x => x.GenreName.Contains(SearchTerm)).ToList(); RecordList = context.tblRecords.Where(x => x.RecordName.Contains(SearchTerm)).ToList(); }
// for sorting albums by genre public ListViewModel(int?id) { GenreID = id; RecordShackCMSEntities context = new RecordShackCMSEntities(); GenreList = context.tblGenres.ToList(); if (id != null) { RecordsList = context.tblRecords.Where(x => x.GenreID == id).ToList(); } else { RecordsList = context.tblRecords.ToList(); } }
public EditViewModel(int id, string name, string bio, string imgsrc, string imgalt, string genreselected, string artistselected, DateTime releasedate) { RecordShackCMSEntities context = new RecordShackCMSEntities(); List <SelectListItem> glist = new List <SelectListItem>(); foreach (var item in context.tblGenres.ToList()) { glist.Add(new SelectListItem() { Text = item.GenreName, Value = item.GenreID.ToString() }); } Genre = glist; List <SelectListItem> alist = new List <SelectListItem>(); foreach (var item in context.tblArtists.ToList()) { alist.Add(new SelectListItem() { Text = item.ArtistName, Value = item.ArtistID.ToString() }); } Artist = alist; RecordID = id; RecordName = name; RecordBio = bio; ImageSrc = imgsrc; ImageAlt = imgalt; GenreSelected = genreselected; ArtistSelected = artistselected; ReleaseDate = String.Format("{0:yyyy-MM-dd}", releasedate); }