public virtual AuditUserHistory Update(AuditUserHistory auditUserHistory) { if (!auditUserHistory.IsDirty || auditUserHistory.IsNull) { // Nothing to do - no point hammering the database unnecessarily return(auditUserHistory); } IDbCommand command = CreateCommand(); if (auditUserHistory.IsNew) { // Adding command.CommandText = "INSERT INTO [AuditUserHistory] ([SessionId], [IpAddress], [AuditUserActionId], [UserId], [Notes], [Date]) VALUES (@sessionId, @ipAddress, @auditUserActionId, @userId, @notes, @date) ; SELECT @@identity AS NewId;"; } else { // Updating command.CommandText = "UPDATE [AuditUserHistory] SET [SessionId] = @sessionId, [IpAddress] = @ipAddress, [AuditUserActionId] = @auditUserActionId, [UserId] = @userId, [Notes] = @notes, [Date] = @date WHERE AuditUserHistoryId = @auditUserHistoryId"; } command.Parameters.Add(CreateParameter("@sessionId", auditUserHistory.SessionId)); command.Parameters.Add(CreateParameter("@ipAddress", auditUserHistory.IpAddress)); command.Parameters.Add(CreateParameter("@auditUserActionId", auditUserHistory.AuditUserActionId)); command.Parameters.Add(CreateParameter("@userId", auditUserHistory.UserId)); command.Parameters.Add(CreateParameter("@notes", auditUserHistory.Notes)); command.Parameters.Add(CreateParameter("@date", auditUserHistory.Date)); if (auditUserHistory.IsNew) { auditUserHistory.AuditUserHistoryId = Convert.ToInt32(ExecScalar(command)); } else { command.Parameters.Add(CreateParameter("@auditUserHistoryId", auditUserHistory.AuditUserHistoryId)); ExecuteCommand(command); } auditUserHistory.IsDirty = false; auditUserHistory.ChangedProperties.Clear(); return(auditUserHistory); }
protected override object ReadRow(IRowReader reader) { AuditUserHistory auditUserHistory = AuditUserHistory.New(); // Table Fields auditUserHistory.AuditUserHistoryId = reader.GetInt32("AuditUserHistoryId"); auditUserHistory.SessionId = reader.GetString("SessionId"); auditUserHistory.IpAddress = reader.GetString("IpAddress"); auditUserHistory.AuditUserActionId = reader.GetInt32("AuditUserActionId"); auditUserHistory.UserId = reader.GetInt32("UserId"); auditUserHistory.Notes = reader.GetString("Notes"); auditUserHistory.Date = reader.GetDateTime("Date"); // View Fields auditUserHistory.Description = reader.GetString("Description"); auditUserHistory.UserName = reader.GetString("UserName"); auditUserHistory.UserEmail = reader.GetString("UserEmail"); auditUserHistory.PrimaryBrandId = reader.GetInt32("PrimaryBrandId"); auditUserHistory.IsDirty = false; auditUserHistory.ChangedProperties.Clear(); return(auditUserHistory); }
public static AuditUserHistory Update(AuditUserHistory auditUserHistory) { return(AuditUserHistoryMapper.Instance.Update(auditUserHistory)); }
public static AuditUserHistory FindOne(AuditUserHistoryFinder finder) { AuditUserHistory AuditUserHistory = AuditUserHistoryMapper.Instance.FindOne(finder); return(AuditUserHistory ?? Empty); }
public static AuditUserHistory Get(Nullable <Int32> AuditUserHistoryId) { AuditUserHistory AuditUserHistory = AuditUserHistoryMapper.Instance.Get(AuditUserHistoryId); return(AuditUserHistory ?? Empty); }