public static Lightbox Update(Lightbox lightbox)
{
Lightbox lb = LightboxMapper.Instance.Update(lightbox);
LightboxBrandMapper.Instance.DeleteLightboxBrands(lb.LightboxId);
foreach (Brand brand in lb.Brands)
{
LightboxBrand o = LightboxBrand.New();
o.LightboxId = lb.LightboxId.GetValueOrDefault();
o.BrandId = brand.BrandId.GetValueOrDefault();
LightboxBrand.Update(o);
}
return(lb);
}
public virtual Lightbox Update(Lightbox lightbox)
{
if (!lightbox.IsDirty || lightbox.IsNull)
{
// Nothing to do - no point hammering the database unnecessarily
return(lightbox);
}
IDbCommand command = CreateCommand();
if (lightbox.IsNew)
{
// Adding
command.CommandText = "INSERT INTO [Lightbox] ([UserId], [Name], [Summary], [Notes], [IsPublic], [IsDefault], [CreateDate]) VALUES (@userId, @name, @summary, @notes, @isPublic, @isDefault, @createDate) ; SELECT @@identity AS NewId;";
}
else
{
// Updating
command.CommandText = "UPDATE [Lightbox] SET [UserId] = @userId, [Name] = @name, [Summary] = @summary, [Notes] = @notes, [IsPublic] = @isPublic, [IsDefault] = @isDefault, [CreateDate] = @createDate WHERE LightboxId = @lightboxId";
}
command.Parameters.Add(CreateParameter("@userId", lightbox.UserId));
command.Parameters.Add(CreateParameter("@name", lightbox.Name));
command.Parameters.Add(CreateParameter("@summary", lightbox.Summary));
command.Parameters.Add(CreateParameter("@notes", lightbox.Notes));
command.Parameters.Add(CreateParameter("@isPublic", lightbox.IsPublic));
command.Parameters.Add(CreateParameter("@isDefault", lightbox.IsDefault));
command.Parameters.Add(CreateParameter("@createDate", lightbox.CreateDate));
if (lightbox.IsNew)
{
lightbox.LightboxId = Convert.ToInt32(ExecScalar(command));
}
else
{
command.Parameters.Add(CreateParameter("@lightboxId", lightbox.LightboxId));
ExecuteCommand(command);
}
lightbox.IsDirty = false;
lightbox.ChangedProperties.Clear();
return(lightbox);
}
protected override object ReadRow(IRowReader reader)
{
Lightbox lightbox = Lightbox.New();
// Table Fields
lightbox.LightboxId = reader.GetInt32("LightboxId");
lightbox.UserId = reader.GetInt32("UserId");
lightbox.Name = reader.GetString("Name");
lightbox.Summary = reader.GetString("Summary");
lightbox.Notes = reader.GetString("Notes");
lightbox.IsPublic = reader.GetBoolean("IsPublic");
lightbox.IsDefault = reader.GetBoolean("IsDefault");
lightbox.CreateDate = reader.GetDateTime("CreateDate");
lightbox.IsDirty = false;
lightbox.ChangedProperties.Clear();
return(lightbox);
}
public static Lightbox Get(Nullable <Int32> LightboxId)
{
Lightbox Lightbox = LightboxMapper.Instance.Get(LightboxId);
return(Lightbox ?? Empty);
}
public static Lightbox FindOne(LightboxFinder finder)
{
Lightbox Lightbox = LightboxMapper.Instance.FindOne(finder);
return(Lightbox ?? Empty);
}
