/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MvcApplication1.Model.Student model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Student(");
strSql.Append("LastName,FirstMidName,EnrollmentDate,age)");
strSql.Append(" values (");
strSql.Append("@LastName,@FirstMidName,@EnrollmentDate,@age)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@LastName", SqlDbType.NVarChar,50),
new SqlParameter("@FirstMidName", SqlDbType.NVarChar,50),
new SqlParameter("@EnrollmentDate", SqlDbType.DateTime),
new SqlParameter("@age", SqlDbType.Int,4)};
parameters[0].Value = model.LastName;
parameters[1].Value = model.FirstMidName;
parameters[2].Value = model.EnrollmentDate;
parameters[3].Value = model.age;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
public ReviewHotelViewModel(MvcApplication1.HotelService.HotelModel hotel, String requestedRoomTypeCode, DateTime checkIn, DateTime checkOut)
{
this.Hotel = hotel;
this.RequestedRoomTypeCode = requestedRoomTypeCode;
this.CheckIn = checkIn;
this.CheckOut = checkOut;
}
public FlightPaymentViewModel(int referenceNumber, CreditCardViewModel creditCard, MvcApplication1.BookingService.PassengerModel[] passengers, MvcApplication1.AirportService.FlightModel flight, char travelClass)
{
this.ReferenceNumber = referenceNumber;
this.CreditCard = creditCard;
this.Passengers = passengers;
this.Flight = flight;
this.TravelClass = travelClass;
}
public FlightQueryViewModel(MvcApplication1.AirportService.FlightModel[] flights, int seats)
{
this.Airports = null;
this.DepartureDate = DateTime.Now;
this.DepartureAirportCode = String.Empty;
this.ArrivalAirportCode = String.Empty;
this.Seats = seats;
this.Flights = flights;
}
public HotelPaymentViewModel(int referenceNumber, CreditCardViewModel creditCard, MvcApplication1.BookingService.PassengerModel[] passengers, MvcApplication1.HotelService.HotelModel hotel, String roomTypeCode, DateTime checkIn, DateTime checkOut, int roomsRequested)
{
this.ReferenceNumber = referenceNumber;
this.CreditCard = creditCard;
this.Passengers = passengers;
this.Hotel = hotel;
this.RoomTypeCode = roomTypeCode;
this.CheckIn = checkIn;
this.CheckOut = checkOut;
this.RoomsRequested = roomsRequested;
}
private MvcApplication1.AirportService.FlightModel[] FilterBySeats(MvcApplication1.AirportService.FlightModel[] flights, int seats)
{
var f = new List<MvcApplication1.AirportService.FlightModel>();
foreach (var flight in flights)
{
if (flight.TravelClasses.Where(m => (m.Capacity - m.Taken) >= seats).Count() > 0)
{
f.Add(flight);
}
}
return f.ToArray<MvcApplication1.AirportService.FlightModel>();
}
private String CreateReceiptEmailBody(MvcApplication1.BookingService.BookingModel booking, MvcApplication1.AirportService.FlightModel flight)
{
var travelClass = flight.TravelClasses.Where(m => m.ClassCode == booking.TravelClassCode).FirstOrDefault<MvcApplication1.AirportService.TravelClass>();
var emailBody = new StringBuilder();
emailBody.AppendLine("Reference Number: " + booking.ReferenceNumber);
emailBody.AppendLine("Flight Number: " + flight.FlightNumber);
emailBody.AppendLine("Aircraft " + flight.Aircraft);
emailBody.AppendLine("Airline: " + flight.Airline);
emailBody.AppendLine("Airline Code: " + flight.AirlineCode);
emailBody.AppendLine("Origin Airport: " + flight.OriginAirport);
emailBody.AppendLine("Origin Country: " + flight.OriginCountry);
emailBody.AppendLine("Departure Time: " + flight.DepartureTime);
emailBody.AppendLine("Destination Airport: " + flight.DestinationAirport);
emailBody.AppendLine("Destination Country: " + flight.DestinationCountry);
emailBody.AppendLine("Arrival Time: " + flight.ArrivalTime);
emailBody.AppendLine("Travel Class: " + travelClass.ClassName);
emailBody.AppendLine("Cost: " + travelClass.Cost.ToString("C"));
emailBody.AppendLine("Seats Requested: " + booking.Passengers.Length);
emailBody.AppendLine("Total: " + (travelClass.Cost * booking.Passengers.Length).ToString("C"));
for (var i = 0; i < booking.Passengers.Length; i++)
{
emailBody.AppendLine("Passenger " + i + 1);
emailBody.AppendLine("Passport Number: " + booking.Passengers[i].PassportNumber);
emailBody.AppendLine("Title: " + booking.Passengers[i].Title);
emailBody.AppendLine("First Name: " + booking.Passengers[i].FirstName);
emailBody.AppendLine("Last Name: " + booking.Passengers[i].LastName);
emailBody.AppendLine("Date of Birth: " + booking.Passengers[i].DateOfBirth);
emailBody.AppendLine("Address: " + booking.Passengers[i].Address);
emailBody.AppendLine("City: " + booking.Passengers[i].City);
emailBody.AppendLine("State: " + booking.Passengers[i].State);
emailBody.AppendLine("Postal Code: " + booking.Passengers[i].PostalCode);
emailBody.AppendLine("Phone: " + booking.Passengers[i].Phone);
emailBody.AppendLine("Email: " + booking.Passengers[i].Email);
}
return emailBody.ToString();
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MvcApplication1.Model.Student model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Student set ");
strSql.Append("LastName=@LastName,");
strSql.Append("FirstMidName=@FirstMidName,");
strSql.Append("EnrollmentDate=@EnrollmentDate,");
strSql.Append("age=@age");
strSql.Append(" where StudentID=@StudentID");
SqlParameter[] parameters = {
new SqlParameter("@LastName", SqlDbType.NVarChar,50),
new SqlParameter("@FirstMidName", SqlDbType.NVarChar,50),
new SqlParameter("@EnrollmentDate", SqlDbType.DateTime),
new SqlParameter("@age", SqlDbType.Int,4),
new SqlParameter("@StudentID", SqlDbType.Int,4)};
parameters[0].Value = model.LastName;
parameters[1].Value = model.FirstMidName;
parameters[2].Value = model.EnrollmentDate;
parameters[3].Value = model.age;
parameters[4].Value = model.StudentID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MvcApplication1.Model.Student model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MvcApplication1.Model.Student model)
{
return dal.Update(model);
}
public ReviewFlightViewModel(MvcApplication1.AirportService.FlightModel flight, int seats)
{
this.Flight = flight;
this.Seats = seats;
}
private String CreateReceiptEmailBody(MvcApplication1.BookingService.ReservationModel booking, MvcApplication1.HotelService.HotelModel hotel)
{
var roomType = hotel.Rooms.Where(m => m.Code == booking.RoomTypeCode).FirstOrDefault<MvcApplication1.HotelService.RoomType>();
var emailBody = new StringBuilder();
emailBody.AppendLine("Reference Number: " + booking.ReferenceNumber);
emailBody.AppendLine("Hotel: " + hotel.Name);
emailBody.AppendLine("Address: " + hotel.Address);
emailBody.AppendLine("Country: " + hotel.Country);
emailBody.AppendLine("Check-In Date: " + booking.CheckIn.ToString("d"));
emailBody.AppendLine("Check-Out Date: " + booking.CheckOut.ToString("d"));
emailBody.AppendLine("Room Type: " + roomType.Type);
emailBody.AppendLine("Cost: " + roomType.Rates.ToString("C"));
emailBody.AppendLine("Rooms Requested: " + booking.RoomsRequested);
emailBody.AppendLine("Total: " + (roomType.Rates * booking.RoomsRequested).ToString("C"));
for (var i = 0; i < booking.Passengers.Length; i++)
{
emailBody.AppendLine("Passenger " + i + 1);
emailBody.AppendLine("Passport Number: " + booking.Passengers[i].PassportNumber);
emailBody.AppendLine("Title: " + booking.Passengers[i].Title);
emailBody.AppendLine("First Name: " + booking.Passengers[i].FirstName);
emailBody.AppendLine("Last Name: " + booking.Passengers[i].LastName);
emailBody.AppendLine("Date of Birth: " + booking.Passengers[i].DateOfBirth);
emailBody.AppendLine("Address: " + booking.Passengers[i].Address);
emailBody.AppendLine("City: " + booking.Passengers[i].City);
emailBody.AppendLine("State: " + booking.Passengers[i].State);
emailBody.AppendLine("Postal Code: " + booking.Passengers[i].PostalCode);
emailBody.AppendLine("Phone: " + booking.Passengers[i].Phone);
emailBody.AppendLine("Email: " + booking.Passengers[i].Email);
}
return emailBody.ToString();
}
