ViewVC Help
View Directory | Revision Log | Download Tarball | View Changeset | Root Listing
root/AnywhereTS-MSSQL/trunk/TSAdminTool
Revision 149 - Directory Listing - [select for diffs]
Modified Sun Jul 15 11:21:36 2012 UTC (10 years, 10 months ago) by william
Diff to previous 148 (colored)

Revision 148 - Directory Listing - [select for diffs]
Modified Sun Jul 15 09:15:41 2012 UTC (10 years, 10 months ago) by william
Diff to previous 145 (colored)

Revision 145 - Directory Listing - [select for diffs]
Modified Sun Jul 15 08:34:18 2012 UTC (10 years, 10 months ago) by william
Diff to previous 141 (colored)
+ add installer classes (did not need to create new projects)

Revision 141 - Directory Listing - [select for diffs]
Modified Sun Jul 15 08:21:04 2012 UTC (10 years, 10 months ago) by william
Diff to previous 136 (colored)

Revision 136 - Directory Listing - [select for diffs]
Modified Sun Jul 15 08:14:41 2012 UTC (10 years, 10 months ago) by william
Diff to previous 135 (colored)
+ fix issues when creating tables on an empty database

Revision 135 - Directory Listing - [select for diffs]
Modified Sun Jul 15 05:58:56 2012 UTC (10 years, 10 months ago) by william
Diff to previous 134 (colored)
+ tables are created for an empty database

Revision 134 - Directory Listing - [select for diffs]
Modified Sun Jul 15 05:13:20 2012 UTC (10 years, 10 months ago) by william
Diff to previous 133 (colored)
+ fix errors in database
+ logon to 'master' database and refer to our database is sql statments
+ remove empty GO statements from end of .sql files

Revision 133 - Directory Listing - [select for diffs]
Modified Sun Jul 15 05:00:59 2012 UTC (10 years, 10 months ago) by william
Diff to previous 132 (colored)
+ wip to get rid of errors

Revision 132 - Directory Listing - [select for diffs]
Modified Sun Jul 15 03:09:38 2012 UTC (10 years, 10 months ago) by william
Diff to previous 131 (colored)

Revision 131 - Directory Listing - [select for diffs]
Modified Sun Jul 15 02:55:20 2012 UTC (10 years, 10 months ago) by william
Diff to previous 128 (colored)
+ move all database options to DatabaseLog (even if it comes from ATSAdmin.exe)

Revision 128 - Directory Listing - [select for diffs]
Modified Sat Jul 14 13:01:52 2012 UTC (10 years, 10 months ago) by william
Diff to previous 123 (colored)
+ fix RunScript ==> CommandType must be set to Text

Revision 123 - Directory Listing - [select for diffs]
Modified Sat Jul 14 11:14:09 2012 UTC (10 years, 10 months ago) by william
Diff to previous 121 (colored)
+ bulk commit
-- add SQLSerer SMO support for executing TSQL commands

Revision 121 - Directory Listing - [select for diffs]
Modified Sat Jul 14 09:40:33 2012 UTC (10 years, 10 months ago) by william
Diff to previous 120 (colored)
+ log context

Revision 120 - Directory Listing - [select for diffs]
Modified Sat Jul 14 09:39:59 2012 UTC (10 years, 10 months ago) by william
Diff to previous 119 (colored)
+ don't specigy filename or log paths in CREATE DATABASE (let SQL Server handle that)

Revision 119 - Directory Listing - [select for diffs]
Modified Sat Jul 14 09:08:55 2012 UTC (10 years, 10 months ago) by william
Diff to previous 118 (colored)
+ bulk commit again

Revision 118 - Directory Listing - [select for diffs]
Modified Sat Jul 14 09:08:21 2012 UTC (10 years, 10 months ago) by william
Diff to previous 116 (colored)
make sure to replace db name in scripts with current db name

Revision 116 - Directory Listing - [select for diffs]
Modified Sat Jul 14 08:03:33 2012 UTC (10 years, 10 months ago) by william
Diff to previous 113 (colored)
+ more logging work

Revision 113 - Directory Listing - [select for diffs]
Modified Sat Jul 14 07:18:30 2012 UTC (10 years, 10 months ago) by william
Diff to previous 112 (colored)
remove all calls to Logging.Initialize() outsite of the Logging class

Revision 112 - Directory Listing - [select for diffs]
Modified Sat Jul 14 07:14:59 2012 UTC (10 years, 10 months ago) by william
Diff to previous 111 (colored)
+ update to .NET Framework 4.0

Revision 111 - Directory Listing - [select for diffs]
Modified Sat Jul 14 07:07:25 2012 UTC (10 years, 10 months ago) by william
Diff to previous 110 (colored)
+ upgrade to VS2010

Revision 110 - Directory Listing - [select for diffs]
Modified Sat Jul 14 06:26:14 2012 UTC (10 years, 10 months ago) by william
Diff to previous 108 (colored)

Revision 108 - Directory Listing - [select for diffs]
Modified Sat Jul 14 06:25:40 2012 UTC (10 years, 10 months ago) by william
Diff to previous 107 (colored)

Revision 107 - Directory Listing - [select for diffs]
Modified Sat Jul 14 06:24:01 2012 UTC (10 years, 10 months ago) by william
Diff to previous 99 (colored)

Revision 99 - Directory Listing - [select for diffs]
Modified Sat Jul 14 04:50:27 2012 UTC (10 years, 10 months ago) by william
Diff to previous 98 (colored)
+ bulk commit

Revision 98 - Directory Listing - [select for diffs]
Modified Sat Jul 14 03:14:54 2012 UTC (10 years, 10 months ago) by william
Diff to previous 97 (colored)
+ more work

Revision 97 - Directory Listing - [select for diffs]
Modified Sat Jul 14 03:02:06 2012 UTC (10 years, 10 months ago) by william
Diff to previous 96 (colored)
+ alter context for Program.cs

Revision 96 - Directory Listing - [select for diffs]
Modified Sat Jul 14 03:01:07 2012 UTC (10 years, 10 months ago) by william
Diff to previous 94 (colored)
force initialize logging

Revision 94 - Directory Listing - [select for diffs]
Modified Sat Jul 14 02:52:23 2012 UTC (10 years, 10 months ago) by william
Diff to previous 93 (colored)
+ add lots of debug logging with proper context

Revision 93 - Directory Listing - [select for diffs]
Modified Sat Jul 14 02:35:50 2012 UTC (10 years, 10 months ago) by william
Diff to previous 92 (colored)
+ update to .net 3.5 (so we have linq and extension support)

Revision 92 - Directory Listing - [select for diffs]
Modified Sat Jul 14 00:55:41 2012 UTC (10 years, 10 months ago) by william
Diff to previous 91 (colored)

Revision 91 - Directory Listing - [select for diffs]
Modified Sat Jul 14 00:36:23 2012 UTC (10 years, 10 months ago) by william
Diff to previous 90 (colored)

Revision 90 - Directory Listing - [select for diffs]
Modified Fri Jul 13 22:58:13 2012 UTC (10 years, 10 months ago) by william
Diff to previous 88 (colored)

Revision 88 - Directory Listing - [select for diffs]
Modified Fri Jul 13 22:42:09 2012 UTC (10 years, 10 months ago) by william
Diff to previous 87 (colored)

Revision 87 - Directory Listing - [select for diffs]
Modified Fri Jul 13 22:37:40 2012 UTC (10 years, 10 months ago) by william
Diff to previous 86 (colored)
+ start implementation of AnywhereTS.DBSupport

Revision 86 - Directory Listing - [select for diffs]
Modified Fri Jul 13 21:13:27 2012 UTC (10 years, 10 months ago) by william
Diff to previous 83 (colored)
+ Admin: add referens to DBSupport
+ add logging support for database

Revision 83 - Directory Listing - [select for diffs]
Modified Fri Jul 13 20:57:30 2012 UTC (10 years, 10 months ago) by william
Diff to previous 82 (colored)

Revision 82 - Directory Listing - [select for diffs]
Modified Fri Jul 13 20:57:21 2012 UTC (10 years, 10 months ago) by william
Diff to previous 81 (colored)

Revision 81 - Directory Listing - [select for diffs]
Modified Fri Jul 13 20:56:44 2012 UTC (10 years, 10 months ago) by william
Diff to previous 79 (colored)
change DBName from AtsDb ==> AnywhereTS

Revision 79 - Directory Listing - [select for diffs]
Modified Fri Jul 13 02:24:25 2012 UTC (10 years, 10 months ago) by william
Diff to previous 78 (colored)
change Database Name: AnywhereTS ==> AtsDb
+ need to add user settings
  - set ServerIP
  - set ServerDBInstance (SQLEXPRESS or other)
  - need to set other settings
* build connection strings from these user settings at RunTime
  and remove the atsConnectionString user settings
Connection string types:
- SQL Server Express Database
- SQL Server Database (Enterprise, etc [not an Express version])
- SQL Server Database File (.mdf)

Revision 78 - Directory Listing - [select for diffs]
Modified Fri Jul 13 02:21:43 2012 UTC (10 years, 10 months ago) by william
Diff to previous 77 (colored)
+ comment-out NDC using statments that pass-in .sql script as context (this will keep the log file(s) lean an' mean)

Revision 77 - Directory Listing - [select for diffs]
Modified Fri Jul 13 01:35:49 2012 UTC (10 years, 10 months ago) by william
Diff to previous 76 (colored)
+ fix syntax error in UpdateDatabase4.sql (commas cannot come after the last item in an ALTER table statement)

Revision 76 - Directory Listing - [select for diffs]
Modified Fri Jul 13 01:22:58 2012 UTC (10 years, 10 months ago) by william
Diff to previous 75 (colored)
+ automatically replace the hardcoded database name AnyhwereTS with ATSGlobals.strDatabaseName when accessing SQLServerResources class

Revision 75 - Directory Listing - [select for diffs]
Modified Fri Jul 13 01:12:48 2012 UTC (10 years, 10 months ago) by william
Diff to previous 74 (colored)
Qualify all INSERT/DELETE/UPDATE statments with databasename

Revision 74 - Directory Listing - [select for diffs]
Modified Fri Jul 13 00:43:28 2012 UTC (10 years, 10 months ago) by william
Diff to previous 73 (colored)
ATSGlobals.strDatabaseName

Revision 73 - Directory Listing - [select for diffs]
Modified Thu Jul 12 22:00:37 2012 UTC (10 years, 10 months ago) by william
Diff to previous 72 (colored)
+ attempt to get inner exception, if any

Revision 72 - Directory Listing - [select for diffs]
Modified Thu Jul 12 21:23:35 2012 UTC (10 years, 10 months ago) by william
Diff to previous 70 (colored)
atsDataSet.Designer.cs:
ConnectionString = global::AnywhereTS.Properties.Settings.Default.atsConnectionString.Replace("AnywhereTS", "master");

Revision 70 - Directory Listing - [select for diffs]
Modified Thu Jul 12 20:47:35 2012 UTC (10 years, 10 months ago) by william
Diff to previous 69 (colored)
+ get NDC ThreadContectStack using reflection

Revision 69 - Directory Listing - [select for diffs]
Modified Thu Jul 12 20:06:53 2012 UTC (10 years, 10 months ago) by william
Diff to previous 68 (colored)
+ fix retrievale of NDC stack
+ get exception type name

Revision 68 - Directory Listing - [select for diffs]
Modified Thu Jul 12 19:40:36 2012 UTC (10 years, 10 months ago) by william
Diff to previous 67 (colored)
+ show abort, retry, ignore dialog to user when unhandled exception is shown

Revision 67 - Directory Listing - [select for diffs]
Modified Thu Jul 12 19:34:37 2012 UTC (10 years, 10 months ago) by william
Diff to previous 66 (colored)
Clone NDC stack within using statemnt

Revision 66 - Directory Listing - [select for diffs]
Modified Thu Jul 12 19:23:51 2012 UTC (10 years, 10 months ago) by william
Diff to previous 65 (colored)
+ add support in unhandled exception handler to display the log4net output in a messagebox

Revision 65 - Directory Listing - [select for diffs]
Modified Thu Jul 12 19:07:58 2012 UTC (10 years, 10 months ago) by william
Diff to previous 64 (colored)
also use bApplication.ThreadException in addition to AppDomain.UnhandledException

Revision 64 - Directory Listing - [select for diffs]
Modified Thu Jul 12 18:56:31 2012 UTC (10 years, 10 months ago) by william
Diff to previous 63 (colored)
+ more exception logging

Revision 63 - Directory Listing - [select for diffs]
Modified Thu Jul 12 18:17:31 2012 UTC (10 years, 10 months ago) by william
Diff to previous 62 (colored)
DeleteClient(): make sure to log if mac address cannot be found and show a messagebox

Revision 62 - Directory Listing - [select for diffs]
Modified Thu Jul 12 18:13:24 2012 UTC (10 years, 10 months ago) by william
Diff to previous 61 (colored)
+ catch some errors and log in atsDataSet.Designer.cs

Revision 61 - Directory Listing - [select for diffs]
Modified Thu Jul 12 17:34:46 2012 UTC (10 years, 10 months ago) by william
Diff to previous 60 (colored)
+ more wip for unhandled exception

Revision 60 - Directory Listing - [select for diffs]
Modified Thu Jul 12 17:12:08 2012 UTC (10 years, 10 months ago) by william
Diff to previous 59 (colored)
+ turnoff DEBUG constant and change debug info from: pdb-only to full

Revision 59 - Directory Listing - [select for diffs]
Modified Thu Jul 12 17:03:02 2012 UTC (10 years, 10 months ago) by william
Diff to previous 58 (colored)
don't change cursor to waitcursor on form load

Revision 58 - Directory Listing - [select for diffs]
Modified Thu Jul 12 17:00:14 2012 UTC (10 years, 10 months ago) by william
Diff to previous 57 (colored)
move appdomain unhandled exceptions again (put into called methods)

Revision 57 - Directory Listing - [select for diffs]
Modified Thu Jul 12 16:47:17 2012 UTC (10 years, 10 months ago) by william
Diff to previous 56 (colored)
move appdomain unhandled exception clause to the forms that are called by program.cs

Revision 56 - Directory Listing - [select for diffs]
Modified Thu Jul 12 16:44:24 2012 UTC (10 years, 10 months ago) by william
Diff to previous 55 (colored)
use master instead of AnywhereTS

Revision 55 - Directory Listing - [select for diffs]
Modified Thu Jul 12 16:32:50 2012 UTC (10 years, 10 months ago) by william
Diff to previous 54 (colored)
use ex.GetType() instead of e.ExceptionObject.GetType()

Revision 54 - Directory Listing - [select for diffs]
Modified Thu Jul 12 16:31:47 2012 UTC (10 years, 10 months ago) by william
Diff to previous 52 (colored)
if we donot have a SqlException then prefix NDC with Exception instead of SqlException

Revision 52 - Directory Listing - [select for diffs]
Modified Thu Jul 12 16:29:51 2012 UTC (10 years, 10 months ago) by william
Diff to previous 51 (colored)
+ add support to log all unhandled exception(s)

Revision 51 - Directory Listing - [select for diffs]
Modified Thu Jul 12 16:21:35 2012 UTC (10 years, 10 months ago) by william
Diff to previous 50 (colored)
fix an issue that was resolved by connecting to master database instead of AnywhereTS database

Revision 50 - Directory Listing - [select for diffs]
Modified Thu Jul 12 14:51:57 2012 UTC (10 years, 10 months ago) by william
Diff to previous 47 (colored)
+ define DEBUG constant and package .pdb debug files in installers

Revision 47 - Directory Listing - [select for diffs]
Modified Thu Jul 12 14:29:34 2012 UTC (10 years, 10 months ago) by william
Diff to previous 46 (colored)
+ fix compilation errors

Revision 46 - Directory Listing - [select for diffs]
Modified Thu Jul 12 14:17:14 2012 UTC (10 years, 10 months ago) by william
Diff to previous 45 (colored)
+ add logging across ATSAdmin Tool project

Revision 45 - Directory Listing - [select for diffs]
Modified Thu Jul 12 13:01:44 2012 UTC (10 years, 10 months ago) by william
Diff to previous 44 (colored)
remove one sqlCon.close()

Revision 44 - Directory Listing - [select for diffs]
Modified Thu Jul 12 12:59:45 2012 UTC (10 years, 10 months ago) by william
Diff to previous 43 (colored)
+ make sure connection is not already opened before attempted to open it

Revision 43 - Directory Listing - [select for diffs]
Modified Thu Jul 12 12:43:29 2012 UTC (10 years, 10 months ago) by william
Diff to previous 41 (colored)
use ATSGlobals.strDatabaseVersion instead of duplicating the value in Database.cs

Revision 41 - Directory Listing - [select for diffs]
Modified Thu Jul 12 12:41:04 2012 UTC (10 years, 10 months ago) by william
Diff to previous 40 (colored)
+ add logging in CheckVersion

Revision 40 - Directory Listing - [select for diffs]
Modified Thu Jul 12 12:25:58 2012 UTC (10 years, 10 months ago) by william
Diff to previous 39 (colored)
+ more logging and changes

Revision 39 - Directory Listing - [select for diffs]
Modified Thu Jul 12 12:21:43 2012 UTC (10 years, 10 months ago) by william
Diff to previous 36 (colored)
+ add logging messages

Revision 36 - Directory Listing - [select for diffs]
Modified Thu Jul 12 11:35:07 2012 UTC (10 years, 10 months ago) by william
Diff to previous 35 (colored)
+ add logging library (to be shared across application)

Revision 35 - Directory Listing - [select for diffs]
Modified Thu Jul 12 11:05:02 2012 UTC (10 years, 10 months ago) by william
Diff to previous 34 (colored)
+ setup app.config for multiple loggers

Revision 34 - Directory Listing - [select for diffs]
Modified Thu Jul 12 10:58:36 2012 UTC (10 years, 10 months ago) by william
Diff to previous 33 (colored)
+ add personal SQLServer isntance to app.config (this can be put back if released to public)

Revision 33 - Directory Listing - [select for diffs]
Modified Thu Jul 12 10:52:05 2012 UTC (10 years, 10 months ago) by william
Diff to previous 32 (colored)
+ attempt to add log4net support to ATSAdmin

Revision 32 - Directory Listing - [select for diffs]
Modified Thu Jul 12 10:34:47 2012 UTC (10 years, 10 months ago) by william
Diff to previous 29 (colored)
+ add reference to log4net

Revision 29 - Directory Listing - [select for diffs]
Modified Thu Jul 12 10:01:23 2012 UTC (10 years, 10 months ago) by william
Diff to previous 26 (colored)
update and add 3rdparty/MDAudi100/TrackBar.dll

Revision 26 - Directory Listing - [select for diffs]
Modified Thu Jul 12 07:41:33 2012 UTC (10 years, 10 months ago) by william
Diff to previous 25 (colored)

Revision 25 - Directory Listing - [select for diffs]
Modified Wed Jul 11 20:39:32 2012 UTC (10 years, 10 months ago) by william
Diff to previous 24 (colored)
+ commit current wip for non-existing database

Revision 24 - Directory Listing - [select for diffs]
Modified Wed Jul 11 20:15:18 2012 UTC (10 years, 10 months ago) by william
Diff to previous 23 (colored)
+ comment-out version check and verify message

Revision 23 - Directory Listing - [select for diffs]
Modified Wed Jul 11 20:14:42 2012 UTC (10 years, 10 months ago) by william
Diff to previous 22 (colored)
+ remove database drop when database does not exist

Revision 22 - Directory Listing - [select for diffs]
Modified Wed Jul 11 20:13:17 2012 UTC (10 years, 10 months ago) by william
Diff to previous 21 (colored)
+ finish support for creating tables in an empty database (incase the database are pre-created, but contains no tables)
- still have AD login issues when creating the database from scratch (ie. it did not exist to begin with)

Revision 21 - Directory Listing - [select for diffs]
Modified Wed Jul 11 19:34:51 2012 UTC (10 years, 10 months ago) by william
Diff to previous 20 (colored)
+ commit wip for when database exists, but is empty

Revision 20 - Directory Listing - [select for diffs]
Modified Wed Jul 11 18:48:42 2012 UTC (10 years, 10 months ago) by william
Diff to previous 19 (colored)
+ deprecate some File ACL methods

Revision 19 - Directory Listing - [select for diffs]
Modified Wed Jul 11 18:07:00 2012 UTC (10 years, 10 months ago) by william
Diff to previous 18 (colored)
+ fix instancename parsing

Revision 18 - Directory Listing - [select for diffs]
Modified Wed Jul 11 17:45:48 2012 UTC (10 years, 10 months ago) by william
Diff to previous 17 (colored)
+ add support to createdatabase is it does not exist

Revision 17 - Directory Listing - [select for diffs]
Modified Wed Jul 11 16:48:23 2012 UTC (10 years, 10 months ago) by william
Diff to previous 16 (colored)
+ fix more references to SQLEXPRESS

Revision 16 - Directory Listing - [select for diffs]
Modified Wed Jul 11 16:36:27 2012 UTC (10 years, 10 months ago) by william
Diff to previous 12 (colored)
ProSupport.InitDatabase(): don't overwrite the application settings for connection string

Revision 12 - Directory Listing - [select for diffs]
Modified Wed Jul 11 16:06:57 2012 UTC (10 years, 10 months ago) by william
Diff to previous 11 (colored)
change version frpom: *.0 to *.1

Revision 11 - Directory Listing - [select for diffs]
Modified Wed Jul 11 16:02:50 2012 UTC (10 years, 10 months ago) by william
Diff to previous 10 (colored)
Runtime Version:2.0.50727.3603 => Runtime Version:2.0.50727.5456

Revision 10 - Directory Listing - [select for diffs]
Modified Wed Jul 11 16:01:40 2012 UTC (10 years, 10 months ago) by william
Diff to previous 9 (colored)
SetupDatabase():
sqlCon.ConnectionString = Properties.Settings.Default.atsConnectionString;

+ this enables the user to set the connection string
(they could use SQLEXPRESS or a full Server install with named instances)
Data Source=.\SQLEXPRESS
-or-
Data Source=IPADDRES\INSTANCENAME

Revision 9 - Directory Listing - [select for diffs]
Modified Wed Jul 11 15:53:30 2012 UTC (10 years, 10 months ago) by william
Diff to previous 7 (colored)
append -MSSQL

Revision 7 - Directory Listing - [select for diffs]
Modified Wed Jul 11 15:13:26 2012 UTC (10 years, 10 months ago) by william
Diff to previous 4 (colored)
update svn:ignores
Revision 4 - Directory Listing - [select for diffs]
Added Wed Jul 11 14:19:13 2012 UTC (10 years, 10 months ago) by william
imported from https://anywherets.svn.sourceforge.net/svnroot/anywherets/trunk/
Revision: 1
Author: beartown
Date: 3:10:40 AM, Monday, June 21, 2010
Message:
First upload. Still todo in order to get a fully working product: Replace Thinstation images with vanilla Thinstation, modify ImageDesigntimeConfig.cs, ImageRuntimeConfig.cs in order to support the Thinstation image

Convenience Links