/// <summary>
/// Fill SqlParameter by reading a EPlayer object to execute stored procedure
/// </summary>
/// <param name="p_oData"></param>
/// <returns></returns>
static private SqlParameter[] RegisterSqlParameter(EHackFile p_oData)
{
SqlParameter[] arParams = new SqlParameter[4];
arParams[0] = new SqlParameter("@ApplicationID", SqlDbType.Int);
arParams[1] = new SqlParameter("@ComputerID", SqlDbType.NVarChar, 50);
arParams[2] = new SqlParameter("@CaseID", SqlDbType.Int);
arParams[3] = new SqlParameter("@Content", SqlDbType.NVarChar, 50);
arParams[0].Value = p_oData.ApplicationID;
arParams[1].Value = p_oData.User.ID;
arParams[2].Value = p_oData.CaseID;
arParams[3].Value = p_oData.Content;
return(arParams);
}
public static bool Insert(EHackFile _pdata)
{
SqlDataReader oReader = null;
try
{
//Initialize the return object
EHackFile oData = new EHackFile();
//Fill the request's parameters
SqlParameter[] p_sqlParams = RegisterSqlParameter(_pdata);
//Call the request
oReader = CCstData.GetInstance(_pdata.ApplicationID).DatabaseEngine.ExecuteReader(CommandType.StoredProcedure, CCstDatabase.SP_HackDetection_Insert_File, p_sqlParams);
//If there is a result (not null)
if (oReader != null)
{
while (oReader.Read())
{
//Read the data and convert the SqlDataReader in the waiting object
return(oReader.GetString(oReader.GetOrdinal("ID")) == "0");
}
}
return(false);
}
catch (Exception e)
{
throw e;
}
finally
{
if (oReader != null && !oReader.IsClosed)
{
oReader.Close();
}
}
}
