public async Task <bool> CreateAppointment(AppointmenTO filtro)
{
List <AppointmenTO> appointmentsByPacient = new List <AppointmenTO>();
using (AppointmentsEntities dbContext = new AppointmentsEntities())
{
appointmentsByPacient = await(from app in dbContext.Appointments
join pat in dbContext.Pacients on app.IdKeyPacient equals pat.IdKey
join sta in dbContext.States on app.Type.IdKey equals sta.IdKey
where app.IdKeyPacient == filtro.IdKeyPacient &&
DbFunctions.TruncateTime(app.Date) == filtro.Date.Date &&
sta.Description == "Programado"
select app).ProjectTo <AppointmenTO>().ToListAsync();
if (appointmentsByPacient.Count <= 0)
{
Appointment AppointmentCreate = Mapper.Map <Appointment>(filtro);
dbContext.Appointments.Add(AppointmentCreate);
dbContext.SaveChanges();
}
else
{
return(false);
}
}
return(true);
}
public async Task <bool> UpdateAppointment(AppointmenTO filtro)
{
List <AppointmenTO> appointmentsByPacient = new List <AppointmenTO>();
using (AppointmentsEntities dbContext = new AppointmentsEntities())
{
appointmentsByPacient = await(from app in dbContext.Appointments
join pat in dbContext.Pacients on app.IdKeyPacient equals pat.IdKey
where app.IdKeyPacient == filtro.IdKeyPacient &&
app.IdKey == filtro.IdKey &&
DbFunctions.DiffHours(app.Date, SqlFunctions.GetDate().Value) <= 24
select app).ProjectTo <AppointmenTO>().ToListAsync();
if (appointmentsByPacient.Count <= 0)
{
Appointment AppointmentUpdate = Mapper.Map <Appointment>(filtro);
dbContext.Appointments.Attach(AppointmentUpdate);
var entry = dbContext.Entry(AppointmentUpdate);
entry.Property(e => e.IdState).IsModified = true;
// other changed properties
dbContext.SaveChanges();
}
else
{
return(false);
}
}
return(true);
}
public async Task <ICollection <StateTO> > GetStates()
{
List <StateTO> states = new List <StateTO>();
using (AppointmentsEntities dbContext = new AppointmentsEntities())
{
states = await dbContext.States.ProjectTo <StateTO>().ToListAsync();
}
return(states);
}
public async Task <ICollection <TypeTO> > GetTypes()
{
List <TypeTO> types = new List <TypeTO>();
using (AppointmentsEntities dbContext = new AppointmentsEntities())
{
types = await dbContext.Types.ProjectTo <TypeTO>().ToListAsync();
}
return(types);
}
public async Task <PacientTO> GetPacientInfo(string IdPacient)
{
PacientTO PacienteInfoByPacient = new PacientTO();
using (AppointmentsEntities dbContext = new AppointmentsEntities())
{
PacienteInfoByPacient = await dbContext.Pacients.Where(x => x.Id == IdPacient).ProjectTo <PacientTO>().FirstOrDefaultAsync();
}
return(PacienteInfoByPacient);
}
/// <see cref="MasGlobal.Employees.Domain.Integration.EmployeeIntegrationDAO.GetEmployees"/>
public async Task <ICollection <AppointmenTO> > GetAppointments(string IdPacient)
{
List <AppointmenTO> appointmentsByPacient = new List <AppointmenTO>();
using (AppointmentsEntities dbContext = new AppointmentsEntities())
{
appointmentsByPacient = await(from app in dbContext.Appointments
join pat in dbContext.Pacients on app.IdKeyPacient equals pat.IdKey
where pat.Id == IdPacient
select app).ProjectTo <AppointmenTO>().ToListAsync();
}
return(appointmentsByPacient);
}
public GenericRepository(AppointmentsEntities context)
{
this.context = context;
this.dbSet = context.Set <TEntity>();
}
