public List <Content> SearchForTitle(string title)
{
ChkContext();
var coList = DALServices.SearchForTitle(context, title);
return(coList);
}
public List <AllContentForGrid> GetAllContents()
{
List <AllContentForGrid> allCntL = new List <AllContentForGrid>();
allCntL = DALServices.GetAllContents(context);
return(allCntL);
}
public List <AllRatingsForGrid> GetAllRatingsForGrid()
{
List <AllRatingsForGrid> allGnrL = new List <AllRatingsForGrid>();
allGnrL = DALServices.GetAllRatingsForGrid(context);
return(allGnrL);
}
public bool IsRatingDuplicate(string name)
{
ChkContext();
bool b = DALServices.IsRatingDuplicate(context, name);
ClearContext();
return(b);
}
public Genre GetGenre(int genreid)
{
Genre g = new Genre();
using (context)
{
g = DALServices.GetGenre(context, genreid);
}
ClearContext();
return(g);
}
public int DeleteRating(int id)
{
var gnr = new Rating();
gnr.Id = id;
ChkContext();
int results = DALServices.DeleteRating(context, gnr);
ClearContext();
return(results);
}
public Rating GetRatingByCod(string mpaacode)
{
Rating gnr = new Rating();
ChkContext();
using (context)
{
gnr = DALServices.GetRatingByCode(context, mpaacode);
}
ClearContext();
return(gnr);
}
public Rating AddRating(Rating newgnr)
{
Rating gnr = new Rating();
ChkContext();
using (context)
{
gnr = DALServices.AddRating(context, newgnr);
}
ClearContext();
return(gnr);
}
public DVDIcon AddDVDIcon(DVDIcon newdvi)
{
DVDIcon dvi = new DVDIcon();
ChkContext();
using (context)
{
dvi = DALServices.AddDVDIcon(context, newdvi);
}
ClearContext();
return(dvi);
}
public List <Rating> GetAllRatings()
{
List <Rating> rL = new List <Rating>();
ChkContext();
using (context)
{
rL = DALServices.GetAllRatings(context);
}
ClearContext();
return(rL);
}
public Rating GetRating(int ratingid)
{
Rating r = new Rating();
ChkContext();
using (context)
{
r = DALServices.GetRating(context, ratingid);
}
ClearContext();
return(r);
}
public Genre GetGenreByName(string name)
{
Genre gnr = new Genre();
ChkContext();
using (context)
{
gnr = DALServices.GetGenreByname(context, name);
}
ClearContext();
return(gnr);
}
public Genre AddGenre(Genre newgnr)
{
Genre gnr = new Genre();
ChkContext();
using (context)
{
gnr = DALServices.AddGenre(context, newgnr);
}
ClearContext();
return(gnr);
}
public Genre UpdateGenre(Genre newgenre)
{
Genre g = new Genre();
ChkContext();
using (context)
{
g = DALServices.UpdateGenre(context, newgenre);
}
ClearContext();
return(g);
}
public List <Genre> GetAllGenres()
{
List <Genre> gL = new List <Genre>();
ChkContext();
using (context)
{
gL = DALServices.GetAllGenres(context);
}
ClearContext();
return(gL);
}
public List <DVDIcon> GetAllDVDIcons()
{
List <DVDIcon> dviL = new List <DVDIcon>();
ChkContext();
using (context)
{
dviL = DALServices.GetAllDVDIcons(context);
}
ClearContext();
return(dviL);
}
public DVDIcon GetDVDIconByName(string iconname)
{
DVDIcon dvi = new DVDIcon();
ChkContext();
using (context)
{
dvi = DALServices.GetDVDIconByname(context, iconname);
}
ClearContext();
return(dvi);
}
public Rating UpdateRating(Rating newrating)
{
Rating rating = new Rating();
ChkContext();
using (context)
{
rating = DALServices.UpdateRating(context, newrating);
}
ClearContext();
return(rating);
}
public DVDIcon GetDVDIcon(int dvdiconid)
{
DVDIcon dvi = new DVDIcon();
ChkContext();
using (context)
{
dvi = DALServices.GetDVDIcon(context, dvdiconid);
}
ClearContext();
return(dvi);
}
// get a box by number
public StorageBox GetBox(int boxnumber)
{
StorageBox sb = DALServices.GetBox(context, boxnumber);
return(sb);
}
// ADD the next Case to a specific box
public Case AddNextCase(int boxnum)
{
Case ca = DALServices.AddNextCase(context, boxnum);
return(ca);
}
// ADD a new DVD Box - no related records
private StorageBox AddDVDBox()
{
StorageBox sb = DALServices.AddABox(context, "DVD");
return(sb);
}
// get next available box # for adding a new box
public int GetNextBoxNumber()
{
int nxtbxn = DALServices.GetNextBoxNumber(context);
return(nxtbxn);
}
// get all content numbers per disc/case/box
public List <DVDMC.AllContentNums> GetDiscContentNumbers(int boxnumber, int casenumber, int discnumber)
{
var cons = DALServices.GetDiscContentNumbers(context, boxnumber, casenumber, discnumber);
return(cons);
}
public int TotalContents()
{
var totals = DALServices.TotalContents(context);
return(totals);
}
// get all disc numbers per case/box
public List <DVDMC.AllDiscNums> GetCaseDiscNumbers(int boxnumber, int casenumber)
{
var dins = DALServices.GetCaseDiscNumbers(context, boxnumber, casenumber);
return(dins);
}
// get all case numbers per box
public List <DVDMC.AllCaseNums> GetBoxCaseNumbers(int boxnumber)
{
var cans = DALServices.GetBoxCaseNumbers(context, boxnumber);
return(cans);
}
// get all content numbers
public List <DVDMC.AllContentNums> GetAllContentNumbers()
{
var consList = DALServices.GetAllContentNumbers(context);
return(consList);
}
// get all disc numbers
public List <DVDMC.AllDiscNums> GetAllDiscNumbers()
{
var dinsList = DALServices.GetAllDiscNumbers(context);
return(dinsList);
}
// get all box numbers
public List <int> GetAllBoxNumbers()
{
var bxnsList = DALServices.GetAllBoxNumbers(context);
return(bxnsList);
}
