/// <summary> /// to fetch details /// </summary> /// <returns></returns> public FinanceConditionBO GetfinanceConditionID(int financeConditionID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_DETAIL_FINANCE_COND"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("F_FINANCECONDITIONID", financeConditionID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); FinanceConditionBO Boobj = null; FinanceConditionList Listobj = new FinanceConditionList(); Boobj = new FinanceConditionBO(); while (dr.Read()) { if (ColumnExists(dr, "FINANCECONDITION") && !dr.IsDBNull(dr.GetOrdinal("FINANCECONDITION"))) { Boobj.FINANCECONDITION = dr.GetString(dr.GetOrdinal("FINANCECONDITION")); } if (ColumnExists(dr, "FINANCECONDITIONID") && !dr.IsDBNull(dr.GetOrdinal("FINANCECONDITIONID"))) { Boobj.FINANCECONDITIONID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("FINANCECONDITIONID"))); } } dr.Close(); return(Boobj); }
/// <summary> /// to fetch details /// </summary> /// <returns></returns> public FinanceConditionList GetAllFinanceConditions() { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GET_FINAN_COND_ALL"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); FinanceConditionBO Boobj = null; FinanceConditionList Listobj = new FinanceConditionList(); while (dr.Read()) { Boobj = new FinanceConditionBO(); if (!dr.IsDBNull(dr.GetOrdinal("FINANCECONDITIONID"))) { Boobj.FINANCECONDITIONID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("FINANCECONDITIONID"))); } if (!dr.IsDBNull(dr.GetOrdinal("FINANCECONDITION"))) { Boobj.FINANCECONDITION = dr.GetString(dr.GetOrdinal("FINANCECONDITION")); } if (!dr.IsDBNull(dr.GetOrdinal("ISDELETED"))) { Boobj.ISDELETED = dr.GetString(dr.GetOrdinal("ISDELETED")); } Listobj.Add(Boobj); } dr.Close(); return(Listobj); }