/// <summary>
/// 创建新的 Triplets 对象。
/// </summary>
/// <param name="id">Id 属性的初始值。</param>
/// <param name="timeStamp">TimeStamp 属性的初始值。</param>
/// <param name="subject">Subject 属性的初始值。</param>
/// <param name="verb">Verb 属性的初始值。</param>
/// <param name="object">Object 属性的初始值。</param>
public static Triplets CreateTriplets(global::System.Int32 id, global::System.DateTime timeStamp, global::System.String subject, global::System.String verb, global::System.String @object)
{
Triplets triplets = new Triplets();
triplets.Id = id;
triplets.TimeStamp = timeStamp;
triplets.Subject = subject;
triplets.Verb = verb;
triplets.Object = @object;
return triplets;
}
/// <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();
}
}
/// <summary>
/// 用于向 TripletsSet EntitySet 添加新对象的方法，已弃用。请考虑改用关联的 ObjectSet<T> 属性的 .Add 方法。
/// </summary>
public void AddToTripletsSet(Triplets triplets)
{
base.AddObject("TripletsSet", triplets);
}
