Devart Forums

Code: Select all

Code: Select all

public string CurrentUserName {
        get { return iCurrentUserName; }
        set { 
            iCurrentUserName = value;

            if ( ! string.IsNullOrEmpty( iCurrentUserName ) && ! string.IsNullOrWhiteSpace( iCurrentUserName ) ) {
                MembershipUser user = Membership.GetUser( iCurrentUserName );

                if ( user == null ) {
                    Log( string.Format( "User \"{0}\" is not a registered user.  Cannot proceed with this user.", CurrentUserName ), EventTypeEnum.Error );

                    // Set the current user name to the empty string and the current domain ID to null
                    iCurrentUserName = string.Empty;
                    CurrentDomainId  = null;
                }

                if ( user.IsLockedOut ) {
                    string msg = string.Format( "User \"{0}\" is currently locked out.  Cannot proceed with this user.", CurrentUserName );
                    Log( msg, EventTypeEnum.Error );

                    iCurrentUserName = string.Empty;
                    CurrentDomainId  = null;
                }

                CurrentUser = CarSystemUser.Attach( user, true );
                UserProfile = CurrentUser.UserProfile;
                UserProfile.Save();
                CurrentDomainId = UserProfile.DomainId;
            }
        }
    }

Code: Select all

CREATE OR REPLACE FUNCTION "CarSystem"."ScanLists"( OUT RowCount INT ) RETURNS INT
AS $$
...

Code: Select all

Cannot create method for a storage function 'ScanLists' that can be composed. Only stored procedures can be mapped."

Code: Select all

CREATE TABLE "CarSystem"."Images" (
	"ImageId"			UUID		PRIMARY KEY DEFAULT UUID_GENERATE_V4(),
	"ReadId"			UUID		NOT NULL REFERENCES "CarSystem"."Reads"        ( "ReadId" ),
	"ImageTypeId"			INT		NOT NULL REFERENCES "CarSystem"."ImageTypes"   ( "ImageTypeId" ),
	"ImageClassId"			INT		NOT NULL REFERENCES "CarSystem"."ImageClasses" ( "ImageClassId" ) DEFAULT 3,
	"ImageOid"			INT		NOT NULL,
	"OrigX"				INT		NULL,
	"OrigY"				INT		NULL,
	"Width"				INT		NULL,
	"Height"			INT		NULL,
	"Camera"			VARCHAR(16)	NULL,
	"TimeStamp"			TIMESTAMPTZ	NOT NULL,
	"CreatedDate"			TIMESTAMPTZ	NOT NULL DEFAULT CURRENT_TIMESTAMP,
	i_active			SMALLINT	NOT NULL DEFAULT 1,
	"ModifyDate"			TIMESTAMPTZ	NULL
);

Code: Select all

CREATE OR REPLACE FUNCTION "CarSystem"."InsertList"( ListName VARCHAR(50), ListTypeId INT, DomainId INT, Geofencing VARCHAR, Salt VARCHAR(50), WhiteListAlarmClassId INT ) RETURNS VOID AS $$
    INSERT INTO "CarSystem"."Lists"
         ( "ListName", "ListTypeId", "DomainId", "LastUpdate", "Geofencing", "Salt", "WhiteListAlarmClassId" )
    VALUES
        ( $1, $2, $3, NOW(), $4, $5, $6 );
$$ LANGUAGE SQL;

Code: Select all

  
	
	  
	
	
	  
	
  
  
	
	
	
	
	
	
  
  
	
	  
	  
	
  

  
	
	
	  
		
				-->
		
		
	  
	
	
	  
		
		
	  
	
	
	  
		
				-->
		
		
	  
	
  
  
	
	  
		1234
	  
	  
		80fdc536-581a-4ee2-8563-cfba2fa6e94a
	  
	  
		Car54
	  
	  
		Car54
	  
	  
		False