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