/// <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);
}
