Esempi in C# (CSharp) per TimeRecorder.Repository.SQLite.Tracking.Dao WorkingHourTableRow

Esempio n. 1

File: WorkingHourDao.cs Progetto: visionarylab/TimeRecorder

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

            Connection.Execute(sql, row);
        }

Esempio n. 2

File: WorkingHourDao.cs Progetto: visionarylab/TimeRecorder

        public void Insert(WorkingHourTableRow row)
        {
            #region SQL
            const string sql = @"
INSERT INTO
  workinghours
(
  ymd
  , starttime
  , endtime
)
VALUES
(
  @ymd
  , @starttime
  , @endtime
)
";
            #endregion

            Connection.Execute(sql, row);
        }