/// <summary>
/// to get the HolderType data from the database
/// </summary>
private void GetHolderType()
{
HolderTypeBO objHolderType = (new PAP_RelationBLL()).GetHolderTypes(Convert.ToInt32(Session["HH_ID"]), Convert.ToInt32(ViewState["HOLDERTYPE_ID"]))[0];
if (objHolderType != null)
{
Master.PageHeader = string.Format("Details of {0}", objHolderType.HolderTypeName);
if (objHolderType.HolderTypeName.ToUpper() == "Children (U18)".ToUpper())
{
hfDateCheck.Value = "true";
CustomValidator2.Enabled = true;
CustomValidator3.Enabled = true;
CustomValidator4.Enabled = false;
}
else if (objHolderType.HolderTypeName.ToUpper() == "Children (+18)".ToUpper())
{
hfDateCheck.Value = "true";
CustomValidator3.Enabled = true;
CustomValidator2.Enabled = false;
CustomValidator4.Enabled = true;
}
else
{
hfDateCheck.Value = "false";
CustomValidator3.Enabled = false;
CustomValidator2.Enabled = false;
CustomValidator4.Enabled = false;
}
}
else
{
hfDateCheck.Value = "false";
CustomValidator2.Enabled = false;
}
}
/// <summary>
/// To Get Holder Types
/// </summary>
/// <param name="householdID"></param>
/// <param name="holderTypeID"></param>
/// <returns></returns>
public HolderTypeList GetHolderTypes(int householdID, int holderTypeID)
{
proc = "USP_MST_GET_HOLDERTYPES";
cnn = new OracleConnection(con);
HolderTypeBO objHolderType = null;
HolderTypeList HolderTypes = new HolderTypeList();
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("HHID_", householdID);
if (holderTypeID > 0)
{
cmd.Parameters.Add("HOLDERTYPEID_", holderTypeID);
}
else
{
cmd.Parameters.Add("HOLDERTYPEID_", DBNull.Value);
}
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
try
{
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
objHolderType = new HolderTypeBO();
if (!dr.IsDBNull(dr.GetOrdinal("HOLDERTYPEID")))
{
objHolderType.HolderTypeID = dr.GetInt32(dr.GetOrdinal("HOLDERTYPEID"));
}
if (!dr.IsDBNull(dr.GetOrdinal("HOLDERTYPE")))
{
objHolderType.HolderTypeName = dr.GetString(dr.GetOrdinal("HOLDERTYPE"));
}
if (!dr.IsDBNull(dr.GetOrdinal("HOLDERCOUNT")))
{
objHolderType.HolderCount = dr.GetInt32(dr.GetOrdinal("HOLDERCOUNT"));
}
if (!dr.IsDBNull(dr.GetOrdinal("AFFECTEDHOLDERCOUNT")))
{
objHolderType.AffectedHolderCount = dr.GetInt32(dr.GetOrdinal("AFFECTEDHOLDERCOUNT"));
}
HolderTypes.Add(objHolderType);
}
dr.Close();
}
catch (Exception ex)
{
throw ex;
}
return(HolderTypes);
}
