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 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(); }