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