/// <summary>
/// Fill SqlParameter by reading a EPlayer object to execute stored procedure
/// </summary>
/// <param name="p_oData"></param>
/// <returns></returns>
static private SqlParameter[] RegisterSqlParameter(ELoggerData p_oData)
{
SqlParameter[] arParams = new SqlParameter[5];
arParams[0] = new SqlParameter("@ApplicationID", SqlDbType.Int);
arParams[1] = new SqlParameter("@Message", SqlDbType.NVarChar, 500);
arParams[2] = new SqlParameter("@Importance", SqlDbType.Int);
arParams[3] = new SqlParameter("@LoggerCategory", SqlDbType.NVarChar, 100);
arParams[4] = new SqlParameter("@LoggerType", SqlDbType.NVarChar, 50);
arParams[0].Value = p_oData.ApplicationID;
arParams[1].Value = p_oData.Message;
arParams[2].Value = p_oData.Importance;
arParams[3].Value = p_oData.Category;
arParams[4].Value = p_oData.Type;
return(arParams);
}
/// <summary>
/// Fill ELoggerData object by reading SqlDataReader returned by stored procedure
/// </summary>
/// <param name="oReader"></param>
/// <returns></returns>
static private ELoggerData ReadData(SqlDataReader oReader)
{
try
{
ELoggerData oData = new ELoggerData();
//ELoggerData
oData.ID = oReader.GetString(oReader.GetOrdinal("ID"));
return(oData);
}
catch (SqlException e)
{
Console.WriteLine("Reading failed! Error: " + e.Message);
throw e;
}
catch (System.Exception e)
{
Console.WriteLine("Reading failed! Error: " + e.Message);
throw e;
}
}
public static ELoggerData Insert(ELoggerData iData)
{
SqlDataReader oReader = null;
try
{
//Fill the request's parameters
SqlParameter[] p_sqlParams = RegisterSqlParameter(iData);
//Call the request
oReader = CCstData.GetInstance(iData.ApplicationID).DatabaseEngine.ExecuteReader(CommandType.StoredProcedure, CCstDatabase.SP_LoggerData_Insert, p_sqlParams);
//If there is a result (not null)
if (oReader != null)
{
ELoggerData oData = new ELoggerData();
while (oReader.Read())
{
oData = ReadData(oReader);
}
//If an error occurs, ID -1 is given
return(oData);
}
return(null);
}
catch (Exception e)
{
throw e;
}
finally
{
if (oReader != null && !oReader.IsClosed)
{
oReader.Close();
}
}
}
