private bool SaveReservationPayment(SqlInt32 reservationId, Ferry ferry, int ferryAdultOrChild) { Reservation_Payments pay = new Reservation_Payments(); pay.Reservation_ID = reservationId; pay.PaymentPersonnel = 0;//Utility.GetUserIdFromUserName(HttpContext.Current.User.Identity.Name); pay.CreatedDate = Utility.GetSqlDateTimeFromDateTime(DateTime.Today); pay.Discount_ID = SqlInt32.Parse(this.hidDiscountId.Value); pay.AvailedService_Type = ferryAdultOrChild; //1=Reservation;2=Bills & Services;3=Amenities pay.Discount_Offered = new SqlMoney(0.00); pay.Rate_ID = (SqlInt32)ferry.Ferry_ID; pay.PaymentStatus = PaymentStatus.NOT_PAID; /* * if (ferryAdultOrChild == PAYMENT_AVAILED_SERVICETYPES.FERRY_ADULTS) * { * pay.UnitsConsumed = SqlInt32.Parse(this.drpNumberOfAdults.SelectedValue); * pay.TotalCost_Before_Discount = (ferry.Cost_For_Adults * pay.UnitsConsumed); * SqlMoney costAfterDiscount = (pay.TotalCost_Before_Discount - pay.Discount_Offered); * pay.Cost_After_Discount = costAfterDiscount; * } * else if (ferryAdultOrChild == PAYMENT_AVAILED_SERVICETYPES.FERRY_KIDS) * { * pay.UnitsConsumed = SqlInt32.Parse(this.drpNumberOfChildren.SelectedValue); * pay.TotalCost_Before_Discount = (ferry.Cost_For_Kids * pay.UnitsConsumed); * SqlMoney costAfterDiscount = (pay.TotalCost_Before_Discount - pay.Discount_Offered); * pay.Cost_After_Discount = costAfterDiscount; * } */ pay.AmountReceived = 0; return(pay.Insert()); }
private void GetReservationPayment(SqlInt32 reservationId) { if (reservationPaymentsTbl == null) { Reservation_Payments rpay = new Reservation_Payments(); rpay.Reservation_ID = reservationId; reservationPaymentsTbl = rpay.SelectAll(); } }
private void BindReservationPayments(int reservationId) { //GetReservationPayments(reservationId, ref paymentsTbl); Reservation_Payments payments = new Reservation_Payments(); payments.Reservation_ID = reservationId; paymentsTbl = payments.SelectAll(); paymentsGrid.DataSource = paymentsTbl; paymentsGrid.DataBind(); }
private void CancelPayment(SqlInt32 paymentId) { Reservation_Payments rp = new Reservation_Payments(); rp.Payment_ID = paymentId; int reservationId = Int32.Parse(hidReservationId.Value); if (rp.Delete()) { BindReservationPayments(reservationId); return; } }
protected void btnWelcomeLetter_Click(object sender, EventArgs e) { Reservation_Payments rp = new Reservation_Payments(); rp.Reservation_ID = SqlInt32.Parse(hidReservationId.Value); // rp.SelectOne(); DataTable resevePay = rp.GetReservationPayment(); Session["welcomeLetter"] = resevePay; string popupScript = "<script language='javascript'>" + "window.open('Welcome.aspx','ThisPopUp1', " + "'left = 300, top=150, " + "menubar=no, scrollbars=yes, resizable=yes')" + "</script>"; Page.ClientScript.RegisterStartupScript(GetType(), "PopupScript", popupScript); }
private void GetReservationPayments(int reservationId, ref DataTable paymentsTbl) { Reservation_Payments payments = new Reservation_Payments(); payments.Reservation_ID = reservationId; paymentsTbl = payments.SelectAll(); /*if (Session["ReservationPaymentsTable"] == null) * { * Reservation_Payments payments = new Reservation_Payments(); * payments.Reservation_ID = reservationId; * paymentsTbl = payments.SelectAll(); * Session.Add("ReservationPaymentsTable", paymentsTbl); * } * else * paymentsTbl = (DataTable)Session["ReservationPaymentsTable"]; */ }
protected void btnPrintReservationConfirm_Click(object sender, EventArgs e) { if (Request.QueryString["Reservation_ID"] != null) { reservationId = Request.Params["Reservation_ID"] != null || Request.Params["Reservation_ID"] != "" ? Int32.Parse(Request.Params["Reservation_ID"].ToString()) : 0; hidReservationId.Value = reservationId.ToString(); } Reservation_Payments pay = new Reservation_Payments(); pay.Reservation_ID = SqlInt32.Parse(hidReservationId.Value.ToString()); DataTable resevePay = pay.GetReservationPayment(); Session["resevePay"] = resevePay; string popupScript = "<script language='javascript'>" + "window.open('ReservConfirm.aspx','ThisPopUp12', " + "'left = 300, top=150, " + "menubar=no, scrollbars=yes, resizable=yes')" + "</script>"; Page.ClientScript.RegisterStartupScript(GetType(), "PopupScript", popupScript); return; }
private void SaveBooking(SqlInt32 guestId, out SqlInt32 paymentId, out SqlInt32 reservationId) { paymentId = -1; reservationId = -1; Reservations r = new Reservations(); r.ReservationDate = Utility.GetSqlDateTimeFromDateTime(DateTime.Today); r.FromDate = Utility.GetSqlDateTimeFromDateTime(DateTime.Parse(this.hidFromDate.Value)); r.ToDate = Utility.GetSqlDateTimeFromDateTime(DateTime.Parse(this.hidToDate.Value)); r.ReservationPersonnel = 0; //Utility.GetUserIdFromUserName(HttpContext.Current.User.Identity.Name); r.RateType = SqlInt32.Parse(this.hidRateType.Value); SqlInt32 rateId = SqlInt32.Parse(this.hidRateId.Value); r.Rate_ID = rateId; r.RoomType_ID = SqlInt32.Parse(this.hidRoomTypeId.Value); r.Room_ID = SqlInt32.Parse(this.hidRoomId.Value); r.Parent_Reservation_ID = 0; r.Connected_Room_ID = 0; r.Guest_ID = guestId; r.BookingStatus = BookingStatus.CONFIRMED; r.Remarks = string.Empty; Reservation_Payments pay = new Reservation_Payments(); pay.PaymentPersonnel = 0;//Utility.GetUserIdFromUserName(HttpContext.Current.User.Identity.Name); pay.CreatedDate = Utility.GetSqlDateTimeFromDateTime(DateTime.Today); pay.Discount_ID = SqlInt32.Parse(this.hidDiscountId.Value); pay.AvailedService_Type = PAYMENT_AVAILED_SERVICETYPES.RESERVATION; //1=Reservation;2=Bills & Services;3=Amenities pay.Rate_ID = rateId; pay.UnitsConsumed = SqlInt32.Parse(this.hidBookingDays.Value); pay.Discount_Offered = SqlMoney.Parse(this.hidDiscountOffered.Value); pay.TotalCost_Before_Discount = SqlMoney.Parse(this.hidTotalCost.Value); SqlMoney costAfterDiscount = SqlMoney.Parse(this.hidCostAfterDiscount.Value);; pay.Cost_After_Discount = costAfterDiscount; pay.AmountReceived = 0; if (pay.AmountReceived == 0) { r.PaymentStatus = PaymentStatus.NOT_PAID; r.PendingAmount = pay.Cost_After_Discount - pay.AmountReceived; } else { this.pnlStatus.Visible = true; this.pnlStatus.CssClass = "alert alert-danger"; lblMsg.Text = "Booking Must be Less than or Equal to Cost after Discount"; return; } if (pay.AmountReceived != 0) { pay.PaymentMode = SqlInt32.Parse(this.hidSelectedCardType.Value); } pay.Remarks = r.Remarks; pay.PaymentStatus = 1;//Active if (r.Insert()) { pay.Reservation_ID = r.Reservation_ID; reservationId = r.Reservation_ID; Session.Add("ReservationID", reservationId); Session.Add("Reservation", r); if (pay.Insert()) { this.pnlStatus.Visible = true; this.pnlStatus.CssClass = "alert alert-danger"; lblMsg.Text = "Reservation & Payment was successfully saved."; paymentId = pay.Payment_ID; Session.Add("PaymentID", paymentId); Session.Add("Reservation_Payments", pay); /* * //Insert Ferry Payment as well * //Ferry * Ferry ferry = new Ferry(); * Session.Add("WantFerry", false); * if (this.chkWantFerry.Checked) * { * Session.Add("WantFerry", true); * DataTable toReturn = ferry.SelectAll(); * ferry.Ferry_ID = (Int32)toReturn.Rows[0]["Ferry_ID"]; * ferry.SelectOne(); * ferry.NumberOfAdults = SqlInt32.Parse(this.drpNumberOfAdults.SelectedValue); * ferry.NumberOfKids = SqlInt32.Parse(this.drpNumberOfChildren.SelectedValue); * Session.Add("Ferry", ferry); * bool saveFerry = false; * if(Int32.Parse(drpNumberOfAdults.SelectedValue) > 0) * saveFerry=SaveReservationPayment(r.Reservation_ID, ferry, PAYMENT_AVAILED_SERVICETYPES.FERRY_ADULTS); * if (Int32.Parse(drpNumberOfChildren.SelectedValue) > 0) * saveFerry=SaveReservationPayment(r.Reservation_ID, ferry, PAYMENT_AVAILED_SERVICETYPES.FERRY_KIDS); * if (!saveFerry) * { * this.pnlStatus.Visible = true; * this.pnlStatus.CssClass = "alert alert-danger"; * lblMsg.Text = "There was a problem in saving the Ferry"; * lblMsg.ForeColor = Color.Red; * return; * } * } */ return; } else { this.pnlStatus.Visible = true; this.pnlStatus.CssClass = "alert alert-danger"; lblMsg.Text = "Reservation was saved. However, there was a problem in saving the Payment"; lblMsg.ForeColor = Color.Red; return; } } else { this.pnlStatus.Visible = true; this.pnlStatus.CssClass = "alert alert-danger"; lblMsg.Text = "There was a problem. Could not save Reservation"; lblMsg.ForeColor = Color.Red; return; } }
private void BindReservation(KNET_Payments knet, Reservations reservation, Guests guest) { this.lblKnetPaymentId.Text = knet.KNET_Payment_ID; this.lblKnetReference.Text = knet.Ref; Reservation_Payments payments = new Reservation_Payments(); payments.Reservation_ID = knet.Reservation_ID; DataTable pays = payments.SelectAll(); int numKidsFerry = 0, numAdultsFerry = 0, numDays = 0; SqlMoney roomCharges = new SqlMoney(0.00); SqlMoney ferryCharges = new SqlMoney(0.00); SqlMoney kidsFerryCost = new SqlMoney(0.00); SqlMoney adultsFerryCost = new SqlMoney(0.00); SqlMoney totalCost = new SqlMoney(0.00); if (pays.Rows.Count > 0) { foreach (DataRow r in pays.Rows) { if ((Int32)r["AvailedService_Type"] == PAYMENT_AVAILED_SERVICETYPES.FERRY_KIDS) { numKidsFerry = (Int32)r["UnitsConsumed"]; kidsFerryCost = (Decimal)r["Cost_After_Discount"]; } if ((Int32)r["AvailedService_Type"] == PAYMENT_AVAILED_SERVICETYPES.FERRY_ADULTS) { numAdultsFerry = (Int32)r["UnitsConsumed"]; adultsFerryCost = (Decimal)r["Cost_After_Discount"]; } if ((Int32)r["AvailedService_Type"] == PAYMENT_AVAILED_SERVICETYPES.RESERVATION) { numDays = (Int32)r["UnitsConsumed"]; roomCharges = (Decimal)r["Cost_After_Discount"]; } } } ferryCharges = (adultsFerryCost + kidsFerryCost); totalCost = (ferryCharges + roomCharges); this.lblRoomCharges.Text = roomCharges.ToString(); this.lblFerryCharges.Text = ferryCharges.ToString(); this.lblTotalCharges.Text = totalCost.ToString(); this.lblDays.Text = numDays.ToString(); this.lblFerryKids.Text = numKidsFerry.ToString(); this.lblFerryAdults.Text = numAdultsFerry.ToString(); reservation.Reservation_ID = knet.Reservation_ID; reservation.SelectOne(); this.lblFromDate.Text = Utility.GetDateTimeFromSqlDateTime(reservation.FromDate).ToString("dd/MM/yyyy"); this.lblToDate.Text = Utility.GetDateTimeFromSqlDateTime(reservation.ToDate).ToString("dd/MM/yyyy"); this.lblRoomType.Text = reservation.RoomType_ID.ToString(); this.lblFerryKidsValidity.Text = Utility.GetDateTimeFromSqlDateTime(reservation.FromDate).ToString("dd/MM/yyyy"); this.lblFerryAdultsValidity.Text = Utility.GetDateTimeFromSqlDateTime(reservation.FromDate).ToString("dd/MM/yyyy"); this.lblDepartureTickets.Text = (numKidsFerry + numAdultsFerry).ToString(); this.lblDepartureDate.Text = Utility.GetDateTimeFromSqlDateTime(reservation.ToDate).ToString("dd/MM/yyyy"); this.lblGuestFirstName.Text = guest.FirstName.ToString(); this.lblGuestMiddleName.Text = guest.MiddleName.ToString(); this.lblGuestLastName.Text = guest.LastName.ToString(); this.lblGuestEmail.Text = guest.Email.ToString(); this.lblGuestMobile.Text = guest.MobileNumber.ToString(); this.lblGuestCvd.Text = guest.Civil_ID.ToString(); }
protected void btnSavePayment_Click(object sender, EventArgs e) { if (drpServiceType.SelectedValue == "-1") { lblPaymentMsg.Text = "Please select a Service Type"; lblPaymentMsg.ForeColor = Color.Red; return; } if (drpService.SelectedValue == "-1") { lblPaymentMsg.Text = "Please select a Service Type"; lblPaymentMsg.ForeColor = Color.Red; return; } Reservation_Payments rp = new Reservation_Payments(); rp.Reservation_ID = SqlInt32.Parse(hidReservationId.Value); rp.CreatedDate = Utility.GetSqlDateTimeFromDateTime(DateTime.Today); rp.PaymentPersonnel = Utility.GetUserIdFromUserName(HttpContext.Current.User.Identity.Name); rp.AvailedService_Type = SqlInt32.Parse(drpServiceType.SelectedValue); Reservations r = new Reservations(); r.Reservation_ID = SqlInt32.Parse(hidReservationId.Value); r.SelectOne(); if (drpServiceType.SelectedValue.Equals("1"))//If type reservation { if (r.PendingAmount <= 0) { lblPaymentMsg.Text = "There are no more Pending amounts to be paid for the reservation"; lblPaymentMsg.ForeColor = Color.Red; return; } if (string.IsNullOrEmpty(lblCost.Text) || SqlMoney.Parse(lblCost.Text) == 0) { lblPaymentMsg.Text = "There are no more Pending amounts to be paid for the reservation"; lblPaymentMsg.ForeColor = Color.Red; return; } if (SqlMoney.Parse(lblCost.Text) != 0) { SqlMoney toPay = SqlMoney.Parse(lblCost.Text); SqlMoney amountReceived = SqlMoney.Parse(txtAmountReceived.Text); if (amountReceived < toPay || amountReceived > toPay) { lblPaymentMsg.Text = "Please pay only the Pending Reservation Amount to confirm reservation"; lblPaymentMsg.ForeColor = Color.Red; return; } r.PendingAmount = new SqlMoney(0.00);//SqlMoney.Parse(lblCost.Text); r.BookingStatus = BookingStatus.CONFIRMED; r.PaymentStatus = PaymentStatus.FULLY_PAID; r.Update(); } rp.Rate_ID = r.Rate_ID; rp.UnitsConsumed = 0; rp.TotalCost_Before_Discount = r.PendingAmount; } else { if (r.BookingStatus != BookingStatus.CHECKED_IN) { lblPaymentMsg.Text = "Cannot Save Payment. Not yet Checked In"; lblPaymentMsg.ForeColor = Color.Red; return; } if (String.IsNullOrEmpty(txtUnits.Text)) { lblPaymentMsg.Text = "Please enter Units consumed"; lblPaymentMsg.ForeColor = Color.Red; return; } rp.Rate_ID = SqlInt32.Parse(drpService.SelectedValue); rp.UnitsConsumed = SqlInt32.Parse(txtUnits.Text); rp.TotalCost_Before_Discount = SqlMoney.Parse(lblCost.Text); } if (drpPaymentModes.SelectedValue == "-1") { lblPaymentMsg.Text = "Please select a Payment Mode"; lblPaymentMsg.ForeColor = Color.Red; return; } rp.Invoice = txtInvoice.Text == string.Empty ? string.Empty : txtInvoice.Text; rp.PaymentStatus = 1;//Active; rp.Discount_Offered = txtDiscount.Text == string.Empty ? 0 : SqlMoney.Parse(txtDiscount.Text); rp.Cost_After_Discount = rp.Discount_Offered == 0? rp.TotalCost_Before_Discount: SqlMoney.Parse(lblAfterDiscount.Text); rp.AmountReceived = txtAmountReceived.Text == string.Empty ? 0 : SqlMoney.Parse(txtAmountReceived.Text); rp.PaymentMode = SqlInt32.Parse(drpPaymentModes.SelectedValue); if (rp.Insert()) { Response.Redirect("Reservation.aspx?Reservation_ID=" + hidReservationId.Value, true); } else { lblPaymentMsg.Text = rp.ErrorDesc.ToString() + " Error Playment Not saved !!!"; lblPaymentMsg.ForeColor = Color.Green; return; } }
protected void btnSaveBooking_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtFromDate.Text) || string.IsNullOrEmpty(txtToDate.Text) || drpRoomTypes.SelectedValue.Equals("-1") || drpRateTypes.SelectedValue.Equals("-1") || drpRatesAvailable.SelectedValue.Equals("-1") || drpAvailableRooms.SelectedValue.Equals("-1") ) { lblMsg.Text = "Please select all the Booking fields"; lblMsg.ForeColor = Color.Red; return; } if (string.IsNullOrEmpty(txtBookingAmount.Text)) { lblMsg.Text = "Please calculate your booking amount"; lblMsg.ForeColor = Color.Red; return; } if (string.IsNullOrEmpty(hidNewGuestId.Value)) { lblMsg.Text = "Please select a Guest"; lblMsg.ForeColor = Color.Red; return; } lblMsg.Text = string.Empty; Reservations r = new Reservations(); r.ReservationDate = Utility.GetSqlDateTimeFromDateTime(DateTime.Today); r.FromDate = Utility.GetSqlDateTimeFromDateTime(DateTime.Parse(txtFromDate.Text)); r.ToDate = Utility.GetSqlDateTimeFromDateTime(DateTime.Parse(txtToDate.Text)); r.ReservationPersonnel = Utility.GetUserIdFromUserName(HttpContext.Current.User.Identity.Name); r.RateType = SqlInt32.Parse(drpRateTypes.SelectedValue); SqlInt32 rateId = SqlInt32.Parse(drpRatesAvailable.SelectedValue); r.Rate_ID = rateId; r.RoomType_ID = SqlInt32.Parse(drpRoomTypes.SelectedValue); r.Room_ID = SqlInt32.Parse(drpAvailableRooms.SelectedValue); r.Parent_Reservation_ID = 0; r.Connected_Room_ID = 0; r.Guest_ID = SqlInt32.Parse(hidNewGuestId.Value); r.BookingStatus = BookingStatus.CONFIRMED; r.Remarks = string.Empty; Reservation_Payments pay = new Reservation_Payments(); pay.PaymentPersonnel = Utility.GetUserIdFromUserName(HttpContext.Current.User.Identity.Name); pay.CreatedDate = Utility.GetSqlDateTimeFromDateTime(DateTime.Today); pay.Discount_ID = SqlInt32.Parse(hidDiscountId.Value); pay.AvailedService_Type = 1; //1=Reservation;2=Bills & Services;3=Amenities pay.Rate_ID = rateId; pay.UnitsConsumed = SqlInt32.Parse(hidBookingDays.Value); pay.Discount_Offered = SqlMoney.Parse(hidDiscountOffered.Value); pay.TotalCost_Before_Discount = SqlMoney.Parse(hidTotalCost.Value); pay.Cost_After_Discount = SqlMoney.Parse(hidCostAfterDiscount.Value); pay.AmountReceived = SqlMoney.Parse(txtBookingAmount.Text); if (pay.AmountReceived < pay.Cost_After_Discount) { r.PaymentStatus = PaymentStatus.PARTIAL_PAID; r.PendingAmount = pay.Cost_After_Discount - pay.AmountReceived; } else if (pay.AmountReceived == pay.Cost_After_Discount) { r.PaymentStatus = PaymentStatus.FULLY_PAID; } else { lblMsg.Text = "Booking Must be Less than or Equal to Cost after Discount"; lblMsg.ForeColor = Color.Red; return; } if (pay.AmountReceived != 0) { if (drpPaymentModes.SelectedValue == "-1") { lblMsg.Text = "Please select a Payment Mode"; lblMsg.ForeColor = Color.Red; return; } else { pay.PaymentMode = SqlInt32.Parse(drpPaymentModes.SelectedValue); } } pay.Remarks = r.Remarks; pay.PaymentStatus = 1; //Active if (r.Insert()) { pay.Reservation_ID = r.Reservation_ID; if (pay.Insert()) { // DataTable resevePay = pay.GetReservationPayment(); //Session["resevePay"] = resevePay; //string popupScript = "<script language='javascript'>" + // "window.open('ReservConfirm.aspx','ThisPopUp', " + // "'left = 300, top=150, " + // "menubar=no, scrollbars=yes, resizable=yes')" + // "</script>"; //Page.ClientScript.RegisterStartupScript(GetType(), "PopupScript", popupScript); Response.Redirect("Reservation.aspx?Reservation_ID=" + r.Reservation_ID.ToString(), true); } else { lblMsg.Text = "Reservation was saved. However, there was a problem in saving the Payment"; lblMsg.ForeColor = Color.Red; return; } } }
protected void btnSave_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(hidCheckInID.Value) || hidCheckInID.Value == "0") { lblStatus.Text = "The Reservation is invalid. Not Checked In"; return; } if (drpBillServices.SelectedValue == "-1") { lblStatus.Text = "Please choose a Bill Service"; return; } if (drpCheckIn.SelectedValue == "-1") { lblStatus.Text = "Please Bill Service"; return; } Reservation_Payments rp = new Reservation_Payments(); rp.Reservation_ID = SqlInt32.Parse(drpCheckIn.SelectedValue); rp.CreatedDate = Utility.GetSqlDateTimeFromDateTime(DateTime.Today); rp.PaymentPersonnel = Utility.GetUserIdFromUserName(HttpContext.Current.User.Identity.Name); rp.AvailedService_Type = PAYMENT_AVAILED_SERVICETYPES.BILLS_SERVICES; rp.Rate_ID = SqlInt32.Parse(drpBillServices.SelectedValue); rp.UnitsConsumed = SqlInt32.Parse(txtQuantity.Text); rp.TotalCost_Before_Discount = SqlMoney.Parse(txtPrice.Text); rp.Invoice = txtInvoice.Text == string.Empty ? string.Empty : txtInvoice.Text; rp.PaymentStatus = 1;//Active; rp.Discount_Offered = txtDiscount.Text == string.Empty ? 0 : SqlMoney.Parse(txtDiscount.Text); rp.Cost_After_Discount = rp.Discount_Offered == 0 ? rp.TotalCost_Before_Discount : SqlMoney.Parse(lblAfterDiscount.Text); rp.AmountReceived = txtAmountReceived.Text == string.Empty ? 0 : SqlMoney.Parse(txtAmountReceived.Text); if (rp.AmountReceived > 0) { if (drpPaymentModes.SelectedValue == "-1") { lblStatus.Text = "Please select a Payment Mode"; lblStatus.ForeColor = Color.Red; return; } else { rp.PaymentMode = SqlInt32.Parse(drpPaymentModes.SelectedValue); } } if (rp.Insert()) { rp.InsertServiceInvoice(); lblStatus.Text = "Payment Saved"; lblStatus.ForeColor = Color.Green; // return; //---------------for Printing the Amenity invoice---------------------------------------- DataTable amenitytbl = new DataTable(); DataColumn Id = new DataColumn("ID", typeof(int)); DataColumn ReservationID = new DataColumn("ReservationID", typeof(int)); DataColumn RoomId = new DataColumn("RoomID", typeof(string)); DataColumn ServiceName = new DataColumn("ServiceName", typeof(string)); DataColumn Invoice = new DataColumn("Invoice", typeof(string)); DataColumn Cost = new DataColumn("Cost", typeof(double)); DataColumn Qty = new DataColumn("Quantity", typeof(int)); DataColumn TotCost = new DataColumn("TotCost", typeof(double)); DataColumn Discount = new DataColumn("Discount", typeof(double)); DataColumn AfterDiscount = new DataColumn("AfterDiscount", typeof(double)); DataColumn AmountReceived = new DataColumn("AmountRecevied", typeof(double)); DataColumn PaymentMode = new DataColumn("PaymentMode", typeof(string)); DataColumn CreatedBy = new DataColumn("CreatedBy", typeof(string)); DataColumn InvoiceNo = new DataColumn("InvoiceNo", typeof(string)); amenitytbl.Columns.Add(Id); amenitytbl.Columns.Add(ReservationID); amenitytbl.Columns.Add(RoomId); amenitytbl.Columns.Add(ServiceName); amenitytbl.Columns.Add(Invoice); amenitytbl.Columns.Add(Cost); amenitytbl.Columns.Add(Qty); amenitytbl.Columns.Add(TotCost); amenitytbl.Columns.Add(Discount); amenitytbl.Columns.Add(AfterDiscount); amenitytbl.Columns.Add(AmountReceived); amenitytbl.Columns.Add(PaymentMode); amenitytbl.Columns.Add(CreatedBy); amenitytbl.Columns.Add(InvoiceNo); DataRow row = amenitytbl.NewRow(); row["Id"] = 1; row["ReservationID"] = Int32.Parse(rp.Reservation_ID.ToString()); row["ServiceName"] = drpBillServices.SelectedItem.Text; row["Invoice"] = txtInvoice.Text; row["Cost"] = double.Parse(lblPrice.Text); row["Quantity"] = int.Parse(rp.UnitsConsumed.ToString()); row["TotCost"] = double.Parse(rp.TotalCost_Before_Discount.ToString()); row["Discount"] = double.Parse(rp.Discount_Offered.ToString()); row["AfterDiscount"] = double.Parse(rp.Cost_After_Discount.ToString()); row["AmountRecevied"] = double.Parse(rp.AmountReceived.ToString()); row["PaymentMode"] = drpPaymentModes.SelectedItem.Text; row["CreatedBy"] = HttpContext.Current.User.Identity.Name; row["InvoiceNo"] = rp.ServiceNo.ToString(); amenitytbl.Rows.Add(row); Session["Inv"] = amenitytbl; string popupScript = "<script language='javascript'>" + "window.open('AmenityInvView.aspx','ThisPopUp1', " + "'left = 300, top=150, " + "menubar=no, scrollbars=yes, resizable=yes')" + "</script>"; Page.ClientScript.RegisterStartupScript(GetType(), "PopupScript", popupScript); //---------------------------------------------------------------------------------- } else { lblStatus.Text = rp.ErrorDesc.ToString() + " Error Playment Not saved !!!"; lblStatus.ForeColor = Color.Red; return; } }
private void ConfirmCheckOut(SqlInt32 reserationId) { if (reserationId == 0) { this.lblMsg.Text = "Invalid Reservation. Try Again"; lblMsg.ForeColor = Color.Red; return; } Reservations r = new Reservations(); r.Reservation_ID = reserationId; r.SelectOne(); Reservation_Payments rps = new Reservation_Payments(); rps.Reservation_ID = reserationId; DataTable rpsTable = rps.SelectAll(); CheckIn chkIn = new CheckIn(); chkIn.Reservation_ID = reserationId; chkIn.SelectOne(); lblBookingFromDate.Text = r.FromDate.Value.ToString("MMMM d, yyyy"); lblBookingToDate.Text = r.ToDate.Value.ToString("MMMM d, yyyy"); int bookedDays = Utility.GetNumberOfDaysFromRange(r.FromDate.Value, r.ToDate.Value); lblBookedDays.Text = bookedDays.ToString(); lblCheckInDate.Text = chkIn.CheckIn_Date.Value.ToString("MMMM d, yyyy"); SqlDateTime chkOutDate = Utility.GetSqlCheckOutTimeFromDate(DateTime.Now); if (r.ToDate.Value >= DateTime.Now) { chkOutDate = r.ToDate; } lblCheckOutDate.Text = chkOutDate.Value.ToString("MMMM d, yyyy"); int stayedDays = Utility.GetNumberOfDaysFromRange(r.FromDate.Value, chkOutDate.Value); lblStayedDays.Text = stayedDays.ToString(); CheckOut chkOut = new CheckOut(); chkOut.Reservation_ID = reserationId; DataTable table = chkOut.ConfirmCheckOut(); grid.DataSource = table; grid.DataBind(); SqlMoney pendingAmount = new SqlMoney(0.00); foreach (DataRow row in table.Rows) { SqlMoney amount = SqlMoney.Parse(row["PendingAmount"].ToString()); pendingAmount = pendingAmount + amount; } if (stayedDays > bookedDays) { int difference = stayedDays - bookedDays; Rates rate = new Rates(); rate.Rate_ID = r.Rate_ID; rate.SelectOne(); pendingAmount = pendingAmount + (difference * rate.Rate); } this.lblPendingPayment.Text = pendingAmount.ToString(); }
protected void btnCheckOut_Click(object sender, EventArgs e) { Reservations r = new Reservations(); r.Reservation_ID = SqlInt32.Parse(hidReservationId.Value); r.SelectOne(); Reservation_Payments rps = new Reservation_Payments(); rps.Reservation_ID = SqlInt32.Parse(hidReservationId.Value); DataTable rpsTable = rps.SelectAll(); CheckIn chkIn = new CheckIn(); chkIn.Reservation_ID = SqlInt32.Parse(hidReservationId.Value); chkIn.SelectOne(); CheckOut chkOut = new CheckOut(); chkOut.Reservation_ID = SqlInt32.Parse(hidReservationId.Value); chkOut.SelectOne(); DataTable table = chkOut.ConfirmCheckOut(); chkOut.CheckOut_Date = Utility.GetSqlDateTimeFromDateTime(DateTime.Now); chkOut.CheckIn_ID = chkIn.CheckIn_ID; chkOut.FinalSettlementAmount = SqlMoney.Parse(lblPendingPayment.Text); chkOut.Remarks = txtComments.Text; SqlMoney totalCostOfReservation = new SqlMoney(0.00); SqlMoney totalDiscountForReservation = new SqlMoney(0.00); SqlMoney totalCostOfReservationAfterDiscount = new SqlMoney(0.00); SqlMoney totalRcvdForReservation = new SqlMoney(0.00); SqlMoney totalCostOfServicesAmneities = new SqlMoney(0.00); SqlMoney totalDiscountForServicesAmneities = new SqlMoney(0.00); SqlMoney totalCostOfServicesAmneitiesAfterDiscount = new SqlMoney(0.00); SqlMoney totalRcvdForServicesAmneities = new SqlMoney(0.00); foreach (DataRow row in table.Rows) { if (row["ServiceType"].ToString().Equals("Reservation")) { totalCostOfReservation += SqlMoney.Parse(row["Total_Before_Discount"].ToString()); totalDiscountForReservation += SqlMoney.Parse(row["DiscountOffered"].ToString()); totalCostOfReservationAfterDiscount += SqlMoney.Parse(row["Cost_After_Discount"].ToString()); totalRcvdForReservation += SqlMoney.Parse(row["AmountReceived"].ToString()); } else { totalCostOfServicesAmneities += SqlMoney.Parse(row["Total_Before_Discount"].ToString()); totalCostOfServicesAmneities += SqlMoney.Parse(row["DiscountOffered"].ToString()); totalCostOfServicesAmneitiesAfterDiscount += SqlMoney.Parse(row["Cost_After_Discount"].ToString()); totalRcvdForServicesAmneities += SqlMoney.Parse(row["AmountReceived"].ToString()); } } SqlMoney pendingPayment = SqlMoney.Parse(lblPendingPayment.Text); chkOut.Cost_Of_Reservation = totalCostOfReservation; chkOut.DiscountOffered_For_Reservations = totalDiscountForReservation; chkOut.AmountReceived_For_Reservation = totalRcvdForReservation; chkOut.Cost_Of_ServicesAmenities = totalCostOfServicesAmneities; chkOut.DiscountOffered_For_ServicesAmenities = totalDiscountForServicesAmneities; chkOut.AmountReceived_For_ServicesAmenities = totalRcvdForServicesAmneities; chkOut.FinalSettlementAmount = pendingPayment; if (chkOut.FinalSettlementAmount > 0) { if (drpPaymentModes.SelectedValue == "-1") { lblMsg.Text = "Please select a Payment Mode"; lblMsg.ForeColor = Color.Red; return; } else { chkOut.PaymentMode = SqlInt32.Parse(drpPaymentModes.SelectedValue); } } chkOut.CheckOut_Personnel = Utility.GetUserIdFromUserName(HttpContext.Current.User.Identity.Name); if (chkOut.Insert()) { hidCheckOutId.Value = chkOut.CheckIn_ID.ToString(); //-------------INSERT TO iNVOICES TABLE TO GENERATE THE iNVOICE NO------------- chkOut.InsertInvoice(); //------------------------------------------------------------------------------- lblMsg.Text = "Successfully Checked Out"; lblMsg.ForeColor = Color.Green; } else { lblMsg.Text = "Error in Checking Out"; lblMsg.ForeColor = Color.Red; } }
protected void btnCheckIn_Click(object sender, EventArgs e) { DateTime checkInDate = DateTime.Parse(txtCheckInDate.Text); SqlDateTime sCheckInDate = Utility.GetSqlCheckInTimeFromDate(checkInDate); if (checkInDate.Date > DateTime.Today || checkInDate.Date < DateTime.Today) { lblMsg.Text = "Invalid Date is wrong"; } Reservations r = new Reservations(); r.Reservation_ID = SqlInt32.Parse(hidReservationId.Value); r.SelectOne(); Reservation_Payments rp = new Reservation_Payments(); rp.Reservation_ID = r.Reservation_ID; rp.SelectAll(); if (r.BookingStatus == BookingStatus.CHECKED_IN) { lblMsg.Text = "Invalid Check In. Already Checked In"; lblMsg.ForeColor = Color.Red; return; } if (r.PaymentStatus == PaymentStatus.PARTIAL_PAID) { lblMsg.Text = "Please pay the pending amount"; lblMsg.ForeColor = Color.Red; return; } if (sCheckInDate.Value.Date > r.ToDate.Value.Date) { lblMsg.Text = "Invalid Check In Date. Booking Period is past"; lblMsg.ForeColor = Color.Red; btnCancel.Visible = true; return; } if (sCheckInDate.Value.Date < r.FromDate.Value.Date) { lblMsg.Text = "Invalid Check In Date. Selected date is earlier than Booked From date"; lblMsg.ForeColor = Color.Red; return; } CheckIn checkIn = new CheckIn(); checkIn.Reservation_ID = r.Reservation_ID; checkIn.CheckIn_Date = sCheckInDate; checkIn.Remarks = txtComments.Text; checkIn.CheckIn_Date = Utility.GetSqlDateTimeFromDateTime(DateTime.Now); checkIn.CheckIn_Personnel = Utility.GetUserIdFromUserName(HttpContext.Current.User.Identity.Name); if (checkIn.Insert()) { lblMsg.Text = "Sucessfully Checked In"; lblMsg.ForeColor = Color.Green; return; } else { lblMsg.Text = checkIn.ErrorCode.ToString() + " - " + checkIn.ErrorDesc.ToString(); lblMsg.ForeColor = Color.Red; return; } }
protected void SetPreviousPageProperties() { //Guest Info; Guests guest = (Guests)Session["Guest"]; this.lblGuestName.Text = (guest.FirstName + " " + guest.MiddleName + " " + guest.LastName).ToString(); this.lblGuestMobile.Text = guest.MobileNumber.ToString(); this.lblGuestCvd.Text = guest.Civil_ID.ToString(); this.lblGuestEmail.Text = guest.Email.ToString(); this.hidGuestId.Value = guest.Guest_ID.ToString(); this.Guest_ID = guest.Guest_ID; //Reservation Info; Reservations reservation = (Reservations)Session["Reservation"]; this.hidFromDate.Value = reservation.FromDate.ToString(); this.lblFromDate.Text = "<span class=\"glyphicon glyphicon-calendar\" aria-hidden=\"true\"></span> " + Utility.GetDateTimeFromSqlDateTime(reservation.FromDate).ToString("dd/MM/yyyy"); this.FromDate = reservation.FromDate; this.hidToDate.Value = reservation.ToDate.ToString(); this.lblToDate.Text = "<span class=\"glyphicon glyphicon-calendar\" aria-hidden=\"true\"></span> " + Utility.GetDateTimeFromSqlDateTime(reservation.ToDate).ToString("dd/MM/yyyy"); this.ToDate = reservation.ToDate; this.hidNumAdults.Value = Session["NumAdults"].ToString(); this.lblAdults.Text = Session["NumAdults"].ToString(); this.NumAdults = (SqlInt32)Session["NumAdults"]; this.hidNumKids.Value = Session["NumKids"].ToString(); this.lblKids.Text = Session["NumKids"].ToString(); this.NumKids = (SqlInt32)Session["NumKids"]; this.hidBookingDays.Value = Session["BookingDays"].ToString(); this.lblDays.Text = Session["BookingDays"].ToString(); this.BookingDays = (SqlInt32)Session["BookingDays"]; this.NumRooms = (SqlInt32)Session["NumRooms"]; this.hidNumRooms.Value = Session["NumRooms"].ToString(); this.lblRoomType.Text = Session["RoomType"].ToString(); this.hidRoomType.Value = Session["RoomType"].ToString(); this.RoomType = Session["RoomType"].ToString(); this.hidRoomTypeId.Value = Session["RoomType_ID"].ToString(); this.RoomType_ID = (SqlInt32)Session["RoomType_ID"]; this.hidRoomId.Value = Session["Room_ID"].ToString(); this.Room_ID = (SqlInt32)Session["Room_ID"]; this.hidRate.Value = Session["Rate"].ToString(); this.Rate = (SqlMoney)Session["Rate"]; this.hidRateType.Value = Session["RateType"].ToString(); this.RateType = (SqlInt32)Session["RateType"]; this.hidRateId.Value = Session["Rate_ID"].ToString(); this.Rate_ID = (SqlInt32)Session["Rate_ID"]; this.TotalCostAfterDiscount = (SqlMoney)Session["TotalCostAfterDiscount"]; this.hidDiscountOffered.Value = Session["DiscountOffered"].ToString(); this.DiscountOffered = (SqlMoney)Session["DiscountOffered"]; this.hidTotalCost.Value = Session["TotalCost"].ToString(); this.TotalCost = (SqlMoney)Session["TotalCost"]; this.hidDiscountId.Value = Session["Discount_ID"].ToString(); this.Discount_ID = (SqlInt32)Session["Discount_ID"]; this.hidReservationId.Value = Session["ReservationID"].ToString(); this.Reservation_ID = (SqlInt32)Session["ReservationID"]; this.hidPaymentId.Value = Session["PaymentID"].ToString(); this.Payment_ID = (SqlInt32)Session["PaymentID"]; //Payment Info Reservation_Payments pay = (Reservation_Payments)Session["Reservation_Payments"]; this.lblRoomCharges.Text = pay.Cost_After_Discount.ToString(); this.hidRoomCharges.Value = pay.Cost_After_Discount.ToString(); this.hidCostAfterDiscount.Value = pay.Cost_After_Discount.ToString(); SqlMoney totalRoomCost = new SqlMoney(0.00); SqlMoney totalFerryCost = new SqlMoney(0.00); SqlMoney kidsFerryCost = new SqlMoney(0.00); SqlMoney adultsFerryCost = new SqlMoney(0.00); SqlMoney totalCost = new SqlMoney(0.00); GetReservationPayment(reservation.Reservation_ID); if (reservationPaymentsTbl != null) { foreach (DataRow r in reservationPaymentsTbl.Rows) { if ((Int32)r["AvailedService_Type"] == PAYMENT_AVAILED_SERVICETYPES.FERRY_KIDS) { kidsFerryCost = (Decimal)r["Cost_After_Discount"]; } if ((Int32)r["AvailedService_Type"] == PAYMENT_AVAILED_SERVICETYPES.FERRY_ADULTS) { adultsFerryCost = (Decimal)r["Cost_After_Discount"]; } if ((Int32)r["AvailedService_Type"] == PAYMENT_AVAILED_SERVICETYPES.RESERVATION) { totalRoomCost = (Decimal)r["Cost_After_Discount"]; } } } totalFerryCost = (adultsFerryCost + kidsFerryCost); totalCost = (totalFerryCost + totalRoomCost); /* * //Ferry Ticket Info * bool wantFerry = (bool)Session["WantFerry"]; * if (wantFerry) * { * Ferry ferry = (Ferry)Session["Ferry"]; * if (ferry != null) * { * this.lblFerryAdults.Text = ferry.NumberOfAdults.ToString(); * this.lblFerryKids.Text = ferry.NumberOfKids.ToString(); * this.lblFerryAdultsValidity.Text = Utility.GetDateTimeFromSqlDateTime(reservation.FromDate).ToString("dd/MM/yyyy"); * this.lblFerryKidsValidity.Text = Utility.GetDateTimeFromSqlDateTime(reservation.FromDate).ToString("dd/MM/yyyy"); * this.lblDepartureDate.Text = Utility.GetDateTimeFromSqlDateTime(reservation.ToDate).ToString("dd/MM/yyyy"); * this.lblDepartureTickets.Text = (ferry.NumberOfAdults + ferry.NumberOfKids).ToString(); * this.lblFerryCharges.Text = totalFerryCost.ToString();//ferry.Total_Cost.ToString(); * this.lblTotalCharges.Text = totalCost.ToString();//(pay.Cost_After_Discount + ferry.Total_Cost).ToString(); * this.hidCostAfterDiscount.Value = totalCost.ToString();//(pay.Cost_After_Discount + ferry.Total_Cost).ToString(); * } * } * else * { * this.lblFerryAdults.Text = "0"; * this.lblFerryKids.Text = "0"; * this.lblFerryAdultsValidity.Text = "N/A"; * this.lblFerryKidsValidity.Text = "N/A"; * this.lblDepartureDate.Text = "N/A"; * this.lblDepartureTickets.Text = "0"; * this.lblFerryCharges.Text = "0.00"; * this.lblTotalCharges.Text = (pay.Cost_After_Discount).ToString(); * } */ this.lblTotalCharges.Text = (pay.Cost_After_Discount).ToString(); roomTbl = (DataTable)Session["AvailableRooms"]; //PreviousPage.AvailableRooms; }