/// <summary>
/// To Get NPS
/// </summary>
/// <param name="householdID"></param>
/// <returns></returns>
public Non_perm_structureList GetNPS(int householdID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_SEL_NPS";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("HHID_", householdID);
cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
NonPermanentStructureBO BOobj1 = null;
Non_perm_structureList Non_perm_structureListobj = new Non_perm_structureList();
while (dr.Read())
{
BOobj1 = new NonPermanentStructureBO();
BOobj1.NonPermanentStructureID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("NONPERM_STRUCTUREID")));
BOobj1.STR_TYPE = dr.GetString(dr.GetOrdinal("str_type"));
BOobj1.STR_CATEGORYNAME = dr.GetString(dr.GetOrdinal("str_categoryname"));
BOobj1.STR_CONDITION = dr.GetString(dr.GetOrdinal("str_condition"));
BOobj1.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED"));
Non_perm_structureListobj.Add(BOobj1);
}
dr.Close();
return(Non_perm_structureListobj);
}
/// <summary>
/// To Get Non Permanent Structure Id
/// </summary>
/// <param name="NonPermanentStructureID"></param>
/// <returns></returns>
public NonPermanentStructureBO GetNPSId(int NonPermanentStructureID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_GET_NPS";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("S_NONPERM_STRUCTUREID", NonPermanentStructureID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
NonPermanentStructureBO BOobj1 = null;
Non_perm_structureList Non_perm_structureListobj = new Non_perm_structureList();
BOobj1 = new NonPermanentStructureBO();
while (dr.Read())
{
if (ColumnExists(dr, "nonperm_structureid") && !dr.IsDBNull(dr.GetOrdinal("nonperm_structureid")))
{
BOobj1.NonPermanentStructureID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("nonperm_structureid")));
}
if (ColumnExists(dr, "str_typeid") && !dr.IsDBNull(dr.GetOrdinal("str_typeid")))
{
BOobj1.StructureTypeID = dr.GetInt32(dr.GetOrdinal("str_typeid"));
}
if (ColumnExists(dr, "categoryid") && !dr.IsDBNull(dr.GetOrdinal("categoryid")))
{
BOobj1.CategoryID = dr.GetInt32(dr.GetOrdinal("categoryid"));
}
if (ColumnExists(dr, "str_conditionid") && !dr.IsDBNull(dr.GetOrdinal("str_conditionid")))
{
BOobj1.StructureConditionID = dr.GetInt32(dr.GetOrdinal("str_conditionid"));
}
if (ColumnExists(dr, "otherstructuretype") && !dr.IsDBNull(dr.GetOrdinal("otherstructuretype")))
{
BOobj1.OtherStructureType = dr.GetString(dr.GetOrdinal("otherstructuretype"));
}
if (ColumnExists(dr, "owner") && !dr.IsDBNull(dr.GetOrdinal("owner")))
{
BOobj1.Owner = dr.GetString(dr.GetOrdinal("owner"));
}
if (ColumnExists(dr, "ownername") && !dr.IsDBNull(dr.GetOrdinal("ownername")))
{
BOobj1.OwnerName = dr.GetString(dr.GetOrdinal("ownername"));
}
if (ColumnExists(dr, "occupant") && !dr.IsDBNull(dr.GetOrdinal("occupant")))
{
BOobj1.Occupant = dr.GetString(dr.GetOrdinal("occupant"));
}
if (ColumnExists(dr, "otheroccupantname") && !dr.IsDBNull(dr.GetOrdinal("otheroccupantname")))
{
BOobj1.OtherOccupantName = dr.GetString(dr.GetOrdinal("otheroccupantname"));
}
if (ColumnExists(dr, "occupantstatusid") && !dr.IsDBNull(dr.GetOrdinal("occupantstatusid")))
{
BOobj1.OccupantStatusID = dr.GetInt32(dr.GetOrdinal("occupantstatusid"));
}
if (ColumnExists(dr, "otheroccupantstatus") && !dr.IsDBNull(dr.GetOrdinal("otheroccupantstatus")))
{
BOobj1.OtherOccupantStatus = dr.GetString(dr.GetOrdinal("otheroccupantstatus"));
}
if (!dr.IsDBNull(dr.GetOrdinal("dimen_length")))
{
BOobj1.DimensionLength = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("dimen_length")));
}
if (!dr.IsDBNull(dr.GetOrdinal("dimen_width")))
{
BOobj1.DimensionWidth = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("dimen_width")));
}
if (!dr.IsDBNull(dr.GetOrdinal("noofrooms")))
{
BOobj1.NoOfRooms = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("noofrooms")));
}
if (!dr.IsDBNull(dr.GetOrdinal("surfacearea")))
{
BOobj1.SurfaceArea = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("surfacearea")));
}
}
dr.Close();
return(BOobj1);
}