public List <CaseAuthorization> GetCaseAuthorizationsAndGeneralHours(int caseID, bool omitBCBAAuths = false) { List <CaseAuthorization> list = new List <CaseAuthorization>(); var context = new Models.CoreEntityModel(); List <Models.CaseAuthCode> entities; if (omitBCBAAuths) { entities = context.CaseAuthCodes.Where(x => x.CaseID == caseID && x.CaseAuthClass.ID == 3).ToList(); } else { entities = context.CaseAuthCodes.Where(x => x.CaseID == caseID).ToList(); } foreach (var entity in entities) { var auth = Mappings.AuthorizationMappings.CaseAuthorization(entity); var generalHoursEntities = context.CaseAuthCodeGeneralHours.Where(x => x.CaseAuthID == auth.CaseAuthorizationID); auth.GeneralHours = Mappings.AuthorizationMappings.CaseAuthorizationGeneralHours(generalHoursEntities.ToList()); list.Add(auth); } list = list.OrderBy(x => x.StartDate).ThenBy(x => x.AuthClass.Code).ToList(); return(list); }
public List <MonthlyCasePeriod> GetCaseMonthlyPeriods(int caseID, DateTime startDate, DateTime endDate) { var context = new Models.CoreEntityModel(); try { var items = new List <MonthlyCasePeriod>(); var data = context.Database.SqlQuery <CaseMonthlyPeriodSprocDTO>( "GetCaseMonthlyPeriods @CaseID, @StartDate, @EndDate", new SqlParameter("@CaseID", caseID), new SqlParameter("@StartDate", startDate), new SqlParameter("@EndDate", endDate) ).ToList(); foreach (var dataItem in data) { var item = new Domain.Cases.MonthlyCasePeriod(); item.ID = dataItem.ID; item.FirstDayOfMonth = dataItem.PeriodFirstDayOfMonth; items.Add(item); } return(items); } catch (Exception e) { Dymeng.Framework.Exceptions.Handle(e); throw e; } }
public List <string> GetZipsByCounty(string state, string county) { var context = new Models.CoreEntityModel(); var items = context.ZipCodes.Where(x => x.ZipState == state && x.ZipCounty == county).Select(x => x.ZipCode1).Distinct().ToList(); return(items); }
public List <Service> GetServicesByProviderType(int providerTypeID) { // get from cache or db var cacheKey = "ServicesForProviderType" + providerTypeID; var list = CacheService.Get(cacheKey) as List <Service>; if (list != null) { return(list); } else { list = new List <Service>(); var context = new Models.CoreEntityModel(); var entities = context.ProviderTypeServices.Where(x => x.ProviderTypeID == providerTypeID).ToList(); foreach (var entity in entities) { var serviceEntity = entity.Service; list.Add(Mappings.CaseMappings.Service(serviceEntity)); } CacheService.Add(cacheKey, list); } return(list); }
public Domain.Email.SMTPAccount GetSMTPAccount(string accountName) { var entity = new Models.CoreEntityModel().SMTPAccounts.Where(x => x.AccountName == accountName).FirstOrDefault(); if (entity == null) { return(null); } var acct = new Domain.Email.SMTPAccount(); acct.AuthenticationMode = ((int?)entity.AccountAuthMode) ?? 1; acct.DisplayName = entity.AccountDisplayName; acct.FromAddress = entity.AccountDefaultFromAddress; acct.ID = entity.ID; acct.Name = entity.AccountName; acct.Password = entity.AccountPassword; acct.Port = (int?)entity.AccountPort ?? 25; acct.ReplyToAddress = entity.AccountDefaultReplyAddress; acct.Server = entity.AccountServer; acct.Username = entity.AccountUsername; acct.UseSSL = entity.AccountUseSSL ?? true; return(acct); }
public Domain.Cases.Authorization GetAuthorization(int id) { var context = new Models.CoreEntityModel(); var entity = context.AuthCodes.Find(id); return(Mappings.AuthorizationMappings.Authorization(entity)); }
public Domain.Cases.Authorization GetAuthorization(string authCode) { var context = new Models.CoreEntityModel(); var entity = context.AuthCodes.Where(x => x.CodeCode == authCode).FirstOrDefault(); return(Mappings.AuthorizationMappings.Authorization(entity)); }
public List <AABC.Domain.Providers.PayrollHours> GetPayrollHoursByPeriod(DateTime periodFirstDayOfMonth, int filter) { // filter has to match with AABC.Web.App.Providers.Models.PayrollFilter // due to this being an old structure, this isn't the ideal way to handle it // (this data project should be refactored so it doesn't need the filter, but // it's a big project, so we'll cheat for now) // int filter: // 0: non // 1: NY only // 2: non-NY var context = new Models.CoreEntityModel(); var data = context.Database.SqlQuery <PayrollHoursByPeriodSprocDTO>( "webreports.PayablesByPeriod @FirstDayOfMonth, @StateFilter", new System.Data.SqlClient.SqlParameter("@FirstDayOfMonth", periodFirstDayOfMonth), new System.Data.SqlClient.SqlParameter("@StateFilter", filter) ).ToList(); var items = new List <Domain.Providers.PayrollHours>(); foreach (var dataItem in data) { var item = new Domain.Providers.PayrollHours(); item.ID = dataItem.ID; item.PayrollID = dataItem.PayrollID; item.FirstName = dataItem.ProviderFirstName; item.LastName = dataItem.ProviderLastName; item.TotalHours = (double)dataItem.TotalPayable; item.EntriesMissingCatalystData = dataItem.EntriesMissingCatalystData; items.Add(item); } return(items); }
public List <Domain.Cases.Authorization> GetAuthorizations() { var context = new Models.CoreEntityModel(); var entities = context.AuthCodes.ToList(); return(Mappings.AuthorizationMappings.Authorizations(entities)); }
public bool ProviderNumberExists(string providerNumber) { var context = new Models.CoreEntityModel(); var data = context.Providers.Where(x => x.ProviderNPI == providerNumber || x.ProviderNumber == providerNumber).FirstOrDefault(); return(data == null ? false : true); }
public Case GetCase(int caseID) { var context = new Models.CoreEntityModel(); var c = context.Cases.Find(caseID); return(Mappings.CaseMappings.Case(c)); }
public IEnumerable <Domain.Providers.Provider> GetActiveProviders() { var context = new Models.CoreEntityModel(); var data = context.Providers.ToList(); return(Mappings.ProviderMappings.Providers(data)); }
public List <CaseAuthorizationHours> GetCaseHoursByCaseByProvider(int caseID, int providerID, DateTime?cutoffDate = null) { var context = new Models.CoreEntityModel(); IQueryable <Models.CaseAuthHour> q; if (cutoffDate == null) { q = (from auths in context.CaseAuthCodes join hours in context.CaseAuthHours on auths.ID equals hours.CaseAuthID where auths.CaseID == caseID && hours.CaseProviderID == providerID select hours) .Union( from hours in context.CaseAuthHours where hours.CaseID == caseID && hours.CaseProviderID == providerID select hours ); } else { q = (from auths in context.CaseAuthCodes join hours in context.CaseAuthHours on auths.ID equals hours.CaseAuthID where auths.CaseID == caseID && hours.CaseProviderID == providerID && hours.HoursDate >= cutoffDate.Value select hours) .Union( from hours in context.CaseAuthHours where hours.CaseID == caseID && hours.CaseProviderID == providerID && hours.HoursDate >= cutoffDate.Value select hours ); } var providerHours = q.ToList(); var list = Mappings.AuthorizationMappings.CaseAuthorizationHours(providerHours); var services = GetServices(); var providerService = new ProviderService(); foreach (var hours in list) { hours.Service = services.Where(x => x.ID == hours.Service.ID).FirstOrDefault(); var provider = providerService.GetProvider(hours.ProviderID); Domain.Cases.CaseProvider cp = new CaseProvider(); cp.FirstName = provider.FirstName; cp.LastName = provider.LastName; hours.Provider = cp; } return(list); }
public List <Models.Sprocs.PeriodHoursMatrixByCase> PeriodHoursMatrix(int caseID, DateTime startDate, DateTime endDate) { var context = new Models.CoreEntityModel(); return(context.Database.SqlQuery <Models.Sprocs.PeriodHoursMatrixByCase>( "dbo.GetPeriodHoursMatrixByCase @CaseID, @StartDate, @EndDate", new SqlParameter("@CaseID", caseID), new SqlParameter("@StartDate", startDate), new SqlParameter("@EndDate", endDate) ).ToList()); }
public List <CaseAuthorizationHours> GetCaseHoursByCaseAndDate(int caseID, DateTime date) { List <CaseAuthorizationHours> list = new List <CaseAuthorizationHours>(); var context = new Models.CoreEntityModel(); var entities = context.CaseAuthHours.Where(x => x.CaseID == caseID && x.HoursDate == date).ToList(); list = Mappings.AuthorizationMappings.CaseAuthorizationHours(entities); return(list); }
public List <CaseAuthorizationHours> GetCaseHoursByDateRange(DateTime startDate, DateTime endDate) { var list = new List <CaseAuthorizationHours>(); var context = new Models.CoreEntityModel(); var entities = context.CaseAuthHours.Where(x => x.HoursDate >= startDate && x.HoursDate <= endDate).ToList(); list = Mappings.AuthorizationMappings.CaseAuthorizationHours(entities); return(list); }
public List <string> GetCountiesList(string state) { if (state == null) { return(new List <string>()); } var context = new Models.CoreEntityModel(); var items = context.ZipCodes.Where(x => x.ZipState == state && x.ZipCounty != null).Select(x => x.ZipCounty).Distinct().ToList(); return(items); }
public List <Case> GetCasesByPatientName(string firstName, string lastName) { var context = new Models.CoreEntityModel(); var q = from cases in context.Cases join patients in context.Patients on cases.PatientID equals patients.ID where patients.PatientFirstName == firstName && patients.PatientLastName == lastName select cases; var entities = q.ToList(); return(Mappings.CaseMappings.Cases(q, true).ToList()); }
public List <Domain.Hours.HoursDownload> GetHoursForDownload(int providerID, int caseID, int month, int year) { var context = new Models.CoreEntityModel(); var entities = context.Database.SqlQuery <Domain.Hours.HoursDownload>( "[dbo].GetHoursForDownload @ProviderID, @CaseID, @Month, @Year", new SqlParameter("@ProviderID", providerID), new SqlParameter("@CaseID", caseID), new SqlParameter("@Month", month), new SqlParameter("@Year", year) ).ToList(); return(entities); }
public AuthorizationClass GetAuthClassByCode(string authClassCode) { var context = new Models.CoreEntityModel(); var entity = context.CaseAuthClasses.Where(x => x.AuthClassCode == authClassCode).FirstOrDefault(); if (entity == null) { return(null); } else { return(Mappings.AuthorizationMappings.AuthorizationClass(entity)); } }
public CaseProvider GetCaseProviderByProviderAndCaseIDs(int providerID, int caseID) { var context = new Models.CoreEntityModel(); var entity = context.CaseProviders.Where(x => x.ProviderID == providerID && x.CaseID == caseID).FirstOrDefault(); entity.Provider = context.Providers.Where(x => x.ID == providerID).FirstOrDefault(); if (entity == null) { return(null); } else { return(Mappings.CaseMappings.CaseProvider(entity)); } }
public List <CaseAuthorizationHours> GetCaseHoursByCase(int caseID, DateTime?cutoff = null) { List <CaseAuthorizationHours> list = new List <CaseAuthorizationHours>(); var context = new Models.CoreEntityModel(); IQueryable <Models.CaseAuthHour> q; if (cutoff == null) { q = (from hours in context.CaseAuthHours where hours.CaseID == caseID select hours) .Union( from hours in context.CaseAuthHours join auths in context.CaseAuthCodes on hours.CaseAuthID equals auths.ID where auths.CaseID == caseID && hours.CaseAuthID == auths.ID select hours ); } else { q = (from hours in context.CaseAuthHours where hours.CaseID == caseID && hours.HoursDate >= cutoff.Value select hours) .Union( from hours in context.CaseAuthHours join auths in context.CaseAuthCodes on hours.CaseAuthID equals auths.ID where auths.CaseID == caseID && hours.CaseAuthID == auths.ID && hours.HoursDate >= cutoff.Value select hours ); } var entities = q.ToList(); list = Mappings.AuthorizationMappings.CaseAuthorizationHours(entities); foreach (var hours in list) { hours.Provider = Mappings.CaseMappings.CaseProvider(context.CaseProviders.Where(x => x.ProviderID == hours.Provider.ID.Value).FirstOrDefault()); hours.Authorization = Mappings.AuthorizationMappings.CaseAuthorization(context.CaseAuthCodes.Where(x => x.ID == hours.Authorization.ID).FirstOrDefault()); } return(list); }
public List <Provider> GetProviders() { var context = new Models.CoreEntityModel(); var entityProviders = context.Providers.ToList(); var entityProviderUsers = context.ProviderPortalUsers.ToList(); var providers = Mappings.ProviderMappings.Providers(entityProviders); var users = Mappings.ProviderPortalMappings.ProviderPortalUsers(entityProviderUsers); foreach (var p in providers) { p.PortalUser = users.Where(x => x.ProviderID == p.ID).FirstOrDefault(); } return(providers.ToList()); }
public CaseAuthorizationHours GetCaseHoursItem(int hoursID) { var item = new CaseAuthorizationHours(); var context = new Models.CoreEntityModel(); var entity = context.CaseAuthHours.Find(hoursID); if (entity == null) { return(null); } else { return(Mappings.AuthorizationMappings.CaseAuthorizationHour(entity)); } }
public IEnumerable <Domain.General.GeneralLanguage> GetCommonLanguages() { var cache = CacheService.Get(CacheServiceItems.CommonLanguageList); if (cache == null) { var context = new Models.CoreEntityModel(); var data = context.CommonLanguages.ToList(); var models = Mappings.GeneralMappings.GeneralLanguages(data); CacheService.Add(CacheServiceItems.CommonLanguageList, models, 120); return(models); } else { return(cache as List <Domain.General.GeneralLanguage>); } }
private User setupUser(string username) { var context = new Models.CoreEntityModel(); var entity = context.WebUsers.Where(x => x.UserName == username).FirstOrDefault(); if (entity == null) { return(null); } var user = Mappings.WebUserMappings.User(entity); user.Permissions = Mappings.WebUserMappings.Permissions(context.WebUserPermissions.Where(x => x.WebUserID == user.ID).ToList()); user.Options = Mappings.WebUserMappings.Options(context.WebUserOptions.Where(x => x.WebUserID == user.ID).ToList()); return(user); }
public ProviderPortalUser GetPortalUserByAspNetUsername(string aspNetUsername) { var context = new Models.CoreEntityModel(); var entity = context.ProviderPortalUsers.Where(x => x.ProviderUserNumber == aspNetUsername).FirstOrDefault(); if (entity == null) { return(null); } var ppu = Mappings.ProviderPortalMappings.ProviderPortalUser(entity, false); var provider = context.Providers.Find(ppu.ProviderID); ppu.FirstName = provider.ProviderFirstName; ppu.LastName = provider.ProviderLastName; return(ppu); }
public List <Domain.Cases.Case> GetActiveCasesByProvider(int providerID, int visibleAfterEndDateDays) { var context = new Models.CoreEntityModel(); DateTime cutoff = DateTime.Now.AddDays(visibleAfterEndDateDays * -1); var q = from c in context.Cases join cp in context.CaseProviders on c.ID equals cp.CaseID where cp.ProviderID == providerID && cp.Active == true && c.CaseStatus != (int)Domain.Cases.CaseStatus.History && (!cp.ActiveStartDate.HasValue || cp.ActiveStartDate.Value <= DateTime.Now) && (!cp.ActiveEndDate.HasValue || cp.ActiveEndDate.Value >= cutoff) select c; var entities = q.ToList(); return(Mappings.CaseMappings.Cases(entities).ToList()); }
public List <Domain.General.GuardianRelationship> GetGuardianRelationships() { CacheServiceItems key = CacheServiceItems.GuardianRelationship; var list = CacheService.Get(key) as List <Domain.General.GuardianRelationship>; if (list != null) { return(list); } else { list = new List <Domain.General.GuardianRelationship>(); var context = new Models.CoreEntityModel(); var entities = context.GuardianRelationships.ToList(); list = Mappings.GeneralMappings.GuardianRelationships(entities).ToList(); CacheService.Add(key, list); return(list); } }
//public List<Domain.Cases.Case> GetActiveCasesByProvider(int providerID) { // var context = new Models.CoreEntityModel(); // var q = from c in context.Cases // join cp in context.CaseProviders on c.ID equals cp.CaseID // where cp.ProviderID == providerID && cp.Active == true // select c; // var entities = q.ToList(); // return Mappings.CaseMappings.Cases(entities).ToList(); //} public List <CaseAuthorization> GetCaseAuthorizationsAndHours(int caseID) { List <CaseAuthorization> list = new List <CaseAuthorization>(); var context = new Models.CoreEntityModel(); var entities = context.CaseAuthCodes.Where(x => x.CaseID == caseID).ToList(); foreach (var entity in entities) { var auth = Mappings.AuthorizationMappings.CaseAuthorization(entity); var hoursEntities = context.CaseAuthHours.Where(x => x.CaseAuthID == auth.CaseAuthorizationID); auth.Hours = Mappings.AuthorizationMappings.CaseAuthorizationHours(hoursEntities.ToList()); list.Add(auth); } return(list); }