public bool UpdateSystemAspectsandMeetingStartTime(int firstConnectionTime)
{
try
{
WMIStuff.SystemInformationClass sysinfo = new WMIStuff.SystemInformationClass();
/*load System Information*/
sysinfo.ExtractSysInformation();
string strQuery = "Update ctool_applicationlogging set ";
startTickCount = System.Environment.TickCount;
string strQueryPostFix = " where id=" + RecordID.ToString() + ";";
/*
* `applog_processor` text COMMENT 'this filed contain processor name of client sytem',
* `applog_ram` int(1) default NULL COMMENT 'this field contain the ram of client machine',
* `applog_ipaddress` text COMMENT 'this field contain the ip address of the client',
* `applog_systemdrive` text COMMENT 'this field contain the System drive of the client',
* `applog_appinstallationpath` text COMMENT 'this field contains the installation path',
* `applog_disconnection` int(4) default '0' COMMENT 'this field tell about client disconnection in a meeting',
* `applog_virtualmemory` text COMMENT 'this field contain the total virtual memory of the system',
* `applog_clr` text COMMENT 'this field contain the .Net framwork version',
* `applog_os` text COMMENT 'this field contain the operating system of client',
* `applog_servicepack` text COMMENT 'this field contains the service pack of client machine.',
* `applog_meetstarttime` int(4) default NULL COMMENT 'this filed contains the meeting start time',
* `applog_meetendtime` int(4) default NULL COMMENT 'this field contains the meeting end time',
* `applog_applicationversion` text COMMENT 'this filed contains the application version',
* `applog_companyid` int(4) default NULL COMMENT 'this field contains the company id',
* `applog_browseruseragent` text COMMENT 'this field contains the browser agent of client',
* `applog_firstconnectiontime` int(4) default NULL COMMENT 'this field contain the first connection time in milliseconds',
* `applog_otherdata` text COMMENT 'this field contains the other data like Antivirus, firewall',
* `applog_applicationName` text COMMENT 'this field is contain app name like webmeeting..for future',
* `meetingid` int(4) default NULL,
* `joiningDate`
* */
strQuery += " applog_processor='" + sysinfo.sysinfo.strProcessorName + "',";
strQuery += "applog_ram=" + sysinfo.sysinfo.nPhysicalRam.ToString() + ",";
strQuery += "applog_appinstallationpath='" + Application.StartupPath + "',";
strQuery += "applog_virtualmemory=" + sysinfo.sysinfo.nTotalVirtualMemory + ",";
strQuery += "applog_clr='" + System.Environment.Version.ToString() + "',";
strQuery += "applog_os='" + sysinfo.sysinfo.strOperatingSystem + "',";
strQuery += "applog_servicepack='" + sysinfo.sysinfo.strOperatingSystemPack + "',";
strQuery += "applog_applicationversion='" + Application.ProductVersion + "',";
strQuery += "applog_firstconnectiontime=" + firstConnectionTime.ToString() + ",";
strQuery += "applog_applicationName='Webmeeting',";
strQuery += "applog_meetstarttime=" + Convert.ToString((this.startTickCount / 1000) / 60);
strQuery = strQuery + strQueryPostFix;
if (WSlogService.LogRecord(strQuery) == "1")
{
return(true);
}
}
catch (Exception ex)
{
Client.ClientUI.getInstance().ExceptionLog(" Stack Trace :: " + ex.StackTrace + " Source :: " + ex.Source + " Message::: " + ex.Message);
}
return(false);
}
public bool UpdateSystemAspectsandMeetingStartTime(int firstConnectionTime)
{
try
{
WMIStuff.SystemInformationClass sysinfo=new WMIStuff.SystemInformationClass();
/*load System Information*/
sysinfo.ExtractSysInformation();
string strQuery="Update ctool_applicationlogging set ";
startTickCount=System.Environment.TickCount;
string strQueryPostFix=" where id=" + RecordID.ToString()+";";
/*
* `applog_processor` text COMMENT 'this filed contain processor name of client sytem',
`applog_ram` int(1) default NULL COMMENT 'this field contain the ram of client machine',
`applog_ipaddress` text COMMENT 'this field contain the ip address of the client',
`applog_systemdrive` text COMMENT 'this field contain the System drive of the client',
`applog_appinstallationpath` text COMMENT 'this field contains the installation path',
`applog_disconnection` int(4) default '0' COMMENT 'this field tell about client disconnection in a meeting',
`applog_virtualmemory` text COMMENT 'this field contain the total virtual memory of the system',
`applog_clr` text COMMENT 'this field contain the .Net framwork version',
`applog_os` text COMMENT 'this field contain the operating system of client',
`applog_servicepack` text COMMENT 'this field contains the service pack of client machine.',
`applog_meetstarttime` int(4) default NULL COMMENT 'this filed contains the meeting start time',
`applog_meetendtime` int(4) default NULL COMMENT 'this field contains the meeting end time',
`applog_applicationversion` text COMMENT 'this filed contains the application version',
`applog_companyid` int(4) default NULL COMMENT 'this field contains the company id',
`applog_browseruseragent` text COMMENT 'this field contains the browser agent of client',
`applog_firstconnectiontime` int(4) default NULL COMMENT 'this field contain the first connection time in milliseconds',
`applog_otherdata` text COMMENT 'this field contains the other data like Antivirus, firewall',
`applog_applicationName` text COMMENT 'this field is contain app name like webmeeting..for future',
`meetingid` int(4) default NULL,
`joiningDate`
* */
strQuery+=" applog_processor='" + sysinfo.sysinfo.strProcessorName+"',";
strQuery+="applog_ram=" + sysinfo.sysinfo.nPhysicalRam.ToString()+ ",";
strQuery+="applog_appinstallationpath='" + Application.StartupPath + "',";
strQuery+="applog_virtualmemory=" + sysinfo.sysinfo.nTotalVirtualMemory+ ",";
strQuery+="applog_clr='"+System.Environment.Version.ToString()+"',";
strQuery+="applog_os='"+sysinfo.sysinfo.strOperatingSystem+"',";
strQuery+="applog_servicepack='"+sysinfo.sysinfo.strOperatingSystemPack+"',";
strQuery+="applog_applicationversion='"+Application.ProductVersion+"',";
strQuery+="applog_firstconnectiontime="+firstConnectionTime.ToString()+",";
strQuery+="applog_applicationName='Webmeeting',";
strQuery+="applog_meetstarttime="+Convert.ToString((this.startTickCount/1000)/60);
strQuery=strQuery+strQueryPostFix;
if(WSlogService.LogRecord(strQuery)=="1")
{
return true;
}
}
catch(Exception ex)
{
Client.ClientUI.getInstance().ExceptionLog(" Stack Trace :: " + ex.StackTrace + " Source :: "+ex.Source + " Message::: "+ex.Message);
}
return false;
}