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;
}
}
