//Tv programok importálása XML fájlból.
public bool ImportTvPrograms(string filepath)
{
try
{
using (TvContext context = new TvContext())
{
using (StreamReader sr = new StreamReader(filepath))
{
XmlSerializer ser = new XmlSerializer(typeof(List <TvProgram>));
List <TvProgram> tvPrograms = (List <TvProgram>)ser.Deserialize(sr);
foreach (var prgm in tvPrograms)
{
if (this.ValidateProgram(prgm))
{
context.Programs.Add(prgm);
}
//AddTvProgram(prgm);
}
context.SaveChanges();
return(true);
}
}
}
catch (IOException ex)
{
Console.WriteLine(ex.Message);
return(false);
}
}
public void BulkGenerate(string[] channels, DateTime fromDate, DateTime toDate, string showNamesFile)
{
using (TvContext context = new TvContext())
{
var collision = from p in context.Programs
where p.StartTime >= fromDate
&&
p.EndTime <= toDate
select p;
if (collision.Count() > 0)
{
throw new TvProgramCreateEditException("Az adott invervallumban már léteznek műsorok.", TvProgramCreateEditExceptionDetails.Collision);
}
DateTime now = new DateTime(fromDate.Year, fromDate.Month, fromDate.Day);
toDate = toDate.AddDays(1);
while (now.Date != toDate.Date)
{
foreach (string channel in channels)
{
List <TvProgram> todayPrograms = GenerateRandomPrograms(channel, now, showNamesFile);
context.Programs.AddRange(todayPrograms);
}
now = now.Date.AddDays(1);
}
context.SaveChanges();
}
}
public void DeleteReservation(TvProgram program)
{
using (TvContext context = new TvContext())
{
TvProgram old = context.Programs.First(p => p.ProgramId == program.ProgramId);
context.Entry(old).State = System.Data.Entity.EntityState.Modified;
context.Entry(old).Entity.Reserved = null;
context.Entry(old).Entity.ReservedRoomId = null;
context.SaveChanges();
}
}
public void DeleteProgram(TvProgram program)
{
if (program != null)
{
using (TvContext context = new TvContext())
{
TvProgram p = context.Programs.Find(program.ProgramId);
context.Entry(p).State = System.Data.Entity.EntityState.Deleted;
context.Programs.Remove(p);
context.SaveChanges();
}
}
}
public void AddTvProgram(TvProgram program)
{
if (this.ValidateProgram(program))
{
using (TvContext context = new TvContext())
{
if (program.ProgramId != 0)
{
TvProgram old = context.Programs.First(p => p.ProgramId == program.ProgramId);
context.Entry(old).State = System.Data.Entity.EntityState.Modified;
context.Entry(old).CurrentValues.SetValues(program);
//Console.WriteLine(context.Entry(old).Entity.Title);
context.SaveChanges();
}
else
{
context.Programs.Add(program);
context.SaveChanges();
}
}
}
}
//TV program lefoglalása.
/// <summary>
/// TV program lefoglalása egy adott szobához
/// </summary>
/// <param name="program">Foglalandó műsor</param>
/// <param name="room">Lefoglaló szoba</param>
public static void ReserveTvProgram(TvProgram program, Room room)
{
using (TvContext context = new TvContext())
{
try
{
TvProgram prg = context.Programs.Find(program.ProgramId);
Room r = context.Rooms.Find(room.RoomId);
prg.Reserved = r;
context.SaveChanges();
}
catch (Exception)
{
MessageBox.Show("Nem sikerült a foglalás.\nHiba lépett fel. Frissítsen és próbálja újra.", "Hiba.", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
