/// <summary> /// to fetch all details /// </summary> /// <returns></returns> public GrievancesMasterList GetALLGrievancesCategory() { OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GETALL_GRIVCATEGORY"; 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); GrievancesMasterBO objTypeBO = null; GrievancesMasterList objGrievancesCategorys = new GrievancesMasterList(); while (dr.Read()) { objTypeBO = new GrievancesMasterBO(); objTypeBO.GRIEVANCECATEGID = dr.GetInt32(dr.GetOrdinal("GRIEVANCECATEGID")); objTypeBO.GrievancesCategory = dr.GetString(dr.GetOrdinal("GRIEVANCECATEGORY")); objTypeBO.IsDeleted = dr.GetString(dr.GetOrdinal("isdeleted")); objGrievancesCategorys.Add(objTypeBO); } dr.Close(); return(objGrievancesCategorys); }
/// <summary> /// to fetch all details /// </summary> /// <param name="GRIEVANCECATEGID"></param> /// <returns></returns> public GrievancesMasterBO GetGrievancesCategoryId(int GRIEVANCECATEGID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GET_GRIVCATEGORYBYID"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("GRIEVANCECATEGID_", GRIEVANCECATEGID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); GrievancesMasterBO objconsultantType = null; GrievancesMasterList Users = new GrievancesMasterList(); objconsultantType = new GrievancesMasterBO(); while (dr.Read()) { if (ColumnExists(dr, "GRIEVANCECATEGORY") && !dr.IsDBNull(dr.GetOrdinal("GRIEVANCECATEGORY"))) { objconsultantType.GrievancesCategory = dr.GetString(dr.GetOrdinal("GRIEVANCECATEGORY")); } if (ColumnExists(dr, "GRIEVANCECATEGID") && !dr.IsDBNull(dr.GetOrdinal("GRIEVANCECATEGID"))) { objconsultantType.GRIEVANCECATEGID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("GRIEVANCECATEGID"))); } } dr.Close(); return(objconsultantType); }