public PartyListItemViewModel(Party party, string name) { this.Guid = party.Guid; this.OrderGuid = party.OrderGuid; this.PartyDate = party.PartyDate; this.HireDate = party.HireDate; this.ReturnDate = party.ReturnDate; this.Name = name; this.IsDelivery = party.DropoffAddress.HasValue; this.IsPickup = party.PickupAddress.HasValue; }
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 }); } } }