private void ShowReservationInvoice() { xrReservation reservationInvoiceReport = new xrReservation(); if (Request.QueryString["ReservationID"] == null || Request.QueryString["ReservationID"] == string.Empty) { return; } ResMan.Reservation reservation = new ResMan.Reservation(); reservation.ReservationId = Convert.ToInt64(Request.QueryString["ReservationID"].ToString()); reservation = reservation.Select(); reservationInvoiceReport.xrCellInvoiceNo.Text = "Invoice No - INV" + reservation.ReservationId.ToString(); reservationInvoiceReport.xrCellInvoiceDate.Text = "Invoice Date - " + DateTime.Now.ToString(); reservationInvoiceReport.xrCellReservationCode.Text = "Code - " + reservation.ReservationCode; reservationInvoiceReport.xrCellReservationDate.Text = "Booking Date - " + reservation.BookingDate.ToString(); StringBuilder sbCustomer = new StringBuilder(); sbCustomer.Append(reservation.CustomerName + Environment.NewLine); sbCustomer.Append(reservation.BillingAddressLine1 + Environment.NewLine); sbCustomer.Append(reservation.BillingAddressLine2 + Environment.NewLine); sbCustomer.Append(reservation.BillingCity + ", "); sbCustomer.Append(reservation.BillingPostCode + Environment.NewLine); sbCustomer.Append(reservation.BillingState + ", " + reservation.CountryName); reservationInvoiceReport.xrCellCustomer.Text = sbCustomer.ToString(); Company company = new Company(); company.CompanyId = SessionHandler.CurrentCompanyId; company = company.Select(); if (company.CompanyLogo != null) { reservationInvoiceReport.xrPbLogo.Image = (Bitmap)((new ImageConverter()).ConvertFrom(company.CompanyLogo));; } reservationInvoiceReport.xrCellCompanyName.Text = company.CompanyName; StringBuilder sbCompany = new StringBuilder(); sbCompany.Append(company.CompanyAddress + Environment.NewLine); sbCompany.Append(company.CompanyCity + Environment.NewLine); sbCompany.Append(company.CompanyEmail + Environment.NewLine); sbCompany.Append("Tel - " + company.CompanyTelephone + Environment.NewLine); sbCompany.Append("Fax - " + company.CompanyFax); reservationInvoiceReport.xrCellCompnayAddress.Text = sbCompany.ToString(); DataSet dsRoomInfo = new DataSet(); dsRoomInfo = reservation.ReservationRoomDataSet; //// Room info section if (dsRoomInfo != null && dsRoomInfo.Tables.Count > 0 && dsRoomInfo.Tables[0] != null && dsRoomInfo.Tables[0].Rows.Count > 0) { decimal roomInfoTotal; roomInfoTotal = 0; for (int i = 0; i <= dsRoomInfo.Tables[0].Rows.Count - 1; i++) { if (i == 0) { reservationInvoiceReport.xrCellCustomerName.Text = dsRoomInfo.Tables[0].Rows[i]["Sharers"] != null ? dsRoomInfo.Tables[0].Rows[i]["Sharers"].ToString() : string.Empty; reservationInvoiceReport.xrCellCheckIn.Text = dsRoomInfo.Tables[0].Rows[i]["CheckInDate"] != null?Convert.ToDateTime(dsRoomInfo.Tables[0].Rows[i]["CheckInDate"].ToString()).ToShortDateString() : string.Empty; reservationInvoiceReport.xrCellCheckOut.Text = dsRoomInfo.Tables[0].Rows[i]["CheckOutDate"] != null?Convert.ToDateTime(dsRoomInfo.Tables[0].Rows[i]["CheckOutDate"].ToString()).ToShortDateString() : string.Empty; reservationInvoiceReport.xrCellRoom.Text = dsRoomInfo.Tables[0].Rows[i]["RoomName"] != null ? dsRoomInfo.Tables[0].Rows[i]["RoomName"].ToString() : string.Empty; reservationInvoiceReport.xrCellRate.Text = dsRoomInfo.Tables[0].Rows[i]["Rate"] != null ? dsRoomInfo.Tables[0].Rows[i]["Rate"].ToString() : string.Empty; reservationInvoiceReport.xrCellNights.Text = dsRoomInfo.Tables[0].Rows[i]["Days"] != null ? dsRoomInfo.Tables[0].Rows[i]["Days"].ToString() : string.Empty; reservationInvoiceReport.xrCellAmount.Text = dsRoomInfo.Tables[0].Rows[i]["Amount"] != null ? dsRoomInfo.Tables[0].Rows[i]["Amount"].ToString() : string.Empty; roomInfoTotal = Convert.ToDecimal(reservationInvoiceReport.xrCellAmount.Text); } else { XRTableCell cell1 = new XRTableCell(); XRTableCell cell2 = new XRTableCell(); XRTableCell cell3 = new XRTableCell(); XRTableCell cell4 = new XRTableCell(); XRTableCell cell5 = new XRTableCell(); XRTableCell cell6 = new XRTableCell(); XRTableCell cell7 = new XRTableCell(); cell1.Text = dsRoomInfo.Tables[0].Rows[i]["Sharers"] != null ? dsRoomInfo.Tables[0].Rows[i]["Sharers"].ToString() : string.Empty; cell2.Text = dsRoomInfo.Tables[0].Rows[i]["CheckInDate"] != null?Convert.ToDateTime(dsRoomInfo.Tables[0].Rows[i]["CheckInDate"].ToString()).ToShortDateString() : string.Empty; cell3.Text = dsRoomInfo.Tables[0].Rows[i]["CheckOutDate"] != null?Convert.ToDateTime(dsRoomInfo.Tables[0].Rows[i]["CheckOutDate"].ToString()).ToShortDateString() : string.Empty; cell4.Text = dsRoomInfo.Tables[0].Rows[i]["RoomName"] != null ? dsRoomInfo.Tables[0].Rows[i]["RoomName"].ToString() : string.Empty; cell5.Text = dsRoomInfo.Tables[0].Rows[i]["Rate"] != null ? dsRoomInfo.Tables[0].Rows[i]["Rate"].ToString() : string.Empty; cell6.Text = dsRoomInfo.Tables[0].Rows[i]["Days"] != null ? dsRoomInfo.Tables[0].Rows[i]["Days"].ToString() : string.Empty; cell7.Text = dsRoomInfo.Tables[0].Rows[i]["Amount"] != null ? dsRoomInfo.Tables[0].Rows[i]["Amount"].ToString() : string.Empty; roomInfoTotal = roomInfoTotal + Convert.ToDecimal(cell7.Text); XRTableRow dataRow = new XRTableRow(); dataRow.Cells.Add(cell1); dataRow.Cells.Add(cell2); dataRow.Cells.Add(cell3); dataRow.Cells.Add(cell4); dataRow.Cells.Add(cell5); dataRow.Cells.Add(cell6); dataRow.Cells.Add(cell7); cell1.WidthF = reservationInvoiceReport.xrCellCustomerName.WidthF; cell2.WidthF = reservationInvoiceReport.xrCellCheckIn.WidthF; cell3.WidthF = reservationInvoiceReport.xrCellCheckOut.WidthF; cell4.WidthF = reservationInvoiceReport.xrCellRoom.WidthF; cell5.WidthF = reservationInvoiceReport.xrCellRate.WidthF; cell6.WidthF = reservationInvoiceReport.xrCellNights.WidthF; cell7.WidthF = reservationInvoiceReport.xrCellAmount.WidthF; cell1.TextAlignment = reservationInvoiceReport.xrCellCustomerName.TextAlignment; cell7.TextAlignment = reservationInvoiceReport.xrCellAmount.TextAlignment; reservationInvoiceReport.xrTableRoomInfo.Rows.Add(dataRow); } } //// Add total row XRTableCell cellFooter1 = new XRTableCell(); XRTableCell cellFooter2 = new XRTableCell(); cellFooter1.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cellFooter2.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); XRTableRow tableRowFooter = new XRTableRow(); cellFooter1.WidthF = reservationInvoiceReport.xrCellCustomerName.WidthF + reservationInvoiceReport.xrCellCheckIn.WidthF + reservationInvoiceReport.xrCellCheckOut.WidthF + reservationInvoiceReport.xrCellRoom.WidthF + reservationInvoiceReport.xrCellRate.WidthF + reservationInvoiceReport.xrCellNights.WidthF; cellFooter2.WidthF = reservationInvoiceReport.xrCellAmount.WidthF; cellFooter1.Text = "Room Total"; cellFooter1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; cellFooter2.Text = roomInfoTotal.ToString(); cellFooter2.TextAlignment = reservationInvoiceReport.xrCellAmount.TextAlignment; tableRowFooter.Cells.Add(cellFooter1); tableRowFooter.Cells.Add(cellFooter2); reservationInvoiceReport.xrTableRoomInfo.Rows.Add(tableRowFooter); XRTableCell blankCell = new XRTableCell(); blankCell.Text = " "; blankCell.BackColor = System.Drawing.Color.LightGray; XRTableRow blankRow = new XRTableRow(); blankRow.Cells.Add(blankCell); reservationInvoiceReport.xrTableRoomInfo.Rows.Add(blankRow); } //// Additional Service section DataSet dsAdditionalService = new DataSet(); dsAdditionalService = reservation.ReservationAdditionalServiceDataSet; if (dsAdditionalService != null && dsAdditionalService.Tables.Count > 0 && dsAdditionalService.Tables[0] != null && dsAdditionalService.Tables[0].Rows.Count > 0) { XRTableCell cell1 = new XRTableCell(); XRTableCell cell2 = new XRTableCell(); XRTableCell cell3 = new XRTableCell(); cell1.Text = "Service Type"; cell2.Text = "Note"; cell3.Text = "Amount"; cell1.WidthF = reservationInvoiceReport.xrCellCustomerName.WidthF; cell2.WidthF = reservationInvoiceReport.xrCellCheckIn.WidthF + reservationInvoiceReport.xrCellCheckOut.WidthF + reservationInvoiceReport.xrCellRoom.WidthF + reservationInvoiceReport.xrCellRate.WidthF + reservationInvoiceReport.xrCellNights.WidthF; cell3.WidthF = reservationInvoiceReport.xrCellAmount.WidthF; cell1.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cell2.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cell3.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); XRTableRow headerRow = new XRTableRow(); headerRow.Cells.Add(cell1); headerRow.Cells.Add(cell2); headerRow.Cells.Add(cell3); reservationInvoiceReport.xrTableRoomInfo.Rows.Add(headerRow); decimal serviceTotal; serviceTotal = 0; for (int i = 0; i <= dsAdditionalService.Tables[0].Rows.Count - 1; i++) { XRTableCell dataCell1 = new XRTableCell(); XRTableCell dataCell2 = new XRTableCell(); XRTableCell dataCell3 = new XRTableCell(); dataCell1.Text = dsAdditionalService.Tables[0].Rows[i]["ServiceName"] != null ? dsAdditionalService.Tables[0].Rows[i]["ServiceName"].ToString() : string.Empty; dataCell2.Text = dsAdditionalService.Tables[0].Rows[i]["Note"] != null ? dsAdditionalService.Tables[0].Rows[i]["Note"].ToString() : string.Empty; dataCell3.Text = dsAdditionalService.Tables[0].Rows[i]["Amount"] != null ? dsAdditionalService.Tables[0].Rows[i]["Amount"].ToString() : string.Empty; serviceTotal = serviceTotal + Convert.ToDecimal(dataCell3.Text); dataCell1.WidthF = reservationInvoiceReport.xrCellCustomerName.WidthF; dataCell2.WidthF = reservationInvoiceReport.xrCellCheckIn.WidthF + reservationInvoiceReport.xrCellCheckOut.WidthF + reservationInvoiceReport.xrCellRoom.WidthF + reservationInvoiceReport.xrCellRate.WidthF + reservationInvoiceReport.xrCellNights.WidthF; dataCell3.WidthF = reservationInvoiceReport.xrCellAmount.WidthF; dataCell3.TextAlignment = reservationInvoiceReport.xrCellAmount.TextAlignment; XRTableRow dataRow = new XRTableRow(); dataRow.Cells.Add(dataCell1); dataRow.Cells.Add(dataCell2); dataRow.Cells.Add(dataCell3); reservationInvoiceReport.xrTableRoomInfo.Rows.Add(dataRow); } XRTableCell cellFooter1 = new XRTableCell(); XRTableCell cellFooter2 = new XRTableCell(); cellFooter1.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cellFooter2.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); XRTableRow tableRowFooter = new XRTableRow(); cellFooter1.WidthF = reservationInvoiceReport.xrCellCustomerName.WidthF + reservationInvoiceReport.xrCellCheckIn.WidthF + reservationInvoiceReport.xrCellCheckOut.WidthF + reservationInvoiceReport.xrCellRoom.WidthF + reservationInvoiceReport.xrCellRate.WidthF + reservationInvoiceReport.xrCellNights.WidthF; cellFooter2.WidthF = reservationInvoiceReport.xrCellAmount.WidthF; cellFooter1.Text = "Service Total"; cellFooter1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; cellFooter2.Text = serviceTotal.ToString(); cellFooter2.TextAlignment = reservationInvoiceReport.xrCellAmount.TextAlignment; tableRowFooter.Cells.Add(cellFooter1); tableRowFooter.Cells.Add(cellFooter2); reservationInvoiceReport.xrTableRoomInfo.Rows.Add(tableRowFooter); XRTableCell blankCell1 = new XRTableCell(); blankCell1.Text = " "; blankCell1.BackColor = System.Drawing.Color.LightGray; XRTableRow blankRow1 = new XRTableRow(); blankRow1.Cells.Add(blankCell1); reservationInvoiceReport.xrTableRoomInfo.Rows.Add(blankRow1); } //// Display Net Total XRTableRow tableRowNetTotal = new XRTableRow(); XRTableCell cellNetTotal1 = new XRTableCell(); XRTableCell cellNetTotal2 = new XRTableCell(); cellNetTotal1.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cellNetTotal2.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cellNetTotal1.Text = "Net Total"; cellNetTotal2.Text = reservation.NetTotal.ToString(); cellNetTotal1.WidthF = reservationInvoiceReport.xrCellCustomerName.WidthF + reservationInvoiceReport.xrCellCheckIn.WidthF + reservationInvoiceReport.xrCellCheckOut.WidthF + reservationInvoiceReport.xrCellRoom.WidthF + reservationInvoiceReport.xrCellRate.WidthF + reservationInvoiceReport.xrCellNights.WidthF; cellNetTotal2.WidthF = reservationInvoiceReport.xrCellAmount.WidthF; cellNetTotal1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; cellNetTotal2.TextAlignment = reservationInvoiceReport.xrCellAmount.TextAlignment; tableRowNetTotal.Cells.Add(cellNetTotal1); tableRowNetTotal.Cells.Add(cellNetTotal2); reservationInvoiceReport.xrTableRoomInfo.Rows.Add(tableRowNetTotal); //// Display Discount XRTableRow tableRowDiscount = new XRTableRow(); XRTableCell cellDiscount1 = new XRTableCell(); XRTableCell cellDiscount2 = new XRTableCell(); cellDiscount1.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cellDiscount2.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cellDiscount1.Text = "Discount"; cellDiscount2.Text = reservation.Discount.ToString(); cellDiscount1.WidthF = reservationInvoiceReport.xrCellCustomerName.WidthF + reservationInvoiceReport.xrCellCheckIn.WidthF + reservationInvoiceReport.xrCellCheckOut.WidthF + reservationInvoiceReport.xrCellRoom.WidthF + reservationInvoiceReport.xrCellRate.WidthF + reservationInvoiceReport.xrCellNights.WidthF; cellDiscount2.WidthF = reservationInvoiceReport.xrCellAmount.WidthF; cellDiscount1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; cellDiscount2.TextAlignment = reservationInvoiceReport.xrCellAmount.TextAlignment; tableRowDiscount.Cells.Add(cellDiscount1); tableRowDiscount.Cells.Add(cellDiscount2); reservationInvoiceReport.xrTableRoomInfo.Rows.Add(tableRowDiscount); //// Display Tax Amount XRTableRow tableRowTaxType = new XRTableRow(); XRTableCell cellTaxType1 = new XRTableCell(); XRTableCell cellTaxType2 = new XRTableCell(); cellTaxType1.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cellTaxType2.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cellTaxType1.Text = "Tax Amount"; cellTaxType2.Text = reservation.TaxAmount.ToString(); cellTaxType1.WidthF = reservationInvoiceReport.xrCellCustomerName.WidthF + reservationInvoiceReport.xrCellCheckIn.WidthF + reservationInvoiceReport.xrCellCheckOut.WidthF + reservationInvoiceReport.xrCellRoom.WidthF + reservationInvoiceReport.xrCellRate.WidthF + reservationInvoiceReport.xrCellNights.WidthF; cellTaxType2.WidthF = reservationInvoiceReport.xrCellAmount.WidthF; cellTaxType1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; cellTaxType2.TextAlignment = reservationInvoiceReport.xrCellAmount.TextAlignment; tableRowTaxType.Cells.Add(cellTaxType1); tableRowTaxType.Cells.Add(cellTaxType2); reservationInvoiceReport.xrTableRoomInfo.Rows.Add(tableRowTaxType); //// Display Total XRTableRow tableRowTotal = new XRTableRow(); XRTableCell cellTotal1 = new XRTableCell(); XRTableCell cellTotal2 = new XRTableCell(); cellTotal1.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cellTotal2.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cellTotal1.Text = "Total"; cellTotal2.Text = reservation.Total.ToString(); cellTotal1.WidthF = reservationInvoiceReport.xrCellCustomerName.WidthF + reservationInvoiceReport.xrCellCheckIn.WidthF + reservationInvoiceReport.xrCellCheckOut.WidthF + reservationInvoiceReport.xrCellRoom.WidthF + reservationInvoiceReport.xrCellRate.WidthF + reservationInvoiceReport.xrCellNights.WidthF; cellTotal2.WidthF = reservationInvoiceReport.xrCellAmount.WidthF; cellTotal1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; cellTotal2.TextAlignment = reservationInvoiceReport.xrCellAmount.TextAlignment; tableRowTotal.Cells.Add(cellTotal1); tableRowTotal.Cells.Add(cellTotal2); reservationInvoiceReport.xrTableRoomInfo.Rows.Add(tableRowTotal); //// Display Paid Amount XRTableRow tableRowPaidAmount = new XRTableRow(); XRTableCell cellPaidAmount1 = new XRTableCell(); XRTableCell cellPaidAmount2 = new XRTableCell(); cellPaidAmount1.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cellPaidAmount2.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cellPaidAmount1.Text = "Paid Amount"; cellPaidAmount2.Text = reservation.PaidAmount.ToString(); cellPaidAmount1.WidthF = reservationInvoiceReport.xrCellCustomerName.WidthF + reservationInvoiceReport.xrCellCheckIn.WidthF + reservationInvoiceReport.xrCellCheckOut.WidthF + reservationInvoiceReport.xrCellRoom.WidthF + reservationInvoiceReport.xrCellRate.WidthF + reservationInvoiceReport.xrCellNights.WidthF; cellPaidAmount2.WidthF = reservationInvoiceReport.xrCellAmount.WidthF; cellPaidAmount1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; cellPaidAmount2.TextAlignment = reservationInvoiceReport.xrCellAmount.TextAlignment; tableRowPaidAmount.Cells.Add(cellPaidAmount1); tableRowPaidAmount.Cells.Add(cellPaidAmount2); reservationInvoiceReport.xrTableRoomInfo.Rows.Add(tableRowPaidAmount); //// Display Balance XRTableRow tableRowBalance = new XRTableRow(); XRTableCell cellBalance1 = new XRTableCell(); XRTableCell cellBalance2 = new XRTableCell(); cellBalance1.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cellBalance2.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cellBalance1.Text = "Balance"; cellBalance2.Text = reservation.Balance.ToString(); cellBalance1.WidthF = reservationInvoiceReport.xrCellCustomerName.WidthF + reservationInvoiceReport.xrCellCheckIn.WidthF + reservationInvoiceReport.xrCellCheckOut.WidthF + reservationInvoiceReport.xrCellRoom.WidthF + reservationInvoiceReport.xrCellRate.WidthF + reservationInvoiceReport.xrCellNights.WidthF; cellBalance2.WidthF = reservationInvoiceReport.xrCellAmount.WidthF; cellBalance1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; cellBalance2.TextAlignment = reservationInvoiceReport.xrCellAmount.TextAlignment; tableRowBalance.Cells.Add(cellBalance1); tableRowBalance.Cells.Add(cellBalance2); reservationInvoiceReport.xrTableRoomInfo.Rows.Add(tableRowBalance); //// Payment section DataSet dsPaymentSection = new DataSet(); dsPaymentSection = reservation.ReservationPaymentDataSet; if (dsPaymentSection != null && dsPaymentSection.Tables.Count > 0 && dsPaymentSection.Tables[0] != null && dsPaymentSection.Tables[0].Rows.Count > 0) { XRTableCell blankCell = new XRTableCell(); blankCell.Text = " "; blankCell.BackColor = System.Drawing.Color.LightGray; XRTableRow blankRow = new XRTableRow(); blankRow.Cells.Add(blankCell); reservationInvoiceReport.xrTableRoomInfo.Rows.Add(blankRow); XRTableCell cell1 = new XRTableCell(); XRTableCell cell2 = new XRTableCell(); XRTableCell cell3 = new XRTableCell(); XRTableCell cell4 = new XRTableCell(); XRTableCell cell5 = new XRTableCell(); XRTableCell cell6 = new XRTableCell(); cell1.Text = "Type"; cell2.Text = "Payment Date"; cell3.Text = "Card Type"; cell4.Text = "Card No"; cell5.Text = "Name on Card"; cell6.Text = "Amount"; cell1.WidthF = 110; cell2.WidthF = 126; cell3.WidthF = 99; cell4.WidthF = 161; cell5.WidthF = 168; cell6.WidthF = 117; cell1.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cell2.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cell3.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cell4.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cell5.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cell6.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); XRTableRow headerRow = new XRTableRow(); headerRow.Cells.Add(cell1); headerRow.Cells.Add(cell2); headerRow.Cells.Add(cell3); headerRow.Cells.Add(cell4); headerRow.Cells.Add(cell5); headerRow.Cells.Add(cell6); reservationInvoiceReport.xrTableRoomInfo.Rows.Add(headerRow); decimal paymentTotal; paymentTotal = 0; for (int i = 0; i <= dsPaymentSection.Tables[0].Rows.Count - 1; i++) { XRTableCell dataCell1 = new XRTableCell(); XRTableCell dataCell2 = new XRTableCell(); XRTableCell dataCell3 = new XRTableCell(); XRTableCell dataCell4 = new XRTableCell(); XRTableCell dataCell5 = new XRTableCell(); XRTableCell dataCell6 = new XRTableCell(); dataCell1.Text = dsPaymentSection.Tables[0].Rows[i]["PaymentTypeName"] != null ? dsPaymentSection.Tables[0].Rows[i]["PaymentTypeName"].ToString() : string.Empty; dataCell2.Text = dsPaymentSection.Tables[0].Rows[i]["PaymentDate"] != null?Convert.ToDateTime(dsPaymentSection.Tables[0].Rows[i]["PaymentDate"].ToString()).ToShortDateString() : string.Empty; dataCell3.Text = dsPaymentSection.Tables[0].Rows[i]["Name"] != null ? dsPaymentSection.Tables[0].Rows[i]["Name"].ToString() : string.Empty; dataCell4.Text = dsPaymentSection.Tables[0].Rows[i]["CCNo"] != null ? dsPaymentSection.Tables[0].Rows[i]["CCNo"].ToString() : string.Empty; dataCell5.Text = dsPaymentSection.Tables[0].Rows[i]["CCNameOnCard"] != null ? dsPaymentSection.Tables[0].Rows[i]["CCNameOnCard"].ToString() : string.Empty; dataCell6.Text = dsPaymentSection.Tables[0].Rows[i]["Amount"] != null ? dsPaymentSection.Tables[0].Rows[i]["Amount"].ToString() : string.Empty; paymentTotal = paymentTotal + Convert.ToDecimal(dataCell6.Text); dataCell1.WidthF = 110; dataCell2.WidthF = 126; dataCell3.WidthF = 99; dataCell4.WidthF = 161; dataCell5.WidthF = 168; dataCell6.WidthF = 117; dataCell6.TextAlignment = reservationInvoiceReport.xrCellAmount.TextAlignment; XRTableRow dataRow = new XRTableRow(); dataRow.Cells.Add(dataCell1); dataRow.Cells.Add(dataCell2); dataRow.Cells.Add(dataCell3); dataRow.Cells.Add(dataCell4); dataRow.Cells.Add(dataCell5); dataRow.Cells.Add(dataCell6); reservationInvoiceReport.xrTableRoomInfo.Rows.Add(dataRow); } XRTableCell cellFooter1 = new XRTableCell(); XRTableCell cellFooter2 = new XRTableCell(); cellFooter1.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cellFooter2.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); XRTableRow tableRowFooter = new XRTableRow(); cellFooter1.WidthF = reservationInvoiceReport.xrCellCustomerName.WidthF + reservationInvoiceReport.xrCellCheckIn.WidthF + reservationInvoiceReport.xrCellCheckOut.WidthF + reservationInvoiceReport.xrCellRoom.WidthF + reservationInvoiceReport.xrCellRate.WidthF + reservationInvoiceReport.xrCellNights.WidthF; cellFooter2.WidthF = reservationInvoiceReport.xrCellAmount.WidthF; cellFooter1.Text = "Total"; cellFooter1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; cellFooter2.Text = paymentTotal.ToString(); cellFooter2.TextAlignment = reservationInvoiceReport.xrCellAmount.TextAlignment; tableRowFooter.Cells.Add(cellFooter1); tableRowFooter.Cells.Add(cellFooter2); reservationInvoiceReport.xrTableRoomInfo.Rows.Add(tableRowFooter); } rvReportViewer.Report = reservationInvoiceReport; }
private void ShowReservationInvoice() { xrReservation reservationInvoiceReport = new xrReservation(); if (Request.QueryString["ReservationID"] == null || Request.QueryString["ReservationID"] == string.Empty) { return; } ResMan.Reservation reservation = new ResMan.Reservation(); reservation.ReservationId = Convert.ToInt64(Request.QueryString["ReservationID"].ToString()); reservation = reservation.Select(); reservationInvoiceReport.xrCellInvoiceNo.Text = "Invoice No - INV" + reservation.ReservationId.ToString(); reservationInvoiceReport.xrCellInvoiceDate.Text = "Invoice Date - " + DateTime.Now.ToString(); reservationInvoiceReport.xrCellReservationCode.Text = "Code - " + reservation.ReservationCode; reservationInvoiceReport.xrCellReservationDate.Text = "Booking Date - " + reservation.BookingDate.ToString(); StringBuilder sbCustomer = new StringBuilder(); sbCustomer.Append(reservation.CustomerName + Environment.NewLine); sbCustomer.Append(reservation.BillingAddressLine1 + Environment.NewLine); sbCustomer.Append(reservation.BillingAddressLine2 + Environment.NewLine); sbCustomer.Append(reservation.BillingCity + ", "); sbCustomer.Append(reservation.BillingPostCode + Environment.NewLine); sbCustomer.Append(reservation.BillingState + ", " + reservation.CountryName); reservationInvoiceReport.xrCellCustomer.Text = sbCustomer.ToString(); Company company = new Company(); company.CompanyId = SessionHandler.CurrentCompanyId; company = company.Select(); if (company.CompanyLogo != null) { reservationInvoiceReport.xrPbLogo.Image = (Bitmap)((new ImageConverter()).ConvertFrom(company.CompanyLogo)); ; } reservationInvoiceReport.xrCellCompanyName.Text = company.CompanyName; StringBuilder sbCompany = new StringBuilder(); sbCompany.Append(company.CompanyAddress + Environment.NewLine); sbCompany.Append(company.CompanyCity + Environment.NewLine); sbCompany.Append(company.CompanyEmail + Environment.NewLine); sbCompany.Append("Tel - " + company.CompanyTelephone + Environment.NewLine); sbCompany.Append("Fax - " + company.CompanyFax); reservationInvoiceReport.xrCellCompnayAddress.Text = sbCompany.ToString(); DataSet dsRoomInfo = new DataSet(); dsRoomInfo = reservation.ReservationRoomDataSet; //// Room info section if (dsRoomInfo != null && dsRoomInfo.Tables.Count > 0 && dsRoomInfo.Tables[0] != null && dsRoomInfo.Tables[0].Rows.Count > 0) { decimal roomInfoTotal; roomInfoTotal = 0; for (int i = 0; i <= dsRoomInfo.Tables[0].Rows.Count - 1; i++) { if (i == 0) { reservationInvoiceReport.xrCellCustomerName.Text = dsRoomInfo.Tables[0].Rows[i]["Sharers"] != null ? dsRoomInfo.Tables[0].Rows[i]["Sharers"].ToString() : string.Empty; reservationInvoiceReport.xrCellCheckIn.Text = dsRoomInfo.Tables[0].Rows[i]["CheckInDate"] != null ? Convert.ToDateTime(dsRoomInfo.Tables[0].Rows[i]["CheckInDate"].ToString()).ToShortDateString() : string.Empty; reservationInvoiceReport.xrCellCheckOut.Text = dsRoomInfo.Tables[0].Rows[i]["CheckOutDate"] != null ? Convert.ToDateTime(dsRoomInfo.Tables[0].Rows[i]["CheckOutDate"].ToString()).ToShortDateString() : string.Empty; reservationInvoiceReport.xrCellRoom.Text = dsRoomInfo.Tables[0].Rows[i]["RoomName"] != null ? dsRoomInfo.Tables[0].Rows[i]["RoomName"].ToString() : string.Empty; reservationInvoiceReport.xrCellRate.Text = dsRoomInfo.Tables[0].Rows[i]["Rate"] != null ? dsRoomInfo.Tables[0].Rows[i]["Rate"].ToString() : string.Empty; reservationInvoiceReport.xrCellNights.Text = dsRoomInfo.Tables[0].Rows[i]["Days"] != null ? dsRoomInfo.Tables[0].Rows[i]["Days"].ToString() : string.Empty; reservationInvoiceReport.xrCellAmount.Text = dsRoomInfo.Tables[0].Rows[i]["Amount"] != null ? dsRoomInfo.Tables[0].Rows[i]["Amount"].ToString() : string.Empty; roomInfoTotal = Convert.ToDecimal(reservationInvoiceReport.xrCellAmount.Text); } else { XRTableCell cell1 = new XRTableCell(); XRTableCell cell2 = new XRTableCell(); XRTableCell cell3 = new XRTableCell(); XRTableCell cell4 = new XRTableCell(); XRTableCell cell5 = new XRTableCell(); XRTableCell cell6 = new XRTableCell(); XRTableCell cell7 = new XRTableCell(); cell1.Text = dsRoomInfo.Tables[0].Rows[i]["Sharers"] != null ? dsRoomInfo.Tables[0].Rows[i]["Sharers"].ToString() : string.Empty; cell2.Text = dsRoomInfo.Tables[0].Rows[i]["CheckInDate"] != null ? Convert.ToDateTime(dsRoomInfo.Tables[0].Rows[i]["CheckInDate"].ToString()).ToShortDateString() : string.Empty; cell3.Text = dsRoomInfo.Tables[0].Rows[i]["CheckOutDate"] != null ? Convert.ToDateTime(dsRoomInfo.Tables[0].Rows[i]["CheckOutDate"].ToString()).ToShortDateString() : string.Empty; cell4.Text = dsRoomInfo.Tables[0].Rows[i]["RoomName"] != null ? dsRoomInfo.Tables[0].Rows[i]["RoomName"].ToString() : string.Empty; cell5.Text = dsRoomInfo.Tables[0].Rows[i]["Rate"] != null ? dsRoomInfo.Tables[0].Rows[i]["Rate"].ToString() : string.Empty; cell6.Text = dsRoomInfo.Tables[0].Rows[i]["Days"] != null ? dsRoomInfo.Tables[0].Rows[i]["Days"].ToString() : string.Empty; cell7.Text = dsRoomInfo.Tables[0].Rows[i]["Amount"] != null ? dsRoomInfo.Tables[0].Rows[i]["Amount"].ToString() : string.Empty; roomInfoTotal = roomInfoTotal + Convert.ToDecimal(cell7.Text); XRTableRow dataRow = new XRTableRow(); dataRow.Cells.Add(cell1); dataRow.Cells.Add(cell2); dataRow.Cells.Add(cell3); dataRow.Cells.Add(cell4); dataRow.Cells.Add(cell5); dataRow.Cells.Add(cell6); dataRow.Cells.Add(cell7); cell1.WidthF = reservationInvoiceReport.xrCellCustomerName.WidthF; cell2.WidthF = reservationInvoiceReport.xrCellCheckIn.WidthF; cell3.WidthF = reservationInvoiceReport.xrCellCheckOut.WidthF; cell4.WidthF = reservationInvoiceReport.xrCellRoom.WidthF; cell5.WidthF = reservationInvoiceReport.xrCellRate.WidthF; cell6.WidthF = reservationInvoiceReport.xrCellNights.WidthF; cell7.WidthF = reservationInvoiceReport.xrCellAmount.WidthF; cell1.TextAlignment = reservationInvoiceReport.xrCellCustomerName.TextAlignment; cell7.TextAlignment = reservationInvoiceReport.xrCellAmount.TextAlignment; reservationInvoiceReport.xrTableRoomInfo.Rows.Add(dataRow); } } //// Add total row XRTableCell cellFooter1 = new XRTableCell(); XRTableCell cellFooter2 = new XRTableCell(); cellFooter1.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cellFooter2.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); XRTableRow tableRowFooter = new XRTableRow(); cellFooter1.WidthF = reservationInvoiceReport.xrCellCustomerName.WidthF + reservationInvoiceReport.xrCellCheckIn.WidthF + reservationInvoiceReport.xrCellCheckOut.WidthF + reservationInvoiceReport.xrCellRoom.WidthF + reservationInvoiceReport.xrCellRate.WidthF + reservationInvoiceReport.xrCellNights.WidthF; cellFooter2.WidthF = reservationInvoiceReport.xrCellAmount.WidthF; cellFooter1.Text = "Room Total"; cellFooter1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; cellFooter2.Text = roomInfoTotal.ToString(); cellFooter2.TextAlignment = reservationInvoiceReport.xrCellAmount.TextAlignment; tableRowFooter.Cells.Add(cellFooter1); tableRowFooter.Cells.Add(cellFooter2); reservationInvoiceReport.xrTableRoomInfo.Rows.Add(tableRowFooter); XRTableCell blankCell = new XRTableCell(); blankCell.Text = " "; blankCell.BackColor = System.Drawing.Color.LightGray; XRTableRow blankRow = new XRTableRow(); blankRow.Cells.Add(blankCell); reservationInvoiceReport.xrTableRoomInfo.Rows.Add(blankRow); } //// Additional Service section DataSet dsAdditionalService = new DataSet(); dsAdditionalService = reservation.ReservationAdditionalServiceDataSet; if (dsAdditionalService != null && dsAdditionalService.Tables.Count > 0 && dsAdditionalService.Tables[0] != null && dsAdditionalService.Tables[0].Rows.Count > 0) { XRTableCell cell1 = new XRTableCell(); XRTableCell cell2 = new XRTableCell(); XRTableCell cell3 = new XRTableCell(); cell1.Text = "Service Type"; cell2.Text = "Note"; cell3.Text = "Amount"; cell1.WidthF = reservationInvoiceReport.xrCellCustomerName.WidthF; cell2.WidthF = reservationInvoiceReport.xrCellCheckIn.WidthF + reservationInvoiceReport.xrCellCheckOut.WidthF + reservationInvoiceReport.xrCellRoom.WidthF + reservationInvoiceReport.xrCellRate.WidthF + reservationInvoiceReport.xrCellNights.WidthF; cell3.WidthF = reservationInvoiceReport.xrCellAmount.WidthF; cell1.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cell2.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cell3.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); XRTableRow headerRow = new XRTableRow(); headerRow.Cells.Add(cell1); headerRow.Cells.Add(cell2); headerRow.Cells.Add(cell3); reservationInvoiceReport.xrTableRoomInfo.Rows.Add(headerRow); decimal serviceTotal; serviceTotal = 0; for (int i = 0; i <= dsAdditionalService.Tables[0].Rows.Count - 1; i++) { XRTableCell dataCell1 = new XRTableCell(); XRTableCell dataCell2 = new XRTableCell(); XRTableCell dataCell3 = new XRTableCell(); dataCell1.Text = dsAdditionalService.Tables[0].Rows[i]["ServiceName"] != null ? dsAdditionalService.Tables[0].Rows[i]["ServiceName"].ToString() : string.Empty; dataCell2.Text = dsAdditionalService.Tables[0].Rows[i]["Note"] != null ? dsAdditionalService.Tables[0].Rows[i]["Note"].ToString() : string.Empty; dataCell3.Text = dsAdditionalService.Tables[0].Rows[i]["Amount"] != null ? dsAdditionalService.Tables[0].Rows[i]["Amount"].ToString() : string.Empty; serviceTotal = serviceTotal + Convert.ToDecimal(dataCell3.Text); dataCell1.WidthF = reservationInvoiceReport.xrCellCustomerName.WidthF; dataCell2.WidthF = reservationInvoiceReport.xrCellCheckIn.WidthF + reservationInvoiceReport.xrCellCheckOut.WidthF + reservationInvoiceReport.xrCellRoom.WidthF + reservationInvoiceReport.xrCellRate.WidthF + reservationInvoiceReport.xrCellNights.WidthF; dataCell3.WidthF = reservationInvoiceReport.xrCellAmount.WidthF; dataCell3.TextAlignment = reservationInvoiceReport.xrCellAmount.TextAlignment; XRTableRow dataRow = new XRTableRow(); dataRow.Cells.Add(dataCell1); dataRow.Cells.Add(dataCell2); dataRow.Cells.Add(dataCell3); reservationInvoiceReport.xrTableRoomInfo.Rows.Add(dataRow); } XRTableCell cellFooter1 = new XRTableCell(); XRTableCell cellFooter2 = new XRTableCell(); cellFooter1.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cellFooter2.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); XRTableRow tableRowFooter = new XRTableRow(); cellFooter1.WidthF = reservationInvoiceReport.xrCellCustomerName.WidthF + reservationInvoiceReport.xrCellCheckIn.WidthF + reservationInvoiceReport.xrCellCheckOut.WidthF + reservationInvoiceReport.xrCellRoom.WidthF + reservationInvoiceReport.xrCellRate.WidthF + reservationInvoiceReport.xrCellNights.WidthF; cellFooter2.WidthF = reservationInvoiceReport.xrCellAmount.WidthF; cellFooter1.Text = "Service Total"; cellFooter1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; cellFooter2.Text = serviceTotal.ToString(); cellFooter2.TextAlignment = reservationInvoiceReport.xrCellAmount.TextAlignment; tableRowFooter.Cells.Add(cellFooter1); tableRowFooter.Cells.Add(cellFooter2); reservationInvoiceReport.xrTableRoomInfo.Rows.Add(tableRowFooter); XRTableCell blankCell1 = new XRTableCell(); blankCell1.Text = " "; blankCell1.BackColor = System.Drawing.Color.LightGray; XRTableRow blankRow1 = new XRTableRow(); blankRow1.Cells.Add(blankCell1); reservationInvoiceReport.xrTableRoomInfo.Rows.Add(blankRow1); } //// Display Net Total XRTableRow tableRowNetTotal = new XRTableRow(); XRTableCell cellNetTotal1 = new XRTableCell(); XRTableCell cellNetTotal2 = new XRTableCell(); cellNetTotal1.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cellNetTotal2.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cellNetTotal1.Text = "Net Total"; cellNetTotal2.Text = reservation.NetTotal.ToString(); cellNetTotal1.WidthF = reservationInvoiceReport.xrCellCustomerName.WidthF + reservationInvoiceReport.xrCellCheckIn.WidthF + reservationInvoiceReport.xrCellCheckOut.WidthF + reservationInvoiceReport.xrCellRoom.WidthF + reservationInvoiceReport.xrCellRate.WidthF + reservationInvoiceReport.xrCellNights.WidthF; cellNetTotal2.WidthF = reservationInvoiceReport.xrCellAmount.WidthF; cellNetTotal1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; cellNetTotal2.TextAlignment = reservationInvoiceReport.xrCellAmount.TextAlignment; tableRowNetTotal.Cells.Add(cellNetTotal1); tableRowNetTotal.Cells.Add(cellNetTotal2); reservationInvoiceReport.xrTableRoomInfo.Rows.Add(tableRowNetTotal); //// Display Discount XRTableRow tableRowDiscount = new XRTableRow(); XRTableCell cellDiscount1 = new XRTableCell(); XRTableCell cellDiscount2 = new XRTableCell(); cellDiscount1.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cellDiscount2.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cellDiscount1.Text = "Discount"; cellDiscount2.Text = reservation.Discount.ToString(); cellDiscount1.WidthF = reservationInvoiceReport.xrCellCustomerName.WidthF + reservationInvoiceReport.xrCellCheckIn.WidthF + reservationInvoiceReport.xrCellCheckOut.WidthF + reservationInvoiceReport.xrCellRoom.WidthF + reservationInvoiceReport.xrCellRate.WidthF + reservationInvoiceReport.xrCellNights.WidthF; cellDiscount2.WidthF = reservationInvoiceReport.xrCellAmount.WidthF; cellDiscount1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; cellDiscount2.TextAlignment = reservationInvoiceReport.xrCellAmount.TextAlignment; tableRowDiscount.Cells.Add(cellDiscount1); tableRowDiscount.Cells.Add(cellDiscount2); reservationInvoiceReport.xrTableRoomInfo.Rows.Add(tableRowDiscount); //// Display Tax Amount XRTableRow tableRowTaxType = new XRTableRow(); XRTableCell cellTaxType1 = new XRTableCell(); XRTableCell cellTaxType2 = new XRTableCell(); cellTaxType1.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cellTaxType2.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cellTaxType1.Text = "Tax Amount"; cellTaxType2.Text = reservation.TaxAmount.ToString(); cellTaxType1.WidthF = reservationInvoiceReport.xrCellCustomerName.WidthF + reservationInvoiceReport.xrCellCheckIn.WidthF + reservationInvoiceReport.xrCellCheckOut.WidthF + reservationInvoiceReport.xrCellRoom.WidthF + reservationInvoiceReport.xrCellRate.WidthF + reservationInvoiceReport.xrCellNights.WidthF; cellTaxType2.WidthF = reservationInvoiceReport.xrCellAmount.WidthF; cellTaxType1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; cellTaxType2.TextAlignment = reservationInvoiceReport.xrCellAmount.TextAlignment; tableRowTaxType.Cells.Add(cellTaxType1); tableRowTaxType.Cells.Add(cellTaxType2); reservationInvoiceReport.xrTableRoomInfo.Rows.Add(tableRowTaxType); //// Display Total XRTableRow tableRowTotal = new XRTableRow(); XRTableCell cellTotal1 = new XRTableCell(); XRTableCell cellTotal2 = new XRTableCell(); cellTotal1.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cellTotal2.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cellTotal1.Text = "Total"; cellTotal2.Text = reservation.Total.ToString(); cellTotal1.WidthF = reservationInvoiceReport.xrCellCustomerName.WidthF + reservationInvoiceReport.xrCellCheckIn.WidthF + reservationInvoiceReport.xrCellCheckOut.WidthF + reservationInvoiceReport.xrCellRoom.WidthF + reservationInvoiceReport.xrCellRate.WidthF + reservationInvoiceReport.xrCellNights.WidthF; cellTotal2.WidthF = reservationInvoiceReport.xrCellAmount.WidthF; cellTotal1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; cellTotal2.TextAlignment = reservationInvoiceReport.xrCellAmount.TextAlignment; tableRowTotal.Cells.Add(cellTotal1); tableRowTotal.Cells.Add(cellTotal2); reservationInvoiceReport.xrTableRoomInfo.Rows.Add(tableRowTotal); //// Display Paid Amount XRTableRow tableRowPaidAmount = new XRTableRow(); XRTableCell cellPaidAmount1 = new XRTableCell(); XRTableCell cellPaidAmount2 = new XRTableCell(); cellPaidAmount1.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cellPaidAmount2.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cellPaidAmount1.Text = "Paid Amount"; cellPaidAmount2.Text = reservation.PaidAmount.ToString(); cellPaidAmount1.WidthF = reservationInvoiceReport.xrCellCustomerName.WidthF + reservationInvoiceReport.xrCellCheckIn.WidthF + reservationInvoiceReport.xrCellCheckOut.WidthF + reservationInvoiceReport.xrCellRoom.WidthF + reservationInvoiceReport.xrCellRate.WidthF + reservationInvoiceReport.xrCellNights.WidthF; cellPaidAmount2.WidthF = reservationInvoiceReport.xrCellAmount.WidthF; cellPaidAmount1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; cellPaidAmount2.TextAlignment = reservationInvoiceReport.xrCellAmount.TextAlignment; tableRowPaidAmount.Cells.Add(cellPaidAmount1); tableRowPaidAmount.Cells.Add(cellPaidAmount2); reservationInvoiceReport.xrTableRoomInfo.Rows.Add(tableRowPaidAmount); //// Display Balance XRTableRow tableRowBalance = new XRTableRow(); XRTableCell cellBalance1 = new XRTableCell(); XRTableCell cellBalance2 = new XRTableCell(); cellBalance1.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cellBalance2.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cellBalance1.Text = "Balance"; cellBalance2.Text = reservation.Balance.ToString(); cellBalance1.WidthF = reservationInvoiceReport.xrCellCustomerName.WidthF + reservationInvoiceReport.xrCellCheckIn.WidthF + reservationInvoiceReport.xrCellCheckOut.WidthF + reservationInvoiceReport.xrCellRoom.WidthF + reservationInvoiceReport.xrCellRate.WidthF + reservationInvoiceReport.xrCellNights.WidthF; cellBalance2.WidthF = reservationInvoiceReport.xrCellAmount.WidthF; cellBalance1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; cellBalance2.TextAlignment = reservationInvoiceReport.xrCellAmount.TextAlignment; tableRowBalance.Cells.Add(cellBalance1); tableRowBalance.Cells.Add(cellBalance2); reservationInvoiceReport.xrTableRoomInfo.Rows.Add(tableRowBalance); //// Payment section DataSet dsPaymentSection = new DataSet(); dsPaymentSection = reservation.ReservationPaymentDataSet; if (dsPaymentSection != null && dsPaymentSection.Tables.Count > 0 && dsPaymentSection.Tables[0] != null && dsPaymentSection.Tables[0].Rows.Count > 0) { XRTableCell blankCell = new XRTableCell(); blankCell.Text = " "; blankCell.BackColor = System.Drawing.Color.LightGray; XRTableRow blankRow = new XRTableRow(); blankRow.Cells.Add(blankCell); reservationInvoiceReport.xrTableRoomInfo.Rows.Add(blankRow); XRTableCell cell1 = new XRTableCell(); XRTableCell cell2 = new XRTableCell(); XRTableCell cell3 = new XRTableCell(); XRTableCell cell4 = new XRTableCell(); XRTableCell cell5 = new XRTableCell(); XRTableCell cell6 = new XRTableCell(); cell1.Text = "Type"; cell2.Text = "Payment Date"; cell3.Text = "Card Type"; cell4.Text = "Card No"; cell5.Text = "Name on Card"; cell6.Text = "Amount"; cell1.WidthF = 110; cell2.WidthF = 126; cell3.WidthF = 99; cell4.WidthF = 161; cell5.WidthF = 168; cell6.WidthF = 117; cell1.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cell2.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cell3.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cell4.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cell5.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cell6.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); XRTableRow headerRow = new XRTableRow(); headerRow.Cells.Add(cell1); headerRow.Cells.Add(cell2); headerRow.Cells.Add(cell3); headerRow.Cells.Add(cell4); headerRow.Cells.Add(cell5); headerRow.Cells.Add(cell6); reservationInvoiceReport.xrTableRoomInfo.Rows.Add(headerRow); decimal paymentTotal; paymentTotal = 0; for (int i = 0; i <= dsPaymentSection.Tables[0].Rows.Count - 1; i++) { XRTableCell dataCell1 = new XRTableCell(); XRTableCell dataCell2 = new XRTableCell(); XRTableCell dataCell3 = new XRTableCell(); XRTableCell dataCell4 = new XRTableCell(); XRTableCell dataCell5 = new XRTableCell(); XRTableCell dataCell6 = new XRTableCell(); dataCell1.Text = dsPaymentSection.Tables[0].Rows[i]["PaymentTypeName"] != null ? dsPaymentSection.Tables[0].Rows[i]["PaymentTypeName"].ToString() : string.Empty; dataCell2.Text = dsPaymentSection.Tables[0].Rows[i]["PaymentDate"] != null ? Convert.ToDateTime(dsPaymentSection.Tables[0].Rows[i]["PaymentDate"].ToString()).ToShortDateString() : string.Empty; dataCell3.Text = dsPaymentSection.Tables[0].Rows[i]["Name"] != null ? dsPaymentSection.Tables[0].Rows[i]["Name"].ToString() : string.Empty; dataCell4.Text = dsPaymentSection.Tables[0].Rows[i]["CCNo"] != null ? dsPaymentSection.Tables[0].Rows[i]["CCNo"].ToString() : string.Empty; dataCell5.Text = dsPaymentSection.Tables[0].Rows[i]["CCNameOnCard"] != null ? dsPaymentSection.Tables[0].Rows[i]["CCNameOnCard"].ToString() : string.Empty; dataCell6.Text = dsPaymentSection.Tables[0].Rows[i]["Amount"] != null ? dsPaymentSection.Tables[0].Rows[i]["Amount"].ToString() : string.Empty; paymentTotal = paymentTotal + Convert.ToDecimal(dataCell6.Text); dataCell1.WidthF = 110; dataCell2.WidthF = 126; dataCell3.WidthF = 99; dataCell4.WidthF = 161; dataCell5.WidthF = 168; dataCell6.WidthF = 117; dataCell6.TextAlignment = reservationInvoiceReport.xrCellAmount.TextAlignment; XRTableRow dataRow = new XRTableRow(); dataRow.Cells.Add(dataCell1); dataRow.Cells.Add(dataCell2); dataRow.Cells.Add(dataCell3); dataRow.Cells.Add(dataCell4); dataRow.Cells.Add(dataCell5); dataRow.Cells.Add(dataCell6); reservationInvoiceReport.xrTableRoomInfo.Rows.Add(dataRow); } XRTableCell cellFooter1 = new XRTableCell(); XRTableCell cellFooter2 = new XRTableCell(); cellFooter1.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); cellFooter2.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold); XRTableRow tableRowFooter = new XRTableRow(); cellFooter1.WidthF = reservationInvoiceReport.xrCellCustomerName.WidthF + reservationInvoiceReport.xrCellCheckIn.WidthF + reservationInvoiceReport.xrCellCheckOut.WidthF + reservationInvoiceReport.xrCellRoom.WidthF + reservationInvoiceReport.xrCellRate.WidthF + reservationInvoiceReport.xrCellNights.WidthF; cellFooter2.WidthF = reservationInvoiceReport.xrCellAmount.WidthF; cellFooter1.Text = "Total"; cellFooter1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; cellFooter2.Text = paymentTotal.ToString(); cellFooter2.TextAlignment = reservationInvoiceReport.xrCellAmount.TextAlignment; tableRowFooter.Cells.Add(cellFooter1); tableRowFooter.Cells.Add(cellFooter2); reservationInvoiceReport.xrTableRoomInfo.Rows.Add(tableRowFooter); } rvReportViewer.Report = reservationInvoiceReport; }