private bool CanAddToContext(Guid userId, string planType, string policyNumber)
{
using (var ctx = new NuMedicsGlobalEntities())
{
return(!ctx.InsurancePlans.Any(a => a.UserId == userId && a.PlanType == planType && a.PolicyNumber == policyNumber));
}
}
private bool CanAddToContext(Guid userId, int hyperglycemicLevel, int hypoglycemicLevel)
{
using (var ctx = new NuMedicsGlobalEntities())
{
return((ctx.CareSettings.Any(a => a.UserId == userId && a.HyperglycemicLevel == hyperglycemicLevel && a.HypoglycemicLevel == hypoglycemicLevel)) ? false : true);
}
}
private void SaveCompletedPumpSettingMappings()
{
try
{
using (var ctx = new NuMedicsGlobalEntities())
{
var stats = new SqlTableStats("PumpSettings");
ctx.PumpSettings.AddRange(CompletedPumpSettingMappings);
stats.PreSaveCount = ctx.ChangeTracker.Entries <PumpSetting>().Where(w => w.State == System.Data.Entity.EntityState.Added).Count();
var saved = ctx.SaveChanges();
stats.PostSaveCount = (saved > stats.PreSaveCount) ? stats.PreSaveCount : saved;
MappingStatistics.SqlTableStatistics.Add(stats);
}
}
catch (DbEntityValidationException e)
{
throw new Exception("Error validating PumpSetting entity", e);
}
catch (Exception e)
{
throw new Exception("Error saving PumpSetting entity", e);
}
SaveCompletedPumpProgramMappings();
}
private bool CanAddToContext(Guid userId)
{
using (var ctx = new NuMedicsGlobalEntities())
{
return(!ctx.Patients.Any(a => a.UserId == userId));
}
}
private bool CanAddToContext(Guid userId, string pumpName)
{
using (var ctx = new NuMedicsGlobalEntities())
{
return(!ctx.Pumps.Any(a => a.UserId == userId && a.PumpName == pumpName));
}
}
private bool CanAddToContext(Guid userId)
{
using (var ctx = new NuMedicsGlobalEntities())
{
return(!ctx.Clinicians.Any(c => c.UserId == userId));
}
}
private bool CanAddToContext(string name, int legacySiteId)
{
using (var ctx = new NuMedicsGlobalEntities())
{
return((ctx.Institutions.Any(a => a.Name == name && a.LegacySiteId == legacySiteId)) ? false : true);
}
}
private static void PatientLinks()
{
using (var ctx = new NuMedicsGlobalEntities())
{
System.Console.WriteLine(ctx.Users.Where(w => w.Patient == null && w.UserType == 2).Count());
System.Console.ReadLine();
}
}
private bool CanAddToContext(string phoneNumber)
{
if (String.IsNullOrEmpty(phoneNumber))
{
return(false);
}
using (var ctx = new NuMedicsGlobalEntities())
{
return(!ctx.PatientPhoneNumbers.Any(a => a.Number == phoneNumber));
}
}
private bool CanAddToContext(Guid userId, string serialNumber)
{
if (String.IsNullOrEmpty(serialNumber))
{
return(false);
}
using (var ctx = new NuMedicsGlobalEntities())
{
return((ctx.PatientDevices.Any(a => a.UserId == userId && a.SerialNumber == serialNumber)) ? false : true);
}
}
private bool CanAddToContext(string providerName)
{
if (String.IsNullOrEmpty(providerName))
{
return(false);
}
using (var ctx = new NuMedicsGlobalEntities())
{
return((ctx.InsuranceProviders.Any(a => a.Name == providerName)) ? false : true);
}
}
private bool CanAddToContext(Guid userid, int subscriptionType, DateTime expiration, Guid institutionId)
{
if (institutionId == Guid.Empty)
{
return(false);
}
using (var ctx = new NuMedicsGlobalEntities())
{
if (MemoryMappings.GetAllInstitutions().Any(a => a.InstitutionId == institutionId))
{
return(!ctx.Subscriptions.Any(a => a.UserId == userid && a.SubscriptionType == subscriptionType && a.ExpirationDate == expiration));
}
else
{
return(false);
}
}
}
public SubscriptionTypeVaidation(DbContext context)
{
db = (NuMedicsGlobalEntities)context;
Init();
}
public NumedicsGlobalHelpersTest()
{
db = new NuMedicsGlobalEntities();
}
public PaymentMethodValidation(DbContext context)
{
db = (NuMedicsGlobalEntities)context;
Init();
}
public CheckStatusValidation(DbContext context)
{
db = (NuMedicsGlobalEntities)context;
Init();
}
public TherapyTypeValidation(DbContext context)
{
db = (NuMedicsGlobalEntities)context;
Init();
}
public NumedicsGlobalHelpers(DbContext context)
{
db = (NuMedicsGlobalEntities)context;
}
public ReadingEventTypeValidation(DbContext context)
{
db = (NuMedicsGlobalEntities)context;
Init();
}
public ApplicationValidation(DbContext context)
{
db = (NuMedicsGlobalEntities)context;
Init();
}
static TransactionManager()
{
DatabaseContext = new NuMedicsGlobalEntities();
}
public InsulinTypeValidation(DbContext context)
{
db = (NuMedicsGlobalEntities)context;
Init();
}
