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