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