private void ComboBoxFillPrivate(DropDownList cbBox, string strListName, bool hasEmptyItem)
{
//var lstItems= new List<{int,string}>()};
using (var db = new DiabetesRegistryEntities1())
{
var res = (from s in db.tbl_Lists
from cs in db.tbl_ListItems
from item in db.tbl_Items
where s.ListID == cs.ListID
where item.ItemID == cs.ItemID
where s.ListName == strListName
select new
{
item.ItemID,
item.Item
}).ToList();
if (hasEmptyItem)
{
res.Insert(0, new { ItemID = 0, Item = "Select..." });
}
cbBox.DataSource = res;
cbBox.DataTextField = "Item";
cbBox.DataValueField = "ItemID";
cbBox.DataBind();
}
}
public void UpdateMedication(int Id)
{
using (var db = new DiabetesRegistryEntities1())
{
PassportMedication med = db.PassportMedications.Find(Id);
if (med == null)
{
ModelState.AddModelError("Error", String.Format("Item with id {0} was not found", Id));
return;
}
TryUpdateModel(med);
if (ModelState.IsValid)
{
try
{
db.SaveChanges();
lsvMedication.EditIndex = -1;
ErrorLabel.Text = String.Empty;
}
catch (Exception exp)
{
ErrorLabel.Text = exp.Message;
}
}
}
}
public void SaveMedication()
{
ClearErrorLabels();
using (var db = new DiabetesRegistryEntities1())
{
var med = new RegistrationMedication();
//todo add code for getting the item added
TryUpdateModel(med);
med.RegistrationType = 1; //1 for child 2 for adult
med.RegistrationId = int.Parse(recordId.Value);
if (ModelState.IsValid)
{
try
{
db.RegistrationMedications.Add(med);
//db.SaveChanges(); NOT yet since we don't have the ID of the record
ErrorLabel.Text = String.Empty;
}
catch (Exception exp)
{
ErrorLabel.Text = exp.Message;
}
}
else
{
//TODO add code for showing model errors
lblErrorsSection5.Text = "Section contains errors";
}
}
}
public List <RegistrationMedication> GetMedication([Control("recordId")] int?regId)
{
using (var db = new DiabetesRegistryEntities1())
{
return(db.RegistrationMedications.Where(x => x.RegistrationId == regId).ToList());
}
}
public void SaveMedication()
{
ClearErrorLabels();
using (var db = new DiabetesRegistryEntities1())
{
var med = new PassportMedication();
//todo add code for getting the item added
TryUpdateModel(med);
if (ModelState.IsValid)
{
var regId = int.Parse(Request.QueryString["regId"]);
var regType = int.Parse(Request.QueryString["regType"]);
try
{
if (recordId.Value == "0")//meaning no passport saved
{
var pass = new DiabetesPassport()
{
RegistrationId = regId,
RegistrationType = regType
};
db.DiabetesPassports.Add(pass);
db.SaveChanges();
ViewState["passId"] = pass.Id;
recordId.Value = pass.Id.ToString();
}
med.PassportId = int.Parse(recordId.Value);
db.PassportMedications.Add(med);
db.SaveChanges(); //NOT yet since we don't have the ID of the record
// List<PassportMedication> meds = new List<PassportMedication>();
//if (ViewState["newMeds"] != null)
//{
// meds = (List<PassportMedication>)ViewState["newMeds"];
//}
//meds.Add(med);
//ViewState["newMeds"] = meds;
ErrorLabel.Text = String.Empty;
}
catch (Exception exp)
{
ErrorLabel.Text = exp.Message;
}
}
else
{
//TODO add code for showing model errors
// lblErrorsSection6.Text = "Section contains errors";
}
}
}
public List <WHODHP.Models.DiabetesPassport> GetPassports()
{
using (var db = new DiabetesRegistryEntities1())
{
var regType = (int)(ViewState["regType"] ?? 0);
var regId = (int)(ViewState["regId"] ?? 0);
var passports = db.DiabetesPassports
.Where(x => x.RegistrationId == regId && x.RegistrationType == regType).ToList();
return(passports);
}
}
public void GetFacilities(DropDownList cbBox)
{
using (var db = new DiabetesRegistryEntities1())
{
var res = db.Clinics.Select(x => new { x.Id, x.Name }).ToList();
res.Insert(0, new { Id = 0, Name = "Select..." });
cbBox.DataSource = res;
cbBox.DataTextField = "Name";
cbBox.DataValueField = "Id";
cbBox.DataBind();
}
}
public List <PassportMedication> GetMedication([Control("recordId")] string regId)
{
//if (IsPostBack)
//{
// List<RegistrationMedication> meds = (List<RegistrationMedication>)ViewState["newMeds"];
// return meds;
//}
int recid = int.Parse(recordId.Value);
using (var db = new DiabetesRegistryEntities1())
{
return(db.PassportMedications.Where(x => x.PassportId == recid).ToList());
}
}
protected void btnFind_Click(object sender, EventArgs e)
{
using (var db = new DiabetesRegistryEntities1())
{
var recId = txtSearchID.Text;
var child = db.DiabetesRegistrationChilds.FirstOrDefault(x =>
x.ChildAndAdolescent_InitialAssessment_IdentityNumber == recId);
if (child != null)
{
btnSave.Visible = true;
divNames.Visible = true;
mainPanel.Visible = true;
divNoRecords.Visible = false;
lblName.Text = string.Format("First Name: {0} Surname: {1}", child.ChildAndAdolescent_InitialAssessment_FirstName,
child.ChildAndAdolescent_InitialAssessment_Surname);
recordId.Value = child.Id.ToString();
txtRegistrationDate.Text = child.ChildAndAdolescent_InitialAssessment_Registration_Date.ToString();
txtClinicalFileNumber.Text = child.ChildAndAdolescent_InitialAssessment_ClinicalFileNo;
txtHospitalFileNumber.Text = child.ChildAndAdolescent_InitialAssessment_ClinicalFileNo;
txtFirstName.Text = child.ChildAndAdolescent_InitialAssessment_FirstName;
txtSurname.Text = child.ChildAndAdolescent_InitialAssessment_Surname;
ddlSex.SelectedValue = child.ChildAndAdolescent_InitialAssessment_Sex;
txtDateOfBirth.Text = child.ChildAndAdolescent_InitialAssessment_DOB.ToString();
ddlReligion.SelectedValue = child.ChildAndAdolescent_InitialAssessment_Religion;
ddlHealthCentre.SelectedValue = child.ChildAndAdolescent_InitialAssessment_HealthCentre;
txtIdentityNumber.Text = child.ChildAndAdolescent_InitialAssessment_IdentityNumber;
ddlIdentityType.SelectedValue = child.ChildAndAdolescent_InitialAssessment_IdentityNumber_Type;
//TODO insert more
txtMedicationAllergy.Text = child.ChildAndAdolescent_InitialAssessment_MedicationAllergy_IfYesDescription
;
lsvMedication.DataBind();
}
else
{
divNames.Visible = false;
divNoRecords.Visible = true;
mainPanel.Visible = false;
btnSave.Visible = false;
btnDelete.Visible = false;
}
}
}
protected void btnFind_Click(object sender, EventArgs e)
{
var searchIdNo = txtSearchID.Text;
using (var db = new DiabetesRegistryEntities1())
{
var res = db.DiabetesRegistrationAdults.Where(y => y.Adult_InitialAssessment_IdentityNumber == searchIdNo).Select(x => new
{ id = x.Id, fname = x.Adult_InitialAssessment_FirstName, lname = x.Adult_InitialAssessment_Surname, type = 2 });
var res2 = db.DiabetesRegistrationChilds.Where(y => y.ChildAndAdolescent_InitialAssessment_IdentityNumber == searchIdNo).Select(x => new
{ id = x.Id, fname = x.ChildAndAdolescent_InitialAssessment_FirstName, lname = x.ChildAndAdolescent_InitialAssessment_Surname, type = 1 });
var res3 = res2.Union(res).FirstOrDefault();
if (res3 != null)
{
var passports = db.DiabetesPassports
.Where(x => x.RegistrationId == res3.id && x.RegistrationType == res3.type).ToList();
divNames.Visible = true;
pnlPassports.Visible = true;
divNoRecords.Visible = false;
ViewState["regType"] = res3.type;
ViewState["regId"] = res3.id;
lsvMedication.DataBind();
if (lsvMedication.Items.Count > 0)
{
btnNew.Text = "Update Passport";
}
else
{
btnNew.Text = "New Passport";
}
lblName.Text = string.Format("First Name: {0} Surname: {1}", res3.fname, res3.lname);
}
else
{
divNames.Visible = false;
divNoRecords.Visible = true;
pnlPassports.Visible = false;
ViewState["regType"] = null;
ViewState["regId"] = null;
}
}
}
protected void btnSave_Click(object sender, ImageClickEventArgs e)
{
var util = new Utility();
var pass = new Models.DiabetesPassport();
// Response.Redirect("~/AllContacts.aspx?type=select");
//if (recordId.Value == "0")
//{
pass.RegistrationId = int.Parse(Request.QueryString["regId"]);
pass.RegistrationType = int.Parse(Request.QueryString["regType"]); //1=child 2=adult
//}
pass.ExaminationDate = util.GetSelectedDate(txtExaminationDate.Text);
pass.Height = int.Parse(string.IsNullOrEmpty(txtHeight.Text) ? "0" : txtHeight.Text);
pass.BMI = txtBMI.Text;
pass.Weight = int.Parse(string.IsNullOrEmpty(txtWeight.Text) ? "0" : txtWeight.Text);
pass.BloodPressure = txtBloodPressure.Text;
pass.WaistCircumference = txtWaistCircumference.Text;
pass.FootExamination = txtFootExamination.Text;
pass.EyeTestConducted = int.Parse(ddlYearlyEyeTest.SelectedValue);
pass.DateEyeTestConducted = util.GetSelectedDate(txtDateEyeTestConducted.Text);
pass.EyeTestDoctor = txtEyeTestDoctor.Text;
// diabetes related complication
pass.RelatedComplicationsDate = util.GetSelectedDate(txtDateRelatedComplications.Text);
pass.AnginaPectoris = int.Parse(ddlAnginaPectoris.SelectedValue);
pass.MyocardialInfraction = int.Parse(ddlMyocardialInfarction.SelectedValue);
pass.CerebralStroke = int.Parse(ddlCerebralStroke.SelectedValue);
pass.Claudication = int.Parse(ddlClaudication.SelectedValue);
pass.RenalDialysisTransplant = int.Parse(ddlRenalDialysisTransplant.SelectedValue);
pass.DiabeticRetinopathy = int.Parse(ddlDiabeticRetinopathy.SelectedValue);
pass.EndStageRenalFailure = int.Parse(ddlEndStageRenalFailure.SelectedValue);
pass.PeripheralNeuropathy = int.Parse(ddlPeripheralNeuropathy.SelectedValue);
pass.PeripheralVascularDisease = int.Parse(ddlPeripheralVascularDisease.SelectedValue);
pass.FootDeformity = int.Parse(ddlFootDeformity.SelectedValue);
pass.DiabeticFootUlcer = int.Parse(ddlDiabeticFootUlcer.SelectedValue);
pass.AboveLimbAmputation = int.Parse(ddlAboveLimbAmputation.SelectedValue);
pass.LowerLimbAmputation = int.Parse(ddlLowerLimbAmputation.SelectedValue);
pass.ToeAmputation = int.Parse(ddlToeAmputation.SelectedValue);
pass.ForefootAmputation = int.Parse(ddlForefootAmputation.SelectedValue);
//My blood test results
pass.BloodTestDate = util.GetSelectedDate(txtDateMyBloodTestResults.Text);
pass.hbA1c = txthba1c.Text;
pass.FastingBloodGlucose = txtFastingBloodGlucose.Text;
pass.LowDensityLipoprotein = txtLowDensityLipoprotein.Text;
pass.HighdensityLipoprotein = txtHighDensityLipoprotein.Text;
pass.Triglycerides = txtTriglycerides.Text;
pass.AlbuminCreatineRatio = txtAlbuminCreatinineRatio.Text;
pass.EstimatedGlomerularFiltrationRate = txtEstimatedGlomerularFiltrationRate.Text;
pass.MicroAlbuminuria = txtMicroAlbuminuria.Text;
pass.Haemoglobin = txtHaemoglobin.Text;
pass.Sodium = txtSodium.Text;
pass.Potassium = txtPotassium.Text;
pass.Creatinine = txtCreatinine.Text;
//my yearly foot examination record by my doctor
pass.FootExaminationConductedDoctor = int.Parse(ddlFootExaminationDoctor.SelectedValue);
pass.FootExaminationConductedDoctorDate = util.GetSelectedDate(txtDateFootExamConductedDoctor.Text);
pass.FootExaminationDoctor = txtNameFootExamDoctor.Text;
//my record diabetes education session
pass.DiabetesMyths = util.GetSelectedDate(txtDiabetesMyths.Text);
pass.WhatIsDiabetes = util.GetSelectedDate(txtWhatIsDiabetes.Text);
pass.DietaryAdvice = util.GetSelectedDate(txtDietaryAdvice.Text);
pass.FootCare = util.GetSelectedDate(txtFootCare.Text);
pass.BloodGlucoseRecord = util.GetSelectedDate(txtBloodGlucoseRecord.Text);
pass.DiabetesAndSmoking = util.GetSelectedDate(txtDiabetesAndSmoking.Text);
pass.RecommendationsinsulinTherapy = util.GetSelectedDate(txtRecommendationsinsulinTherapy.Text);
pass.REcommendationsWoundCare = util.GetSelectedDate(txtREcommendationsWoundCare.Text);
pass.OralHealthAndDiabetes = util.GetSelectedDate(txtOralHealthAndDiabetes.Text);
pass.InstructionsDuringIllness = util.GetSelectedDate(txtInstructionsDuringIllness.Text);
pass.InstructionOralDiabetesTreatment = util.GetSelectedDate(txtInstructionOralDiabetesTreatment.Text);
pass.HowTakeCareDiabetes = util.GetSelectedDate(txtHowTakeCareDiabetes.Text);
pass.DiabetesLongTermComplications = util.GetSelectedDate(txtDiabetesLongTermComplications.Text);
pass.KnowHighBloodGlucoseLevel = util.GetSelectedDate(txtKnowHighBloodGlucoseLevel.Text);
pass.KnowLowBloodGlucoseLevel = util.GetSelectedDate(txtKnowLowBloodGlucoseLevel.Text);
pass.InstructionsDuringTravel = util.GetSelectedDate(txtInstructionsDuringTravel.Text);
pass.DiabetesTargets = util.GetSelectedDate(txtDiabetesTargets.Text);
pass.KnowAfterDiabetesDiagnosed = util.GetSelectedDate(txtKnowAfterDiabetesDiagnosed.Text);
pass.DiabetesAndEyeComplications = util.GetSelectedDate(txtDiabetesAndEyeComplications.Text);
pass.DiabetesAndContraception = util.GetSelectedDate(txtDiabetesAndContraception.Text);
pass.DiabetesInChildren = util.GetSelectedDate(txtDiabetesInChildren.Text);
pass.WhatIsPreDiabetes = util.GetSelectedDate(txtWhatIsPreDiabetes.Text);
pass.GestationalDiabetes = util.GetSelectedDate(txtGestationalDiabetes.Text);
pass.DiabetesAndHypertension = util.GetSelectedDate(txtDiabetesAndHypertension.Text);
pass.BloodGlucoseMonitoringProcedure = util.GetSelectedDate(txtBloodGlucoseMonitoringProcedure.Text);
pass.DiabetescareHospital = util.GetSelectedDate(txtDiabetescareHospital.Text);
pass.DiabetesAndExercise = util.GetSelectedDate(txtDiabetesAndExercise.Text);
pass.InstructionsPreExistingDiabetes = util.GetSelectedDate(txtInstructionsPreExistingDiabetes.Text);
pass.PostPartumCareDiabetes = util.GetSelectedDate(txtPostPartumCareDiabetes.Text);
//Goal setting
pass.GoalSet = int.Parse(ddlGoalSet.SelectedValue);
pass.ProgressMade = int.Parse(ddlProgressMade.SelectedValue);
pass.GoalDate = util.GetSelectedDate(txtGoalDate.Text);
pass.GoalNurse = txtGoalNurse.Text;
using (var db = new DiabetesRegistryEntities1())
{
var recId = int.Parse(recordId.Value);
if (db.DiabetesRegistrationAdults.Any(x => x.Id == recId))
{
pass.Id = recId;
db.DiabetesPassports.Attach(pass);
var record = db.Entry(pass);
record.State = EntityState.Modified;
}
else
{
db.DiabetesPassports.Add(pass);
}
db.SaveChanges();
}
}
protected void btnFind_Click(object sender, EventArgs e)
{
using (var db = new DiabetesRegistryEntities1())
{
var recId = txtSearchID.Text;
var adult = db.DiabetesRegistrationAdults.FirstOrDefault(x =>
x.Adult_InitialAssessment_IdentityNumber == recId);
if (adult != null)
{
btnSave.Visible = true;
divNames.Visible = true;
mainPanel.Visible = true;
divNoRecords.Visible = false;
lblName.Text = string.Format("First Name: {0} Surname: {1}", adult.Adult_InitialAssessment_FirstName,
adult.Adult_InitialAssessment_Surname);
recordId.Value = adult.Id.ToString();
txtRegistrationDate.Text = adult.Adult_InitialAssessment_Registration_Date.ToString();
txtClinicalFileNumber.Text = adult.Adult_InitialAssessment_ClinicalFileNo;
txtHospitalFileNumber.Text = adult.Adult_InitialAssessment_HospitalFileNo;
txtFirstName.Text = adult.Adult_InitialAssessment_FirstName;
txtSurname.Text = adult.Adult_InitialAssessment_Surname;
ddlSex.SelectedValue = adult.Adult_InitialAssessment_Sex;
txtDateOfBirth.Text = adult.Adult_InitialAssessment_DOB.ToString();
ddlReligion.SelectedValue = adult.Adult_InitialAssessment_Religion;
ddlHealthCentre.SelectedValue = adult.Adult_InitialAssessment_HealthCentre;
txtIdentityNumber.Text = adult.Adult_InitialAssessment_IdentityNumber;
ddlIdentityType.SelectedValue = adult.Adult_InitialAssessment_IdentityNumber_Type;
ddlMaritalStatus.SelectedValue = adult.Adult_InitialAssessment_MaritalStatus;
txtAddress.Text = adult.Adult_InitialAssessment_Address;
txtContactNumber.Text = adult.Adult_InitialAssessment_ContactNumbers;
txtOtherContactNumber.Text = adult.Adult_InitialAssessment_ContactNumberOther;
txtRelativeName.Text = adult.Adult_InitialAssessment_CloseRelativeGuardianName;
txtRelativeNumber.Text = adult.Adult_InitialAssessment_CloseRelativeGuardianNumber;
txtOccupation.Text = adult.Adult_InitialAssessment_Occupation;
ddlEmploymentStatus.SelectedValue = adult.Adult_InitialAssessment_EmploymentStatus;
ddlMedicationAllergy.SelectedValue = adult.Adult_InitialAssessment_MedicationAllergy.ToString();
txtMedicationAllergy.Text = adult.Adult_InitialAssessment_MedicationAllergy_IfYesDescription
;
ddlBirthControlMethod.SelectedValue = adult.Adult_InitialAssessment_CurrentControlMethod.ToString();
txtOtherBirthControlMethod.Text = adult.Adult_InitialAssessment_CurrentControlMethod_IfOthersDescription;
ddlHistoryObstetrics.SelectedValue = adult.Adult_InitialAssessment_HistoryObstetricComplications.ToString();
txtHistoryObstetricsYes.Text = adult.Adult_InitialAssessment_HistoryObstetricComplications_IfYesDescription
;
lsvMedication.DataBind();
//Section 2
txtDateDiagnosed.Text = adult.DiabetesRelatedInformation_DateDiagnosedWithDiabetes.ToString();
ddlDietician.SelectedValue = adult.DiabetesRelatedInformation_Dietician.ToString();
ddlNurseReview.SelectedValue = adult.DiabetesRelatedInformation_DiabetesNurseReview.ToString();
ddlSelfManagementEducation.SelectedValue = adult.DiabetesRelatedInformation_DiabetesSelfManagementEducation.ToString();
if (adult.DiabetesRelatedInformation_FamilyHistory_Of_Type1Diabetes.HasValue)
{
ckbType1Diabetes.Checked = adult.DiabetesRelatedInformation_FamilyHistory_Of_Type1Diabetes.Value;
}
if (adult.DiabetesRelatedInformation_FamilyHistory_Of_Type2Diabetes.HasValue)
{
ckbType2Diabetes.Checked = adult.DiabetesRelatedInformation_FamilyHistory_Of_Type2Diabetes.Value;
}
if (adult.DiabetesRelatedInformation_FamilyHistory_PreDiabetesMellitus.HasValue)
{
ckbPreDiabetes.Checked = adult.DiabetesRelatedInformation_FamilyHistory_PreDiabetesMellitus.Value;
}
if (adult.DiabetesRelatedInformation_FamilyHistory_Obesity.HasValue)
{
ckbObesity.Checked = adult.DiabetesRelatedInformation_FamilyHistory_Obesity.Value;
}
if (adult.DiabetesRelatedInformation_FamilyHistory_Hypertension.HasValue)
{
ckbHypertension.Checked = adult.DiabetesRelatedInformation_FamilyHistory_Hypertension.Value;
}
if (adult.DiabetesRelatedInformation_FamilyHistory_Dyslipidaemia.HasValue)
{
ckbDyslipidemia.Checked = adult.DiabetesRelatedInformation_FamilyHistory_Dyslipidaemia.Value;
}
if (adult.DiabetesRelatedInformation_FamilyHistory_PeripheralVascularDisease.HasValue)
{
ckbPeripheralVascularDisease.Checked = adult.DiabetesRelatedInformation_FamilyHistory_PeripheralVascularDisease.Value;
}
if (adult.DiabetesRelatedInformation_FamilyHistory_GestetionalDiabetes.HasValue)
{
ckbGestationalDiabetes.Checked = adult.DiabetesRelatedInformation_FamilyHistory_GestetionalDiabetes.Value;
}
txtDiabetesTypeOther.Text = adult.DiabetesRelatedInformation_FamilyHistory_OtherDescription;
//section comorbidities;
ddlCurrentUsageTobacco.SelectedValue = adult.Comorbidities_TobaccoUse.ToString();
ddlPastUsageTobacco.SelectedValue = adult.Comorbidities_TobaccoUse_Past.ToString();
if (adult.TobaccoCigarette.HasValue)
{
ckbCigarette.Checked = adult.TobaccoCigarette.Value;
}
txtCigaretteNumber.Text = adult.CigarettePerDay.ToString();
if (adult.TobaccoCigar.HasValue)
{
ckbCigars.Checked = adult.TobaccoCigar.Value;
}
txtCigarNumber.Text = adult.CigarPerDay.ToString();
if (adult.TobaccoPipe.HasValue)
{
ckbPipe.Checked = adult.TobaccoPipe.Value;
}
txtPipeNumber.Text = adult.PipePerDay.ToString();
if (adult.TobaccoChewing.HasValue)
{
ckbChewing.Checked = adult.TobaccoChewing.Value;
}
txtChewingNumber.Text = adult.ChewingPerDay.ToString();
if (adult.TobaccoChewing.HasValue)
{
ckbECigarette.Checked = adult.TobaccoECigarette.Value;
}
txtECigaretteNumber.Text = adult.ECigarettePerDay.ToString();
if (adult.TobaccoShisha.HasValue)
{
ckbShisha.Checked = adult.TobaccoShisha.Value;
}
txtShishaNumber.Text = adult.ShishaPerDay.ToString();
ddlCurrentUsageAlcohol.SelectedValue = adult.Comorbidities_AlcoholConsumption.ToString() == ""?"0": adult.Comorbidities_AlcoholConsumption.ToString();
ddlPastUsageAlcohol.SelectedValue = adult.Comorbidities_AlcoholConsumption_Past.ToString() == "" ? "0" : adult.Comorbidities_AlcoholConsumption_Past.ToString();
txtAlcoholUnits.Text = adult.Comorbidities_AlcoholConsumption_IfYes_UnitsPerWeek.ToString();
//section4 = ;
//section 5 = ;
ddlLivesWith.SelectedValue = adult.SocialAssessment_Lives_With.ToString();
txtLivesWithOther.Text = adult.SocialAssessment_Lives_With_Other;
ddlPreferredMethodForHealthInformation.SelectedValue = adult.SocialAssessment_PreferredMethodOfLearningAboutDiabetesAtClinic.ToString();
txtPreferredMethodForHealthInformationOther.Text = adult.SocialAssessment_PreferredMethodOfLearning_Other;
ddlReligiousFamilyCulturalPractices.SelectedValue = adult.SocialAssessment_InfluentialReligiousFamilyCulturalpracticesOnHowYouCareForYourHealth.ToString();
adult.SocialAssessment_InfluentialReligiousFamilyCulturalpractices_IfYesDescription = adult.SocialAssessment_InfluentialReligiousFamilyCulturalpractices_IfYesDescription;
ddlStressors.SelectedValue = adult.SocialAssessment_Stressors.ToString();
txtStressors.Text = adult.SocialAssessment_Stressors_IfYesDescription;
ddlBelieveDiabetes.SelectedValue = adult.SocialAssessment_DoBelieveYouHaveDiabetes.ToString();
//section 6 = ;
txtPercentagePhysicallyActive.Text = adult.DiabetesTreatment_PercentageTimeAtWorkPhysicallyActive;
ddlEngagePhysicalActivity.SelectedValue = adult.DiabetesTreatment_EngagementInPhysicalActivityforRecreation.ToString();
ddlEngageAerobicWalking.SelectedValue = adult.DiabetesTreatment_TypeOfPhysicalActivity_AerobicWalking.ToString();
ddlEngageResistanceWeight.SelectedValue = adult.DiabetesTreatment_TypeOfPhysicalActivity_ResistanceWeight.ToString();
txtNumberHoursPhysicalActivity.Text = adult.DiabetesTreatment_TypeOfPhysicalActivity_HowManyHoursPerWeek.ToString();
ddlPresentTreatmentType.SelectedValue = adult.DiabetesTreatment_PresentTreatmentRegimes_TypeMeal.ToString();
ddlMealType.SelectedValue = adult.DiabetesTreatment_PresentTreatmentRegimes_MealPlan.ToString() == "" ? "0" : adult.DiabetesTreatment_PresentTreatmentRegimes_MealPlan.ToString();
txtTabletSince.Text = adult.DiabetesTreatment_TabletsSince.ToString();
//section 7 ;
ddlAnginaPectoris.SelectedValue = adult.ComplicationsEvents_AnginaPectoris;
ddlMyocardialInfarction.SelectedValue = adult.ComplicationsEvents_MyocardialInfarction;
ddlCerebralStroke.SelectedValue = adult.ComplicationsEvents_CerebralStroke;
ddlClaudication.SelectedValue = ddlClaudication.SelectedValue = adult.ComplicationsEvents_Claudication;
ddlEndStageRenalFailure.SelectedValue = adult.ComplicationsEvents_EndStageRenalFailure;
ddlDiabeticRetinopathy.SelectedValue = adult.ComplicationsEvents_DiabeticRetinopathy;
ddlPeripheralNeuropathy.SelectedValue = adult.ComplicationsEvents_PeripheralNeuropathy;
ddlFootDeformity.SelectedValue = adult.ComplicationsEvents_FootDeformity;
ddlPastHistoryUlceration.SelectedValue = adult.ComplicationsEvents_PastHistoryOfUlceration;
ddlCurrentFootUlcer.SelectedValue = adult.ComplicationsEvents_CurrentFootUlcer;
if (adult.ComplicationsEvents_LowerLimbAmputation_IfYesLeftleg.HasValue)
{
ckbFootUlcerLeft.Checked = adult.ComplicationsEvents_LowerLimbAmputation_IfYesLeftleg.Value;
}
if (adult.ComplicationsEvents_LowerLimbAmputation_IfYesRightleg.HasValue)
{
ckbFootUlcerRight.Checked = adult.ComplicationsEvents_LowerLimbAmputation_IfYesRightleg.Value;
}
ddlLowerLimbAmputation.SelectedValue = adult.ComplicationsEvents_LowerLimbAmputation;
ddlAmputationType.SelectedValue = adult.ComplicationsEvents_LowerLimbAmputationType.ToString() == "" ? "0" : adult.ComplicationsEvents_LowerLimbAmputationType.ToString();
txtTabletSince.Text = adult.DiabetesTreatment_TabletsSince.ToString();
// section 8 = ;
ddlHospitalisationDiabetesRelated.SelectedValue = adult.PreviousDiabetesRelatedHospitalAdmission_DiabetesRelated;
txtNumberDaysHospital.Text = adult.PreviousDiabetesRelatedHospitalAdmission_DiabetesRelated_DaysinHospital.ToString();
if (adult.PreviousDiabetesRelatedHospitalAdmission_IfYesPeripheralVascularDisease.HasValue)
{
ckbPeripheralVascularDisease.Checked = adult.PreviousDiabetesRelatedHospitalAdmission_IfYesPeripheralVascularDisease.Value;
}
if (adult.PreviousDiabetesRelatedHospitalAdmission_IfYesStabilisations.HasValue)
{
ckbStabilization.Checked = adult.PreviousDiabetesRelatedHospitalAdmission_IfYesStabilisations.Value;
}
if (adult.PreviousDiabetesRelatedHospitalAdmission_IfYesCardiovascularDisease.HasValue)
{
ckbCardiovascularDisease.Checked = adult.PreviousDiabetesRelatedHospitalAdmission_IfYesCardiovascularDisease.Value;
}
if (adult.PreviousDiabetesRelatedHospitalAdmission_IfYesInfection.HasValue)
{
ckbInfection.Checked = adult.PreviousDiabetesRelatedHospitalAdmission_IfYesInfection.Value;
}
if (adult.PreviousDiabetesRelatedHospitalAdmission_IfYesCardiovascularDisease.HasValue)
{
ckbCardiovascularDisease.Checked = adult.PreviousDiabetesRelatedHospitalAdmission_IfYesCardiovascularDisease.Value;
}
if (adult.PreviousDiabetesRelatedHospitalAdmission_IfYesFootInfection.HasValue)
{
ckbFootInfection.Checked = adult.PreviousDiabetesRelatedHospitalAdmission_IfYesFootInfection.Value;
}
if (adult.PreviousDiabetesRelatedHospitalAdmission_IfYesEyeproblem.HasValue)
{
ckbEyeProblem.Checked = adult.PreviousDiabetesRelatedHospitalAdmission_IfYesEyeproblem.Value;
}
if (adult.PreviousDiabetesRelatedHospitalAdmission_IfYesSurgery.HasValue)
{
ckbSurgery.Checked = adult.PreviousDiabetesRelatedHospitalAdmission_IfYesSurgery.Value;
}
ddlHypoglycaemiaRequiringAssistance.SelectedValue = adult.PreviousDiabetesRelatedHospitalAdmission_HypoglycaemiaRequiringAssistance;
ddlHyperglycaemiaRequiringAssistance.SelectedValue = adult.PreviousDiabetesRelatedHospitalAdmission_HyperglycaemiaRequiringAssistance;
txtOtherRelatedHospitalAdmission.Text = adult.PreviousDiabetesRelatedHospitalAdmission_Other_Description;
//section section 9 = ;
txtHeight.Text = adult.ExaminationTests_Height.ToString();
txtBMI.Text = adult.ExaminationTests_BMI.ToString();
txtWeight.Text = adult.ExaminationTests_Weight.ToString();
txtBloodPressure.Text = adult.ExaminationTests_BloodPressure;
txtWaistHipRatio.Text = adult.ExaminationTests_WaistHipRatio.ToString();
//section section 10 =;
txthba1c.Text = adult.BloodInvesigationsResults_HbA1c;
txtFastingBloodGlucose.Text = adult.BloodInvesigationsResults_FastingBloodGlucoseLevel;
txtLowDensityLipoprotein.Text = adult.BloodInvestigationsResults_LowDensityLipoprotein;
txtHighDensityLipoprotein.Text = adult.BloodInvestigationsResults_HighDensityLipoprotein;
txtCholesterol.Text = adult.BloodInvestigationsResults_Cholesterol;
txtCreatinine.Text = adult.BloodInvestigationsResults_Creatinine;
txtTriglycerides.Text = adult.BloodInvestigationsResults_Triglycerides;
txtAlbuminCreatinineRatio.Text = adult.BloodInvestigationsResults_AlbuminCreatinineRatio;
txtHaemoglobin.Text = adult.BloodInvestigationsResults_Haemoglobin;
txtSodium.Text = adult.BloodInvestigationsResults_Sodium;
txtUrea.Text = adult.BloodInvestigationsResults_Urea;
txtPotassium.Text = adult.BloodInvestigationsResults_Potassium;
txtEstimatedGlomerularFiltrationRate.Text = adult.BloodInvestigationsResults_EstimatedGlomerularFiltrationRate;
txtMicroAlbuminuria.Text = adult.BloodInvestigationsResults_MicroAlbuminuria;
//section section 11 =;
ddlDiabetesPassportProvided.SelectedValue = adult.PassportProvided.ToString() == "" ? "0" : adult.PassportProvided.ToString();
txtDateDiabetesPassportProvided.Text = adult.DatePassportProvided.ToString();
txtBatchNumber.Text = adult.BatchNo;
txtLotNumber.Text = adult.LotNumber;
txtRegistrationNumber.Text = adult.RegistrationNumber;
txtNameNurse.Text = adult.NameOfNurse;
}
else
{
divNames.Visible = false;
divNoRecords.Visible = true;
mainPanel.Visible = false;
btnSave.Visible = false;
btnDelete.Visible = false;
}
}
}
protected void BtnSave_Click(object sender, ImageClickEventArgs e)
{
var util = new Utility();
var adult = new DiabetesRegistrationAdult();
adult.Adult_InitialAssessment_Registration_Date = util.GetSelectedDate(txtRegistrationDate.Text);
adult.Adult_InitialAssessment_ClinicalFileNo = txtClinicalFileNumber.Text;
adult.Adult_InitialAssessment_HospitalFileNo = txtHospitalFileNumber.Text;
adult.Adult_InitialAssessment_FirstName = txtFirstName.Text;
adult.Adult_InitialAssessment_Surname = txtSurname.Text;
adult.Adult_InitialAssessment_Sex = ddlSex.SelectedValue;
adult.Adult_InitialAssessment_DOB = util.GetSelectedDate(txtDateOfBirth.Text);
adult.Adult_InitialAssessment_Religion = ddlReligion.SelectedValue;
adult.Adult_InitialAssessment_HealthCentre = ddlHealthCentre.SelectedValue;
adult.Adult_InitialAssessment_IdentityNumber = txtIdentityNumber.Text;
adult.Adult_InitialAssessment_IdentityNumber_Type = ddlIdentityType.SelectedValue;
adult.Adult_InitialAssessment_MaritalStatus = ddlMaritalStatus.SelectedValue;
adult.Adult_InitialAssessment_Address = txtAddress.Text;
adult.Adult_InitialAssessment_ContactNumbers = txtContactNumber.Text;
adult.Adult_InitialAssessment_ContactNumberOther = txtOtherContactNumber.Text;
adult.Adult_InitialAssessment_CloseRelativeGuardianName = txtRelativeName.Text;
adult.Adult_InitialAssessment_CloseRelativeGuardianNumber = txtRelativeNumber.Text;
adult.Adult_InitialAssessment_Occupation = txtOccupation.Text;
adult.Adult_InitialAssessment_EmploymentStatus = ddlEmploymentStatus.SelectedValue;
adult.Adult_InitialAssessment_MedicationAllergy = int.Parse(ddlMedicationAllergy.SelectedValue);
adult.Adult_InitialAssessment_MedicationAllergy_IfYesDescription =
txtMedicationAllergy.Text;
adult.Adult_InitialAssessment_CurrentControlMethod = int.Parse(ddlBirthControlMethod.SelectedValue);
adult.Adult_InitialAssessment_CurrentControlMethod_IfOthersDescription = txtOtherBirthControlMethod.Text;
adult.Adult_InitialAssessment_HistoryObstetricComplications = int.Parse(ddlHistoryObstetrics.SelectedValue);
adult.Adult_InitialAssessment_HistoryObstetricComplications_IfYesDescription =
txtHistoryObstetricsYes.Text;
//Section 2
// adult.DiabetesRelatedInformation_DiabetesType = int.Parse(ddlDiabetesType.SelectedValue);
adult.DiabetesRelatedInformation_DateDiagnosedWithDiabetes = util.GetSelectedDate(txtDateDiagnosed.Text);
adult.DiabetesRelatedInformation_Dietician = int.Parse(ddlDietician.SelectedValue);
adult.DiabetesRelatedInformation_DiabetesNurseReview = int.Parse(ddlNurseReview.SelectedValue);
adult.DiabetesRelatedInformation_DiabetesSelfManagementEducation =
int.Parse(ddlSelfManagementEducation.SelectedValue);
adult.DiabetesRelatedInformation_FamilyHistory_Of_Type1Diabetes = ckbType1Diabetes.Checked;
adult.DiabetesRelatedInformation_FamilyHistory_Of_Type2Diabetes = ckbType2Diabetes.Checked;
adult.DiabetesRelatedInformation_FamilyHistory_PreDiabetesMellitus = ckbPreDiabetes.Checked;
adult.DiabetesRelatedInformation_FamilyHistory_Obesity = ckbObesity.Checked;
adult.DiabetesRelatedInformation_FamilyHistory_Hypertension = ckbHypertension.Checked;
adult.DiabetesRelatedInformation_FamilyHistory_Dyslipidaemia = ckbDyslipidemia.Checked;
adult.DiabetesRelatedInformation_FamilyHistory_PeripheralVascularDisease =
ckbPeripheralVascularDisease.Checked;
adult.DiabetesRelatedInformation_FamilyHistory_GestetionalDiabetes = ckbGestationalDiabetes.Checked;
adult.DiabetesRelatedInformation_FamilyHistory_OtherDescription = txtDiabetesTypeOther.Text;
//section 3 comorbidities
adult.Comorbidities_TobaccoUse = int.Parse(ddlCurrentUsageTobacco.SelectedValue);
adult.Comorbidities_TobaccoUse_Past = int.Parse(ddlPastUsageTobacco.SelectedValue);
adult.TobaccoCigarette = ckbCigarette.Checked;
adult.CigarettePerDay = int.Parse(string.IsNullOrWhiteSpace(txtCigaretteNumber.Text) ? "0" : txtCigaretteNumber.Text);
adult.TobaccoCigar = ckbCigars.Checked;
adult.CigarPerDay = int.Parse(string.IsNullOrWhiteSpace(txtCigarNumber.Text) ? "0" : txtCigarNumber.Text);
adult.TobaccoPipe = ckbPipe.Checked;
adult.PipePerDay = int.Parse(string.IsNullOrWhiteSpace(txtPipeNumber.Text) ? "0" : txtPipeNumber.Text);
adult.TobaccoChewing = ckbChewing.Checked;
adult.ChewingPerDay = int.Parse(string.IsNullOrWhiteSpace(txtChewingNumber.Text) ? "0" : txtChewingNumber.Text);
adult.TobaccoECigarette = ckbECigarette.Checked;
adult.ECigarettePerDay = int.Parse(string.IsNullOrWhiteSpace(txtECigaretteNumber.Text) ? "0" : txtECigaretteNumber.Text);
adult.TobaccoShisha = ckbShisha.Checked;
adult.ShishaPerDay = int.Parse(string.IsNullOrWhiteSpace(txtShishaNumber.Text) ? "0" : txtShishaNumber.Text);
adult.Comorbidities_AlcoholConsumption = int.Parse(ddlCurrentUsageAlcohol.SelectedValue);
adult.Comorbidities_AlcoholConsumption_Past = int.Parse(ddlPastUsageAlcohol.SelectedValue);
adult.Comorbidities_AlcoholConsumption_IfYes_UnitsPerWeek =
int.Parse(string.IsNullOrEmpty(txtAlcoholUnits.Text) ? "0" : txtAlcoholUnits.Text);
//section 4
//section 5
adult.SocialAssessment_Lives_With = int.Parse(ddlLivesWith.SelectedValue);
adult.SocialAssessment_Lives_With_Other = txtLivesWithOther.Text;
adult.SocialAssessment_PreferredMethodOfLearningAboutDiabetesAtClinic =
int.Parse(ddlPreferredMethodForHealthInformation.SelectedValue);
adult.SocialAssessment_PreferredMethodOfLearning_Other = txtPreferredMethodForHealthInformationOther.Text;
adult.SocialAssessment_InfluentialReligiousFamilyCulturalpracticesOnHowYouCareForYourHealth =
int.Parse(ddlReligiousFamilyCulturalPractices.SelectedValue);
adult.SocialAssessment_InfluentialReligiousFamilyCulturalpractices_IfYesDescription =
txtReligiousFamilyCulturalPractices.Text;
adult.SocialAssessment_Stressors = int.Parse(ddlStressors.SelectedValue);
adult.SocialAssessment_Stressors_IfYesDescription = txtStressors.Text;
adult.SocialAssessment_DoBelieveYouHaveDiabetes = int.Parse(ddlBelieveDiabetes.SelectedValue);
//section 6
adult.DiabetesTreatment_PercentageTimeAtWorkPhysicallyActive = txtPercentagePhysicallyActive.Text;
adult.DiabetesTreatment_EngagementInPhysicalActivityforRecreation =
int.Parse(ddlEngagePhysicalActivity.SelectedValue);
adult.DiabetesTreatment_TypeOfPhysicalActivity_AerobicWalking =
int.Parse(ddlEngageAerobicWalking.SelectedValue);
adult.DiabetesTreatment_TypeOfPhysicalActivity_ResistanceWeight =
int.Parse(ddlEngageResistanceWeight.SelectedValue);
adult.DiabetesTreatment_TypeOfPhysicalActivity_HowManyHoursPerWeek =
int.Parse(string.IsNullOrEmpty(txtNumberHoursPhysicalActivity.Text) ? "0" : txtNumberHoursPhysicalActivity.Text);
adult.DiabetesTreatment_PresentTreatmentRegimes_TypeMeal =
int.Parse(ddlPresentTreatmentType.SelectedValue);
adult.DiabetesTreatment_PresentTreatmentRegimes_MealPlan = int.Parse(ddlMealType.SelectedValue);
adult.DiabetesTreatment_TabletsSince = util.GetSelectedDate(txtTabletSince.Text);
//section 7
adult.ComplicationsEvents_AnginaPectoris = ddlAnginaPectoris.SelectedValue;
adult.ComplicationsEvents_MyocardialInfarction = ddlMyocardialInfarction.SelectedValue;
adult.ComplicationsEvents_CerebralStroke = ddlCerebralStroke.SelectedValue;
adult.ComplicationsEvents_Claudication = ddlClaudication.SelectedValue;
adult.ComplicationsEvents_EndStageRenalFailure = ddlEndStageRenalFailure.SelectedValue;
adult.ComplicationsEvents_DiabeticRetinopathy = ddlDiabeticRetinopathy.SelectedValue;
adult.ComplicationsEvents_PeripheralNeuropathy = ddlPeripheralNeuropathy.SelectedValue;
adult.ComplicationsEvents_FootDeformity = ddlFootDeformity.SelectedValue;
adult.ComplicationsEvents_PastHistoryOfUlceration = ddlPastHistoryUlceration.SelectedValue;
adult.ComplicationsEvents_CurrentFootUlcer = ddlCurrentFootUlcer.SelectedValue;
adult.ComplicationsEvents_LowerLimbAmputation_IfYesLeftleg = ckbFootUlcerLeft.Checked;
adult.ComplicationsEvents_LowerLimbAmputation_IfYesRightleg = ckbFootUlcerRight.Checked;
adult.ComplicationsEvents_LowerLimbAmputation = ddlLowerLimbAmputation.SelectedValue;
adult.ComplicationsEvents_LowerLimbAmputationType = int.Parse(ddlAmputationType.SelectedValue);
//section 8
adult.PreviousDiabetesRelatedHospitalAdmission_DiabetesRelated =
ddlHospitalisationDiabetesRelated.SelectedValue;
adult.PreviousDiabetesRelatedHospitalAdmission_DiabetesRelated_DaysinHospital =
int.Parse(string.IsNullOrEmpty(txtNumberDaysHospital.Text) ? "0" : txtNumberDaysHospital.Text);
adult.PreviousDiabetesRelatedHospitalAdmission_IfYesPeripheralVascularDisease =
ckbPeripheralVascularDisease.Checked;
adult.PreviousDiabetesRelatedHospitalAdmission_IfYesStabilisations = ckbStabilization.Checked;
adult.PreviousDiabetesRelatedHospitalAdmission_IfYesCardiovascularDisease =
ckbCardiovascularDisease.Checked;
adult.PreviousDiabetesRelatedHospitalAdmission_IfYesInfection = ckbInfection.Checked;
adult.PreviousDiabetesRelatedHospitalAdmission_IfYesCardiovascularDisease =
ckbCardiovascularDisease.Checked;
adult.PreviousDiabetesRelatedHospitalAdmission_IfYesFootInfection = ckbFootInfection.Checked;
adult.PreviousDiabetesRelatedHospitalAdmission_IfYesEyeproblem = ckbEyeProblem.Checked;
adult.PreviousDiabetesRelatedHospitalAdmission_IfYesSurgery = ckbSurgery.Checked;
adult.PreviousDiabetesRelatedHospitalAdmission_HypoglycaemiaRequiringAssistance =
ddlHypoglycaemiaRequiringAssistance.SelectedValue;
adult.PreviousDiabetesRelatedHospitalAdmission_HyperglycaemiaRequiringAssistance =
ddlHyperglycaemiaRequiringAssistance.SelectedValue;
adult.PreviousDiabetesRelatedHospitalAdmission_Other_Description =
txtOtherRelatedHospitalAdmission.Text;
//section 9
adult.ExaminationTests_Height = int.Parse(string.IsNullOrEmpty(txtHeight.Text) ? "0" : txtHeight.Text);
adult.ExaminationTests_BMI = int.Parse(string.IsNullOrEmpty(txtBMI.Text) ? "0" : txtBMI.Text);
adult.ExaminationTests_Weight = int.Parse(string.IsNullOrEmpty(txtWeight.Text) ? "0" : txtWeight.Text);
adult.ExaminationTests_BloodPressure = txtBloodPressure.Text;
adult.ExaminationTests_WaistHipRatio = int.Parse(string.IsNullOrEmpty(txtWaistHipRatio.Text) ? "0" : txtWaistHipRatio.Text);
//section 10
adult.BloodInvesigationsResults_HbA1c = txthba1c.Text;
adult.BloodInvesigationsResults_FastingBloodGlucoseLevel = txtFastingBloodGlucose.Text;
adult.BloodInvestigationsResults_LowDensityLipoprotein = txtLowDensityLipoprotein.Text;
adult.BloodInvestigationsResults_HighDensityLipoprotein = txtHighDensityLipoprotein.Text;
adult.BloodInvestigationsResults_Cholesterol = txtCholesterol.Text;
adult.BloodInvestigationsResults_Creatinine = txtCreatinine.Text;
adult.BloodInvestigationsResults_Triglycerides = txtTriglycerides.Text;
adult.BloodInvestigationsResults_AlbuminCreatinineRatio = txtAlbuminCreatinineRatio.Text;
adult.BloodInvestigationsResults_Haemoglobin = txtHaemoglobin.Text;
adult.BloodInvestigationsResults_Sodium = txtSodium.Text;
adult.BloodInvestigationsResults_Urea = txtUrea.Text;
adult.BloodInvestigationsResults_Potassium = txtPotassium.Text;
adult.BloodInvestigationsResults_EstimatedGlomerularFiltrationRate =
txtEstimatedGlomerularFiltrationRate.Text;
adult.BloodInvestigationsResults_MicroAlbuminuria = txtMicroAlbuminuria.Text;
//section 11
adult.PassportProvided = int.Parse(ddlDiabetesPassportProvided.SelectedValue);
adult.DatePassportProvided = util.GetSelectedDate(txtDateDiabetesPassportProvided.Text);
adult.BatchNo = txtBatchNumber.Text;
adult.LotNumber = txtLotNumber.Text;
adult.RegistrationNumber = txtRegistrationNumber.Text;
adult.NameOfNurse = txtNameNurse.Text;
using (var db = new DiabetesRegistryEntities1())
{
var recId = int.Parse(recordId.Value);
if (db.DiabetesRegistrationAdults.Any(x => x.Id == recId))
{
adult.Id = recId;
db.DiabetesRegistrationAdults.Attach(adult);
var record = db.Entry(adult);
record.State = EntityState.Modified;
}
else
{
db.DiabetesRegistrationAdults.Add(adult);
}
db.SaveChanges();
}
}
protected void btnSave_Click(object sender, ImageClickEventArgs e)
{
var util = new Utility();
var chld = new DiabetesRegistrationChild();
chld.ChildAndAdolescent_InitialAssessment_Registration_Date =
util.GetSelectedDate(txtRegistrationDate.Text);
chld.ChildAndAdolescent_InitialAssessment_ClinicalFileNo = txtClinicalFileNumber.Text;
chld.ChildAndAdolescent_InitialAssessment_HospitalFileNo = txtHospitalFileNumber.Text;
chld.ChildAndAdolescent_InitialAssessment_FirstName = txtFirstName.Text;
chld.ChildAndAdolescent_InitialAssessment_Surname = txtSurname.Text;
chld.ChildAndAdolescent_InitialAssessment_Sex = ddlSex.SelectedValue;
chld.ChildAndAdolescent_InitialAssessment_DOB = util.GetSelectedDate(txtDateOfBirth.Text);
chld.ChildAndAdolescent_InitialAssessment_Religion = ddlReligion.SelectedValue;
chld.ChildAndAdolescent_InitialAssessment_HealthCentre = ddlHealthCentre.SelectedValue;
chld.ChildAndAdolescent_InitialAssessment_IdentityNumber = txtIdentityNumber.Text;
chld.ChildAndAdolescent_InitialAssessment_IdentityNumber_Type = ddlIdentityType.SelectedValue;
chld.ChildAndAdolescent_InitialAssessment_AccompaniedBy = int.Parse(ddlAccompaniedBy.SelectedValue);
chld.ChildAndAdolescent_InitialAssessment_LivesWith = int.Parse(ddlLivesWith.SelectedValue);
chld.ChildAndAdolescent_InitialAssessment_InformationObtainedFrom =
int.Parse(ddlInformationObtainedFrom.SelectedValue);
chld.ChildAndAdolescent_InitialAssessment_MedicationAllergy = int.Parse(ddlMedicalAllergies.SelectedValue);
chld.ChildAndAdolescent_InitialAssessment_MedicationAllergy_IfYesDescription = txtMedicationAllergy.Text;
chld.ChildAndAdolescent_InitialAssessment_DemographicInformation_NameOfCareGiver =
txtNameOfCaregiver.Text;
chld.ChildAndAdolescent_InitialAssessment_DemographicInformation_RelationToTheChild =
txtRelationToChild.Text;
chld.ChildAndAdolescent_InitialAssessment_DemographicInformation_AddressOfTheCaregiver =
txtAddressCaregiver.Text;
chld.ChildAndAdolescent_InitialAssessment_DemographicInformation_SiblingIfYesNumber =
txtSiblingsNumber.Text;
//todo Add ages of siblings in DB
//todo add occupation of mother father and caregiver in DB
chld.ChildAndAdolescent_InitialAssessment_OccupationalStatus_Mother =
int.Parse(ddlMotherEmploymentStatus.SelectedValue);
chld.ChildAndAdolescent_InitialAssessment_OccupationalStatus_Father =
int.Parse(ddlFatherEmploymentStatus.SelectedValue);
chld.ChildAndAdolescent_InitialAssessment_OccupationalStatus_Caregiver =
int.Parse(ddlCaregiverEmploymentStatus.SelectedValue);
chld.ChildAndAdolescent_InitialAssessment_GuardianContactNumber_Mother = txtMotherContact.Text;
chld.ChildAndAdolescent_InitialAssessment_GuardianContactNumber_Father = txtFatherContact.Text;
chld.ChildAndAdolescent_InitialAssessment_GuardianContactNumber_Caregiver = txtCaregiverContact.Text;
chld.ChildAndAdolescent_InitialAssessment_InfluentialReligiousFamilyCulturalpractices =
int.Parse(ddlReligiousFamilyCulturalPractices.SelectedValue);
chld.ChildAndAdolescent_InitialAssessment_InfluentialReligiousFamilyCulturalpractices_IfYesDescription =
txtReligiousFamilyCulturalPractices.Text;
//section 2
chld.DiabetesRelatedInformation_DiabetesType = ddlTypeOfDiabetes.SelectedValue;
chld.DiabetesRelatedInformation_DateDiagnosedWithDiabetes = util.GetSelectedDate(txtDateDiagnosed.Text);
chld.DiabetesRelatedInformation_Dietician = ddlDietician.SelectedValue;
chld.DiabetesRelatedInformation_DiabetesNurseReview = ddlNurseReview.SelectedValue;
chld.DiabetesRelatedInformation_DiabetesSelfManagementEducation = ddlSelfManagementEducation.SelectedValue;
//TODO change type of diabetes parent siblings to checkboxes
//section 3
//TODO convert values to boolean in DB
//chld.Comorbidities_HighBloodPressure = ckbHighBloodPressure.Checked;
//section 4
//TODO add table listview
//section 5
chld.DiabetesTreatment_ChildEngagementInPhysicalActivity = int.Parse(ddlEngagePhysicalActivity.SelectedValue);
chld.DiabetesTreatment_ChildEngagementInPhysicalActivity_IfYesHoursPerWeek =
int.Parse(string.IsNullOrEmpty(txtNumberHoursPhysicalActivity.Text) ? "0" : txtNumberHoursPhysicalActivity.Text);
//section 6
chld.PreviousDiabetesRelatedHospitalAdmission_DiabetesRelatedHositalization =
ddlHospitalisationDiabetesRelated.SelectedValue;
//todo convert checkbox fields to boolean in DB
chld.PreviousDiabetesRelatedHospitalAdmission_DiabetesRelated_DaysinHospital =
int.Parse(string.IsNullOrEmpty(txtNumberDaysHospital.Text) ? "0" : txtNumberDaysHospital.Text);
chld.PreviousDiabetesRelatedHospitalAdmission_HypoglycaemiaRequiringAssistance =
ddlHypoglycaemiaRequiringAssistance.SelectedValue;
//todo add hyperglycaemia to DB
chld.PreviousDiabetesRelatedHospitalAdmission_Other_Description = txtOtherRelatedHospitalAdmission.Text;
//section 7
chld.ExaminationTests_Height = int.Parse(string.IsNullOrEmpty(txtHeight.Text) ? "0" : txtHeight.Text);
chld.ExaminationTests_Weight = int.Parse(string.IsNullOrEmpty(txtWeight.Text) ? "0" : txtWeight.Text);
chld.ExaminationTests_WaistCircumference = int.Parse(string.IsNullOrEmpty(txtWaistCircumference.Text) ? "0" : txtWaistCircumference.Text);
chld.ExaminationTests_BMI = int.Parse(string.IsNullOrEmpty(txtBMI.Text) ? "0" : txtBMI.Text);
chld.ExaminationTests_BloodPressure = txtBloodPressure.Text;
chld.ExaminationTests_WaistHipRatio = int.Parse(string.IsNullOrEmpty(txtNumberDaysHospital.Text) ? "0" : txtNumberDaysHospital.Text);
//section 8
chld.BloodInvesigationsResults_HbA1c = txthba1c.Text;
chld.BloodInvesigationsResults_FastingBloodGlucoseLevel = txtFastingBloodGlucose.Text;
chld.BloodInvestigationsResults_LowDensityLipoprotein = txtLowDensityLipoprotein.Text;
chld.BloodInvestigationsResults_HighDensityLipoprotein = txtHighDensityLipoprotein.Text;
chld.BloodInvestigationsResults_Cholesterol = txtCholesterol.Text;
chld.BloodInvestigationsResults_Creatinine = txtCreatinine.Text;
//TODO add albuminura in DB
chld.BloodInvestigationsResults_Triglycerides = txtTriglycerides.Text;
chld.BloodInvestigationsResults_AlbuminCreatinineRatio = txtAlbuminCreatinineRatio.Text;
chld.BloodInvestigationsResults_Haemoglobin = txtHaemoglobin.Text;
chld.BloodInvestigationsResults_Sodium = txtSodium.Text;
chld.BloodInvestigationsResults_Urea = txtUrea.Text;
chld.BloodInvestigationsResults_Potassium = txtPotassium.Text;
chld.BloodInvestigationsResults_EstimatedGlomerularFiltrationRate =
txtEstimatedGlomerularFiltrationRate.Text;
//TODO ADD section 9 to DB
using (var db = new DiabetesRegistryEntities1())
{
var recId = int.Parse(recordId.Value);
if (db.DiabetesRegistrationAdults.Any(x => x.Id == recId))
{
db.DiabetesRegistrationChilds.Attach(chld);
var record = db.Entry(chld);
record.State = EntityState.Modified;
}
else
{
db.DiabetesRegistrationChilds.Add(chld);
}
var id = db.SaveChanges();
// db.RegistrationMedications
}
}
