/// <summary> /// To Update Health Info /// </summary> /// <param name="objPAPHealth"></param> public void UpdateHealthInfo(PAP_HealthBO objPAPHealth) { cnn = new OracleConnection(con); proc = "USP_TRN_UPD_PAPHEALTH"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Connection.Open(); cmd.Parameters.Add("HHID_", objPAPHealth.HouseholdID); cmd.Parameters.Add("NEARESETHEALTHCENTRE_", objPAPHealth.NearestHealthCentre); cmd.Parameters.Add("DISTANCETOHEALTHCENTRE_", objPAPHealth.DistanceToHealthCentre); cmd.Parameters.Add("USEDBYFAMILY_", objPAPHealth.UsedByFamily); cmd.Parameters.Add("NONUSEREASON_", objPAPHealth.NonUseReason); cmd.Parameters.Add("NOOFBIRTH_", objPAPHealth.NoOfBirth); cmd.Parameters.Add("NOOFDEATH_", objPAPHealth.NoOfDeath); cmd.Parameters.Add("REASONFORDEATH_", objPAPHealth.ReasonForDeath); cmd.Parameters.Add("COMMONDISEASES_", objPAPHealth.CommonDiseases); cmd.Parameters.Add("PRACTICEFAMILYPLANNING_", objPAPHealth.PracticeFamilyPlanning); cmd.Parameters.Add("HEARDOFAIDS_", objPAPHealth.HeardOfAIDS); cmd.Parameters.Add("HOWCONTRACTED_", objPAPHealth.HowContracted); cmd.Parameters.Add("HOWAVOIDED_", objPAPHealth.HowAvoided); cmd.Parameters.Add("UPDATEDBY_", objPAPHealth.UpdatedBy); cmd.ExecuteNonQuery(); cmd.Connection.Close(); }
/// <summary> /// To get the Health Info data from the database /// </summary> private void GetHealthInfo() { PAP_HealthBO objHealth = (new PAP_HealthBLL()).GetHealthInfoByID(Convert.ToInt32(Session["HH_ID"])); if (objHealth != null) { ddlNearestHealthCentre.ClearSelection(); if (ddlNearestHealthCentre.Items.FindByValue(objHealth.NearestHealthCentre) != null) { ddlNearestHealthCentre.Items.FindByValue(objHealth.NearestHealthCentre).Selected = true; } txtDistanceToHealthCentre.Text = objHealth.DistanceToHealthCentre; if (objHealth.UsedByFamily.ToUpper() == "YES") { chkUsedByFamily.Checked = true; } txtNonUseReason.Text = objHealth.NonUseReason; txtNoOfBirth.Text = objHealth.NoOfBirth.ToString(); txtNoOfDeath.Text = objHealth.NoOfDeath.ToString(); txtReasonForDeath.Text = objHealth.ReasonForDeath; string[] sCommonDiseases = objHealth.CommonDiseases.ToString().Split(','); for (int i = 0; i < sCommonDiseases.Length; i++) { if (chklstCommonDiseases.Items.FindByValue(sCommonDiseases[i]) != null) { chklstCommonDiseases.Items.FindByValue(sCommonDiseases[i]).Selected = true; } } string[] sContracted = objHealth.HowContracted.ToString().Split(','); for (int i = 0; i < sContracted.Length; i++) { if (chklsthivcontracted.Items.FindByValue(sContracted[i]) != null) { chklsthivcontracted.Items.FindByValue(sContracted[i]).Selected = true; } } if (objHealth.PracticeFamilyPlanning == "YES") { chkFamilyPlanning.Checked = true; } if (objHealth.HeardOfAIDS == "YES") { chkHeardOfAIDS.Checked = true; } // txtHowContracted.Text = objHealth.HowContracted; txtHowAvoided.Text = objHealth.HowAvoided; } }
/// <summary> /// To Update Health Info /// </summary> /// <param name="objPAPHealth"></param> public void UpdateHealthInfo(PAP_HealthBO objPAPHealth) { (new PAP_HealthDAL()).UpdateHealthInfo(objPAPHealth); }
/// <summary> /// To Get Health Info By ID /// </summary> /// <param name="householdID"></param> /// <returns></returns> public PAP_HealthBO GetHealthInfoByID(int householdID) { proc = "USP_TRN_GET_PAPHEALTH"; cnn = new OracleConnection(con); PAP_HealthBO objPAPHealth = null; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("HHID_", householdID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; OracleDataReader dr = null; try { cmd.Connection.Open(); dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { objPAPHealth = new PAP_HealthBO(); if (!dr.IsDBNull(dr.GetOrdinal("PAP_HEALTHID"))) { objPAPHealth.HealthID = dr.GetInt32(dr.GetOrdinal("PAP_HEALTHID")); } if (!dr.IsDBNull(dr.GetOrdinal("HHID"))) { objPAPHealth.HouseholdID = dr.GetInt32(dr.GetOrdinal("HHID")); } if (!dr.IsDBNull(dr.GetOrdinal("NEARESETHEALTHCENTRE"))) { objPAPHealth.NearestHealthCentre = dr.GetString(dr.GetOrdinal("NEARESETHEALTHCENTRE")); } if (!dr.IsDBNull(dr.GetOrdinal("DISTANCETOHEALTHCENTRE"))) { objPAPHealth.DistanceToHealthCentre = dr.GetString(dr.GetOrdinal("DISTANCETOHEALTHCENTRE")); } if (!dr.IsDBNull(dr.GetOrdinal("USEDBYFAMILY"))) { objPAPHealth.UsedByFamily = dr.GetString(dr.GetOrdinal("USEDBYFAMILY")); } if (!dr.IsDBNull(dr.GetOrdinal("NONUSEREASON"))) { objPAPHealth.NonUseReason = dr.GetString(dr.GetOrdinal("NONUSEREASON")); } if (!dr.IsDBNull(dr.GetOrdinal("NOOFBIRTH"))) { objPAPHealth.NoOfBirth = dr.GetInt32(dr.GetOrdinal("NOOFBIRTH")); } if (!dr.IsDBNull(dr.GetOrdinal("NOOFDEATH"))) { objPAPHealth.NoOfDeath = dr.GetInt32(dr.GetOrdinal("NOOFDEATH")); } if (!dr.IsDBNull(dr.GetOrdinal("REASONFORDEATH"))) { objPAPHealth.ReasonForDeath = dr.GetString(dr.GetOrdinal("REASONFORDEATH")); } if (!dr.IsDBNull(dr.GetOrdinal("COMMONDISEASES"))) { objPAPHealth.CommonDiseases = dr.GetString(dr.GetOrdinal("COMMONDISEASES")); } if (!dr.IsDBNull(dr.GetOrdinal("PRACTICEFAMILYPLANNING"))) { objPAPHealth.PracticeFamilyPlanning = dr.GetString(dr.GetOrdinal("PRACTICEFAMILYPLANNING")); } if (!dr.IsDBNull(dr.GetOrdinal("HEARDOFAIDS"))) { objPAPHealth.HeardOfAIDS = dr.GetString(dr.GetOrdinal("HEARDOFAIDS")); } if (!dr.IsDBNull(dr.GetOrdinal("HOWCONTRACTED"))) { objPAPHealth.HowContracted = dr.GetString(dr.GetOrdinal("HOWCONTRACTED")); } if (!dr.IsDBNull(dr.GetOrdinal("HOWAVOIDED"))) { objPAPHealth.HowAvoided = dr.GetString(dr.GetOrdinal("HOWAVOIDED")); } } } catch (Exception ex) { throw ex; } finally { dr.Close(); } return(objPAPHealth); }
/// <summary> /// to save the data to the database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSaveHealthInfo_Click(object sender, EventArgs e) { PAP_HealthBO objHealth = new PAP_HealthBO(); objHealth.HouseholdID = Convert.ToInt32(Session["HH_ID"]); objHealth.NearestHealthCentre = ddlNearestHealthCentre.SelectedValue; objHealth.DistanceToHealthCentre = txtDistanceToHealthCentre.Text.Trim(); if (chkUsedByFamily.Checked) { objHealth.UsedByFamily = "YES"; } else { objHealth.UsedByFamily = "NO"; } string strMaxNonUseReason = txtNonUseReason.Text.Trim(); if (strMaxNonUseReason.Trim().Length >= 500) { strMaxNonUseReason = txtNonUseReason.Text.ToString().Trim().Substring(0, 500); } objHealth.NonUseReason = strMaxNonUseReason; if (txtNoOfBirth.Text.Trim() != "") { objHealth.NoOfBirth = Convert.ToInt32(txtNoOfBirth.Text.Trim()); } if (txtNoOfDeath.Text.Trim() != "") { objHealth.NoOfDeath = Convert.ToInt32(txtNoOfDeath.Text.Trim()); } string strMax = txtReasonForDeath.Text.Trim(); if (strMax.Trim().Length >= 999) { strMax = txtReasonForDeath.Text.ToString().Trim().Substring(0, 900); } objHealth.ReasonForDeath = strMax; string sCommonDiseases = ""; for (int iitem = 0; iitem < chklstCommonDiseases.Items.Count; iitem++) { if (chklstCommonDiseases.Items[iitem].Selected) { sCommonDiseases += "," + chklstCommonDiseases.Items[iitem].Value; } } if (sCommonDiseases.Length > 0) { sCommonDiseases = sCommonDiseases.Remove(0, 1); } objHealth.CommonDiseases = sCommonDiseases; string sContracted = ""; for (int iitem = 0; iitem < chklsthivcontracted.Items.Count; iitem++) { if (chklsthivcontracted.Items[iitem].Selected) { sContracted += "," + chklsthivcontracted.Items[iitem].Value; } } if (sContracted.Length > 0) { sContracted = sContracted.Remove(0, 1); } objHealth.HowContracted = sContracted; if (chkFamilyPlanning.Checked) { objHealth.PracticeFamilyPlanning = "YES"; } else { objHealth.PracticeFamilyPlanning = "NO"; } if (chkHeardOfAIDS.Checked) { objHealth.HeardOfAIDS = "YES"; } else { objHealth.HeardOfAIDS = "NO"; } //objHealth.HowContracted = txtHowContracted.Text.Trim(); string HIVAVOIDED = txtHowAvoided.Text.Trim(); if (HIVAVOIDED.Trim().Length >= 500) { HIVAVOIDED = txtHowAvoided.Text.ToString().Trim().Substring(0, 900); } objHealth.HowAvoided = HIVAVOIDED; objHealth.UpdatedBy = Convert.ToInt32(Session["USER_ID"]); (new PAP_HealthBLL()).UpdateHealthInfo(objHealth); ChangeRequestStatusHealthInfo(); projectFrozen(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "saved", "alert('Health details saved successfully');", true); }