public DataSet SelectAll(Reservation reservation)
{
Database db = DatabaseFactory.CreateDatabase(Constants.HBMCONNECTIONSTRING);
DbCommand dbCommand = db.GetStoredProcCommand("usp_ReservationSelectAll");
db.AddInParameter(dbCommand, "@CompanyId", DbType.Int32, reservation.CompanyId);
return db.ExecuteDataSet(dbCommand);
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
ResMan.Reservation resobj = new ResMan.Reservation();
resobj.CompanyId = Master.CurrentCompany.CompanyId;
gvReservation.DataSource = resobj.SelectAllDataset();
gvReservation.DataBind();
}
catch (System.Exception)
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
ResMan.Reservation resobj= new ResMan.Reservation();
resobj.CompanyId = Master.CurrentCompany.CompanyId;
gvReservation.DataSource = resobj.SelectAllDataset();
gvReservation.DataBind();
}
catch (System.Exception)
{
}
}
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 Reservation Select()
{
Reservation reservation = HBM.Utility.Generic.Get<Reservation>(this.ReservationId);
if (reservation == null)
{
reservation = new Reservation();
}
reservation.ReservationAdditionalServiceDataSet = (new ReservationDAO()).SelectReservationAdditionalServices(this);
reservation.ReservationPaymentDataSet = (new ReservationDAO()).SelectReservationPayments(this);
reservation.ReservationRoomDataSet = (new ReservationDAO()).SelectReservationRooms(this);
return reservation;
}
private bool SaveData(Int64 reservationId)
{
bool result = false;
DbConnection connection = null;
DbTransaction transaction = null;
try
{
Database db = DatabaseFactory.CreateDatabase(Constants.HBMCONNECTIONSTRING);
connection = db.CreateConnection();
connection.Open();
transaction = connection.BeginTransaction();
ResMan.Reservation reservation = new GenRes.Reservation();
reservation.ReservationId = reservationId;
reservation.CompanyId = Master.CurrentCompany.CompanyId;
reservation.CustomerId = Convert.ToInt32(cmbCustomer.Value);
reservation.SourceId = Convert.ToInt32(cmbSource.Value);
reservation.CheckInDate = Convert.ToDateTime(dtCheckingDate.Text);
reservation.CheckOutDate = Convert.ToDateTime(dtCheckOutDate.Text);
reservation.StatusId = Convert.ToInt32(cmbResStatus.SelectedItem.Value.ToString());
reservation.RoomTotal = Convert.ToDecimal(txtRoomTotal.Text.Trim());
reservation.ServiceTotal = Convert.ToDecimal(txtServiceTotal.Text.Trim());
reservation.NetTotal = Convert.ToDecimal(txtNetTotal.Text.Trim());
reservation.Discount = Convert.ToDecimal(txtDiscount.Text.Trim());
reservation.TaxTypeId = Convert.ToInt32(cmbTax.Value);
reservation.TaxAmount = Convert.ToDecimal(txtTaxTotal.Text.Trim());
reservation.Total = Convert.ToDecimal(txtTotal.Text.Trim());
reservation.PaidAmount = Convert.ToDecimal(txtPaidAmount.Text.Trim());
reservation.Balance = Convert.ToDecimal(txtBalance.Text.Trim());
reservation.TaxPercentage = Convert.ToDecimal(hdnTaxPercent.Value == string.Empty ? "0" : hdnTaxPercent.Value);
reservation.CreatedUser = Master.LoggedUser.UsersId;
reservation.UpdatedUser = Master.LoggedUser.UsersId;
if (Session[Constants.SESSION_RESERVATION_ROOMINFORMATION] != null)
{
reservation.ReservationRoomDataSet = (DataSet)Session[Constants.SESSION_RESERVATION_ROOMINFORMATION];
}
else
{
reservationRoom.ReservationId = reservationId;
reservation.ReservationRoomDataSet = reservationRoom.SelectAllDataSetByReseervationId();
}
if (Session[Constants.SESSION_RESERVATION_ADDTIONALSERVICE] != null)
{
reservation.ReservationAdditionalServiceDataSet = (DataSet)Session[Constants.SESSION_RESERVATION_ADDTIONALSERVICE];
}
else
{
reservationAdditionalService.ReservationId = reservationId;
reservation.ReservationAdditionalServiceDataSet = reservationAdditionalService.SelectAllDataSetByReservationID();
}
if (Session[Constants.SESSION_RESERVATION_PAYMENTINFORMATION] != null)
{
reservation.ReservationPaymentDataSet = (DataSet)Session[Constants.SESSION_RESERVATION_PAYMENTINFORMATION];
}
else
{
reservationPayments.ReservationId = reservationId;
reservation.ReservationPaymentDataSet = reservationPayments.SelectAllDataSetByReservationID();
}
reservation.Save(db, transaction);
if (reservation.StatusId == (int)HBM.Common.Enums.HBMStatus.CheckOut)
{
if (Session[Constants.SESSION_RESERVATION_ROOMINFORMATION] != null)
{
DataSet roomsToMakeDrity = (DataSet)Session[Constants.SESSION_RESERVATION_ROOMINFORMATION];
if (roomsToMakeDrity != null && roomsToMakeDrity.Tables.Count > 0 && roomsToMakeDrity.Tables[0] != null && roomsToMakeDrity.Tables[0].Rows.Count > 0)
{
for (int i = 0; i <= roomsToMakeDrity.Tables[0].Rows.Count - 1; i++)
{
Room dirtyroom = new Room();
dirtyroom.RoomId = Convert.ToInt32(roomsToMakeDrity.Tables[0].Rows[i]["RoomId"].ToString());
dirtyroom.UpdatedUser = Master.LoggedUser.UsersId;
dirtyroom.UpdateRoomAsDirty(db, transaction);
}
}
}
}
transaction.Commit();
this.hdnReservationId.Value = reservation.ReservationId.ToString();
result = true;
}
catch (System.Exception)
{
transaction.Rollback();
}
return result;
}
private bool DisplayData(Int64 reservationId)
{
bool result = false;
DbConnection connection = null;
DbTransaction transaction = null;
try
{
Database db = DatabaseFactory.CreateDatabase(Constants.HBMCONNECTIONSTRING);
connection = db.CreateConnection();
connection.Open();
transaction = connection.BeginTransaction();
ResMan.Reservation reservation = new ResMan.Reservation();
reservation.ReservationId = reservationId;
reservation = reservation.Select();
ltlReservationCode.Text = " - " + reservation.ReservationCode;
cmbCustomer.SelectedItem = cmbCustomer.Items.FindByValue(reservation.CustomerId.ToString());
cmbSource.SelectedItem = cmbSource.Items.FindByValue(reservation.SourceId.ToString());
dtCheckingDate.Value = reservation.CheckInDate;
dtCheckOutDate.Value = reservation.CheckOutDate;
cmbResStatus.SelectedItem = cmbResStatus.Items.FindByValue(reservation.StatusId.ToString());
txtRoomTotal.Text = reservation.RoomTotal.ToString();
txtServiceTotal.Text = reservation.ServiceTotal.ToString();
txtNetTotal.Text = reservation.NetTotal.ToString();
txtDiscount.Text = reservation.Discount.ToString();
cmbTax.SelectedItem = cmbTax.Items.FindByValue(reservation.TaxTypeId.ToString());
txtTaxTotal.Text = reservation.TaxAmount.ToString();
txtTotal.Text = reservation.Total.ToString();
txtPaidAmount.Text = reservation.PaidAmount.ToString();
txtBalance.Text = reservation.Balance.ToString();
hdnTaxPercent.Value = reservation.TaxPercentage.ToString();
this.LoadRoomInformation(reservationId);
this.LoadAddiotnalService(reservationId);
this.LoadPaymentInformation(reservationId);
transaction.Commit();
result = true;
}
catch (System.Exception)
{
transaction.Rollback();
}
return result;
}
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;
}
internal DataSet SelectReservationRooms(Reservation reservation)
{
Database db = DatabaseFactory.CreateDatabase(Constants.HBMCONNECTIONSTRING);
DbCommand dbCommand = db.GetStoredProcCommand("usp_ReservationRoomSelectByReservationID");
db.AddInParameter(dbCommand, "@ReservationId", DbType.Int32, reservation.ReservationId);
return db.ExecuteDataSet(dbCommand);
}