/// <summary> /// To Get New Location /// </summary> /// <param name="HHID"></param> /// <returns></returns> public NewLocationBO GetNewLocation(int HHID) { proc = "USP_TRN_GET_CMP_NEW_PLOT"; cnn = new OracleConnection(con); //NewLocationBO oNewLocationBO = null; NewLocationList lstNewLocation = new NewLocationList(); cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("hhid_", HHID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; NewLocationBO oNewLocationBO = null; try { cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { oNewLocationBO = new NewLocationBO(); //if (!dr.IsDBNull(dr.GetOrdinal("BankID"))) oNewLocationBO.BankID = dr.GetInt32(dr.GetOrdinal("BankID")); //if (!dr.IsDBNull(dr.GetOrdinal("BankName"))) oNewLocationBO.BankName = dr.GetString(dr.GetOrdinal("BankName")); //if (!dr.IsDBNull(dr.GetOrdinal("City"))) oNewLocationBO.City = dr.GetString(dr.GetOrdinal("City")); //if (!dr.IsDBNull(dr.GetOrdinal("BranchName"))) oNewLocationBO.BranchName = dr.GetString(dr.GetOrdinal("BranchName")); //if (!dr.IsDBNull(dr.GetOrdinal("SwiftCode"))) oNewLocationBO.SwiftCode = dr.GetString(dr.GetOrdinal("SwiftCode")); //if (!dr.IsDBNull(dr.GetOrdinal("IsDeleted"))) oNewLocationBO.IsDeleted = dr.GetString(dr.GetOrdinal("IsDeleted")); oNewLocationBO = MapData(dr); //lstNewLocation.Add(oNewLocationBO); } dr.Close(); } catch (Exception ex) { throw ex; } return(oNewLocationBO); }
/// <summary> /// To fetch details /// </summary> /// <param name="HHID"></param> /// <returns></returns> public LivelihoodRestLocationBO GetNewLocation(int HHID) { proc = "USP_TRN_GET_PAP_LIV_REST_LOC"; cnn = new OracleConnection(con); //LivelihoodRestLocationBO oLivelihoodRestLocationBO = null; NewLocationList lstNewLocation = new NewLocationList(); cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("hhid_", HHID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; LivelihoodRestLocationBO oLivelihoodRestLocationBO; try { cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); oLivelihoodRestLocationBO = new LivelihoodRestLocationBO(); while (dr.Read()) { oLivelihoodRestLocationBO = MapData(dr); //lstNewLocation.Add(oLivelihoodRestLocationBO); } dr.Close(); } catch (Exception ex) { throw ex; } return(oLivelihoodRestLocationBO); }