public Save ( Microsoft.Practices.EnterpriseLibrary.Data.Database db, |
||
db | Microsoft.Practices.EnterpriseLibrary.Data.Database | |
transaction | ||
return | bool |
public bool Insert(Reservation reservation, Database db, DbTransaction transaction) { DbCommand command = db.GetStoredProcCommand("usp_ReservationInsert"); db.AddInParameter(command, "@CompanyId", DbType.Int32, reservation.CompanyId); db.AddInParameter(command, "@CustomerId", DbType.Int32, reservation.CustomerId); db.AddInParameter(command, "@StatusId", DbType.Int32, reservation.StatusId); db.AddInParameter(command, "@CheckInDate", DbType.DateTime, reservation.CheckInDate); db.AddInParameter(command, "@CheckOutDate", DbType.DateTime, reservation.CheckOutDate); db.AddInParameter(command, "@SourceId", DbType.Int32, reservation.SourceId); db.AddInParameter(command, "@RoomTotal", DbType.Decimal, reservation.RoomTotal); db.AddInParameter(command, "@ServiceTotal", DbType.Decimal, reservation.ServiceTotal); db.AddInParameter(command, "@NetTotal", DbType.Decimal, reservation.NetTotal); db.AddInParameter(command, "@Discount", DbType.Decimal, reservation.Discount); db.AddInParameter(command, "@TaxAmount", DbType.Decimal, reservation.TaxAmount); db.AddInParameter(command, "@PaidAmount", DbType.Decimal, reservation.PaidAmount); db.AddInParameter(command, "@Total", DbType.Decimal, reservation.Total); db.AddInParameter(command, "@Balance", DbType.Decimal, reservation.Balance); db.AddInParameter(command, "@CreatedUser", DbType.Int32, reservation.CreatedUser); db.AddInParameter(command, "@TaxTypeId", DbType.Int32, reservation.TaxTypeId); db.AddInParameter(command, "@TaxPercentage", DbType.Decimal, reservation.TaxPercentage); db.AddOutParameter(command, "@NewReservationId", DbType.Int32, 8); db.ExecuteNonQuery(command); //Int32 newReservationId = Convert.ToInt32(db.GetParameterValue(command, "@NewReservationId")); reservation.ReservationId = Convert.ToInt32(db.GetParameterValue(command, "@NewReservationId")); ReservationRoom reservationRoom = new ReservationRoom(); reservationRoom.ReservationId = reservation.ReservationId; reservationRoom.ReservationRoomList = reservation.ReservationRoomDataSet; reservationRoom.Save(db, transaction); ReservationAdditionalService reservationAddtionalService = new ReservationAdditionalService(); reservationAddtionalService.ReservationId = reservation.ReservationId; reservationAddtionalService.ReservationAdditionalServiceList = reservation.ReservationAdditionalServiceDataSet; reservationAddtionalService.Save(db, transaction); ReservationPayments reservationPayments = new ReservationPayments(); reservationPayments.ReservationId = reservation.ReservationId; reservationPayments.ReservationPaymentList = reservation.ReservationPaymentDataSet; reservationPayments.Save(db, transaction); return(true); }
public bool Insert(Reservation reservation, Database db, DbTransaction transaction) { DbCommand command = db.GetStoredProcCommand("usp_ReservationInsert"); db.AddInParameter(command, "@CompanyId", DbType.Int32, reservation.CompanyId); db.AddInParameter(command, "@CustomerId", DbType.Int32, reservation.CustomerId); db.AddInParameter(command, "@StatusId", DbType.Int32, reservation.StatusId); db.AddInParameter(command, "@CheckInDate", DbType.DateTime, reservation.CheckInDate); db.AddInParameter(command, "@CheckOutDate", DbType.DateTime, reservation.CheckOutDate); db.AddInParameter(command, "@SourceId", DbType.Int32, reservation.SourceId); db.AddInParameter(command, "@RoomTotal", DbType.Decimal, reservation.RoomTotal); db.AddInParameter(command, "@ServiceTotal", DbType.Decimal, reservation.ServiceTotal); db.AddInParameter(command, "@NetTotal", DbType.Decimal, reservation.NetTotal); db.AddInParameter(command, "@Discount", DbType.Decimal, reservation.Discount); db.AddInParameter(command, "@TaxAmount", DbType.Decimal, reservation.TaxAmount); db.AddInParameter(command, "@PaidAmount", DbType.Decimal, reservation.PaidAmount); db.AddInParameter(command, "@Total", DbType.Decimal, reservation.Total); db.AddInParameter(command, "@Balance", DbType.Decimal, reservation.Balance); db.AddInParameter(command, "@CreatedUser", DbType.Int32, reservation.CreatedUser); db.AddInParameter(command, "@TaxTypeId", DbType.Int32, reservation.TaxTypeId); db.AddInParameter(command, "@TaxPercentage", DbType.Decimal, reservation.TaxPercentage); db.AddOutParameter(command, "@NewReservationId", DbType.Int32,8); db.ExecuteNonQuery(command); //Int32 newReservationId = Convert.ToInt32(db.GetParameterValue(command, "@NewReservationId")); reservation.ReservationId = Convert.ToInt32(db.GetParameterValue(command, "@NewReservationId")); ReservationRoom reservationRoom = new ReservationRoom(); reservationRoom.ReservationId = reservation.ReservationId; reservationRoom.ReservationRoomList = reservation.ReservationRoomDataSet; reservationRoom.Save(db, transaction); ReservationAdditionalService reservationAddtionalService = new ReservationAdditionalService(); reservationAddtionalService.ReservationId = reservation.ReservationId; reservationAddtionalService.ReservationAdditionalServiceList = reservation.ReservationAdditionalServiceDataSet; reservationAddtionalService.Save(db, transaction); ReservationPayments reservationPayments = new ReservationPayments(); reservationPayments.ReservationId = reservation.ReservationId; reservationPayments.ReservationPaymentList = reservation.ReservationPaymentDataSet; reservationPayments.Save(db, transaction); return true; }