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