public static int GetPaymentTermIDByCode(string Code) { var paymentterm = new PaymentTerm(); var query = string.Format(@"select * from PaymentTerm where PaymentTermCode ='{0}'", Code); paymentterm.LoadFromRawSql(query); return paymentterm.ID; }
public static int GetPaymentTermIDByCode(string Code) { var paymentterm = new PaymentTerm(); var query = string.Format(@"select * from PaymentTerm where PaymentTermCode ='{0}'", Code); paymentterm.LoadFromRawSql(query); return(paymentterm.ID); }
private static void AddBookingProcessData(BookingProcess bp, DateTime?date) { DateTime date1 = bp.OfferInfo.CheckIn; if (date != null) { TimeSpan days = date1.Subtract((DateTime)date); int difference = days.Days; DateTime bookingdate = (DateTime)date; if (difference > 60) { List <PaymentTerm> list = new List <PaymentTerm>(); PaymentTerm paymentTerm1 = new PaymentTerm(); paymentTerm1.Date = bookingdate.AddDays(7); paymentTerm1.Percent = 30; paymentTerm1.Eur = bp.PriceValueByBooking * 30 / 100; PaymentTerm paymentTerm2 = new PaymentTerm(); paymentTerm2.Date = bp.OfferInfo.CheckIn.AddDays(-42); paymentTerm2.Percent = 70; paymentTerm2.Eur = bp.PriceValueByBooking * 70 / 100; list.Add(paymentTerm1); list.Add(paymentTerm2); bp.PaymentTerms = list; List <TravelApplicantPayment> travelapplicantpayments = new List <TravelApplicantPayment>(); TravelApplicantPayment payment1 = new TravelApplicantPayment(); payment1.Date = bookingdate.AddDays(7); payment1.Value = bp.PriceValueByBooking * 30 / 100; TravelApplicantPayment payment2 = new TravelApplicantPayment(); payment2.Date = bp.OfferInfo.CheckIn.AddDays(-42); payment2.Value = bp.PriceValueByBooking * 70 / 100; travelapplicantpayments.Add(payment1); travelapplicantpayments.Add(payment2); bp.Payments = travelapplicantpayments; } } List <ProviderPayment> providerpayments = new List <ProviderPayment>(); ProviderPayment Payment = new ProviderPayment(); Payment.Date = bp.OfferInfo.CheckIn.AddDays(-30); Payment.Value = bp.PriceValueByBooking * 80 / 100; providerpayments.Add(Payment); bp.PaymentsForProvider = providerpayments; }