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);
}
