コード例 #1
0
        protected override object ReadRow(IRowReader reader)
        {
            AuditAssetHistory auditAssetHistory = AuditAssetHistory.New();

            // Table Fields
            auditAssetHistory.AuditAssetHistoryId = reader.GetInt32("AuditAssetHistoryId");
            auditAssetHistory.SessionId           = reader.GetString("SessionId");
            auditAssetHistory.IpAddress           = reader.GetString("IpAddress");
            auditAssetHistory.AuditAssetActionId  = reader.GetInt32("AuditAssetActionId");
            auditAssetHistory.UserId  = reader.GetInt32("UserId");
            auditAssetHistory.AssetId = reader.GetInt32("AssetId");
            auditAssetHistory.Notes   = reader.GetString("Notes");
            auditAssetHistory.Date    = reader.GetDateTime("Date");

            // View Fields
            auditAssetHistory.Description        = reader.GetString("Description");
            auditAssetHistory.UserPrimaryBrandId = reader.GetInt32("UserPrimaryBrandId");
            auditAssetHistory.AssetBrandId       = reader.GetInt32("AssetBrandId");
            auditAssetHistory.UserName           = reader.GetString("UserName");
            auditAssetHistory.UserEmail          = reader.GetString("UserEmail");
            auditAssetHistory.Title = reader.GetString("Title");

            auditAssetHistory.IsDirty = false;
            auditAssetHistory.ChangedProperties.Clear();

            return(auditAssetHistory);
        }
コード例 #2
0
        public virtual AuditAssetHistory Update(AuditAssetHistory auditAssetHistory)
        {
            if (!auditAssetHistory.IsDirty || auditAssetHistory.IsNull)
            {
                // Nothing to do - no point hammering the database unnecessarily
                return(auditAssetHistory);
            }

            IDbCommand command = CreateCommand();

            if (auditAssetHistory.IsNew)
            {
                // Adding
                command.CommandText = "INSERT INTO [AuditAssetHistory] ([SessionId], [IpAddress], [AuditAssetActionId], [UserId], [AssetId], [Notes], [Date]) VALUES (@sessionId, @ipAddress, @auditAssetActionId, @userId, @assetId, @notes, @date) ; SELECT @@identity AS NewId;";
            }
            else
            {
                // Updating
                command.CommandText = "UPDATE [AuditAssetHistory] SET [SessionId] = @sessionId, [IpAddress] = @ipAddress, [AuditAssetActionId] = @auditAssetActionId, [UserId] = @userId, [AssetId] = @assetId, [Notes] = @notes, [Date] = @date WHERE AuditAssetHistoryId = @auditAssetHistoryId";
            }

            command.Parameters.Add(CreateParameter("@sessionId", auditAssetHistory.SessionId));
            command.Parameters.Add(CreateParameter("@ipAddress", auditAssetHistory.IpAddress));
            command.Parameters.Add(CreateParameter("@auditAssetActionId", auditAssetHistory.AuditAssetActionId));
            command.Parameters.Add(CreateParameter("@userId", auditAssetHistory.UserId));
            command.Parameters.Add(CreateParameter("@assetId", auditAssetHistory.AssetId));
            command.Parameters.Add(CreateParameter("@notes", auditAssetHistory.Notes));
            command.Parameters.Add(CreateParameter("@date", auditAssetHistory.Date));

            if (auditAssetHistory.IsNew)
            {
                auditAssetHistory.AuditAssetHistoryId = Convert.ToInt32(ExecScalar(command));
            }
            else
            {
                command.Parameters.Add(CreateParameter("@auditAssetHistoryId", auditAssetHistory.AuditAssetHistoryId));
                ExecuteCommand(command);
            }

            auditAssetHistory.IsDirty = false;
            auditAssetHistory.ChangedProperties.Clear();

            return(auditAssetHistory);
        }
コード例 #3
0
 public static AuditAssetHistory Update(AuditAssetHistory auditAssetHistory)
 {
     return(AuditAssetHistoryMapper.Instance.Update(auditAssetHistory));
 }
コード例 #4
0
        public static AuditAssetHistory FindOne(AuditAssetHistoryFinder finder)
        {
            AuditAssetHistory AuditAssetHistory = AuditAssetHistoryMapper.Instance.FindOne(finder);

            return(AuditAssetHistory ?? Empty);
        }
コード例 #5
0
        public static AuditAssetHistory Get(Nullable <Int32> AuditAssetHistoryId)
        {
            AuditAssetHistory AuditAssetHistory = AuditAssetHistoryMapper.Instance.Get(AuditAssetHistoryId);

            return(AuditAssetHistory ?? Empty);
        }