public bool Remove(string cohortId)
{
Guid id = Utils.ToGuid(cohortId);
using (var dbContext = new MedialynxDbCohortContext()) {
if (id != Guid.Empty)
{
string sid = id.ToString("B");
Cohort cohort = dbContext.Cohorts.FirstOrDefault(c => c != null && c.Id == sid);
if (cohort != null)
{
dbContext.Cohorts.Remove(cohort);
dbContext.SaveChanges();
using (var dbContextLinks = new MedialynxDbCohortEnumLinkContext()) {
List <CohortEnumLink> links = dbContextLinks.CohortEnumLink.Where(link => link != null && link.CohortId == sid).ToList();
dbContextLinks.RemoveRange(links);
dbContextLinks.SaveChanges();
}
}
return(true);
}
}
return(false);
}
public void Add(Cohort cohort)
{
using (var dbContext = new MedialynxDbCohortContext()) {
dbContext.Cohorts.Add(cohort);
dbContext.SaveChanges();
}
}
// Get cohort by id
public Cohort GetById(string cohortId = "{00000000-0000-0000-0000-000000000000}")
{
Guid id = Utils.ToGuid(cohortId, false);
if (id == Guid.Empty)
{
return(null);
}
using (var dbContext = new MedialynxDbCohortContext()) {
string sid = id.ToString("B");
return(dbContext.Cohorts.FirstOrDefault(cohort => cohort != null && cohort.Id == sid));
}
}
public void Update(Cohort cohort)
{
using (var dbContext = new MedialynxDbCohortContext()) {
Cohort existsCohort = dbContext.Cohorts.FirstOrDefault(coh => coh != null && coh.Id == cohort.Id);
if (existsCohort != null)
{
if (Utils.CopyPropertyValues <Cohort>(cohort, existsCohort))
{
dbContext.Cohorts.Update(existsCohort);
dbContext.SaveChanges();
}
}
}
}
public List <Cohort> GetAllByUser(string userId)
{
Guid id = Utils.ToGuid(userId);
using (var dbContext = new MedialynxDbCohortContext()) {
if (id != Guid.Empty)
{
string sid = id.ToString("B");
List <Cohort> cohorts = dbContext.Cohorts.Where(c => c != null && c.UserId == sid).ToList();
cohorts.Sort(new CohortComparer());
return(cohorts);
}
}
return(new List <Cohort>());
}
public Cohort GetFirstByUser(string userId, bool notRejected = true)
{
Guid id = Utils.ToGuid(userId);
using (var dbContext = new MedialynxDbCohortContext()) {
if (id != Guid.Empty)
{
string sid = id.ToString("B");
List <Cohort> cohorts = dbContext.Cohorts.Where(c => c != null &&
c.UserId == sid &&
(!notRejected || (c.RequestAdmin != RequestType.Rejected || c.RequestUser != RequestType.Rejected))
).ToList();
cohorts.Sort(new CohortComparer());
return(cohorts.Count > 0 ? cohorts[0] : null);
}
}
return(null);
}
public List <Cohort> Get(string cohortId = "{00000000-0000-0000-0000-000000000000}")
{
Guid id = Utils.ToGuid(cohortId);
List <Cohort> cohorts = new List <Cohort>();
using (var dbContext = new MedialynxDbCohortContext()) {
if (id != Guid.Empty)
{
string sid = id.ToString("B");
Cohort cohort = dbContext.Cohorts.FirstOrDefault(c => c != null && c.Id == sid);
cohorts.Add(cohort);
}
else
{
// Add all cohorts
cohorts.AddRange(dbContext.Cohorts);
}
}
cohorts.Sort(new CohortComparer());
return(cohorts);
}
