private void UpdateKNET(string knetPaymentId, string result, string auth, string Ref, string TranID, string TrackID)
{
KNET_Payments knet = new KNET_Payments();
knet.KNET_Payment_ID = knetPaymentId;
knet.SelectOne();
knet.Result = result;
knet.Auth = auth;
knet.Ref = Ref;
knet.TransVal = TranID;
knet.Track_ID = TrackID;
knet.PaymentSatus = PaymentStatus.KNET_ERROR;
knet.Remarks = knet.Remarks + "- KNET ERROR";
String status = "Error in KNET Payment !!!";
if (result == "CANCELED")
{
knet.PaymentSatus = PaymentStatus.KNET_CANCELED;
knet.Remarks = knet.Remarks + "- KNET CANCELED";
status = "KNET Payment Canceled!!!";
}
if (knet.Update())
{
this.lblStatus.Text = status;
}
else
{
this.lblStatus.Text = "KNET Payment Error. Error in Saving it !!!";
}
}
private KNET_Payments GetKnetPayment(string knetPaymentId)
{
KNET_Payments knet = new KNET_Payments();
knet.KNET_Payment_ID = knetPaymentId;
knet.SelectOne();
return(knet);
}
private void UpdateKNET(string knetPaymentId, string result, string auth, string Ref, string TranID, string TrackID)
{
KNET_Payments knet = new KNET_Payments();
knet.KNET_Payment_ID = knetPaymentId;
knet.SelectOne();
knet.Result = result;
knet.Auth = auth;
knet.Ref = Ref;
knet.TransVal = TranID;
knet.Track_ID = TrackID;
knet.PaymentSatus = PaymentStatus.KNET_SUCCESS;
knet.Remarks = knet.Remarks + "- KNET Success";
if (knet.Update())
{
this.lblStatus.Text = "Successful Payment";
}
else
{
this.lblStatus.Text = "Successful Payment. Error in Saving it !!!";
}
}
private void BindReservation(string knetPaymentId)
{
KNET_Payments knet = new KNET_Payments();
knet.KNET_Payment_ID = knetPaymentId;
knet.SelectOne();
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();
Reservations reservation = new Reservations();
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");
Guests guest = new Guests();
guest.Guest_ID = reservation.Guest_ID;
guest.SelectOne();
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();
if (guest.Email.ToString() != "")
{
SendMail(knetPaymentId, "Success", "", "", "", knet.Reservation_ID.ToString(), guest.Email.ToString(), guest.FirstName.ToString());
}
}