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