private void InsertRequestStatusToDB()
{
WSP.Console.WS_DBOP.GeneralDBOp wsSend = new WSP.Console.WS_DBOP.GeneralDBOp();
wsSend.Timeout = 10000;
wsSend.Url = g_SharedData.WSP_AGENT_SETTING.strWS_URL + "/GeneralDBOp.asmx";
DataTable dtParams = SetParmeterTable();
int iServerNumber = g_SharedData.WSP_AGENT_SETTING.iServerNumber;
dtParams.Rows.Add(iServerNumber, "TimeIn", "DATETIME", "");
dtParams.Rows.Add(iServerNumber, "ServerNum", "INT", "");
dtParams.Rows.Add(iServerNumber, "HostHeader", "STRING", "");
dtParams.Rows.Add(iServerNumber, "SiteName", "STRING", "");
dtParams.Rows.Add(iServerNumber, "ValueDescription", "STRING", "");
dtParams.Rows.Add(iServerNumber, "TotalNumber", "FLOAT", "");
dtParams.Rows.Add(iServerNumber, "LogValue", "STRING", "");
try
{
//wsSend.InsertSPValues("p_tbRequestStatus_Add", DataTableToBytes(dtParams), DataTableToBytes(dtRequestStatus));
wsSend.RequestStatusInsert(DataTableToBytes(dtRequestStatus), iServerNumber, g_dtTimeIn.ToString("yyyy-MM-dd HH:mm:ss"), g_dtTimeIn_UTC.ToString("yyyy-MM-dd HH:mm:ss"));
}
catch (Exception ex)
{
WSPEvent.WriteEvent("Sending IIS requests information has been failed. - " + ex.Message, "W", 1114);
}
}
private void InsertIISLogToDB()
{
WSP.Console.WS_DBOP.GeneralDBOp wsSend = new WSP.Console.WS_DBOP.GeneralDBOp();
wsSend.Timeout = 10000;
wsSend.Url = g_SharedData.WSP_AGENT_SETTING.strWS_URL + "/GeneralDBOp.asmx";
DataTable dtParams = SetParmeterTable();
int iServerNumber = g_SharedData.WSP_AGENT_SETTING.iServerNumber;
dtParams.Rows.Add(iServerNumber, "TimeIn", "DATETIME", "");
dtParams.Rows.Add(iServerNumber, "ServerNum", "INT", "");
dtParams.Rows.Add(iServerNumber, "SiteName", "STRING", "");
dtParams.Rows.Add(iServerNumber, "HostHeader", "STRING", "");
dtParams.Rows.Add(iServerNumber, "URI", "STRING", "");
dtParams.Rows.Add(iServerNumber, "Hits", "INT", "");
dtParams.Rows.Add(iServerNumber, "MaxTimeTaken", "INT", "");
dtParams.Rows.Add(iServerNumber, "AvgTimeTaken", "INT", "");
dtParams.Rows.Add(iServerNumber, "SCBytes", "FLOAT", "");
dtParams.Rows.Add(iServerNumber, "CSBytes", "FLOAT", "");
dtParams.Rows.Add(iServerNumber, "StatusCode", "INT", "");
dtParams.Rows.Add(iServerNumber, "Win32StatusCode", "BIGINT", "");
try
{
wsSend.IISLogInsert(DataTableToBytes(dtIISLog), iServerNumber, g_dtTimeIn.ToString("yyyy-MM-dd HH:mm:ss"), g_dtTimeIn_UTC.ToString("yyyy-MM-dd HH:mm:ss"));
}
catch (Exception ex)
{
WSPEvent.WriteEvent("Sending IIS Log information has been failed. - " + ex.Message, "W", 1114);
}
}
public void InsertAppsUsingWS(DataTable dtAppTrace)
{
int iServerNumber = g_SharedData.WSP_AGENT_SETTING.iServerNumber;
DataTable dtApps = new DataTable();
try
{
WSP.Console.WS_DBOP.GeneralDBOp wsInsert = new WSP.Console.WS_DBOP.GeneralDBOp();
wsInsert.Url = g_SharedData.WSP_AGENT_SETTING.strWS_URL + "/GeneralDBOp.asmx";
wsInsert.Timeout = 10000;
DataTable dtParms = SetParmeterTable();
dtParms.Rows.Add(iServerNumber, "ServerNum", "INT", iServerNumber);
dtParms.Rows.Add(iServerNumber, "TimeIn", "DATETIME", "");
dtParms.Rows.Add(iServerNumber, "AlertRecordID", "STRING", "");
dtParms.Rows.Add(iServerNumber, "ReasonCode", "STRING", "");
dtParms.Rows.Add(iServerNumber, "URI", "STRING", "");
dtParms.Rows.Add(iServerNumber, "ClientLocation", "STRING", "");
dtParms.Rows.Add(iServerNumber, "RunningTime", "INT", "");
dtApps.Columns.Clear();
dtApps.Columns.Add(new DataColumn("ServerNum", typeof(int)));
dtApps.Columns.Add(new DataColumn("TimeIn", typeof(DateTime)));
dtApps.Columns.Add(new DataColumn("AlertRecordID", typeof(Guid)));
dtApps.Columns.Add(new DataColumn("ReasonCode", typeof(string)));
dtApps.Columns.Add(new DataColumn("URI", typeof(string)));
dtApps.Columns.Add(new DataColumn("ClientLocation", typeof(string)));
dtApps.Columns.Add(new DataColumn("RunningTime", typeof(int)));
string strURI = "";
foreach (DataRow dr in dtAppTrace.Rows)
{
strURI = dr["URI"].ToString();
if (strURI.Length >= 128)
{
strURI = strURI.Substring(0, 127);
}
//dtApps.Rows.Add(iServerNumber, dr["TimeIn"].ToString(), dr["AlertRecordID"].ToString(), dr["ReasonCode"].ToString(), strURI, dr["ClientLocation"].ToString(), Convert.ToInt32(dr["RunningTime"].ToString()));
dtApps.Rows.Add(iServerNumber, Convert.ToDateTime(dr["TimeIn"]).ToString("yyyy-MM-dd HH:mm:ss"),
dr["AlertRecordID"].ToString(), dr["ReasonCode"].ToString(), strURI, dr["ClientLocation"].ToString(), Convert.ToInt32(dr["RunningTime"].ToString()));
}
//int iResult = wsInsert.InsertSPValues("p_tbAppTrace_Add", DataTableToBytes(dtParms), DataTableToBytes(dtApps));
int iResult = wsInsert.ApptraceInsert(DataTableToBytes(dtApps), iServerNumber, g_dtTimeIn.ToString("yyyy-MM-dd HH:mm:ss"), g_dtTimeIn_UTC.ToString("yyyy-MM-dd HH:mm:ss"));
dtApps.Clear();
}
catch (Exception ex)
{
WSPEvent.WriteEvent("Service Point Agent has failed to insert list of running applications of WEB. - " + ex.Message, "E", 1173);
}
}
