public void End(WorkPeriodEnd Work)
 {
     using (IDbConnection dbConnection = Connection)
     {
         string sQuery = "INSERT INTO  WorkPeriodEnd (ID,WPEnd)"
                         + " VALUES(@id,@WPEnd)";
         dbConnection.Open();
         dbConnection.Execute(sQuery, Work);
     }
 }
 public void Update(WorkPeriodEnd Work)
 {
     using (IDbConnection dbConnection = Connection)
     {
         string sQuery = " UPDATE Category SET WorkPeriodStart = @WPStart,"
                         + " Status = @Status"
                         + " WHERE Id = @Id";
         dbConnection.Open();
         dbConnection.Execute(sQuery, Work);
     }
 }