Esempio n. 1
0
        // 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;
        }
Esempio n. 2
0
        //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;
        }