public static void GetTreatmentList(ServicesSoapClient _ServicesSoapClient, string DoctorId, string PId, List <TreatmentInfo> Tr)
{
DataSet TreatmentInfoDS = _ServicesSoapClient.GetTreatmentList(PId);
DataTable TreatmentInfoListCache = TreatmentInfoDS.Tables[0];
foreach (DataRow TreatmentInfoItem in TreatmentInfoListCache.Rows)
{
TreatmentInfo TreatmentInfomation = new TreatmentInfo();
TreatmentInfomation.UserId = PId;
TreatmentInfomation.SortNo = Convert.ToInt32(TreatmentInfoItem["SortNo"]);
TreatmentInfomation.TreatmentGoal = TreatmentInfoItem["TreatmentGoalName"].ToString();
TreatmentInfomation.TreatmentAction = TreatmentInfoItem["TreatmentActionName"].ToString();
TreatmentInfomation.Group = TreatmentInfoItem["GroupName"].ToString();
TreatmentInfomation.TreatmentPlan = TreatmentInfoItem["TreatmentPlan"].ToString();
TreatmentInfomation.TreatTime = TreatmentInfoItem["TreatTime"].ToString();
TreatmentInfomation.Duration = TreatmentInfoItem["DurationName"].ToString();
TreatmentInfomation.ReInUserId = TreatmentInfoItem["ReInUserId"].ToString();
if (DoctorId != string.Empty)
{
if (TreatmentInfomation.ReInUserId == DoctorId)
{
TreatmentInfomation.IsAllowed = true;
}
else
{
TreatmentInfomation.IsAllowed = false;
}
}
Tr.Add(TreatmentInfomation);
}
}
protected void Page_Load(object sender, EventArgs e)
{
//InitializedSfdcbinding();
if ((String)Session["AccountId"] != null)
{
strAccountId = (String)Session["AccountId"];
}
if ((String)Session["Email"] != null)
{
strPrimaryEmail = (String)Session["Email"];
}
if ((String)Session["ContactId"] != null)
{
strPrimaryId = (String)Session["ContactId"];
}
else
{
String strPrimaryEmail = (String)Session["Email"];
String strQueryForPrimaryId = "select Id from Contact where Email = '" + strPrimaryEmail + "'"; // 11/17/17 strPrimaryId should be replaced with Email
SForce.QueryResult qrPrimaryId = Sfdcbinding.query(strQueryForPrimaryId);
if (qrPrimaryId.size > 0)
{
SForce.Contact ctPrimaryId = qrPrimaryId.records[0] as SForce.Contact;
strPrimaryId = ctPrimaryId.Id;
}
}
// in the case of incomplete application, retrieve lstDiseaseRecord from salesforce
//if (!IsPostBack)
//{
if ((List <DiseaseRecord>)Session["DiseaseRecord"] != null)
{
lstDiseaseRecord = Session["DiseaseRecord"] as List <DiseaseRecord>;
}
else
{
String strQueryForDiseaseRecord = "select cmm_Account_Creation_Step_Code__c, cmm_Account__c, cmm_Contact__c, cmm_Name__c, " +
"Treated_in_last_12_months__c, Diagnosed_with_Cardiovascular_issues__c, Diagnosed_with_Allergy_Respiratory__c, " +
"Arthritis_back_nervous_system__c, Eyes_nose_ears_hands_feet_conditions__c, Stomach_liver_colon_kidney_conditions__c, " +
"Thyroid_tumor_cancer_medical_conditions__c, Prostate_or_female_reprdct_conditions__c, Congenital_disease_or_other_condition__c, " +
"cmm_Contact__r.cmm_Household_Role__c " +
"from tmp_Disease_Record__c where cmm_Account__c = '" + strAccountId + "'";
SForce.QueryResult qrTempDiseaseRecord = Sfdcbinding.query(strQueryForDiseaseRecord);
if (qrTempDiseaseRecord.size > 0)
{
foreach (SForce.tmp_Disease_Record__c record in qrTempDiseaseRecord.records)
{
lstDiseaseRecord.Add(new DiseaseRecord
{
AccountCreationStepCode = (int)record.cmm_Account_Creation_Step_Code__c,
AccountId = record.cmm_Account__c,
ContactId = record.cmm_Contact__c,
Name = record.cmm_Name__c,
HouseholdRole = record.cmm_Contact__r.cmm_Household_Role__c,
DiagnosedDisease = new Boolean[9] {
(Boolean)record.Treated_in_last_12_months__c,
(Boolean)record.Diagnosed_with_Cardiovascular_issues__c,
(Boolean)record.Diagnosed_with_Allergy_Respiratory__c,
(Boolean)record.Arthritis_back_nervous_system__c,
(Boolean)record.Eyes_nose_ears_hands_feet_conditions__c,
(Boolean)record.Stomach_liver_colon_kidney_conditions__c,
(Boolean)record.Thyroid_tumor_cancer_medical_conditions__c,
(Boolean)record.Prostate_or_female_reprdct_conditions__c,
(Boolean)record.Congenital_disease_or_other_condition__c
}
});
}
}
}
// in the case of incomplete application, retrieve the number of family members from salesforce
if (Session["NumberOfFamilyMembers"] != null)
{
nNumberOfFamilyMembers = (int)Session["NumberOfFamilyMembers"];
}
else
{
nNumberOfFamilyMembers = NumberOfFamilyMembers();
}
// in the case of incomplete application, retrieve lstMemberSDA from salesforce
//if ((List<MemberSmokingDrugAlcohol>)Session["MemberSmokingDrugAlcohol"] != null) lstMemberSDA = Session["MemberSmokingDrugAlcohol"] as List<MemberSmokingDrugAlcohol>;
//else
//{
String strQueryForMemberSDA = "select cmm_Account_Creation_Step_Code__c, cmm_Account__c, cmm_Contact__c, cmm_Name__c, cmm_Household_Role__c, " +
"cmm_bCurrentSmoker__c, cmm_bFormerSmoker__c, cmm_bCurrentDrug__c, cmm_bFormerDrug__c, cmm_bAlcohol__c " +
"from tmp_SmokingDrugAlcohol__c where cmm_Account__r.Id = '" + strAccountId + "'";
SForce.QueryResult qrMemberSDA = Sfdcbinding.query(strQueryForMemberSDA);
if (qrMemberSDA.size > 0)
{
foreach (SForce.tmp_SmokingDrugAlcohol__c sda in qrMemberSDA.records)
{
MemberSmokingDrugAlcohol memberSDA = new MemberSmokingDrugAlcohol();
memberSDA.AccountCreationStepCode = (int)sda.cmm_Account_Creation_Step_Code__c;
memberSDA.AccountId = sda.cmm_Account__c;
switch (sda.cmm_Household_Role__c)
{
case "Head of Household":
memberSDA.HouseholdRole = HouseholdRoles.Primary;
break;
case "Spouse":
memberSDA.HouseholdRole = HouseholdRoles.Spouse;
break;
case "Child":
memberSDA.HouseholdRole = HouseholdRoles.Child;
break;
}
memberSDA.ContactId = sda.cmm_Contact__c;
memberSDA.Name = sda.cmm_Name__c;
memberSDA.bCurrentSmoker = (sda.cmm_bCurrentSmoker__c == "Yes");
memberSDA.bFormerSmoker = (sda.cmm_bFormerSmoker__c == "Yes");
memberSDA.bCurrentDrug = (sda.cmm_bCurrentDrug__c == "Yes");
memberSDA.bFormerDrug = (sda.cmm_bFormerDrug__c == "Yes");
memberSDA.bAlcohol = (sda.cmm_bAlcohol__c == "Yes");
lstMemberSDA.Add(memberSDA);
}
}
//}
// in the case of incomplete application, retrieve lstMedicalHistory from salesforce
if ((List <TreatmentInfo>)Session["TreatmentHistory"] != null)
{
lstTreatmentHistory = Session["TreatmentHistory"] as List <TreatmentInfo>;
}
else
{
String strQueryForTreatmentHistory = "select cmm_Account_Creation_Step_Code__c, cmm_Account__c, cmm_Contact__c, cmm_Household_Role__c, " +
"cmm_Name__c, cmm_Treatment_Date__c, cmm_Treatment_Description__c, cmm_Physician_Info__c " +
"from tmp_Medical_History__c where cmm_Account__r.Id = '" + strAccountId + "'";
SForce.QueryResult qrTmpTreatmentHistory = Sfdcbinding.query(strQueryForTreatmentHistory);
if (qrTmpTreatmentHistory.size > 0)
{
foreach (SForce.tmp_Medical_History__c record in qrTmpTreatmentHistory.records)
{
TreatmentInfo treatment = new TreatmentInfo();
treatment.AccountCreationStepCode = (int)record.cmm_Account_Creation_Step_Code__c;
treatment.AccountId = record.cmm_Account__c;
treatment.ContactId = record.cmm_Contact__c;
treatment.Name = record.cmm_Name__c;
treatment.HouseholdRole = record.cmm_Household_Role__c;
//int nYear = record.cmm_Treatment_Date__c.Value.Year;
//int nMonth = record.cmm_Treatment_Date__c.Value.Month;
//int nDay = record.cmm_Treatment_Date__c.Value.Day;
treatment.TreatmentDate = new DateTime(record.cmm_Treatment_Date__c.Value.Year,
record.cmm_Treatment_Date__c.Value.Month,
record.cmm_Treatment_Date__c.Value.Day);
treatment.TreatmentDescription = record.cmm_Treatment_Description__c;
treatment.PhysicianInfo = record.cmm_Physician_Info__c;
lstTreatmentHistory.Add(treatment);
}
}
}
//}
// if ((List<DiseaseRecord>)Session["DiseaseRecord"] != null) lstDiseaseRecord = Session["DiseaseRecord"] as List<DiseaseRecord>;
// else
// {
// String strQueryForDiseaseRecord = "select cmm_Account_Creation_Step_Code__c, cmm_Account__c, cmm_Contact__c, cmm_Name__c, " +
// "Treated_in_last_12_months__c, Diagnosed_with_Cardiovascular_issues__c, Diagnosed_with_Allergy_Respiratory__c, " +
// "Arthritis_back_nervous_system__c, Eyes_nose_ears_hands_feet_conditions__c, Stomach_liver_colon_kidney_conditions__c, " +
// "Thyroid_tumor_cancer_medical_conditions__c, Prostate_or_female_reprdct_conditions__c, Congenital_disease_or_other_condition__c, " +
// "cmm_Contact__r.cmm_Household_Role__c " +
// "from tmp_Disease_Record__c where cmm_Account__c = '" + strAccountId + "'";
// SForce.QueryResult qrTempDiseaseRecord = Sfdcbinding.query(strQueryForDiseaseRecord);
// if (qrTempDiseaseRecord.size > 0)
// {
// foreach (SForce.tmp_Disease_Record__c record in qrTempDiseaseRecord.records)
// {
// lstDiseaseRecord.Add(new DiseaseRecord
// {
// AccountCreationStepCode = (int)record.cmm_Account_Creation_Step_Code__c,
// AccountId = record.cmm_Account__c,
// ContactId = record.cmm_Contact__c,
// Name = record.cmm_Name__c,
// HouseholdRole = record.cmm_Contact__r.cmm_Household_Role__c,
// DiagnosedDisease = new Boolean[9] { (Boolean)record.Treated_in_last_12_months__c,
// (Boolean)record.Diagnosed_with_Cardiovascular_issues__c,
// (Boolean)record.Diagnosed_with_Allergy_Respiratory__c,
// (Boolean)record.Arthritis_back_nervous_system__c,
// (Boolean)record.Eyes_nose_ears_hands_feet_conditions__c,
// (Boolean)record.Stomach_liver_colon_kidney_conditions__c,
// (Boolean)record.Thyroid_tumor_cancer_medical_conditions__c,
// (Boolean)record.Prostate_or_female_reprdct_conditions__c,
// (Boolean)record.Congenital_disease_or_other_condition__c }
// });
// }
// }
// }
// // in the case of incomplete application, retrieve the number of family members from salesforce
// if (Session["NumberOfFamilyMembers"] != null)
// {
// nNumberOfFamilyMembers = (int)Session["NumberOfFamilyMembers"];
// }
// else
// {
// nNumberOfFamilyMembers = NumberOfFamilyMembers();
// }
// // in the case of incomplete application, retrieve lstMemberSDA from salesforce
// if ((List<MemberSmokingDrugAlcohol>)Session["MemberSmokingDrugAlcohol"] != null) lstMemberSDA = Session["MemberSmokingDrugAlcohol"] as List<MemberSmokingDrugAlcohol>;
// else
// {
// String strQueryForMemberSDA = "select cmm_Account_Creation_Step_Code__c, cmm_Account__c, cmm_Contact__c, cmm_Name__c, cmm_Household_Role__c, " +
// "cmm_bCurrentSmoker__c, cmm_bFormerSmoker__c, cmm_bCurrentDrug__c, cmm_bFormerDrug__c, cmm_bAlcohol__c " +
// "from tmp_SmokingDrugAlcohol__c where cmm_Account__r.Id = '" + strAccountId + "'";
// SForce.QueryResult qrMemberSDA = Sfdcbinding.query(strQueryForMemberSDA);
// if (qrMemberSDA.size > 0)
// {
// foreach (SForce.tmp_SmokingDrugAlcohol__c sda in qrMemberSDA.records)
// {
// MemberSmokingDrugAlcohol memberSDA = new MemberSmokingDrugAlcohol();
// memberSDA.AccountCreationStepCode = (int)sda.cmm_Account_Creation_Step_Code__c;
// memberSDA.AccountId = sda.cmm_Account__c;
// switch (sda.cmm_Household_Role__c)
// {
// case "Head of Household":
// memberSDA.HouseholdRole = HouseholdRoles.Primary;
// break;
// case "Spouse":
// memberSDA.HouseholdRole = HouseholdRoles.Spouse;
// break;
// case "Child":
// memberSDA.HouseholdRole = HouseholdRoles.Child;
// break;
// }
// memberSDA.ContactId = sda.cmm_Contact__c;
// memberSDA.Name = sda.cmm_Name__c;
// memberSDA.bCurrentSmoker = (sda.cmm_bCurrentSmoker__c == "Yes");
// memberSDA.bFormerSmoker = (sda.cmm_bFormerSmoker__c == "Yes");
// memberSDA.bCurrentDrug = (sda.cmm_bCurrentDrug__c == "Yes");
// memberSDA.bFormerDrug = (sda.cmm_bFormerDrug__c == "Yes");
// memberSDA.bAlcohol = (sda.cmm_bAlcohol__c == "Yes");
// lstMemberSDA.Add(memberSDA);
// }
// }
// }
//// in the case of incomplete application, retrieve lstMedicalHistory from salesforce
//if ((List<TreatmentInfo>)Session["TreatmentHistory"] != null) lstTreatmentHistory = Session["TreatmentHistory"] as List<TreatmentInfo>;
//else
//{
// String strQueryForTreatmentHistory = "select cmm_Account_Creation_Step_Code__c, cmm_Account__c, cmm_Contact__c, cmm_Household_Role__c, " +
// "cmm_Name__c, cmm_Treatment_Date__c, cmm_Treatment_Description__c, cmm_Physician_Info__c " +
// "from tmp_Medical_History__c where cmm_Account__r.Id = '" + strAccountId + "'";
// SForce.QueryResult qrTmpTreatmentHistory = Sfdcbinding.query(strQueryForTreatmentHistory);
// if (qrTmpTreatmentHistory.size > 0)
// {
// foreach (SForce.tmp_Medical_History__c record in qrTmpTreatmentHistory.records)
// {
// TreatmentInfo treatment = new TreatmentInfo();
// treatment.AccountCreationStepCode = (int)record.cmm_Account_Creation_Step_Code__c;
// treatment.AccountId = record.cmm_Account__c;
// treatment.ContactId = record.cmm_Contact__c;
// treatment.Name = record.cmm_Name__c;
// treatment.HouseholdRole = record.cmm_Household_Role__c;
// //int nYear = record.cmm_Treatment_Date__c.Value.Year;
// //int nMonth = record.cmm_Treatment_Date__c.Value.Month;
// //int nDay = record.cmm_Treatment_Date__c.Value.Day;
// treatment.TreatmentDate = new DateTime(record.cmm_Treatment_Date__c.Value.Year,
// record.cmm_Treatment_Date__c.Value.Month,
// record.cmm_Treatment_Date__c.Value.Day);
// treatment.TreatmentDescription = record.cmm_Treatment_Description__c;
// treatment.PhysicianInfo = record.cmm_Physician_Info__c;
// lstTreatmentHistory.Add(treatment);
// }
// }
//}
}
