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