/// <summary>
/// Map the basic fields for the GuestPhone table to the GuestPhone model object
/// </summary>
/// <param name="record">The SqlDataReader with the executed query result</param>
/// <param name="prefix">a prefix used to identify fields for the GuestPhone model in the resultset if required</param>
/// <returns>An instance of Model.Customer.GuestPhone</returns>
internal static GuestPhone MapRecord(IDataRecord record, string prefix = "")
{
var guestPhone = new GuestPhone
{
Id = DbHelper.ConvertValue<int>(record[prefix + Parameters.Id]),
GuestId = DbHelper.ConvertValue<int>(record[prefix + Parameters.GuestId]),
PhoneTypeCode = DbHelper.ConvertEnumValue<PhoneTypeEnum>(record[prefix + Parameters.PhoneTypeCode]),
Number = DbHelper.ConvertValue<string>(record[prefix + Parameters.Number])
};
return AuditFieldsHelper.MapRecord(guestPhone, record, prefix);
}
/// <summary>
/// Create GuestPhone for a guest
/// </summary>
public void Create(GuestPhone guestPhone, int guestId)
{
const string SQL =
@"INSERT INTO Customer.GuestPhone
(GuestId, PhoneTypeCode, Number, UpdatedByUserId)
VALUES (@GuestId, @PhoneTypeCode, @Number , @UpdatedByUserId); ";
var parameters = new List<SqlParameter>
{
DbHelper.CreateParameter(GuestPhoneMapper.Parameters.GuestId, guestId),
DbHelper.CreateParameter(GuestPhoneMapper.Parameters.PhoneTypeCode, guestPhone.PhoneTypeCode.GetCode()),
DbHelper.CreateParameter(GuestPhoneMapper.Parameters.Number, guestPhone.Number),
DbHelper.CreateParameter(GuestPhoneMapper.Parameters.UpdatedByUserId, AuditFieldsHelper.GetUserId())
};
DbHelper.ExecuteNonQueryCommand(SQL, parameters: parameters);
}
