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