/// <summary> /// to fetch details /// </summary> /// <returns></returns> public FenceDescriptionList GetFence() { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = " USP_MST_GET_FENCE"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); FenceDescriptionBO objUser = null; FenceDescriptionList Users = new FenceDescriptionList(); while (dr.Read()) { objUser = new FenceDescriptionBO(); objUser.FenceID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("FENCEID"))); objUser.FenceDescription = dr.GetString(dr.GetOrdinal("FENCEDESCRIPTION")); Users.Add(objUser); } dr.Close(); return(Users); }
/// <summary> /// to get details by ID /// </summary> /// <param name="FenceID"></param> /// <returns></returns> public FenceDescriptionBO GetFencebyID(int FenceID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GET_FENCEBYID"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("p_fenceid", FenceID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); FenceDescriptionBO FenceDescriptionBOobj = null; FenceDescriptionList Users = new FenceDescriptionList(); FenceDescriptionBOobj = new FenceDescriptionBO(); while (dr.Read()) { if (ColumnExists(dr, "FENCEDESCRIPTION") && !dr.IsDBNull(dr.GetOrdinal("FENCEDESCRIPTION"))) { FenceDescriptionBOobj.FenceDescription = dr.GetString(dr.GetOrdinal("FENCEDESCRIPTION")); } if (ColumnExists(dr, "FENCEID") && !dr.IsDBNull(dr.GetOrdinal("FENCEID"))) { FenceDescriptionBOobj.FenceID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("FENCEID"))); } if (ColumnExists(dr, "IsDeleted") && !dr.IsDBNull(dr.GetOrdinal("IsDeleted"))) { FenceDescriptionBOobj.IsDeleted = dr.GetString(dr.GetOrdinal("IsDeleted")); } } dr.Close(); return(FenceDescriptionBOobj); }