/// <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);
}
