public List <ReservationGuest> ReservationGuestList(Guid reservationID)
{
ReservationGuest rsGuest;
List <ReservationGuest> rsGuestList = new List <ReservationGuest>();
SqlCommand cmd = new SqlCommand("select*from ReservationGuest where ReservationID=@reservationID", _conn);
cmd.Parameters.AddWithValue("@reservationID", reservationID);
_conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
rsGuest = new ReservationGuest();
rsGuest.ReservationID = (Guid)dr[0];
rsGuest.GuestID = (Guid)dr[1];
rsGuestList.Add(rsGuest);
}
_conn.Close();
rsGuestList.Reverse();
return(rsGuestList);
}
/// <summary>
/// 创建订单
/// </summary>
/// <param name="RequestEt"></param>
public WebServiceResponse <OrderInfoJsonEt> Reservation(CreateOrderJsonEt RequestEt)
{
#region 封装 订单信息对象
Reservation reservation = new Reservation()
{
HotelCode = RequestEt.HotelCode,
RatePlanCode = RequestEt.RatePlanCode,
RoomTypeCode = RequestEt.RoomTypeCode,
NumberOfUnits = RequestEt.NumberOfUnits,
DistributorReservationId = RequestEt.DistributorReservationId,
ReservationStatus = ReservationStatus.Confirmed,
Total = new Total()
{
TotalAmount = RequestEt.TotalAmount
},
StayDateRange = new StayDateRange()
{
CheckIn = RequestEt.CheckIn,
CheckOut = RequestEt.CheckOut
},
ContactPerson = new Customer()
{
GivenName = RequestEt.ContactPerson.GivenName,
Surname = RequestEt.ContactPerson.Surname,
Telephone = RequestEt.ContactPerson.Telephone,
Email = RequestEt.ContactPerson.Email,
Address = RequestEt.ContactPerson.Address,
},
GuestCount = new DaDSService.GuestCount()
{
AdultCount = RequestEt.GuestCount.AdultCount,
ChildCount = RequestEt.GuestCount.ChildCount
},
Comments = new string[1] {
RequestEt.Comment
},
};
List <ReservationGuest> rGuestList = new List <ReservationGuest>();
foreach (var _Guest in RequestEt.GuestList)
{
ReservationGuest rGuest = new ReservationGuest()
{
GivenName = _Guest.GivenName,
Surname = _Guest.Surname,
Telephone = _Guest.Telephone,
Email = _Guest.Email
};
rGuestList.Add(rGuest);
}
reservation.Guests = rGuestList.ToArray();
#endregion
// Web服务对象 提交数据
var responseEt = _Request.Reservation(reservation);
// 处理 Response对象
var jsonEt = HandleResponse <OrderInfoJsonEt>(responseEt.Error);
if (jsonEt.Successful)
{
jsonEt.ResponseEt = new OrderInfoJsonEt()
{
ReservationStatus = responseEt.ReservationStatus.ToString(),
TotalAmount = responseEt.Total.TotalAmount,
ProductReservationId = responseEt.ReservationId.ProductReservationId,
ErpReservationId = responseEt.ReservationId.ErpReservationId,
DistributorReservationId = RequestEt.DistributorReservationId,
CancelTime = responseEt.CancelTime
};
}
return(jsonEt);
}
