/// <summary> /// To get details from database /// </summary> /// <returns></returns> public object GetAllCropDetails() { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GET_ALLCROPTYPES"; 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); CropTypeBO CropTypeBOObj = new CropTypeBO(); CropTypeList CropTypeListObj = new CropTypeList(); CropTypeBOObj = new CropTypeBO(); while (dr.Read()) { CropTypeBOObj = new CropTypeBO(); CropTypeBOObj.CROPTYPEID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CROPTYPEID"))); CropTypeBOObj.CropType = dr.GetString(dr.GetOrdinal("CROPTYPE")); //CropTypeBOObj.UnitName = dr.GetString(dr.GetOrdinal("UNITNAME")); CropTypeBOObj.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED")); CropTypeListObj.Add(CropTypeBOObj); } dr.Close(); return(CropTypeListObj); }
/// <summary> /// To get details by ID /// </summary> /// <param name="CROPTYPEID"></param> /// <returns></returns> public CropTypeBO GetCropTypeById(int CROPTYPEID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_SEL_CROPTYPE "; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("C_CROPTYPEID", CROPTYPEID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); CropTypeBO CropTypeBOObj = null; CropTypeList CropTypeListObj = new CropTypeList(); CropTypeBOObj = new CropTypeBO(); while (dr.Read()) { if (ColumnExists(dr, "CROPTYPEID") && !dr.IsDBNull(dr.GetOrdinal("CROPTYPEID"))) { CropTypeBOObj.CROPTYPEID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CROPTYPEID"))); } if (ColumnExists(dr, "CROPTYPE") && !dr.IsDBNull(dr.GetOrdinal("CROPTYPE"))) { CropTypeBOObj.CropType = dr.GetString(dr.GetOrdinal("CROPTYPE")); } //if (ColumnExists(dr, "UNITNAME") && !dr.IsDBNull(dr.GetOrdinal("UNITNAME"))) // CropTypeBOObj.UnitName = dr.GetString(dr.GetOrdinal("UNITNAME")); if (ColumnExists(dr, "ISDELETED") && !dr.IsDBNull(dr.GetOrdinal("ISDELETED"))) { CropTypeBOObj.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED")); } } dr.Close(); return(CropTypeBOObj); }