public bool Insert(RendezvousTime newRendezvousTime)
{
using (MsSqlHealthContext ctx = new MsSqlHealthContext())
{
if (ctx.RendezvousTimes.Any(d => d.StartTime == newRendezvousTime.StartTime) &&
ctx.RendezvousTimes.Any(d => d.FinishTime == newRendezvousTime.FinishTime))
{
return(false);
}
ctx.RendezvousTimes.Add(newRendezvousTime);
return(ctx.SaveChanges() > -1);
}
}
public bool Delete(int id)
{
using (MsSqlHealthContext ctx = new MsSqlHealthContext())
{
RendezvousTime rendezvousTime = ctx.RendezvousTimes.FirstOrDefault(d => d.Id == id);
if (rendezvousTime == null)
{
return(false);
}
bool b = ctx.Rendezvouses.Any(d => d.RendezvousTimeId == id);
if (b)
{
return(false);
}
ctx.RendezvousTimes.Remove(rendezvousTime);
return(ctx.SaveChanges() > -1);
}
}
public bool Update(RendezvousTime newInfoRendezvousTime)
{
using (MsSqlHealthContext ctx = new MsSqlHealthContext())
{
if (ctx.RendezvousTimes.Any(d => d.StartTime == newInfoRendezvousTime.StartTime) &&
ctx.RendezvousTimes.Any(d => d.FinishTime == newInfoRendezvousTime.FinishTime))
{
return(false);
}
RendezvousTime rendezvousTime = ctx.RendezvousTimes.FirstOrDefault(d => d.Id == newInfoRendezvousTime.Id);
if (rendezvousTime == null)
{
return(false);
}
rendezvousTime.StartTime = newInfoRendezvousTime.StartTime;
rendezvousTime.FinishTime = newInfoRendezvousTime.FinishTime;
rendezvousTime.IsActive = newInfoRendezvousTime.IsActive;
return(ctx.SaveChanges() > -1);
}
}
public bool Update(RendezvousTime newInfoRendezvousTime)
{
return(_rendezvousTimeDal.Update(newInfoRendezvousTime));
}
public bool Insert(RendezvousTime newRendezvousTime)
{
return(_rendezvousTimeDal.Insert(newRendezvousTime));
}
