/// <summary> /// To fetch edtails /// </summary> /// <returns></returns> public CropDiameterList GetCropDiameter() { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_SELECTCROPDIAMTR"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); CropDiameterBO objCropDiameter = null; CropDiameterList CropDiameterList = new CropDiameterList(); while (dr.Read()) { objCropDiameter = new CropDiameterBO(); objCropDiameter.CROPDIAMETERID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CROPDIAMETERID"))); objCropDiameter.CROPDIAMETER = dr.GetString(dr.GetOrdinal("CROPDIAMETER")); objCropDiameter.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED")); CropDiameterList.Add(objCropDiameter); } dr.Close(); return(CropDiameterList); }
/// <summary> /// get details by ID /// </summary> /// <param name="CROPDIAMETERID"></param> /// <returns></returns> public CropDiameterBO GetCropDiameterById(int CROPDIAMETERID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GETSECTCROPDIAMETRID"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("CROPDIAMETERID_", CROPDIAMETERID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); CropDiameterBO CropDiameterObj = null; CropDiameterList CropDiameterList = new CropDiameterList(); CropDiameterObj = new CropDiameterBO(); while (dr.Read()) { if (ColumnExists(dr, "CROPDIAMETER") && !dr.IsDBNull(dr.GetOrdinal("CROPDIAMETER"))) { CropDiameterObj.CROPDIAMETER = dr.GetString(dr.GetOrdinal("CROPDIAMETER")); } if (ColumnExists(dr, "CROPDIAMETERID") && !dr.IsDBNull(dr.GetOrdinal("CROPDIAMETERID"))) { CropDiameterObj.CROPDIAMETERID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CROPDIAMETERID"))); } if (ColumnExists(dr, "ISDELETED") && !dr.IsDBNull(dr.GetOrdinal("ISDELETED"))) { CropDiameterObj.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED")); } } dr.Close(); return(CropDiameterObj); }