public void CreatePumpProgramsMapping()
{
try
{
var dataSet = TableAgent.DataSet.Tables[FbTableName].Rows;
RecordCount = TableAgent.RowCount;
foreach (DataRow row in dataSet)
{
// get userid from old aspnetdb matching on patientid #####.#####
var patId = row["PATIENTID"].ToString();
var userId = MemoryMappings.GetUserIdFromPatientInfo(MigrationVariables.CurrentSiteId, patId);
if (!mHelper.HasPatientMigrated(patId))
{
if (userId != Guid.Empty)
{
var CreationDate = (row["CREATEDATE"] is DBNull) ? DateTime.MinValue : mu.ParseFirebirdDateTime(row["CREATEDATE"].ToString());
var Source = (row["SOURCE"] is DBNull) ? String.Empty : row["SOURCE"].ToString();
var Valid = mu.ParseFirebirdBoolean(row["ACTIVEPROGRAM"].ToString());
for (int i = 1; i < 8; i++)
{
var pKey = (row[$"PROG{i}KEYID"] is DBNull) ? 0 : mu.ParseInt(row[$"PROG{i}KEYID"].ToString());
if (pKey != 0)
{
for (int s = 0; s < 1; s++)
{
PumpProgram p = new PumpProgram();
p.CreationDate = CreationDate;
p.Source = Source;
p.Valid = true;
p.IsEnabled = Valid;
p.ProgramKey = pKey;
p.NumOfSegments = 7;
p.ProgramName = $"Prog {pKey}";
if (s == 0)
{
p.ProgramTypeId = 1;
p.ProgramTimeSlots = GetBasalPrgTimeSlots(userId, CreationDate);
}
if (s == 1)
{
p.ProgramTypeId = 2;
p.ProgramTimeSlots = GetBolusPrgTimeSlots(userId, CreationDate);
}
if (CreationDate != DateTime.MinValue && pKey != 0 && p.ProgramTimeSlots.Count > 0)
{
MemoryMappings.AddPumpProgram(userId, pKey, p);
}
else
{
MappingStatistics.LogFailedMapping("PATIENTPUMPPROGRAM", row["KEYID"].ToString(), "PumpPrograms", typeof(PumpProgram), JsonConvert.SerializeObject(p), "Unable to add PumpProgram to database because creation date was null.");
FailedCount++;
}
}
}
}
}
}
}
MappingStatistics.LogMappingStat("PATIENTPUMPPROGRAM", RecordCount, "PumpPrograms", MemoryMappings.GetAllPumpPrograms().Count, FailedCount);
}
catch (Exception e)
{
throw new Exception("Error creating PumpProgram mapping.", e);
}
}
public void CreatePatientPhoneNumbersMapping()
{
try
{
var dataSet = TableAgent.DataSet.Tables[FbTableName].Rows;
RecordCount = TableAgent.RowCount;
foreach (DataRow row in dataSet)
{
// get userid from old aspnetdb matching on patientid #####.#####
var patId = row["PARENTID"].ToString();
var userId = MemoryMappings.GetUserIdFromPatientInfo(MigrationVariables.CurrentSiteId, patId);
if (!mHelper.HasPatientMigrated(patId))
{
var patNum = new PatientPhoneNumber
{
UserId = userId,
Number = (row["NUMBER"] is DBNull) ? String.Empty : row["NUMBER"].ToString(),
Extension = (row["EXTENSION"] is DBNull) ? String.Empty : row["EXTENSION"].ToString(),
Type = (row["ATYPE"] is DBNull) ? 0 : map.ParseFirebirdPhoneTypes(row["ATYPE"].ToString()),
IsPrimary = (row["ISPRIMARY"] is DBNull) ? false : map.ParseFirebirdBoolean(row["ISPRIMARY"].ToString()),
RecieveText = (row["RECEIVETEXT"] is DBNull) ? false : map.ParseFirebirdBoolean(row["RECEIVETEXT"].ToString()),
LastUpdatedByUser = userId
};
if (userId != Guid.Empty && CanAddToContext(patNum.Number))
{
CompletedMappings.Add(patNum);
}
else
{
var fr = (userId == Guid.Empty) ? "Phone number has no corresponding patient." : "Patient phone number already exist in database.";
MappingStatistics.LogFailedMapping("PHONENUMBERS", row["KEYID"].ToString(), "PatientPhoneNumbers", typeof(PatientPhoneNumber), JsonConvert.SerializeObject(patNum), fr);
FailedCount++;
}
}
}
MappingStatistics.LogMappingStat("PHONENUMBERS", RecordCount, "PatientPhoneNumbers", CompletedMappings.Count, FailedCount);
}
catch (Exception e)
{
throw new Exception("Error creating PatientPhonenumber mapping.", e);
}
}
public void CreateInsuranceCompanyMapping()
{
try
{
var dataSet = TableAgent.DataSet.Tables[FbTableName].Rows;
RecordCount = TableAgent.RowCount;
foreach (DataRow row in dataSet)
{
if (!String.IsNullOrEmpty(row["NAME"].ToString()))
{
var name = row["NAME"].ToString();
var kId = row["KEYID"].ToString();
MemoryMappings.AddCompnay(kId, name);
var ips = new InsuranceProvider
{
Name = name,
IsActive = map.ParseFirebirdBoolean(row["ISACTIVE"].ToString()),
InActiveDate = map.ParseFirebirdDateTime(row["INACTIVEDATE"].ToString()),
LastUpdatedByUser = Guid.Empty
};
var adr = new InsuranceAddress
{
Street1 = (row["STREET1"] is DBNull) ? String.Empty : row["STREET1"].ToString(),
Street2 = (row["STREET2"] is DBNull) ? String.Empty : row["STREET2"].ToString(),
Street3 = (row["STREET3"] is DBNull) ? String.Empty : row["STREET3"].ToString(),
City = (row["CITY"] is DBNull) ? String.Empty : row["CITY"].ToString(),
State = (row["STATE"] is DBNull) ? String.Empty : row["STATE"].ToString(),
Zip = (row["ZIP"] is DBNull) ? String.Empty : row["ZIP"].ToString(),
Country = (row["COUNTRY"] is DBNull) ? String.Empty : row["COUNTRY"].ToString(),
LastUpdatedByUser = Guid.Empty
};
var cont = new InsuranceContact
{
FullName = (row["CONTACTNAME"] is DBNull) ? "No Name" : row["CONTACTNAME"].ToString(),
Email = (row["EMAIL"] is DBNull) ? String.Empty : row["EMAIL"].ToString(),
LastUpdatedByUser = Guid.Empty
};
ips.InsuranceAddresses.Add(adr);
ips.InsuranceContacts.Add(cont);
if (CanAddToContext(ips.Name))
{
CompletedMappings.Add(ips);
}
else
{
MappingStatistics.LogFailedMapping("INSURANCECOS", kId, "InsuranceProviders", typeof(InsuranceProvider), JsonConvert.SerializeObject(ips), "Insurance Provider already exist in database.");
FailedCount++;
}
}
}
MappingStatistics.LogMappingStat("INSURANCECOS", RecordCount, "InsuranceProviders", CompletedMappings.Count, FailedCount);
}
catch (Exception e)
{
throw new Exception("Error creating InsuranceProvider mapping.", e);
}
}
public void CreateInsurancePlansMapping()
{
try
{
var dataSet = TableAgent.DataSet.Tables[FbTableName].Rows;
RecordCount = TableAgent.RowCount;
foreach (DataRow row in dataSet)
{
// get userid from old aspnetdb matching on patientid #####.#####
var patId = (String)row["PATIENTID"].ToString();
var userId = MemoryMappings.GetUserIdFromPatientInfo(MigrationVariables.CurrentSiteId, patId);
if (userId != Guid.Empty)
{
var insp = new InsurancePlan
{
UserId = userId,
PlanName = String.Empty,
PlanType = (row["INSTYPEID"] is DBNull) ? String.Empty : map.GetInsurancePlanType(row["INSTYPEID"].ToString()),
PlanIdentifier = (row["PLANIDENTIFIER"] is DBNull) ? String.Empty : row["PLANIDENTIFIER"].ToString(),
PolicyNumber = (row["POLICYNUMBER"] is DBNull) ? String.Empty : row["POLICYNUMBER"].ToString(),
GroupName = (row["GROUPNAME"] is DBNull) ? String.Empty : row["GROUPNAME"].ToString(),
GroupIdentifier = (row["GROUPNUMBER"] is DBNull) ? String.Empty : row["GROUPNUMBER"].ToString(),
CoPay = (row["COPAY"] is DBNull) ? 0 : map.ParseMoney(row["COPAY"].ToString()),
Purchaser = (row["PURCHASER"] is DBNull) ? String.Empty : row["PURCHASER"].ToString(),
IsActive = (row["ISACTIVE"] is DBNull) ? false : map.ParseFirebirdBoolean(row["ISACTIVE"].ToString()),
InActiveDate = (row["INACTIVEDATE"] is DBNull) ? new DateTime(1800, 1, 1) : map.ParseFirebirdDateTime(row["INACTIVEDATE"].ToString()),
EffectiveDate = (row["EFFECTIVEDATE"] is DBNull) ? new DateTime(1800, 1, 1) : map.ParseFirebirdDateTime(row["EFFECTIVEDATE"].ToString()),
LastUpdatedByUser = userId
};
if (CanAddToContext(insp.UserId, insp.PlanType, insp.PolicyNumber))
{
tempCompanyId.Add(new Tuple <string, InsurancePlan>(row["INSCOID"].ToString(), insp));
CompletedMappings.Add(insp);
}
else
{
MappingStatistics.LogFailedMapping("INSURANCEPLANS2", row["KEYID"].ToString(), "InsurancePlans", typeof(InsurancePlan), JsonConvert.SerializeObject(insp), "Insurance Plan already exist in database.");
FailedCount++;
}
}
}
MappingStatistics.LogMappingStat("INSURANCEPLANS2", RecordCount, "InsurancePlans", CompletedMappings.Count, FailedCount);
}
catch (Exception e)
{
throw new Exception("Error creating InsurancePlan mapping.", e);
}
}