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);
}
