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); }