public static TraceWrapperBase Create(ConnectionInfo connection)
{
string prefix="ConnectionInfoExtended";
foreach (string Extended in ConfigurationManager.AppSettings.AllKeys
.Where(key => key.StartsWith(prefix))
.ToArray())
{
connection[Extended.Substring(prefix.Length, Extended.Length - prefix.Length)] = ConfigurationManager.AppSettings[Extended];
}
//string dataBase = ConfigurationManager.AppSettings["DataBase"];
//if (!string.IsNullOrEmpty(dataBase)) connection.DataBase = dataBase;
//string sourceTable = ConfigurationManager.AppSettings["SourceTable"];
//if (!string.IsNullOrEmpty(sourceTable)) connection.SourceTable = sourceTable;
string traceWrapperType = ConfigurationManager.AppSettings["TraceWrapperBase"];
if (!string.IsNullOrEmpty(traceWrapperType))
{
Type type = ReflectionUtil.CreateType(traceWrapperType);
return (TraceWrapperBase)Activator.CreateInstance(type, new object[] { connection });
}
else
{
return new TraceWrapperTraceServer(connection);
}
}
public BenchmarkResult(ConnectionInfo connection, DataTable tableWeight, DataTable operationWeight)
{
this.connectionInfo = connection;
this.tableWeight = GetDictionaryFromTable(tableWeight);
this.operationWeight = GetDictionaryFromTable(operationWeight);
List<IResultHandler> handlers = new List<IResultHandler>();
handlers.Add(handler);
traceDB = new TraceWrapperSQLDB(connectionInfo, handlers);
traceDB.ProgressUpdated +=new TraceWrapperProgressBase.ProgressUpdateDele(traceDB_ProgressUpdated);
traceDB.OnStateChanged += new StateChangeNotifierDele(traceDB_OnStateChanged);
}
private void button_start_Click(object sender, EventArgs e)
{
if (this.trace == null || this.trace.State == TraceState.NotInitiated || this.trace.State == TraceState.Stopped)
{
ConnectionInfo connectioninfo = new ConnectionInfo();
connectioninfo.ServerName = textBox_server.Text;
connectioninfo.UseIntegratedSecurity = checkBox_useintegratedsecrity.Checked;
if (!connectioninfo.UseIntegratedSecurity)
{
connectioninfo.UserName = textBox_user.Text;
connectioninfo.Password = textBox_password.Text;
}
try
{
trace = TraceWrapperFactory.Create(connectioninfo);
if (checkBox_Interval.Checked) trace.Interval = new TimeSpan(0,Convert.ToInt32(textBox_Interval.Text),0);
tabControl1.TabPages.Clear();
dgdic.Clear();
foreach (IResultHandler handler in trace.Handlers)
{
handler.OnResultChange += new ResultEventHandler(trace_TraceEventHandler);
TabPage tabpage = new TabPage(handler.GetType().Name);
DataGridView dg = new DataGridView();
dg.MouseDown += new MouseEventHandler(dg_MouseDown);
dg.AllowUserToAddRows = false;
dg.Name= "dg"+handler.GetType().Name;
dg.Dock = DockStyle.Fill;
tabpage.Controls.Add(dg);
tabControl1.TabPages.Add(tabpage);
dgdic.Add(handler.GetType().Name, dg);
}
trace.Start();
this.toolStripStatusLabel1.Text = "started";
}
catch (Exception ex)
{
this.toolStripStatusLabel1.Text = ex.Message;
return;
}
}
//button_pause.Enabled = true;
button_stop.Enabled = true;
button_start.Enabled = false;
}
public TraceWrapperTraceServer(ConnectionInfo connectionInfo, List<IResultHandler> handlers = null)
: base(handlers)
{
this.connectionInfo = FromConnectionInfo(connectionInfo);
TraceDefinitionFile.SaveAsTDF("mytrace.tdf");
traceDefinitionFile = "mytrace.tdf";
this.State = TraceState.NotInitiated;
this.backWorker.WorkerReportsProgress = true;
this.backWorker.WorkerSupportsCancellation = true;
this.backWorker.ProgressChanged += new ProgressChangedEventHandler(backWorker_ProgressChanged);
this.backWorker.DoWork += new DoWorkEventHandler(backWorker_DoWork);
}
public static DataTable CreateTableWeight(ConnectionInfo connectioninfo)
{
//DataSet ds = new DataSet("TableWeight");
DataTable casinolink = new DataTable("TableWeight");
casinolink.Columns.Add("Table");
casinolink.Columns.Add("Weight",typeof(decimal));
SqlConnection sqlconnection = new SqlConnection();
try
{
sqlconnection.ConnectionString = connectioninfo.AsConnectionString;
sqlconnection.Open();
string sqlstr = "select Name from dbo.sysobjects where OBJECTPROPERTY(id,N'IsUserTable')=1";
SqlCommand command = sqlconnection.CreateCommand();
command.CommandText = sqlstr;
SqlDataAdapter adapter = new SqlDataAdapter(command);
DataTable dt = new DataTable();
adapter.Fill(dt);
foreach (DataRow tabledr in dt.Rows)
{
string tablename = tabledr[0].ToString();
SqlCommand commands = sqlconnection.CreateCommand();
commands.CommandText = "select count(*) from "+tablename;
int count= (int)commands.ExecuteScalar();
casinolink.Rows.Add(new object[] {tablename,count });
}
return casinolink;
}
catch (Exception)
{
}
finally
{
sqlconnection.Close();
}
//casinolink.Rows.Add(new object[] { "PatronPoint",1});
//casinolink.Rows.Add(new object[] { "PatronPointDetail", 1.5 });
//casinolink.Rows.Add(new object[] { "PatronPointPending", 0.01 });
//casinolink.Rows.Add(new object[] { "PatronPointPlayDailyUsed", 0.1 });
return casinolink;
}
public TraceWrapperSMO(ConnectionInfo connectionInfo, List<IResultHandler> handlers = null)
: base(handlers)
{
server = new Server(connectionInfo.ServerName);
eventSetServer = new ServerTraceEventSet(ServerTraceEvent.LockDeadlock,
ServerTraceEvent.LockDeadlockChain,
ServerTraceEvent.DeadlockGraph);
//TraceDefinitionFile to eventSetServer
//eventSetServer = new ServerTraceEventSet();
//foreach (PropertyInfo pi in typeof(ServerTraceEvent).GetProperties())
//{
// if (pi.PropertyType == typeof(ServerTraceEvent))
// {
// eventSetServer.Add((ServerTraceEvent)pi.GetValue(null, null));
// }
//}
}
public TraceWrapperSQLDB(ConnectionInfo connectionInfo, List<IResultHandler> handlers = null)
: base(handlers)
{
this.traceTable = connectionInfo.SourceTable;
this.connection = new SqlConnection(connectionInfo.AsConnectionString);
}
private void LoadSettings(ConnectionInfo connectionInfo)
{
this.traceTable = connectionInfo["SourceTable"];
this.traceTableCriteria = connectionInfo["Criteria"];
this.connection = new SqlConnection(connectionInfo.AsConnectionString);
}
public TraceWrapperSQLDB(ConnectionInfo connectionInfo, List<IResultHandler> handlers)
: base(handlers)
{
LoadSettings(connectionInfo);
}
public TraceWrapperSQLDB(ConnectionInfo connectionInfo)
: base(null)
{
LoadSettings(connectionInfo);
}
public TraceWrapperServerSide(ConnectionInfo connectionInfo,string servertrcfile, List<IResultHandler> handlers = null)
: base(handlers)
{
fileTRC = servertrcfile;
this.connectionInfo = connectionInfo;
}
private void button1_Click(object sender, EventArgs e)
{
DataTable operationWeight = new DataTable();
operationWeight.ReadXml("OperationWeight.xml");
DataTable tableWeight = new DataTable();
tableWeight.ReadXml("TableWeight.xml");
ConnectionInfo connection = new ConnectionInfo();
connection.ServerName = textBox_server.Text;
connection.UserName = textBox_user.Text;
connection["DataBase"] = textBox_database.Text;
connection.Password = textBox_password.Text;
connection.UseIntegratedSecurity = checkBox_useintegratedsecrity.Checked;
connection["SourceTable"] = textBox_table.Text;
connection["Criteria"] = textBox_Criteria.Text;
excelname = textBox_excel.Text;
label = textBox_label.Text;
BenchmarkResult.BenchmarkResult br = new BenchmarkResult.BenchmarkResult(connection, tableWeight, operationWeight);
br.ProgressUpdated += new BenchmarkResult.BenchmarkResult.progressdele(br_ProgressUpdated);
br.ResultUpdated += new BenchmarkResult.BenchmarkResult.resultdele(br_ResultUpdated);
br.Start();
//Dictionary<string, decimal> result = br.GetResult();
//using (ExcelHelper.ExcelHelper excelHelper = new ExcelHelper.ExcelHelper(textBox_excel.Text))
//{
// excelHelper.Append(textBox_label.Text, result);
//}
}
protected virtual SqlConnectionInfo FromConnectionInfo(ConnectionInfo info)
{
SqlConnectionInfo connectionInfo = new SqlConnectionInfo();
connectionInfo.ServerName = info.ServerName;
connectionInfo.UseIntegratedSecurity = info.UseIntegratedSecurity;
if (!connectionInfo.UseIntegratedSecurity)
{
connectionInfo.UserName = info.UserName;
connectionInfo.Password = info.Password;
}
return connectionInfo;
}
