///<summary>
///Visszaadja a Tv műsorokat egy List adatszerekezetben.
///</summary>
public List <TvProgram> RetrieveTvPrograms(DateTime time, string channel)
{
ProgramDisplay programDisplay = ProgramDisplay.OnlyFree | ProgramDisplay.OnlyReserved;
AgeLimit limit = AgeLimit.Above12 | AgeLimit.Above16 | AgeLimit.Above18 | AgeLimit.Above6 | AgeLimit.NoLimit;
return(RetrieveTvPrograms(time, channel, programDisplay, limit));
}
private AgeLimit FetchAgeLimitMenuSelect()
{
AgeLimit ageLimit = new AgeLimit();
if (korhatarNelkulMenuItem.Checked)
{
ageLimit = ageLimit | AgeLimit.NoLimit;
}
if (korhatar6MenuItem.Checked)
{
ageLimit = ageLimit | AgeLimit.Above6;
}
if (korhatar12MenuItem.Checked)
{
ageLimit = ageLimit | AgeLimit.Above12;
}
if (korhatar16MenuItem.Checked)
{
ageLimit = ageLimit | AgeLimit.Above16;
}
if (korhatar18MenuItem.Checked)
{
ageLimit = ageLimit | AgeLimit.Above18;
}
return(ageLimit);
}
private void ButtonAdd_Click(object sender, RoutedEventArgs e)
{
MainInfoFilm newMainInfoFilm = new MainInfoFilm();
Creators newCreators = new Creators();
BudgetAndFees newBudgetAndFees = new BudgetAndFees();
FilmDescription newFilmDescription = new FilmDescription();
RentalData newRentalData = new RentalData();
AgeLimit newAgeLimit = new AgeLimit();
newMainInfoFilm.Name = tbName.Text;
newMainInfoFilm.CountryCreator = tbCountryCreator.Text;
newMainInfoFilm.Operator = tbOperator.Text;
newMainInfoFilm.Genres = tbGenres.Text;
newMainInfoFilm.idCreators = newCreators.ID;
newMainInfoFilm.idFilmDescription = newFilmDescription.ID;
newMainInfoFilm.idBudgetAndFees = newBudgetAndFees.ID;
newMainInfoFilm.idRentalData = newRentalData.ID;
newMainInfoFilm.idAgeLimit = newAgeLimit.ID;
MemoryStream stream = new MemoryStream();
JpegBitmapEncoder encoder = new JpegBitmapEncoder();
encoder.Frames.Add(BitmapFrame.Create((BitmapImage)imgLoad.Source));
encoder.Save(stream);
newMainInfoFilm.ImageMovie = stream.ToArray();
var currentType = dbContext.db.AgeLimit.FirstOrDefault(item => item.MPAA == cmbMPAA.Text);
newMainInfoFilm.ID = currentType.ID;
newBudgetAndFees.Budget = Convert.ToInt32(tbBudget.Text);
newBudgetAndFees.WorldwideFees = Convert.ToInt32(tbWorldwideFees.Text);
newCreators.Director = tbDirector.Text;
newCreators.Producer = tbProducer.Text;
newRentalData.PremiereInRussia = (DateTime)tbPremiereInRussia.SelectedDate;
newRentalData.PremiereInWorld = (DateTime)tbPremiereInWorld.SelectedDate;
newFilmDescription.Description = tbDescription.Text;
dbContext.db.BudgetAndFees.Add(newBudgetAndFees);
dbContext.db.Creators.Add(newCreators);
dbContext.db.AgeLimit.Add(newAgeLimit);
dbContext.db.RentalData.Add(newRentalData);
dbContext.db.FilmDescription.Add(newFilmDescription);
dbContext.db.MainInfoFilm.Add(newMainInfoFilm);
dbContext.db.SaveChanges();
MessageBox.Show("Вы успешно добавили данные", "Уведомление", MessageBoxButton.OK, MessageBoxImage.Information);
}
//Korhatárhoz tartozó hosszabb szövege üzenet.
public static string GetAgeLimitMessage(AgeLimit limit)
{
switch (limit)
{
case AgeLimit.NoLimit:
return(ageLimitMessages[0]);
case AgeLimit.Above6:
return(ageLimitMessages[1]);
case AgeLimit.Above12:
return(ageLimitMessages[2]);
case AgeLimit.Above16:
return(ageLimitMessages[3]);
case AgeLimit.Above18:
return(ageLimitMessages[4]);
default:
return("Ismeretlen korhatár");
}
}
public List <TvProgram> RetrieveTvPrograms(Tuple <DateTime, DateTime> dateRange, List <string> channels, ProgramDisplay display, AgeLimit ageLimit)
{
LinkedList <TvProgram> list = new LinkedList <TvProgram>();
DateTime startDay = dateRange.Item1.Date;
DateTime endDay = dateRange.Item2.Date;
while (startDay.Date <= endDay.Date)
{
foreach (string channel in channels)
{
foreach (TvProgram program in RetrieveTvPrograms(startDay, channel, display, ageLimit))
{
list.AddFirst(program);
}
startDay.AddDays(1);
}
startDay = startDay.AddDays(1);
}
return(list.ToList());
}
///<summary>
///Visszaadja a Tv műsorokat egy List adatszerekezetben.
///</summary>
public List <TvProgram> RetrieveTvPrograms(DateTime time, string channel, AgeLimit ageLimit)
{
ProgramDisplay programDisplay = ProgramDisplay.OnlyFree | ProgramDisplay.OnlyReserved;
return(RetrieveTvPrograms(time, channel, programDisplay, ageLimit));
}
///<summary>
///Visszaadja a Tv műsorokat egy List adatszerekezetben.
///</summary>
public List <TvProgram> RetrieveTvPrograms(DateTime time, string channel, ProgramDisplay display)
{
AgeLimit limit = AgeLimit.Above12 | AgeLimit.Above16 | AgeLimit.Above18 | AgeLimit.Above6 | AgeLimit.NoLimit;
return(RetrieveTvPrograms(time, channel, display, limit));
}
public static AgeLimit AllAgeLimit()
{
AgeLimit limit = AgeLimit.Above12 | AgeLimit.Above16 | AgeLimit.Above18 | AgeLimit.Above6 | AgeLimit.NoLimit;
return(limit);
}
///<summary>
///Visszaadja a Tv műsorokat egy List adatszerekezetben.
///</summary>
public List <TvProgram> RetrieveTvPrograms(DateTime time, string channel, ProgramDisplay display, AgeLimit ageLimit)
{
using (TvContext context = new TvContext())
{
//Alap lekérés
var shows = from p in context.Programs
where
System.Data.Entity.Core.Objects.EntityFunctions.DiffDays(p.StartTime, time) == 0
&&
(channel == null ? true : p.TvChannel == channel)
&&
((p.AgeLimit & ageLimit) != 0)
select p;
//Ha mindkettő be van pipálva akkor ne variáljunk.
if (!((display & ProgramDisplay.OnlyFree) != 0 && (display & ProgramDisplay.OnlyReserved) != 0))
{
//Szabad időpontok
if ((display & ProgramDisplay.OnlyFree) != 0)
{
shows = from p in shows
where p.Reserved == null
select p;
}
//Ffoglalt időpontok
if ((display & ProgramDisplay.OnlyReserved) != 0)
{
shows = from p in shows
where p.Reserved != null
select p;
}
//Ha egyik sincs kipipálva
if (display == 0)
{
shows = from p in shows
where false
select p;
}
}
//Tv Műsorok visszaadása
List <TvProgram> programs = new List <TvProgram>();
foreach (TvProgram item in shows)
{
programs.Add(item);
}
return(programs);
}
}
