/// <summary> /// To Get Occupant status /// </summary> /// <returns></returns> public PermanentStructureList GetOccupantstatus() { OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_TRN_GET_OCCUPANTSTATUSDATA"; cmd = new OracleCommand(proc, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); PermanentStructureBO BOobj = null; PermanentStructureList Listobj = new PermanentStructureList(); while (dr.Read()) { BOobj = new PermanentStructureBO(); BOobj.OccupantStatusID = (Convert.ToInt32(dr.GetValue(dr.GetOrdinal("OCCUPANTSTATUSID")))); BOobj.OccupantStatus = dr.GetValue(dr.GetOrdinal("OCCUPANTSTATUS")).ToString(); Listobj.Add(BOobj); } dr.Close(); return(Listobj); }
/// <summary> /// To GET STRUCTURE ID /// </summary> /// <param name="STRUCTUREID"></param> /// <returns></returns> public PermanentStructureBO GetSTRUCTUREID(int STRUCTUREID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_TRN_GET_PERSTRC"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("P_PERM_STRUCTUREID", STRUCTUREID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); PermanentStructureBO PermanentStructureobj = null; PermanentStructureList Listobj = new PermanentStructureList(); PermanentStructureobj = new PermanentStructureBO(); while (dr.Read()) { if (!dr.IsDBNull(dr.GetOrdinal("perm_structureid"))) { PermanentStructureobj.PermanentStructureID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("perm_structureid"))); } if (!dr.IsDBNull(dr.GetOrdinal("STR_TYPEID"))) { PermanentStructureobj.StructureTypeID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("STR_TYPEID"))); } if (!dr.IsDBNull(dr.GetOrdinal("OTHERSTRUCTURETYPE"))) { PermanentStructureobj.OtherStructureType = dr.GetString(dr.GetOrdinal("OTHERSTRUCTURETYPE")); } if (!dr.IsDBNull(dr.GetOrdinal("ROOFID"))) { PermanentStructureobj.RoofID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("ROOFID"))); } if (!dr.IsDBNull(dr.GetOrdinal("WALLID"))) { PermanentStructureobj.WallID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("WALLID"))); } if (!dr.IsDBNull(dr.GetOrdinal("FLOORID"))) { PermanentStructureobj.FloorID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("FLOORID"))); } if (!dr.IsDBNull(dr.GetOrdinal("WINDOWID"))) { PermanentStructureobj.WindowID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("WINDOWID"))); } if (!dr.IsDBNull(dr.GetOrdinal("ROOFCONDITIONID"))) { PermanentStructureobj.RoofConditionID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("ROOFCONDITIONID"))); } if (!dr.IsDBNull(dr.GetOrdinal("WALLCONDITIONID"))) { PermanentStructureobj.WallConditionID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("WALLCONDITIONID"))); } if (!dr.IsDBNull(dr.GetOrdinal("FLOORCONDITIONID"))) { PermanentStructureobj.FloorConditionID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("FLOORCONDITIONID"))); } if (!dr.IsDBNull(dr.GetOrdinal("WINDOWCONDITIONID"))) { PermanentStructureobj.WindowConditionID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("WINDOWCONDITIONID"))); } if (!dr.IsDBNull(dr.GetOrdinal("OWNER"))) { PermanentStructureobj.Owner = dr.GetString(dr.GetOrdinal("OWNER")); } if (!dr.IsDBNull(dr.GetOrdinal("OWNERNAME"))) { PermanentStructureobj.OwnerName = dr.GetString(dr.GetOrdinal("OWNERNAME")); } if (!dr.IsDBNull(dr.GetOrdinal("OCCUPANT"))) { PermanentStructureobj.Occupant = dr.GetString(dr.GetOrdinal("OCCUPANT")); } if (!dr.IsDBNull(dr.GetOrdinal("OTHEROCCUPANTNAME"))) { PermanentStructureobj.OtherOccupantName = dr.GetString(dr.GetOrdinal("OTHEROCCUPANTNAME")); } if (!dr.IsDBNull(dr.GetOrdinal("OCCUPANTSTATUSID"))) { PermanentStructureobj.OccupantStatusID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("OCCUPANTSTATUSID"))); } if (!dr.IsDBNull(dr.GetOrdinal("OTHEROCCUPANTSTATUS"))) { PermanentStructureobj.OtherOccupantStatus = dr.GetString(dr.GetOrdinal("OTHEROCCUPANTSTATUS")); } if (!dr.IsDBNull(dr.GetOrdinal("DIMEN_LENGTH"))) { PermanentStructureobj.DimensionLength = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("DIMEN_LENGTH"))); } if (!dr.IsDBNull(dr.GetOrdinal("DIMEN_WIDTH"))) { PermanentStructureobj.DimensionWidth = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("DIMEN_WIDTH"))); } if (!dr.IsDBNull(dr.GetOrdinal("NOOFROOMS"))) { PermanentStructureobj.NoOfRooms = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("NOOFROOMS"))); } if (!dr.IsDBNull(dr.GetOrdinal("SURFACEAREA"))) { PermanentStructureobj.SurfaceArea = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("SURFACEAREA"))); } if (!dr.IsDBNull(dr.GetOrdinal("DEPRECIATEDVALUE"))) { PermanentStructureobj.DepreciatedValue = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("DEPRECIATEDVALUE"))); } if (!dr.IsDBNull(dr.GetOrdinal("REPLACEMENTVALUE"))) { PermanentStructureobj.ReplacementValue = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("REPLACEMENTVALUE"))); } if (!dr.IsDBNull(dr.GetOrdinal("ADDITIONALCOMMENTS"))) { PermanentStructureobj.AdditionalComments = dr.GetString(dr.GetOrdinal("ADDITIONALCOMMENTS")); } if (!dr.IsDBNull(dr.GetOrdinal("ISDELETED"))) { PermanentStructureobj.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED")); } if (!dr.IsDBNull(dr.GetOrdinal("permstructuretype"))) { PermanentStructureobj.StructureType = dr.GetString(dr.GetOrdinal("permstructuretype")); } } dr.Close(); return(PermanentStructureobj); }
/// <summary> /// To Get Permanent Structure /// </summary> /// <param name="hhid"></param> /// <returns></returns> public PermanentStructureList GetPermanentStructure(string hhid) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_TRN_SEL_PERMANST"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("P_HHID", hhid); cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); PermanentStructureBO PermanentStructureobj = null; PermanentStructureList Listobj = new PermanentStructureList(); while (dr.Read()) { PermanentStructureobj = new PermanentStructureBO(); PermanentStructureobj.PermanentStructureID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("perm_structureid"))); if (!dr.IsDBNull(dr.GetOrdinal("str_type"))) { PermanentStructureobj.StructTypid = dr.GetString(dr.GetOrdinal("str_type")); } else { PermanentStructureobj.StructTypid = " "; } if (!dr.IsDBNull(dr.GetOrdinal("depreciatedvalue"))) { PermanentStructureobj.DepreciatedValue = dr.GetDecimal(dr.GetOrdinal("depreciatedvalue")); } else { PermanentStructureobj.DepreciatedValue = 0; } if (!dr.IsDBNull(dr.GetOrdinal("depreciatedvalue"))) { PermanentStructureobj.ReplacementValue = dr.GetDecimal(dr.GetOrdinal("replacementvalue")); } else { PermanentStructureobj.ReplacementValue = 0; } if (!dr.IsDBNull(dr.GetOrdinal("StructureType"))) { PermanentStructureobj.StructureType = dr.GetString(dr.GetOrdinal("StructureType")); } else { PermanentStructureobj.StructureType = ""; } // PermanentStructureobj.IsDeleted = dr.GetString(dr.GetOrdinal("isdeleted")); Listobj.Add(PermanentStructureobj); } dr.Close(); return(Listobj); }