Database

public void GetUsers(ArrayList users)
{
    object[] userData = new object[4];

    OleDbCommand dbCommand = new OleDbCommand("SELECT * FROM tblUsers", this._dbConnection);

    try
    {
        OleDbDataReader dbReader = dbCommand.ExecuteReader();

        while (dbReader.Read())
        {
            User currentUser = new User();
            dbReader.GetValues(userData);

            //get user name
            currentUser.Name = userData[0].ToString();
            //get password
            currentUser.Password = userData[1].ToString();
            //get rights
            string temp = userData[2].ToString();
            int rights = Convert.ToInt16(temp);
            currentUser.Rights = (User.EN_RIGHTS)rights;
            //get jobs
            //still thinking about this one


            users.Add(currentUser);
        }
        dbReader.Close();
    }
    catch (Exception e)
    {
        String temp = String.Format("DBManager::GetUsers: {0}", e.Message);
        MessageBox.Show(temp);
    }
}

public void UpdateJobs(ArrayList copyOfJobs, ArrayList originalJobs)
{
    ArrayList copy = new ArrayList();
    ArrayList original = new ArrayList();

    copy = copyOfJobs;
    original = originalJobs;

    string temp = "";

    if (!copy.Equals(original))
    {
        temp = string.Format("");

        for (int i = 0; i < copyOfJobs.Count; i++)
        {

        }
    }
}

public static Guid GetUserGuid(Guid sourceGuid)
{
   if (sourceGuid == new Guid("589CD136-4AED-4E3E-A391-DDAE8A790D1B"))
      return new Guid("4D0947C1-5746-4DD6-AAFE-5ECB5BACBB9F");
   else if (sourceGuid == new Guid("286BCF1A-8CDD-DE11-9EA4-000C29FC4D89"))
      return new Guid("05F0CAD9-4095-E011-8ED0-00155D785E00");
   // and so on...
}

CREATE TABLE [Users](
   [SourceId] [uniqueidentifier] ROWGUIDCOL NOT NULL,
   [DestinationId] [uniqueidentifier] NOT NULL
)

Dim cnn As ADODB.Connection
Dim rst As ADODB.RecordSet

'set connection (assume correct)
Set cnn = CurrentProject.Connection
Set rst = New ADODB.Recordset
rst.Open "MyTable", cnn, adOpenKeyset, adLockOptimistic, adCmdTableDirect

'rst.index = "PrimaryKey"
'check if recordset valid - if rst.RecordCount >0

rst.Seek fld_cmpr1 & fld_cmpr2 & fld_cmpr3, adSeekFirstEQ

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = Object_ID('[dbo].[__Reporting_GetUserName]') 
AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
BEGIN
DROP FUNCTION [dbo].[__Reporting_GetUserName]
END

BEGIN
EXEC dbo.sp_executesql N'
CREATE FUNCTION [dbo].[__Reporting_GetUserName] (@userId int)
RETURNS VARCHAR(MAX)
AS
BEGIN

DECLARE @UserName VARCHAR(MAX)

SET @UserName = 
(
	IF [FirstName] is not null 
	BEGIN
	SELECT [FirstName] + '' '' + [LastName]
	FROM __User
	WHERE Id = @userId
	END
)

RETURN @UserName
END
'
END