/****************************************************************
* Public Functionalities
**/
public void AddActivities(ActivityDataDoc p_data)
{
if (p_data == null)
{
return;
}
if (p_data.data == null)
{
return;
}
if (p_data.data.Count == 0)
{
return;
}
List <ActivityDataRow> unitData = (List <ActivityDataRow>)p_data.data;
foreach (ActivityDataRow row in unitData)
{
Kreyos_User_Activities act = new Kreyos_User_Activities();
act.UpdateFromRow(row);
this.AddActivity(act);
}
this.Save();
}
//~~~insert new activity
public void InsertActivity(Kreyos_User_Activities p_activity)
{
using (var dbConn = new SQLiteConnection(this.KreyosDBPath))
{
dbConn.RunInTransaction(() =>
{
dbConn.Insert(p_activity);
});
}
}
//~~~update existing activity
public void UpdateActivity(Kreyos_User_Activities p_activity)
{
using (var dbConn = new SQLiteConnection(this.KreyosDBPath))
{
var existingActivity = dbConn.Query <Kreyos_User_Activities>("select * from Kreyos_User_Activities where CreatedTime =" + p_activity.CreatedTime).FirstOrDefault();
if (existingActivity != null)
{
existingActivity.Update(p_activity);
dbConn.RunInTransaction(() =>
{
dbConn.Update(existingActivity);
});
}
}
}
public void AddActivity(Kreyos_User_Activities p_act)
{
m_userActivities.Add(p_act);
}
