protected void Button1_Click(object sender, EventArgs e)
{
// Lets put the secret sync row in the table only if its not present
DataClassesDataContext db = new DataClassesDataContext();
var query = (from g in db.sync_settings
where g.sync_job_id == Constants.AppSyncRowKey
select g).FirstOrDefault();
if (query == null)
{
sync_setting startRow = new sync_setting();
startRow.sync_job_id = Constants.AppSyncRowKey;
startRow.sync_status = Constants.SyncNotStarted;
startRow.sync_frequency_hours = Constants.SyncFrequency;
startRow.sync_server_name = this.Server.MachineName;
startRow.sync_timestamp = DateTime.MinValue;
db.GetTable<sync_setting>().InsertOnSubmit(startRow);
db.SubmitChanges();
}
}
public static WalkLogModel Fetch(int id)
{
DataClassesDataContext db = new DataClassesDataContext();
walk_log t;
var query = (from g in db.walk_logs
where g.log_user == id
select g);
if (query.ToList().Count == 0)
{
t = new walk_log();
t.log_user = id;
db.GetTable<walk_log>().InsertOnSubmit(t);
}
else
{
t = query.First();
}
WalkLogModel p = new WalkLogModel(t);
return p;
}
public static void Save(int userId, DateTime date,
long steps, long aerobicSteps)
{
DataClassesDataContext db = new DataClassesDataContext();
walk_log t = new walk_log();
t.log_user = userId;
t.log_date = date;
t.log_steps = steps;
t.log_aerobicsteps = aerobicSteps;
db.GetTable<walk_log>().InsertOnSubmit(t);
db.SubmitChanges();
}
public static void Insert(walk_log t)
{
DataClassesDataContext db = new DataClassesDataContext();
t.updated_at = DateTime.Now;
db.GetTable<walk_log>().InsertOnSubmit(t);
db.SubmitChanges();
}
