/// <summary>
/// To fetch details from database
/// </summary>
/// <param name="CulturePropID"></param>
/// <returns></returns>
public CulturePropertiesMasterBO GetCulturePropByID(int CulturePropID)
{
CulturePropTypeList CulturePropTypeListObj = new CulturePropTypeList();
CulturePropertiesMasterBO CulturePropertiesMasterBObj = null;
OracleConnection Conn = new OracleConnection(AppConfiguration.ConnectionString);
Conn.Open();
OracleCommand Cmd = null;
try
{
Cmd = new OracleCommand("USP_MST_GET_CULTUREPROPBYID", Conn);
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.Parameters.Add("CULTUREPROPTYPEID_", CulturePropID);
Cmd.Parameters.Add("Sp_RecordSet", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
OracleDataReader dr = Cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
CulturePropertiesMasterBObj = new CulturePropertiesMasterBO();
CulturePropertiesMasterBObj.CulturePropTypeID = Convert.ToInt32(dr["CULTUREPROPTYPEID"]);
CulturePropertiesMasterBObj.CulturePropTypeName = dr["CULTUREPROPTYPE"].ToString();
}
}
catch
{
throw;
}
finally
{
Cmd.Dispose();
Conn.Close();
Conn.Dispose();
}
return(CulturePropertiesMasterBObj);
}
/// <summary>
/// To fetch details from database
/// </summary>
/// <returns></returns>
public CulturePropTypeList GetAllCulturePropertyType()
{
CulturePropTypeList CulturePropTypeListObj = new CulturePropTypeList();
CulturePropertiesMasterBO CulturePropertiesMasterBObj = null;
OracleConnection Conn = new OracleConnection(AppConfiguration.ConnectionString);
Conn.Open();
OracleCommand Cmd = null;
try
{
Cmd = new OracleCommand("USP_SEL_MST_CULTUREPROPERTY", Conn);
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output;
OracleDataReader dr = Cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
CulturePropertiesMasterBObj = new CulturePropertiesMasterBO();
CulturePropertiesMasterBObj.CulturePropTypeID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CULTUREPROPTYPEID")));
CulturePropertiesMasterBObj.CulturePropTypeName = dr.GetString(dr.GetOrdinal("CULTUREPROPTYPE"));
CulturePropertiesMasterBObj.Isdeleted = dr.GetString(dr.GetOrdinal("ISDELETED"));
CulturePropTypeListObj.Add(CulturePropertiesMasterBObj);
}
}
catch
{
throw;
}
finally
{
Cmd.Dispose();
Conn.Close();
Conn.Dispose();
}
return(CulturePropTypeListObj);
}
