// gets info from checkin entry and saves new time entry to database
public void checkout(object sender, EventArgs e)
{
TimeOut = DateTime.Now.TimeOfDay;
using (SQLite.SQLiteConnection conn = new SQLite.SQLiteConnection(App.DB_Path))
{
CheckinEntry checkinInfo = conn.Table <CheckinEntry>().ToList()[0];
TimeIn = TimeSpan.FromHours(checkinInfo.hrs);
DateTime checkindate = DateTime.Now;
if (TimeIn.CompareTo(TimeOut) == 1)
{
checkindate = DateTime.Today.AddDays(-1);
}
TimeEntry te = new TimeEntry(checkindate, TimeIn, TimeOut, checkinInfo.comment);
te.Type = checkinInfo.type;
conn.CreateTable <TimeEntry>();
conn.Insert(te);
conn.DropTable <CheckinEntry>();
}
check_out.IsEnabled = false;
check_in.IsEnabled = true;
}
//sets checkin entry in preparation for saving a time entry to the database
//inserts a soll entry to the database (overwrites if one already exists on that day)
public void checkin(object sender, EventArgs e)
{
var ce = new CheckinEntry(DateTime.Now.TimeOfDay);
ce.comment = comment.Text;
string check = type.SelectedItem.ToString(); // save
switch (check) // save
{
case "Notfall":
ce.type = "NF";
break;
case "Meeting":
ce.type = "M";
break;
case "Wiiterbildig":
ce.type = "WB";
break;
default:
ce.type = " ";
break;
}
var se = new SollEntry(SollZeit.Time, DateTime.Now);
using (SQLite.SQLiteConnection conn = new SQLite.SQLiteConnection(App.DB_Path))
{
conn.CreateTable <CheckinEntry>();
conn.InsertOrReplace(ce);
conn.CreateTable <SollEntry>();
conn.InsertOrReplace(se);
}
check_out.IsEnabled = true;
check_in.IsEnabled = false;
}