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;
 }
예제 #2
0
        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);
        }
예제 #3
0
파일: DBData.cs 프로젝트: ibudisa/IDOM
        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;
        }