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