public static User Build(ITypeReader reader)
{
User user = new User();
user.UserId = reader.GetGuid("UserId");
user.AcceptedLatestTOS = reader.GetBool("AcceptedLatestTOS");
user.LastTOSVersion = reader.GetInt("LastTOSVersion");
user.PasswordExpiration = reader.GetDate("PasswordExpiration");
user.FirstTimeUser = reader.GetBool("NewUser");
user.DisplayName = reader.GetString("DisplayName");
user.FirstName = reader.GetString("FirstName");
user.MiddleName = reader.GetString("MiddleName");
user.LastName = reader.GetString("LastName");
user.Phone = reader.GetString("Phone");
user.Ext = reader.GetString("Ext");
user.SessionTimeoutInterval = reader.GetInt("SessionTimeout");
user.PasswordQuestion = reader.GetString("PasswordQuestion");
user.PasswordAnswer = reader.GetString("PasswordAnswer");
user.AdminUserId = reader.GetGuid("AdministratorUserId");
user.AdminUserName = reader.GetString("AdminUserName");
user.UserType = (UserTypes)reader.GetInt("UserTypeId");
user.UserTypeId = reader.GetInt("UserTypeId");
user.FailedPasswordAttemptCount = reader.GetInt("FailedPasswordAttemptCount");
user.FailedPasswordAnswerAttemptCount = reader.GetInt("FailedPasswordAnswerAttemptCount");
user.Status = reader.GetString("Status");
user.StatusTypeId = reader.GetInt("StatusTypeId");
return(user);
}
public static ApplicationSetting Build(ITypeReader reader)
{
ApplicationSetting applicationSetting = new ApplicationSetting();
applicationSetting.Key = reader.GetString("Key");
applicationSetting.Value = reader.GetString("Value");
return(applicationSetting);
}
public static Subscriber BuildPQRSsubscriber(ITypeReader reader)
{
Subscriber subscriber = Build(reader);
subscriber.NPI = reader.GetString(Columns.NPI, string.Empty);
subscriber.TIN = reader.GetString(Columns.TIN, string.Empty);
return(subscriber);
}
public static SystemSetting Build(ITypeReader reader)
{
SystemSetting systemSetting = new SystemSetting();
systemSetting.KeyName = reader.GetString(Columns.KEYNAME);
systemSetting.Value = reader.GetString(Columns.VALUE);
return(systemSetting);
}
public static TermsOfService Build(ITypeReader reader)
{
TermsOfService tos = new TermsOfService();
tos.TermsOfServiceID = reader.GetInt("TermsOfServiceID");
tos.TermsOfServiceText = reader.GetString("Text");
tos.Version = reader.GetString("Version");
return(tos);
}
public static Role BuildRoles(ITypeReader reader)
{
Role role = new Role();
role.RoleId = reader.GetGuid("RoleId");
role.RoleName = reader.GetString("RoleName");
role.LoweredRoleName = reader.GetString("RoleName").ToLower();
return(role);
}
public static OrgFunction Build(ITypeReader reader)
{
var orgFunction = new OrgFunction();
orgFunction.OrgFunctionId = reader.GetInt("OrgFunctionId");
orgFunction.Name = reader.GetString("OrgFunctionName");
orgFunction.Description = reader.GetString("Description", string.Empty);
orgFunction.IsDeleted = reader.GetBool("DeleteFlag", false);
return(orgFunction);
}
public static ApplicationMessage Build(ITypeReader reader)
{
ApplicationMessage applicationMessage = new ApplicationMessage();
applicationMessage.Code = reader.GetString("Code");
applicationMessage.Title = reader.GetString("Title");
applicationMessage.Text = reader.GetString("Text");
applicationMessage.Audit = reader.GetBool("Audit");
return(applicationMessage);
}
public static Permission Build(ITypeReader reader)
{
Permission permission = new Permission();
permission.PermissionId = reader.GetInt("PermissionId");
permission.Name = reader.GetString("Name");
permission.Description = reader.GetString("Description");
permission.PermissionTypeId = reader.GetInt("PermissionTypeId");
return(permission);
}
public static User BuildImpersonationUsers(ITypeReader reader)
{
User user = new User();
user.UserId = reader.GetGuid("UserId");
user.DisplayName = reader.GetString("DisplayName");
user.UserName = reader.GetString("UserName");
user.Status = reader.GetString("UserStatus");
return(user);
}
public static AccordionMember Build(ITypeReader reader)
{
AccordionMember accordionMember = new AccordionMember();
accordionMember.ControlId = reader.GetInt("ControlId");
accordionMember.Name = reader.GetString("Name");
accordionMember.Path = reader.GetString("Path");
accordionMember.ParentControlName = reader.GetString("ParentControlName");
accordionMember.ParentControlId = reader.GetInt("ParentControlId");
accordionMember.DisplayOrder = reader.GetInt("DisplayOrder");
return(accordionMember);
}
public static Role Build(ITypeReader reader)
{
Role role = new Role();
role.RoleId = reader.GetGuid("RoleId");
role.RoleName = reader.GetString("RoleName");
role.LoweredRoleName = reader.GetString("LoweredRoleName");
role.Description = reader.GetString("Description");
role.UserTypeId = reader.GetInt("UserTypeId");
role.ContractId = reader.GetInt("ContractId");
role.Level = reader.GetInt("Level");
return(role);
}
public static Patient BuildPQRSPatient(ITypeReader reader)
{
Patient patient = new Patient();
patient.Name = reader.GetString(Columns.PATIENTNAME);
patient.PatientId = reader.GetInt(Columns.PATIENTID);
patient.ClientPatientId = reader.GetString(Columns.CLIENTPATIENTID);
patient.Payer = reader.GetString(Columns.PAYER);
patient.DateOfService = DateTime.Parse(reader.GetString(Columns.DOS));
patient.MedicareFeeForService = reader.GetBool(Columns.MFFS);
patient.PatientPqriApptId = reader.GetInt(Columns.PATIENTPQRIAPPTID);
patient.PlaceOfService = reader.GetBool(Columns.PLACEOFSERVICE);
patient.PlaceOfServiceNumber = reader.GetString(Columns.PLACEOFSERVICENUMBER);
return(patient);
}
public static SecurityQuestion Build(ITypeReader reader)
{
SecurityQuestion securityQuestion = new SecurityQuestion();
securityQuestion.QuestionId = reader.GetInt("SecurityQuestionId");
securityQuestion.Question = reader.GetString("Question");
return(securityQuestion);
}
public static PasswordHistory Build(ITypeReader reader)
{
PasswordHistory PasswordHistory = new PasswordHistory();
PasswordHistory.UserId = reader.GetGuid("UserId");
PasswordHistory.Password = reader.GetString("Password");
return(PasswordHistory);
}
public static Control Build(ITypeReader reader)
{
Control control = new Control();
control.ControlId = reader.GetInt("ControlId");
control.DisplayOrder = reader.GetInt("DisplayOrder");
control.IsTab = reader.GetBool("IsTab");
control.IsSubTab = reader.GetBool("IsSubTab");
control.IsVisible = reader.GetBool("IsVisible");
control.ParentControlId = reader.GetInt("ParentControlId");
control.Name = reader.GetString("Name");
control.Path = reader.GetString("Path");
control.Description = reader.GetString("Description");
control.ParentControlName = reader.GetString("ParentControlName");
return(control);
}
public string[] ValidateUser(string userName)
{
using (ITypeReader reader = QueryReader(null, _dbConnName, StoredProcedure.CheckUserValid, userName))
{
if (reader.Read())
{
string condition = reader.GetString("Condition");
string message = reader.GetString("Message");
string daysToExpiration = reader.GetInt("DaysTillPasswordExpiration").ToString();
return(new string[] { condition, message, daysToExpiration });
}
else
{
return new string[] { }
};
}
}
//TODO Need to create list of Groups rather than Id
#region Public Methods
public static Subscriber Build(ITypeReader reader)
{
Subscriber subscriber = new Subscriber();
subscriber.SubscriberId = reader.GetInt(Columns.SUBSCRIBERID);
subscriber.Name = reader.GetString(Columns.SUBSCRIBERNAME);
//subscriber.Status = reader.GetString("Status");
return(subscriber);
}
public static Measure Build(ITypeReader reader)
{
Measure measure = new Measure();
measure.MeasureId = reader.GetInt(Columns.MEASUREIDCOLUMN);
measure.Name = reader.GetString(Columns.MEASURENAMECOLUMN);
measure.Numerator = reader.GetInt(Columns.NUMERATORCOLUMN);
measure.Denominator = reader.GetInt(Columns.DENOMINATORCOLUMN);
measure.Excluded = reader.GetInt(Columns.EXCLUDEDCOLUMN);
measure.LastDate = reader.GetDate(Columns.LASTDATE);
measure.LastValue = reader.GetString(Columns.LASTVALUE);
double percentage = ((double)measure.Numerator / (double)measure.Denominator) * (double)100;
measure.Percentage = String.Format("{0:0 %}", percentage.ToString());
return(measure);
}
public static OptOutType Build(ITypeReader reader)
{
OptOutType ooType = new OptOutType();
ooType.ProtocolId = reader.GetInt("ProtocolId");
ooType.ProtocolName = reader.GetString("ProtocolName");
return(ooType);
}
public static Measure BuildBasic(ITypeReader reader)
{
Measure measure = new Measure();
measure.MeasureId = reader.GetInt(Columns.MEASUREIDCOLUMN);
measure.Name = reader.GetString(Columns.MEASURENAMECOLUMN);
return(measure);
}
public static User BuildLightweight(ITypeReader reader)
{
User user = new User();
user.UserId = reader.GetGuid("UserId");
user.UserName = reader.GetString("UserName");
user.DisplayName = reader.GetString("DisplayName");
user.CreateDate = reader.GetDate("CreateDate").Value;
user.Status = reader.GetString("Status");
user.StatusTypeId = reader.GetInt("StatusTypeId");
user.UserType = (UserTypes)reader.GetInt("UserTypeId");
user.UserTypeId = reader.GetInt("UserTypeId");
user.LastLoginDate = reader.GetDate("LastLoginDate");
user.Email = reader.GetString("Email");
user.IsNewUser = reader.GetBool("IsNewUser");
return(user);
}
public static AttributionType Build(ITypeReader reader)
{
AttributionType attributionType = new AttributionType();
attributionType.AttributionTypeId = reader.GetInt(Columns.ATTRIBUTIONTYPEID);
attributionType.AttributionTypeName = reader.GetString(Columns.ATTRIBUTIONTYPENAME);
return(attributionType);
}
public static UserGroup Build(ITypeReader reader)
{
UserGroup group = new UserGroup();
group.UserId = reader.GetGuid("UserId");
group.GroupId = reader.GetInt("GroupId");
group.Name = reader.GetString("Name");
return(group);
}
public static PageView Build(ITypeReader reader)
{
var pageView = new PageView
{
ContractId = reader.GetInt("ContractId"),
Name = reader.GetString("ViewName"),
Description = reader.GetString("Description"),
IsPageDefaultView = reader.GetBool("IsPageDefaultView"),
IsUserDefaultView = reader.GetBool("IsUserDefaultView"),
ControlId = reader.GetInt("ControlId"),
PageName = reader.GetString("PageName"),
PagePath = reader.GetString("PagePath"),
UserId = reader.GetGuid("UserId"),
ViewContainer = reader.GetString("ViewContainer"),
ViewId = reader.GetInt("ViewId")
};
return(pageView);
}
public static Group Build(ITypeReader reader)
{
Group group = new Group();
group.GroupId = reader.GetInt(Columns.GROUPID);
group.Name = reader.GetString(Columns.NAME);
group.EnableAll = reader.GetBool(Columns.ENABLEALL);
group.CreateDate = reader.GetDate(Columns.CREATEDATE);
return(group);
}
public static Contract Build(ITypeReader reader)
{
Contract contract = new Contract();
PhytelEncrypter phytelEncrypter = new PhytelEncrypter();
contract.ContractId = reader.GetInt("ContractId");
contract.Name = reader.GetString("Name");
contract.Number = reader.GetString("Number");
contract.Database = reader.GetString("Database");
contract.Server = reader.GetString("Server");
contract.DefaultContract = reader.GetBool("DefaultContract");
contract.UserName = reader.GetString("UserName");
contract.Password = phytelEncrypter.Decrypt(reader.GetString("Password"));
contract.ConnectionString = string.Format("Data Source={0};Initial Catalog={1};Persist Security Info=True;User ID={2};Password={3}", contract.Server, contract.Database, contract.UserName, contract.Password);
contract.PhytelContractId = reader.GetInt("PhytelContractId");
return(contract);
}
//public static UserRole BuildUserRoles(ITypeReader reader)
//{
// return new UserRole {
// UserId = reader.GetGuid("UserId"),
// Role = BuildRoles(reader)
// };
//}
public static String BuildStatuses(ITypeReader reader)
{
return(reader.GetString("Status"));
}