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