/// <summary> /// Fill SqlParameter by reading a EPlayer object to execute stored procedure /// </summary> /// <param name="p_oData"></param> /// <returns></returns> static private SqlParameter[] RegisterSqlParameter(EHackHeuristic p_oData) { SqlParameter[] arParams = new SqlParameter[6]; arParams[0] = new SqlParameter("@ApplicationID", SqlDbType.Int); arParams[1] = new SqlParameter("@ComputerID", SqlDbType.NVarChar, 50); arParams[2] = new SqlParameter("@ProcessName", SqlDbType.NVarChar, 50); arParams[3] = new SqlParameter("@WindowName", SqlDbType.NVarChar, 50); arParams[4] = new SqlParameter("@ClassName", SqlDbType.NVarChar, 50); arParams[5] = new SqlParameter("@MD5Value", SqlDbType.NVarChar, 50); arParams[0].Value = p_oData.ApplicationID; arParams[1].Value = p_oData.User.ID; arParams[2].Value = p_oData.ProcessName; arParams[3].Value = p_oData.WindowName; arParams[4].Value = p_oData.ClassName; arParams[5].Value = p_oData.MD5Value; return(arParams); }
public static bool Insert(EHackHeuristic _pdata) { SqlDataReader oReader = null; try { //Initialize the return object EHackHeuristic oData = new EHackHeuristic(); //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_Heuristic, 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(); } } }