/// <summary>
/// to bind the grid
/// </summary>
private void BindGrid()
{
SocioConcernBLL objSocioConcernBLL = new SocioConcernBLL();
SocioConcernList objSocioConcernList = new SocioConcernList();
int HHID = Convert.ToInt32(Session["HH_ID"].ToString());
objSocioConcernList = objSocioConcernBLL.getSocioConcern(HHID);
grdSocioConcerns.DataSource = objSocioConcernList;
grdSocioConcerns.DataBind();
}
/// <summary>
/// To get Socio Concern
/// </summary>
/// <param name="HHID"></param>
/// <returns></returns>
public SocioConcernList getSocioConcern(int HHID)
{
// used in Master page
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = " USP_TRN_GETSOCIALCONCERNS";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("HHID_", HHID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
SocioConcernBO objSocioConcern = null;
SocioConcernList SocioConcernList = new SocioConcernList();
while (dr.Read())
{
objSocioConcern = new SocioConcernBO();
if (!dr.IsDBNull(dr.GetOrdinal("PAP_CONCERNID")))
{
objSocioConcern.PapConcernID = dr.GetInt32(dr.GetOrdinal("PAP_CONCERNID"));
}
if (!dr.IsDBNull(dr.GetOrdinal("HHID")))
{
objSocioConcern.HHID = dr.GetInt32(dr.GetOrdinal("HHID"));
}
if (!dr.IsDBNull(dr.GetOrdinal("CONCERNID")))
{
objSocioConcern.ConcernID = dr.GetInt32(dr.GetOrdinal("CONCERNID"));
}
if (!dr.IsDBNull(dr.GetOrdinal("CONCERN")))
{
objSocioConcern.ConcernName = dr.GetString(dr.GetOrdinal("CONCERN"));
}
if (!dr.IsDBNull(dr.GetOrdinal("OTHERCONCERN")))
{
objSocioConcern.OtherConcern = dr.GetString(dr.GetOrdinal("OTHERCONCERN"));
}
SocioConcernList.Add(objSocioConcern);
}
dr.Close();
return(SocioConcernList);
}
/// <summary>
/// To Get Socio Concern By Id
/// </summary>
/// <param name="PapConcernID"></param>
/// <param name="HHID"></param>
/// <returns></returns>
public SocioConcernBO GetSocioConcernById(int PapConcernID, int HHID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_GET_SOC_CONCERN_ID";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("PapConcernID_", PapConcernID);
cmd.Parameters.Add("HHID_", HHID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
SocioConcernBO SocioConcernObj = null;
SocioConcernList SocioConcernList = new SocioConcernList();
SocioConcernObj = new SocioConcernBO();
while (dr.Read())
{
if (ColumnExists(dr, "OTHERCONCERN") && !dr.IsDBNull(dr.GetOrdinal("OTHERCONCERN")))
{
SocioConcernObj.OtherConcern = dr.GetString(dr.GetOrdinal("OTHERCONCERN"));
}
if (ColumnExists(dr, "PAP_CONCERNID") && !dr.IsDBNull(dr.GetOrdinal("PAP_CONCERNID")))
{
SocioConcernObj.PapConcernID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("PAP_CONCERNID")));
}
if (ColumnExists(dr, "CONCERNID") && !dr.IsDBNull(dr.GetOrdinal("CONCERNID")))
{
SocioConcernObj.ConcernID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CONCERNID")));
}
}
dr.Close();
return(SocioConcernObj);
}