public void InsertZorgmomenten(ZorgmomentRecord record)
{
Database db = new Database(context);
var check = db.CheckRecord(record.id.ToString(), "zorgmoment");
var conn = new SqliteConnection(connectionString);
conn.Open();
var cmd = conn.CreateCommand();
if (check)
{
cmd.CommandText = "UPDATE zorgmoment " +
$"SET client_id = {record.client_id}, datum_tijd = '{record.datum_tijd}', opmerkingen = '{record.opmerkingen}', aanwezigheid_begin = '{record.aanwezigheid_begin}', aanwezigheid_eind = '{record.aanwezigheid_eind}' " +
$"WHERE id = {record.id}";
}
else
{
cmd.CommandText = "INSERT INTO zorgmoment (id, client_id, datum_tijd, opmerkingen, aanwezigheid_begin, aanwezigheid_eind, nieuw) " +
$"VALUES ({record.id}, {record.client_id}, '{record.datum_tijd}', '{record.opmerkingen}', '{record.aanwezigheid_begin}', '{record.aanwezigheid_eind}', 1)";
}
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
conn.Close();
}
protected void OnListItemClick(object sender, AdapterView.ItemClickEventArgs e)
{
var moment = momentRecords[e.Position];
ZorgmomentRecord moment_record = dbz.GetZorgmomentById(moment.id);
Global.zorgmoment = moment_record;
StartActivity(typeof(DetailTaken));
}
public ZorgmomentRecord GetZorgmomentById(string id)
{
var conn = new SqliteConnection(connectionString);
conn.Open();
var cmd = conn.CreateCommand();
cmd.CommandText = $"SELECT * FROM zorgmoment WHERE id = {id}";
cmd.CommandType = CommandType.Text;
SqliteDataReader reader = cmd.ExecuteReader();
ZorgmomentRecord record = new ZorgmomentRecord(reader);
conn.Close();
return(record);
}
public void UpdatePresence(object sender, EventArgs e)
{
DatabaseZorgmoment dbz = new DatabaseZorgmoment(context);
DateTime utc = DateTime.UtcNow;
TimeZoneInfo west = TimeZoneInfo.FindSystemTimeZoneById("Europe/Amsterdam");
DateTime tijdstip = TimeZoneInfo.ConvertTimeFromUtc(utc, west);
if (zorgmoment.aanwezigheid_begin != "" && zorgmoment.aanwezigheid_eind == "")
{
new AlertDialog.Builder(context)
.SetTitle("Afmelden")
.SetMessage("Wilt u zich afmelden bij deze cliënt?")
.SetPositiveButton("Ja", (sender, args) =>
{
dbz.UpdateAanwezigheid(zorgmoment.id.ToString(), "eind", tijdstip.ToString());
ZorgmomentRecord moment_record = dbz.GetZorgmomentById(zorgmoment.id.ToString());
Global.zorgmoment = moment_record;
aanwezigheid.SetBackgroundColor(Color.ParseColor("#aa00ca"));
aanwezigheid.SetTextColor(Color.ParseColor("#FFFFFF"));
aanwezigheid.Text = res.GetString(Resource.String.aanwezigheid_uit);
})
.SetNegativeButton("Nee", (sender, args) => { })
.Show();
}
else if (zorgmoment.aanwezigheid_begin == "")
{
new AlertDialog.Builder(context)
.SetTitle("Aanmelden")
.SetMessage("Wilt u zich aanwezig melden bij deze cliënt?")
.SetPositiveButton("Ja", (sender, args) =>
{
dbz.UpdateAanwezigheid(zorgmoment.id.ToString(), "begin", tijdstip.ToString());
ZorgmomentRecord moment_record = dbz.GetZorgmomentById(zorgmoment.id.ToString());
Global.zorgmoment = moment_record;
aanwezigheid.SetBackgroundColor(Color.ParseColor("#00c000"));
aanwezigheid.Text = res.GetString(Resource.String.aanwezigheid_aan);
})
.SetNegativeButton("Nee", (sender, args) => { })
.Show();
}
}
public void DownloadData(string id)
{
var webClient = new WebClient()
{
Encoding = Encoding.UTF8
};
string personalisedUrl = url + id;
try
{
byte[] myDataBuffer = webClient.DownloadData(personalisedUrl);
string download = Encoding.ASCII.GetString(myDataBuffer);
JsonValue value = JsonValue.Parse(download);
foreach (JsonObject result in value)
{
DatabaseClient dbc = new DatabaseClient(context);
ClientRecord clientRecord = new ClientRecord(result);
dbc.InsertClientData(clientRecord);
DatabaseZorgmoment dbz = new DatabaseZorgmoment(context);
ZorgmomentRecord momentRecord = new ZorgmomentRecord(result);
dbz.InsertZorgmomenten(momentRecord);
DatabaseTaak dbt = new DatabaseTaak(context);
foreach (JsonObject taak in result["taken"])
{
TaakRecord taakRecord = new TaakRecord(taak);
dbt.InsertTaken(taakRecord);
}
}
}
catch (WebException e)
{
Console.WriteLine("exception: " + e.Message);
}
}
public ArrayList GetAllZorgmomenten()
{
var conn = new SqliteConnection(connectionString);
conn.Open();
var cmd = conn.CreateCommand();
cmd.CommandText = "SELECT * FROM zorgmoment ORDER BY datum_tijd ASC";
cmd.CommandType = CommandType.Text;
SqliteDataReader reader = cmd.ExecuteReader();
ArrayList momentRecords = new ArrayList();
while (reader.Read())
{
ZorgmomentRecord row = new ZorgmomentRecord(reader);
momentRecords.Add(row);
}
conn.Close();
return(momentRecords);
}
public PresentButtonAdapter(Activity context)
{
this.context = context;
zorgmoment = Global.zorgmoment;
res = context.Resources;
}
