/// <summary> /// classify the activity update the dictionary and write into the database again /// </summary> public void classify() { int counter = 0; foreach (DataRow row in ds.Tables[0].Rows) { counter++; Console.Write(counter + " "); for (int i = 0; i < 3; i++) { Console.Write(row[i].ToString() + " "); } Console.WriteLine(); Duration du = new Duration() { TimeStamp = Convert.ToDateTime(row[0].ToString()), Activity_id = row[1].ToString(), Activity_duration = row[2].ToString(), }; if (Activity_Dic.ContainsKey(du.Activity_id)) { Activity_Dic[du.Activity_id]++; } else { Activity_Dic.Add(du.Activity_id, 1); } ////Embedded em = new Embedded() ////{ //// TimeStamp=Convert.ToDateTime(row[0].ToString()), //// Item1=row[1].ToString(), //// Item2=row[2].ToString() ////}; using (Week8Container w8c = new Week8Container()) { w8c.DurationSet.AddObject(du); //w8c.EmbeddedSet.AddObject(em); w8c.SaveChanges(); } } using (Week8Container w8c = new Week8Container()) { totalEventNumber = w8c.DurationSet.Count(); } }
/// <summary> /// classify the activity update the dictionary and write into the database again /// </summary> public void classify() { int counter = 0; foreach (DataRow row in ds[0].Tables[0].Rows) { counter++; Console.Write(counter + " "); for (int i = 0; i < 3; i++) { Console.Write(row[i].ToString() + " "); } Console.WriteLine(); Duration du = new Duration() { TimeStamp = Convert.ToDateTime(row[0].ToString()), Activity_id = row[1].ToString(), Activity_duration = row[2].ToString(), }; if (Activity_Dic.ContainsKey(du.Activity_id)) { Activity_Dic[du.Activity_id]++; } else { Activity_Dic.Add(du.Activity_id, 1); } using (Week8Container w8c = new Week8Container()) { w8c.DurationSet.AddObject(du); w8c.SaveChanges(); } } Console.Write("☆☆☆☆☆☆☆First Table:DurationSet Import into database done☆☆☆☆☆☆☆"); foreach (DataRow row in ds[1].Tables[0].Rows) { Embedded em = new Embedded() { TimeStamp = Convert.ToDateTime(row[0].ToString()), Item1 = row[1].ToString(), Item2 = row[2].ToString() }; using (Week8Container w8c = new Week8Container()) { w8c.EmbeddedSet.AddObject(em); w8c.SaveChanges(); } } Console.Write("☆☆☆☆☆☆☆Second Table:EmbeddedSet Import into database done☆☆☆☆☆☆☆"); foreach (DataRow row in ds[2].Tables[0].Rows)//////////////// { Triplets tr = new Triplets() { TimeStamp = Convert.ToDateTime(row[0].ToString()), Subject = row[1].ToString(), Verb = row[2].ToString(), Object=row[3].ToString() }; using (Week8Container w8c = new Week8Container()) { w8c.TripletsSet.AddObject(tr); w8c.SaveChanges(); } } Console.Write("☆☆☆☆☆☆☆Third Table:TripletsSet Import into database done☆☆☆☆☆☆☆"); using (Week8Container w8c = new Week8Container()) { totalEventNumber = w8c.DurationSet.Count(); } }
private void Clean_DB_Table() { //清空DurationSet表 using (Week8Container container = new Week8Container()) { var result=from needTODelete in container.DurationSet select needTODelete; if (result.Count() > 0) { foreach (var item in result) { container.DurationSet.DeleteObject(item); } } container.SaveChanges(); } Console.WriteLine("Database Table DurationSet is cleaned"); //清空EmbeddedSet表 using (Week8Container container = new Week8Container()) { var result = from needTODelete in container.EmbeddedSet select needTODelete; if (result.Count() > 0) { foreach (var item in result) { container.EmbeddedSet.DeleteObject(item); } } container.SaveChanges(); } Console.WriteLine("Database Table EmbeddedSet is cleaned"); //清空TripletsSet表 using (Week8Container container = new Week8Container()) { var result = from needTODelete in container.TripletsSet select needTODelete; if (result.Count() > 0) { foreach (var item in result) { container.TripletsSet.DeleteObject(item); } } container.SaveChanges(); } Console.WriteLine("Database Table TripletsSet is cleaned"); }
/// <summary> /// show total activity number /// </summary> public void Show_TotalActivityNumber() { using (Week8Container container = new Week8Container()) { Console.WriteLine("Total event Number is" + container.DurationSet.Count()); } }
private void Clean_DB_Table() { using (Week8Container container = new Week8Container()) { var result=from needTODelete in container.DurationSet select needTODelete; if (result.Count() > 0) { foreach (var item in result) { container.DurationSet.DeleteObject(item); } } container.SaveChanges(); } }