protected override object ReadRow(IRowReader reader) { AssetImageSize assetImageSize = AssetImageSize.New(); // Table Fields assetImageSize.AssetImageSizeId = reader.GetInt32("AssetImageSizeId"); assetImageSize.Description = reader.GetString("Description"); assetImageSize.Height = reader.GetInt32("Height"); assetImageSize.Width = reader.GetInt32("Width"); assetImageSize.DotsPerInch = reader.GetInt32("DotsPerInch"); assetImageSize.FileSuffix = reader.GetString("FileSuffix"); assetImageSize.IsDirty = false; assetImageSize.ChangedProperties.Clear(); return(assetImageSize); }
public virtual AssetImageSize Update(AssetImageSize assetImageSize) { if (!assetImageSize.IsDirty || assetImageSize.IsNull) { // Nothing to do - no point hammering the database unnecessarily return(assetImageSize); } IDbCommand command = CreateCommand(); if (assetImageSize.IsNew) { // Adding command.CommandText = "INSERT INTO [AssetImageSize] ([Description], [Height], [Width], [DotsPerInch], [FileSuffix]) VALUES (@description, @height, @width, @dotsPerInch, @fileSuffix) ; SELECT @@identity AS NewId;"; } else { // Updating command.CommandText = "UPDATE [AssetImageSize] SET [Description] = @description, [Height] = @height, [Width] = @width, [DotsPerInch] = @dotsPerInch, [FileSuffix] = @fileSuffix WHERE AssetImageSizeId = @assetImageSizeId"; } command.Parameters.Add(CreateParameter("@description", assetImageSize.Description)); command.Parameters.Add(CreateParameter("@height", assetImageSize.Height)); command.Parameters.Add(CreateParameter("@width", assetImageSize.Width)); command.Parameters.Add(CreateParameter("@dotsPerInch", assetImageSize.DotsPerInch)); command.Parameters.Add(CreateParameter("@fileSuffix", assetImageSize.FileSuffix)); if (assetImageSize.IsNew) { assetImageSize.AssetImageSizeId = Convert.ToInt32(ExecScalar(command)); } else { command.Parameters.Add(CreateParameter("@assetImageSizeId", assetImageSize.AssetImageSizeId)); ExecuteCommand(command); } assetImageSize.IsDirty = false; assetImageSize.ChangedProperties.Clear(); return(assetImageSize); }
public static AssetImageSize Update(AssetImageSize assetImageSize) { return(AssetImageSizeMapper.Instance.Update(assetImageSize)); }
public static AssetImageSize FindOne(AssetImageSizeFinder finder) { AssetImageSize AssetImageSize = AssetImageSizeMapper.Instance.FindOne(finder); return(AssetImageSize ?? Empty); }
public static AssetImageSize Get(Nullable <Int32> AssetImageSizeId) { AssetImageSize AssetImageSize = AssetImageSizeMapper.Instance.Get(AssetImageSizeId); return(AssetImageSize ?? Empty); }