/// <summary>
/// To Get Serial Number
/// </summary>
/// <param name="CONFIGITEM"></param>
/// <returns></returns>
public WIS_ConfigBO GetSerialNumber(string CONFIGITEM)
{
proc = "USP_RPT_UPD_SERIALNO";
cnn = new OracleConnection(con);
WIS_ConfigBO oWIS_ConfigBO = null;
WIS_ConfigList lstWIS_Config = new WIS_ConfigList();
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("CONFIGITEM_", CONFIGITEM);
// cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
try
{
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
oWIS_ConfigBO = new WIS_ConfigBO();
oWIS_ConfigBO = MapData(dr);
// lstWIS_Config.Add(oWIS_ConfigBO);
}
dr.Close();
}
catch (Exception ex)
{
throw ex;
}
return(oWIS_ConfigBO);
}
/// <summary>
/// To Get Configuration
/// </summary>
/// <param name="SearchValue"></param>
/// <returns></returns>
public WIS_ConfigBO getConfiguration(string SearchValue)
{
proc = "USP_GET_WIS_CONFIGURATION";
cnn = new OracleConnection(con);
WIS_ConfigBO oWIS_ConfigBO = null;
WIS_ConfigList lstWIS_Config = new WIS_ConfigList();
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("ConfigItem_", SearchValue);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
try
{
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
oWIS_ConfigBO = new WIS_ConfigBO();
oWIS_ConfigBO = MapData(dr);
// lstWIS_Config.Add(oWIS_ConfigBO);
}
dr.Close();
}
catch (Exception ex)
{
throw ex;
}
return(oWIS_ConfigBO);
}
