/// <summary>
/// To Get Inst Contact By HHID
/// </summary>
/// <param name="HHID"></param>
/// <returns></returns>
public PAP_InstitutionList GetInstContactByHHID(int HHID)
{
PAP_InstitutionBO objInstitution = null;
PAP_InstitutionList PAP_Institutionlist1;
try
{
cnn = new OracleConnection(con);
cmd = new OracleCommand("USP_TRN_GET_PAPINAT_CONTACT", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("HHIDIN", HHID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cnn.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
PAP_Institutionlist1 = new PAP_InstitutionList();
while (dr.Read())
{
objInstitution = new PAP_InstitutionBO();
if (!dr.IsDBNull(dr.GetOrdinal("HHID")))
{
objInstitution.HHID = dr.GetInt32(dr.GetOrdinal("HHID"));
}
if (!dr.IsDBNull(dr.GetOrdinal("POSITIONID")))
{
objInstitution.POSITIONID = dr.GetInt32(dr.GetOrdinal("POSITIONID"));
}
if (!dr.IsDBNull(dr.GetOrdinal("CONT_DISTRICT")))
{
objInstitution.CONT_DISTRICT = dr.GetString(dr.GetOrdinal("CONT_DISTRICT"));
}
if (!dr.IsDBNull(dr.GetOrdinal("CONT_COUNTY")))
{
objInstitution.CONT_COUNTY = dr.GetString(dr.GetOrdinal("CONT_COUNTY"));
}
if (!dr.IsDBNull(dr.GetOrdinal("CONT_SUBCOUNTY")))
{
objInstitution.CONT_SUBCOUNTY = dr.GetString(dr.GetOrdinal("CONT_SUBCOUNTY"));
}
if (!dr.IsDBNull(dr.GetOrdinal("CONT_PARISH")))
{
objInstitution.CONT_PARISH = dr.GetString(dr.GetOrdinal("CONT_PARISH"));
}
if (!dr.IsDBNull(dr.GetOrdinal("CONT_VILLAGE")))
{
objInstitution.CONT_VILLAGE = dr.GetString(dr.GetOrdinal("CONT_VILLAGE"));
}
if (!dr.IsDBNull(dr.GetOrdinal("CONTACTPHONE1")))
{
objInstitution.CONTACTPHONE1 = dr.GetString(dr.GetOrdinal("CONTACTPHONE1"));
}
if (!dr.IsDBNull(dr.GetOrdinal("CONTACTPHONE2")))
{
objInstitution.CONTACTPHONE2 = dr.GetString(dr.GetOrdinal("CONTACTPHONE2"));
}
PAP_Institutionlist1.Add(objInstitution);
}
dr.Close();
}
catch (Exception ex)
{
throw ex;
}
return(PAP_Institutionlist1);
}
/// <summary>
/// to get the Instruction Data from the database
/// </summary>
private void GetInstContactData()
{
int HHID = Convert.ToInt32(Session["HH_ID"]);
PAP_HouseholdBLL objHouseHoldBLL = new PAP_HouseholdBLL();
PAP_HouseholdBO objHouseHold = objHouseHoldBLL.GetHouseHoldData(HHID);
if (objHouseHold != null)
{
txtHouseHoldID.Text = Convert.ToString(objHouseHold.HhId);
txtName.Text = Convert.ToString(objHouseHold.InstitutionName);
txtPlots.Text = Convert.ToString(objHouseHold.Noofplots);
txtPlotReference.Text = Convert.ToString(objHouseHold.PlotReference);
txtSurname.Text = Convert.ToString(objHouseHold.Surname);
txtfirstname.Text = Convert.ToString(objHouseHold.Firstname);
txtOthername.Text = Convert.ToString(objHouseHold.Othername);
//Ediwn: 27SEP2016
txtFullname.Text = txtSurname.Text + " " + txtfirstname.Text + " " + txtOthername.Text;
txtPapUid.Text = Convert.ToString(objHouseHold.Papuid);
if (objHouseHold.CapturedDate.Trim() != "")
{
dpCapturedDate.Text = Convert.ToDateTime(objHouseHold.CapturedDate).ToString(UtilBO.DateFormat);
}
txtCapturedBy.Text = Convert.ToString(objHouseHold.CapturedBy);
ddlGouAllowance.ClearSelection();
if (ddlGouAllowance.Items.FindByValue(objHouseHold.GouStatus.ToString()) != null)
{
ddlGouAllowance.Items.FindByValue(objHouseHold.GouStatus.ToString()).Selected = true;
}
ddlUnderTakingPeriod.ClearSelection();
if (ddlUnderTakingPeriod.Items.FindByValue(objHouseHold.UnderTakingPeriod.ToString()) != null)
{
ddlUnderTakingPeriod.Items.FindByValue(objHouseHold.UnderTakingPeriod.ToString()).Selected = true;
}
rdlResident.ClearSelection();
if (objHouseHold.Isresident == "No")
{
rdlResident.Items[1].Selected = true;
}
else
{
rdlResident.Items[0].Selected = true;
}
ddloptionGroup.SelectedValue = Convert.ToString(objHouseHold.OptiongroupId);
ddlGender.ClearSelection();
if (ddlGender.Items.FindByValue(objHouseHold.Sex) != null)
{
ddlGender.Items.FindByValue(objHouseHold.Sex).Selected = true;
}
if (objHouseHold.DateofBirth.Trim() != "")
{
dpDateofBirth.Text = Convert.ToDateTime(objHouseHold.DateofBirth).ToString(UtilBO.DateFormat);
}
ddlDistrict.ClearSelection();
if (ddlDistrict.Items.FindByText(Convert.ToString(objHouseHold.District).ToUpper()) != null)
{
ddlDistrict.Items.FindByText(Convert.ToString(objHouseHold.District).ToUpper()).Selected = true;
}
if (ddlDistrict.SelectedIndex > 0)
{
BindCounties(ddlDistrict.SelectedItem.Value, ddlCounty);
if (Convert.ToString(objHouseHold.County) != "")
{
ddlCounty.ClearSelection();
if (ddlCounty.Items.FindByText(Convert.ToString(objHouseHold.County).ToUpper()) != null)
{
ddlCounty.Items.FindByText(Convert.ToString(objHouseHold.County).ToUpper()).Selected = true;
}
}
}
if (ddlCounty.SelectedIndex > 0)
{
BindSubCounties(ddlCounty.SelectedItem.Value, ddlSubCounty);
if (Convert.ToString(objHouseHold.SubCounty) != "")
{
ddlSubCounty.ClearSelection();
if (ddlSubCounty.Items.FindByText(Convert.ToString(objHouseHold.SubCounty).ToUpper()) != null)
{
ddlSubCounty.Items.FindByText(Convert.ToString(objHouseHold.SubCounty).ToUpper()).Selected = true;
}
}
}
if (ddlSubCounty.SelectedIndex > 0)
{
BindVillages(ddlSubCounty.SelectedItem.Value, ddlVillage);
if (Convert.ToString(objHouseHold.Village) != "")
{
ddlVillage.ClearSelection();
if (ddlVillage.Items.FindByText(Convert.ToString(objHouseHold.Village).ToUpper()) != null)
{
ddlVillage.Items.FindByText(Convert.ToString(objHouseHold.Village).ToUpper()).Selected = true;
}
}
BindParish(ddlSubCounty.SelectedItem.Value, ddlParish);
if (Convert.ToString(objHouseHold.Village) != "")
{
ddlParish.ClearSelection();
if (ddlParish.Items.FindByText(Convert.ToString(objHouseHold.Parish).ToUpper()) != null)
{
ddlParish.Items.FindByText(Convert.ToString(objHouseHold.Parish).ToUpper()).Selected = true;
}
}
}
PAP_InstitutionBLL objInstitutionBLL = new PAP_InstitutionBLL();
PAP_InstitutionList objPAP_InstitutionList = objInstitutionBLL.GetInstContactByHHID(HHID);
if (objPAP_InstitutionList.Count > 0)
{
ddlPosition.ClearSelection();
ddlPosition.SelectedValue = (Convert.ToString(objPAP_InstitutionList[0].POSITIONID));
ddlCPDistrict.ClearSelection();
if (ddlCPDistrict.Items.FindByText(Convert.ToString(objPAP_InstitutionList[0].CONT_DISTRICT).ToUpper()) != null)
{
ddlCPDistrict.Items.FindByText(Convert.ToString(objPAP_InstitutionList[0].CONT_DISTRICT).ToUpper()).Selected = true;
}
if (ddlCPDistrict.SelectedIndex > 0)
{
BindCounties(ddlCPDistrict.SelectedItem.Value, ddlCPCounty);
if (Convert.ToString(objHouseHold.County) != "")
{
ddlCPCounty.ClearSelection();
if (ddlCPCounty.Items.FindByText(Convert.ToString(objPAP_InstitutionList[0].CONT_COUNTY).ToUpper()) != null)
{
ddlCPCounty.Items.FindByText(Convert.ToString(objPAP_InstitutionList[0].CONT_COUNTY).ToUpper()).Selected = true;
}
}
}
if (ddlCPCounty.SelectedIndex > 0)
{
BindSubCounties(ddlCPCounty.SelectedItem.Value, ddlCPSubCounty);
uplCPSubCounty.Update();
if (Convert.ToString(objHouseHold.SubCounty) != "")
{
ddlCPSubCounty.ClearSelection();
if (ddlCPSubCounty.Items.FindByText(Convert.ToString(objPAP_InstitutionList[0].CONT_SUBCOUNTY).ToUpper()) != null)
{
ddlCPSubCounty.Items.FindByText(Convert.ToString(objPAP_InstitutionList[0].CONT_SUBCOUNTY).ToUpper()).Selected = true;
}
}
}
if (ddlCPSubCounty.SelectedIndex > 0)
{
BindVillages(ddlCPSubCounty.SelectedItem.Value, ddlCPVillage);
uplCPVillage.Update();
if (Convert.ToString(objHouseHold.Village) != "")
{
ddlCPVillage.ClearSelection();
if (ddlCPVillage.Items.FindByText(Convert.ToString(objPAP_InstitutionList[0].CONT_VILLAGE).ToUpper()) != null)
{
ddlCPVillage.Items.FindByText(Convert.ToString(objPAP_InstitutionList[0].CONT_VILLAGE).ToUpper()).Selected = true;
}
}
BindParish(ddlCPSubCounty.SelectedItem.Value, ddlCPParish);
uplCPParish.Update();
if (Convert.ToString(objHouseHold.Village) != "")
{
ddlCPParish.ClearSelection();
if (ddlCPParish.Items.FindByText(Convert.ToString(objPAP_InstitutionList[0].CONT_PARISH).ToUpper()) != null)
{
ddlCPParish.Items.FindByText(Convert.ToString(objPAP_InstitutionList[0].CONT_PARISH).ToUpper()).Selected = true;
}
}
}
txtTelephoneNo1.Text = Convert.ToString(objPAP_InstitutionList[0].CONTACTPHONE1);
txtTelephoneNo2.Text = Convert.ToString(objPAP_InstitutionList[0].CONTACTPHONE2);
}
getImage(HHID);
//imgPAPPhoto.ImageUrl = "~/ShowImage.ashx?photoModule=PAP&perStuID=0&id=" + HHID.ToString();
}
}
