static void UseStopwatch(MyWatch quiz2, string command)
{
switch (command)
{
case "start":
try
{
quiz2.Start();
}
catch (InvalidOperationException)
{
Console.WriteLine("stopWatch is already started\n");
}
break;
case "stop":
try
{
quiz2.Stop();
Console.WriteLine("Duration: {0}\n", quiz2.GetDuration());
}
catch (InvalidOperationException)
{
Console.WriteLine("stopWatch is not started\n");
}
break;
default:
break;
}
}
public void ReadFile2DB(long iterations = 10, int progressLength = 20) //to do multiple versions
{
MyDataBase dtb = new MyDataBase();
var db = dtb.db;
var Cols = db.Tables[0].Columns.Cast <DataColumn>().Where(x => x.ColumnName != "id").Select(y => y.ColumnName).ToList();
//var Cols = (from dc in db.DataTable1.Columns.Cast<DataColumn>()
// where dc.ColumnName != "id"
// select dc.ColumnName).ToList();
//Cols.ForEach(Console.WriteLine);
string line;
MyWatch t = new MyWatch();
using (StreamReader sr = new StreamReader(myFn))
{
int i = 1;
MyProgBar progressBar = new MyProgBar(iterations, progressLength);
progressBar.Init();
while ((line = sr.ReadLine()) != null)
{
progressBar.Step(i++);
List <string> newDataRow = line.Split(',').Take(6).ToList();
newDataRow = newDataRow.Select(s => s.Replace('.', ',')).ToList(); //Double
DataRow dr = db.Tables[0].NewRow();
Cols.ForEach(x => dr[x.ToString()] = newDataRow[Cols.IndexOf(x.ToString())]);
db.Tables[0].Rows.Add(dr);
}
}
t.StopAndPrint();
}
public bool PutWatch(MyWatch W)
{
if (User.Identity.IsAuthenticated)
{
var wtc = (from w in db.Watches.Where(n => (n.ClaimedIdentifier == User.Identity.Name) && (n.Name == W.Name))
select w).FirstOrDefault();
if (wtc == null)
{
db.Watches.AddObject(new Models.Watch { ClaimedIdentifier = User.Identity.Name, Name = W.Name });
db.SaveChanges();
return true;
}
else
{
db.Watches.DeleteObject(wtc);
db.SaveChanges();
return false;
}
}
else
{
throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.Unauthorized));
}
}
static public DataTable getTable()
{
DataTable dt = new DataTable();
try {
dt.Columns.Add("key");
dt.Columns.Add("per");
dt.Columns.Add("total");
dt.Columns.Add("avarage");
dt.Columns.Add("min");
dt.Columns.Add("max");
dt.Columns.Add("last");
dt.Columns.Add("merges");
dt.Columns.Add("count");
Dictionary <string, MyWatch> ret = new Dictionary <string, MyWatch>();
lock (watches) {
List <string> keys = watches.Keys.ToList();
keys.Sort();
foreach (string key in keys)
{
if (key == null)
{
continue;
}
MyWatch entry = watches[key];
string mainkey = key.Split('|')[0];
if (!ret.ContainsKey(mainkey))
{
ret.Add(mainkey, new MyWatch());
}
ret[mainkey].merge(entry);
}
}
TimeSpan tot = DateTime.UtcNow - Start;
foreach (KeyValuePair <string, MyWatch> ent in ret)
{
DataRow dr = dt.NewRow();
dr["key"] = ent.Key;
dr["per"] = string.Format("{0:0.0%}", ent.Value.Total.TotalSeconds / tot.TotalSeconds);
dr["total"] = formatTimeSpan(ent.Value.Total);
dr["avarage"] = formatTimeSpan(ent.Value.Avarage_ms);
dr["count"] = string.Format("{0:n0}", ent.Value.Count);
dr["min"] = formatTimeSpan(ent.Value.Min);
dr["max"] = formatTimeSpan(ent.Value.Max);
dr["last"] = formatTimeSpan(ent.Value.Last);
dr["merges"] = string.Format("{0:n0}", ent.Value.CountMerges);
dt.Rows.Add(dr);
}
} catch (Exception ex) {
Logging.logException("", ex);
}
return(dt);
}
public void DataTable1()
{
DataTable dt = null;
for (int i = 0; i < 1; i++)
{
string sql = " select top 1111 * from companyinfo ";
dt = nda.ExecuteDataTable(sql);
foreach (DataRow dr in dt.Rows)
{
// Console.WriteLine(dr[4]);
}
}
MyWatch sp = new MyWatch();
sp.Start();
// List<Company> list = nda.GetEntityList<Company>(dt);
sp.End();
}
public void merge(MyWatch ow)
{
this.count += ow.count;
if (ow.min < this.min)
{
this.min = ow.min;
}
if (ow.max > this.max)
{
this.max = ow.max;
}
this.Elapsed = this.Elapsed.Add(ow.Elapsed);
if (ow.lastStop > this.lastStop)
{
this.last = ow.last;
}
this.CountMerges++;
}
public void DataTable1()
{
DataTable dt = null;
for (int i = 0; i < 1; i++)
{
string sql = " select top 1111 * from companyinfo ";
dt = nda.ExecuteDataTable(sql);
foreach (DataRow dr in dt.Rows)
{
// Console.WriteLine(dr[4]);
}
}
MyWatch sp = new MyWatch();
sp.Start();
// List<Company> list = nda.GetEntityList<Company>(dt);
sp.End();
}
public void Write2File(long iterations = 10, int progLength = 20)
{
MyWatch t = new MyWatch();
GenerateCSV generateCSV = new GenerateCSV();
t.Start();
using (StreamWriter sw = new StreamWriter(myFn))
{
string line;
MyProgBar progressBar = new MyProgBar(iterations, progLength);
progressBar.Init();
for (int i = 1; i <= iterations; i++)
{
progressBar.Step(i);
line = generateCSV.GenerateLine();
sw.WriteLine(line);
}
}
t.StopAndPrint();
}
