/// <summary> /// To Get Option Group /// </summary> /// <returns></returns> public OptionGroupList GetOptionGroup() { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GETOPTION_GROUPS"; 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); OptionGroupBO objOptionGroupBO = null; OptionGroupList OptionGroup = new OptionGroupList(); while (dr.Read()) { objOptionGroupBO = new OptionGroupBO(); objOptionGroupBO.OptionGroupID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("optiongroupid"))); objOptionGroupBO.OptionGroupName = dr.GetString(dr.GetOrdinal("optiongroup")); objOptionGroupBO.IsDeleted = dr.GetString(dr.GetOrdinal("isdeleted")); OptionGroup.Add(objOptionGroupBO); } dr.Close(); return(OptionGroup); }
public OptionGroupList GetOptionDescription(int Pid) { OracleConnection con = new OracleConnection(connStr); OracleCommand cmd; string proc = "USP_DSH_GET_OPT_DESCRIPTION"; cmd = new OracleCommand(proc, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("PID_", Pid); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); OptionGroupBO oOptionGroupBO = null; OptionGroupList lstOptionGroup = new OptionGroupList(); while (dr.Read()) { oOptionGroupBO = new OptionGroupBO(); oOptionGroupBO.OptionGroupID = (Convert.ToInt32(dr.GetValue(dr.GetOrdinal("DESCRIPTIONID")))); oOptionGroupBO.OptionGroupName = dr.GetValue(dr.GetOrdinal("DESCRIPTION")).ToString(); lstOptionGroup.Add(oOptionGroupBO); } dr.Close(); return(lstOptionGroup); }
/// <summary> /// To Load Option Group Data /// </summary> /// <returns></returns> public OptionGroupList LoadOptionGroupData() { cnn = new OracleConnection(AppConfiguration.ConnectionString); string proc = "USP_MST_GET_OPTIONGROUPS"; 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); OptionGroupBO obMaster = null; OptionGroupList Master = new OptionGroupList(); while (dr.Read()) { obMaster = new OptionGroupBO(); obMaster.OptionGroupID = dr.GetInt32(dr.GetOrdinal("ID")); obMaster.OptionGroupName = dr.GetString(dr.GetOrdinal("Name")); Master.Add(obMaster); } dr.Close(); return(Master); }