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