public void SaveParty(Party party, IActionBy actionBy) { if(this.GetPartyByGuid(party.Guid) == null) { string sql = @"Insert Into VintageRabbit.Parties (Guid, OrderGuid, Status, PartyDate, DropoffAddress, PickupAddress, ChildsName, Age, PartyTime, [PartyAddress], [RSVPDetails], DateCreated, DateLastModified, LastModifiedBy) Values (@Guid, @OrderGuid, @Status, @PartyDate, @DropoffAddress, @PickupAddress, @ChildsName, @Age, @PartyTime, @PartyAddress, @RSVPDetails, @DateCreated, @DateLastModified, @LastModifiedBy)"; using (SqlConnection connection = new SqlConnection(this._connectionString)) { connection.Execute(sql, new { Guid = party.Guid, OrderGuid = party.OrderGuid, Status = party.Status.ToString(), PartyDate = party.PartyDate, DropoffAddress = party.DropoffAddress, PickupAddress = party.PickupAddress, ChildsName = party.ChildsName, Age = party.Age, PartyTime = party.PartyTime, PartyAddress = party.PartyAddress, RSVPDetails = party.RSVPDetails, DateCreated = DateTime.Now, DateLastModified = DateTime.Now, LastModifiedBy = actionBy.Email }); } } else { string sql = @"Update VintageRabbit.Parties Set OrderGuid = @OrderGuid, Status = @Status, PartyDate = @PartyDate, DropoffAddress = @DropoffAddress, PickupAddress = @PickupAddress, ChildsName = @ChildsName, Age = @Age, PartyTime = @PartyTime, [PartyAddress] = @PartyAddress, RSVPDetails = @RSVPDetails, DateLastModified = @DateLastModified, LastModifiedBy = @LastModifiedBy Where Guid = @Guid"; using (SqlConnection connection = new SqlConnection(this._connectionString)) { connection.Execute(sql, new { Guid = party.Guid, OrderGuid = party.OrderGuid, Status = party.Status.ToString(), PartyDate = party.PartyDate, DropoffAddress = party.DropoffAddress, PickupAddress = party.PickupAddress, ChildsName = party.ChildsName, Age = party.Age, PartyTime = party.PartyTime, PartyAddress = party.PartyAddress, RSVPDetails = party.RSVPDetails, DateLastModified = DateTime.Now, LastModifiedBy = actionBy.Email }); } } }
public Product SaveProduct(Product product, IActionBy actionBy) { string categories = this._serializer.Serialize(product.Categories); string images = this._serializer.Serialize(product.Images); if (product.Id == 0) { string sql = @"Insert Into VintageRabbit.Products ([Guid], Code, [Type], Title, Description, Price, Keywords, Inventory, IsFeatured, DateCreated, DateLastModified, UpdatedBy, Categories, Images) Values (@Guid, @Code, @Type, @Title, @Description, @Price, @Keywords, @Inventory, @IsFeatured, @DateCreated, @DateLastModified, @UpdatedBy, @Categories, @Images); Select cast(SCOPE_IDENTITY() as int)"; using (SqlConnection connection = new SqlConnection(this._connectionString)) { IEnumerable<int> productIds = connection.Query<int>(sql, new { Guid = product.Guid, Code = product.Code, Type = product.Type.ToString(), Title = product.Title, Description = product.Description, Price = product.Cost, Keywords = product.Keywords, IsFeatured = product.IsFeatured, DateCreated = DateTime.Now, DateLastModified = DateTime.Now, UpdatedBy = actionBy.Email, Categories = categories, Inventory = product.Inventory, Images = images }); if(productIds.Any()) { product.Id = productIds.First(); } } } else { string sql = @"Update VintageRabbit.Products Set [Guid] = @Guid, Code = @Code, [Type] = @Type, Title = @Title, Description = @Description, Price = @Price, Keywords = @Keywords, IsFeatured = @IsFeatured, Inventory = @Inventory, DateLastModified = @DateLastModified, UpdatedBy = @UpdatedBy, Categories = @Categories, Images = @Images Where Id = @ProductId"; using (SqlConnection connection = new SqlConnection(this._connectionString)) { connection.Execute(sql, new { Guid = product.Guid, Code = product.Code, Type = product.Type.ToString(), Title = product.Title.Trim(), Description = product.Description.Trim(), Price = product.Cost, Keywords = product.Keywords, IsFeatured = product.IsFeatured, DateLastModified = DateTime.Now, UpdatedBy = actionBy.Email, Categories = categories, Inventory = product.Inventory, Images = images, ProductId = product.Id }); } } this.SaveProductCategories(product); return product; }
public SaveProductMessage(Product product, IActionBy actionBy) { this.Product = product; this.ActionBy = actionBy; }