public static LoanList GetList(int applicantId)
{
LoanList loans = new LoanList();
using(OracleConnection oraDbConn =
new OracleConnection(
ConnStringFactory.getConnString(
ConnStringFactory.ConnStringType.Oracle))){
oraDbConn.Open();
using(OracleCommand getLoansByAppIdCommand = new OracleCommand()){
getLoansByAppIdCommand.CommandType = CommandType.StoredProcedure;
getLoansByAppIdCommand.CommandText = "LoansPKG.getLoansByAppId";
getLoansByAppIdCommand.Connection = oraDbConn;
getLoansByAppIdCommand.Parameters.AddWithValue("AppId", applicantId);
OracleParameter outputCursor = new OracleParameter("IO_CURSOR", OracleType.Cursor);
outputCursor.Direction = ParameterDirection.Output;
getLoansByAppIdCommand.Parameters.Add(outputCursor);
using (OracleDataReader loanListReader =
getLoansByAppIdCommand.ExecuteReader()) {
while(loanListReader.Read()){
loans.Add(FillDataRecord(loanListReader));
}
}
}
}
return loans;
}
/// <summary>
/// To Get Loan
/// </summary>
/// <param name="EncumbrancepurposeName"></param>
/// <returns></returns>
public LoanList GetLoan(string EncumbrancepurposeName)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_GET_ENCUMBRANCEPURPOSE";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
if (EncumbrancepurposeName.ToString() == "")
{
cmd.Parameters.Add("@EncumbrancepurposeNameIN", DBNull.Value);
}
else
{
cmd.Parameters.Add("@EncumbrancepurposeNameIN", EncumbrancepurposeName.ToString());
}
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
LoanBO objLoan = null;
LoanList Loan = new LoanList();
while (dr.Read())
{
objLoan = new LoanBO();
objLoan.EncumbranceId = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("ENCUMBRANCEID")));
objLoan.Encumbrancepurpose = dr.GetString(dr.GetOrdinal("ENCUMBRANCEPURPOSE"));
objLoan.IsDeleted = dr.GetString(dr.GetOrdinal("isdeleted"));
Loan.Add(objLoan);
}
dr.Close();
return(Loan);
}
