/// <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); }
/// <summary> /// To Get Option Group By Id /// </summary> /// <param name="OptionGroupID"></param> /// <returns></returns> public OptionGroupBO GetOptionGroupById(int OptionGroupID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GETOPTION_GROUPSBYID"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("OPTIONGROUPID_", OptionGroupID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); OptionGroupBO objOptionGroupBO = null; OptionGroupList OptionGroup = new OptionGroupList(); objOptionGroupBO = new OptionGroupBO(); while (dr.Read()) { if (ColumnExists(dr, "optiongroupid") && !dr.IsDBNull(dr.GetOrdinal("optiongroupid"))) { objOptionGroupBO.OptionGroupID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("optiongroupid"))); } if (ColumnExists(dr, "optiongroup") && !dr.IsDBNull(dr.GetOrdinal("optiongroup"))) { objOptionGroupBO.OptionGroupName = Convert.ToString(dr.GetValue(dr.GetOrdinal("optiongroup"))); } if (ColumnExists(dr, "isdeleted") && !dr.IsDBNull(dr.GetOrdinal("isdeleted"))) { objOptionGroupBO.IsDeleted = dr.GetString(dr.GetOrdinal("isdeleted")); } } dr.Close(); return(objOptionGroupBO); }