public static Rating GetRatingByCode(MyDVDsContext context, string mpaacode)
{
var Rating = context.Ratings
.Where(i => i.MPAACode == mpaacode).FirstOrDefault();
return(Rating);
}
public static Genre GetGenreByname(MyDVDsContext context, string name)
{
var Genre = context.Genres
.Where(i => i.Name == name).FirstOrDefault();
return(Genre);
}
public static Genre GetGenre(MyDVDsContext context, int genreid)
{
var g = context.Genres
.Where(i => i.Id == genreid).FirstOrDefault();
return(g);
}
public static DVDIcon GetDVDIcon(MyDVDsContext context, int dvdiconid)
{
var dvdicon = context.DVDIcons
.Where(i => i.Id == dvdiconid).FirstOrDefault();
return(dvdicon);
}
// ADD the next Disc to a specific case/box
public static Disc AddNextDisc(MyDVDsContext context, int boxnum, int casenum)
{
Case ca = new Case();
Disc di = new Disc();
// get the box specific case
ca = GetCase(context, boxnum, casenum);
// set the next disc #
di.DiscNumber = GetNextDiscNumber(ca);
// set fields
di.Notes = "";
di.IsACollection = false;
di.Title = "";
// set parent nav
di.CaseId = ca.Id;
ca.TotalDiscs++;
di.Case = ca;
// add the new disc to the case
ca.Discs.Add(di);
context.SaveChanges();
return(di);
}
public static DVDIcon GetDVDIconByname(MyDVDsContext context, string iconname)
{
var dvdicon = context.DVDIcons
.Where(i => i.Name == iconname).FirstOrDefault();
return(dvdicon);
}
public static Rating GetRating(MyDVDsContext context, int ratingid)
{
var r = context.Ratings
.Where(i => i.Id == ratingid).FirstOrDefault();
return(r);
}
// get a content by id
public static Content GetContentById(MyDVDsContext context, int id)
{
Content co = context.Contents
.Where(c => c.Id == id)
.FirstOrDefault();
return(co);
}
// get a content by number
public static Content GetContent(MyDVDsContext context, int boxnumber, int casenumber, int discnumber, int contentnumber)
{
Content co = context.Contents
.Where(c => c.Disc.Case.StorageBox.BoxNumber == boxnumber && c.Disc.Case.CaseNumber == casenumber && c.Disc.DiscNumber == discnumber && c.ContentNumber == contentnumber)
.FirstOrDefault();
return(co);
}
// get a disc by number
public static Disc GetDisc(MyDVDsContext context, int boxnumber, int casenumber, int discnumber)
{
Disc di = context.Discs
.Where(s => s.Case.StorageBox.BoxNumber == boxnumber && s.Case.CaseNumber == casenumber && s.DiscNumber == discnumber)
.FirstOrDefault();
return(di);
}
// get a box by number
public static StorageBox GetBox(MyDVDsContext context, int boxnumber)
{
StorageBox box = context.StorageBoxes
.Where(p => p.BoxNumber == boxnumber)
.FirstOrDefault();
return(box);
}
public void ClearContext()
{
if (context != null)
{
context.Dispose();
context = null;
}
}
// get a case by number
public static Case GetCase(MyDVDsContext context, int boxnumber, int casenumber)
{
Case ca = context.Cases
.Where(s => s.StorageBox.BoxNumber == boxnumber && s.CaseNumber == casenumber)
.FirstOrDefault();
return(ca);
}
// get all box numbers
public static List <int> GetAllBoxNumbers(MyDVDsContext context)
{
var bxns = context.StorageBoxes
.Select(b => b.BoxNumber)
.ToList();
return(bxns);
}
public static List <Content> SearchForTitle(MyDVDsContext context, string title)
{
List <Content> coList = context.Contents
.Where(c => c.Title.Contains(title))
.ToList();
return(coList);
}
// get all content numbers
public static List <DVDMC.AllContentNums> GetAllContentNumbers(MyDVDsContext context)
{
var cons = context.Contents
.Select(x => new DVDMC.AllContentNums {
bxNumber = x.Disc.Case.StorageBox.BoxNumber, caNumber = x.Disc.Case.CaseNumber, diNumber = x.Disc.Case.CaseNumber, coNumber = x.ContentNumber
})
.ToList();
return(cons);
}
// get all disc numbers
public static List <DVDMC.AllDiscNums> GetAllDiscNumbers(MyDVDsContext context)
{
var dins = context.Discs
.Select(d => new DVDMC.AllDiscNums {
bxNumber = d.Case.StorageBox.BoxNumber, caNumber = d.Case.CaseNumber, diNumber = d.DiscNumber
})
.ToList();
return(dins);
}
// get all case numbers
public static List <DVDMC.AllCaseNums> GetAllCaseNumbers(MyDVDsContext context)
{
var cans = context.Cases
.Select(c => new DVDMC.AllCaseNums {
bxNumber = c.StorageBox.BoxNumber, caNumber = c.CaseNumber
})
.ToList();
return(cans);
}
// get all disc numbers per case/box
public static List <DVDMC.AllDiscNums> GetCaseDiscNumbers(MyDVDsContext context, int boxnumber, int casenumber)
{
var dins = context.Discs
.Where(d => d.Case.StorageBox.BoxNumber == boxnumber && d.Case.CaseNumber == casenumber)
.Select(d => new DVDMC.AllDiscNums {
bxNumber = d.Case.StorageBox.BoxNumber, caNumber = d.Case.CaseNumber, diNumber = d.DiscNumber
})
.ToList();
return(dins);
}
// get all case numbers per box
public static List <DVDMC.AllCaseNums> GetBoxCaseNumbers(MyDVDsContext context, int boxnumber)
{
var cans = context.Cases
.Where(c => c.StorageBox.BoxNumber == boxnumber)
.Select(c => new DVDMC.AllCaseNums {
bxNumber = c.StorageBox.BoxNumber, caNumber = c.CaseNumber
})
.ToList();
return(cans);
}
public static Rating AddRating(MyDVDsContext context, Rating newRtg)
{
// add it
context.Ratings.Add(newRtg);
context.SaveChanges();
newRtg = GetRating(context, newRtg.Id);
return(newRtg);
}
public static DVDIcon UpdateDVDIcon(MyDVDsContext context, DVDIcon newdvi)
{
var olddvi = GetDVDIcon(context, newdvi.Id);
context.Entry(olddvi).CurrentValues.SetValues(newdvi);
context.SaveChanges();
newdvi = GetDVDIcon(context, newdvi.Id);
return(newdvi);
}
public static Genre UpdateGenre(MyDVDsContext context, Genre newgenre)
{
var oldgenre = GetGenre(context, newgenre.Id);
context.Entry(oldgenre).CurrentValues.SetValues(newgenre);
context.SaveChanges();
newgenre = GetGenre(context, newgenre.Id);
return(newgenre);
}
public static Rating UpdateRating(MyDVDsContext context, Rating newrating)
{
var oldrating = GetRating(context, newrating.Id);
context.Entry(oldrating).CurrentValues.SetValues(newrating);
context.SaveChanges();
newrating = GetRating(context, newrating.Id);
return(newrating);
}
public static Genre AddGenre(MyDVDsContext context, Genre newgnr)
{
// add it
context.Genres.Add(newgnr);
context.SaveChanges();
newgnr = GetGenre(context, newgnr.Id);
return(newgnr);
}
// get all content numbers per disc/case/box
public static List <DVDMC.AllContentNums> GetDiscContentNumbers(MyDVDsContext context, int boxnumber, int casenumber, int discnumber)
{
var cons = context.Contents
.Where(x => x.Disc.Case.StorageBox.BoxNumber == boxnumber && x.Disc.Case.CaseNumber == casenumber && x.Disc.DiscNumber == discnumber)
.Select(x => new DVDMC.AllContentNums {
bxNumber = x.Disc.Case.StorageBox.BoxNumber, caNumber = x.Disc.Case.CaseNumber, diNumber = x.Disc.Case.CaseNumber, coNumber = x.ContentNumber
})
.ToList();
return(cons);
}
public static DVDIcon AddDVDIcon(MyDVDsContext context, DVDIcon newdvi)
{
// add it
context.DVDIcons.Add(newdvi);
context.SaveChanges();
newdvi = GetDVDIcon(context, newdvi.Id);
return(newdvi);
}
// get next available box # for adding a new box
public static int GetNextBoxNumber(MyDVDsContext context)
{
int nxtnumber = 1;
if (context.StorageBoxes.Count() > 0)
{
nxtnumber = context.StorageBoxes.Max(n => n.BoxNumber);
nxtnumber += 1;
}
return(nxtnumber);
}
public static List <AllRatingsForGrid> GetAllRatingsForGrid(MyDVDsContext context)
{
List <AllRatingsForGrid> allRtgL = new List <AllRatingsForGrid>();
allRtgL = context.Ratings
.Select(x => new AllRatingsForGrid {
Id = x.Id, MPAACode = x.MPAACode, Description = x.Description
})
.OrderBy(x => x.MPAACode)
.ToList();
return(allRtgL);
}
public static List <AllGenresForGrid> GetAllGenresForGrid(MyDVDsContext context)
{
List <AllGenresForGrid> allGnrL = new List <AllGenresForGrid>();
allGnrL = context.Genres
.Select(x => new AllGenresForGrid {
Id = x.Id, GenreName = x.Name
})
.OrderBy(x => x.GenreName)
.ToList();
return(allGnrL);
}
