/// <summary> /// GetCropDescription /// </summary> /// <returns></returns> public CropDescriptionList GetCropDescription() { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_SELECTCROPDESCRIPTION"; 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); CropDescriptionBO objCropDescription = null; CropDescriptionList CropDescriptionList = new CropDescriptionList(); while (dr.Read()) { objCropDescription = new CropDescriptionBO(); objCropDescription.CROPDESID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CROPDESCRIPTIONID"))); objCropDescription.CROPDESNAME = dr.GetString(dr.GetOrdinal("CROPDESCRIPTION")); objCropDescription.CROPDESISDeleted = dr.GetString(dr.GetOrdinal("ISDELETED")); objCropDescription.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED")); CropDescriptionList.Add(objCropDescription); } dr.Close(); return(CropDescriptionList); }
/// <summary> /// to get details by ID /// </summary> /// <param name="CROPDESCRIPTIONID"></param> /// <returns></returns> public CropDescriptionBO GetCropDescriptionId(int CROPDESCRIPTIONID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GETSELECTCROPDESC"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("CROPDESCRIPTIONID_", CROPDESCRIPTIONID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); CropDescriptionBO CropDescriptionObj = null; CropDescriptionList CropDescriptionList = new CropDescriptionList(); CropDescriptionObj = new CropDescriptionBO(); while (dr.Read()) { if (ColumnExists(dr, "CROPDESCRIPTION") && !dr.IsDBNull(dr.GetOrdinal("CROPDESCRIPTION"))) { CropDescriptionObj.CROPDESNAME = dr.GetString(dr.GetOrdinal("CROPDESCRIPTION")); } if (ColumnExists(dr, "CROPDESCRIPTIONID") && !dr.IsDBNull(dr.GetOrdinal("CROPDESCRIPTIONID"))) { CropDescriptionObj.CROPDESID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CROPDESCRIPTIONID"))); } if (ColumnExists(dr, "ISDELETED") && !dr.IsDBNull(dr.GetOrdinal("ISDELETED"))) { CropDescriptionObj.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED")); } } dr.Close(); return(CropDescriptionObj); }