C# (CSharp) TimeRecorder.Repository.SQLite.Tracking.Dao WorkingTimeTableRow Examples

Example #1

File: WorkingTimeDao.cs Project: visionarylab/TimeRecorder

        public int Insert(WorkingTimeTableRow row)
        {
            #region SQL
            const string sql = @"
INSERT INTO 
  workingtimes
(
  taskid
  , ymd
  , starttime
  , endtime
)
values
(
  @taskid
  , @ymd
  , @starttime
  , @endtime
)
";
            #endregion

            Connection.Execute(sql, row, Transaction);

            return((int)Connection.LastInsertRowId);
        }

Example #2

File: WorkingTimeDao.cs Project: visionarylab/TimeRecorder

        public void Update(WorkingTimeTableRow row)
        {
            #region SQL
            const string sql = @"
UPDATE
  workingtimes
SET
  taskid = @taskid
  , ymd = @ymd
  , starttime = @starttime
  , endtime = @endtime
WHERE
  id = @id
";
            #endregion

            Connection.Execute(sql, row, Transaction);
        }