/// <summary>
/// True if the specified hoursID is an SSG entry, and if this is the entry that the SSG was originated with
/// </summary>
/// <param name="hoursID"></param>
/// <returns></returns>
public static bool IsOriginatingHoursEntry(int hoursID)
{
if (_context == null)
{
_context = ContextProvider.Context;
}
var entry = _context.Hours.Find(hoursID);
if (entry.SSGParentID.HasValue)
{
if (entry.SSGParentID.Value == entry.ID)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
// Constructors
public CasesRepository(ICurrentUserProvider currentUserProvider, IDBContextProvider dBContextProvider, ISettingsProvider settingsRepository)
{
_currentUser = currentUserProvider;
_context = dBContextProvider.CoreContext;
_settings = settingsRepository;
hoursEntryMappings = new HoursEntryMappings(_currentUser.Provider, _context);
}
public TimesheetImporter(string filePath)
{
_filePath = filePath;
_context = new Data.V2.CoreContext();
_context.Configuration.AutoDetectChangesEnabled = false;
_context.Configuration.ValidateOnSaveEnabled = false;
}
internal bool UserHasAcceptedTerms(Domain2.PatientPortal.Terms terms)
{
var ctx = new Data.V2.CoreContext();
var user = ctx.PatientPortalLogins.Where(x => x.ID == AppService.Current.User.CurrentUser.ID).Single();
return(user.AcceptedTerms.Any(m => m.TermsId == terms.ID));
}
public HoursEntryResolver(Domain.Cases.Case targetCase, Domain.Cases.CaseAuthorizationHours authHours, Data.Services.ICaseService caseService)
{
this.targetCase = targetCase;
subjectHours = authHours;
ValidationErrors = new List <Dymeng.Framework.Validation.ValidationError>();
this.caseService = caseService;
_context2 = new Data.V2.CoreContext();
}
private void resolveHoursAuths(int hoursID)
{
var c2 = new Data.V2.CoreContext();
var h = c2.Hours.Find(hoursID);
var authResolver = new DomainServices.Hours.AuthResolver(h);
authResolver.UpdateAuths(c2);
}
/// <summary>
/// Update the database with the authorization breakdowns
/// Use an existing hours context to do this
/// </summary>
/// <param name="context"></param>
public void UpdateAuths(Data.V2.CoreContext context)
{
var auths = GetAuthorizationBreakdowns();
if (_hours.AuthorizationBreakdowns != null)
{
while (_hours.AuthorizationBreakdowns.Count > 0)
{
context.AuthorizationBreakdowns.Remove(_hours.AuthorizationBreakdowns.First());
}
context.SaveChanges();
}
_hours.AuthorizationBreakdowns = auths;
context.SaveChanges();
}
public static HoursEligiblityVM GetModel()
{
var context = new Data.V2.CoreContext();
var model = new HoursEligiblityVM();
var insuranceIssues = context.HoursEntryEligibleCasesWithoutActiveInsurance().ToList();
var authIssues = context.HoursEntryEligibleCasesWithoutActiveAuthorizations().ToList();
var ruleIssues = context.HoursEntryEligibleAuthorizationsWithoutMatchRules().ToList();
model.ActiveInsuranceIssues = ActiveInsuranceIssue.Transform(insuranceIssues);
model.ActiveAuthorizationIssues = ActiveAuthorizationIssue.Transform(authIssues);
model.ActiveRuleIssues = ActiveRuleIssue.Transform(ruleIssues);
return(model);
}
/// <summary>
/// Returns a list of Case IDs for associated SSG entries, or null if not an SSG entry
/// </summary>
/// <param name="hoursID"></param>
/// <returns></returns>
public static int[] GetAssociatedCaseIDs(int hoursID)
{
if (_context == null)
{
_context = ContextProvider.Context;
}
var entry = _context.Hours.Find(hoursID);
if (entry.SSGParentID.HasValue)
{
return(_context.Hours.Where(x => x.SSGParentID == entry.SSGParentID.Value).Select(x => x.CaseID).ToArray());
}
else
{
return(null);
}
}
private Data.V2.CoreContext addToContext(Data.V2.CoreContext context, Domain2.Integrations.Catalyst.HasDataEntry entity, int count, int commitCount, bool recreateContext)
{
//https://stackoverflow.com/questions/5940225/fastest-way-of-inserting-in-entity-framework
context.Set <Domain2.Integrations.Catalyst.HasDataEntry>().Add(entity);
if (count % commitCount == 0)
{
context.SaveChanges();
if (recreateContext)
{
context.Dispose();
context = new Data.V2.CoreContext();
context.Configuration.AutoDetectChangesEnabled = false;
}
}
return(context);
}
public void Import()
{
var table = getTableFromExcel();
// do this differently if we ever get real volume...
_context.CatalystHasDataEntries.RemoveRange(_context.CatalystHasDataEntries);
_context.SaveChanges();
table.Rows.Remove(table.Rows[0]); // blank row
var dateRow = table.Rows[0];
int colCount = table.Columns.Count;
int count = 0;
for (int i = 1; i < table.Rows.Count - 1; i++)
{
string studentName = table.Rows[i][0].ToString();
for (int j = 1; j < colCount - 1; j++)
{
DateTime d = getDateFromRawValue(dateRow[j].ToString());
var initials = table.Rows[i][j].ToString();
if (!string.IsNullOrWhiteSpace(initials.Trim()))
{
count++;
var item = new Domain2.Integrations.Catalyst.HasDataEntry();
item.Name = studentName;
item.ProviderInitialsSet = initials.Trim();
item.Date = d;
_context = addToContext(_context, item, count, 100, true);
}
}
}
_context.SaveChanges();
}
public InsuranceManager()
{
_context = ContextProvider.Context;
}
public SocialSkillsGroup(Data.V2.CoreContext context)
{
_context = context;
}
public PatientsService()
{
_context = AppService.Current.Data.Context;
}
public FinalizeService()
{
_context = AppService.Current.Context;
_hoursNotesValidator = new HoursNotesValidator();
_caseService = new CaseService();
}
public ProviderQueryService(Data.V2.CoreContext context, Repositories.IProviderRepository repository)
{
_context = AppService.Current.DataContextV2;
_repository = repository;
}
public AdminService()
{
_legacyUserRepository = new App.Account.UserRepository();
_context = AppService.Current.DataContextV2;
}
public SignInService(Data.V2.CoreContext context)
{
_context = context;
}
public CurrentUserProvider(IDBContextProvider _dbContextProvider)
{
_dbContext = _dbContextProvider.CoreContext;
}
public ReportingService()
{
hoursRepo = new Repos.HoursRepo();
_context = AppService.Current.DataContextV2;
}
public ServiceProvider(Data.V2.CoreContext context)
{
_context = context;
}
public ServiceProvider()
{
_context = ContextProvider.Context;
}
public SocialSkillsGroup()
{
_context = ContextProvider.Context;
}
public PatientService(Data.V2.CoreContext context)
{
_context = context;
}
public InsuranceManager(Data.V2.CoreContext context)
{
_context = context;
}
public HourService(Data.V2.CoreContext context)
{
_context = context;
}
public ProviderCommandService(Data.V2.CoreContext context, Repositories.IProviderRepository repository)
{
_context = context;
_repository = repository;
}
public BatchAuthResolver(Data.V2.CoreContext context)
{
Context = context;
}
public SettingsService()
{
_context = AppService.Current.Data.Context;
}
public HomeRepository(Data.V2.CoreContext context)
{
caseService = new Data.Services.CaseService();
connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["CoreConnection"].ConnectionString;
_context = context;
}
