/// <summary> /// To get details /// </summary> /// <returns></returns> public object GetCropNameDetails() { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GET_CROPNAME"; 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); CropNameBO CropNameBOObj = null; CropNameList CropNameListObj = new CropNameList(); CropNameBOObj = new CropNameBO(); while (dr.Read()) { CropNameBOObj = new CropNameBO(); CropNameBOObj.CROPID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CROPID"))); CropNameBOObj.CropName = dr.GetString(dr.GetOrdinal("CROPNAME")); CropNameBOObj.IsDeletedBy = dr.GetString(dr.GetOrdinal("ISDELETED")); CropNameListObj.Add(CropNameBOObj); } dr.Close(); return(CropNameListObj); }
/// <summary> /// To get details by ID /// </summary> /// <param name="CROPID"></param> /// <returns></returns> public CropNameBO GetCropNameById(int CROPID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_SEL_CROPNAME "; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("C_CROPID", CROPID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); CropNameBO CropNameBOObj = null; CropNameList CropNameListObj = new CropNameList(); CropNameBOObj = new CropNameBO(); while (dr.Read()) { if (!dr.IsDBNull(dr.GetOrdinal("CROPID"))) { CropNameBOObj.CROPID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CROPID"))); } if (!dr.IsDBNull(dr.GetOrdinal("CROPNAME"))) { CropNameBOObj.CropName = dr.GetString(dr.GetOrdinal("CROPNAME")); } if (!dr.IsDBNull(dr.GetOrdinal("UNITNAME"))) { CropNameBOObj.UnitName = dr.GetString(dr.GetOrdinal("UNITNAME")); } } dr.Close(); return(CropNameBOObj); }