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