コード例 #1
0
        public void DeletHotelTariffCharges(HotelTariffPriceDetailsInfo hoteltariffpricedetail)
        {
            foreach (var item in hoteltariffpricedetail.HotelTariffCharges)
            {
                List <SqlParameter> sqlParam = new List <SqlParameter>();

                sqlParam.Add(new SqlParameter("HotelTariffPriceDetailsId", item.HotelTariffPriceDetailsId));

                _sqlHelper.ExecuteNonQuery(sqlParam, Storeprocedures.spDeletHotelTariffCharges.ToString(), CommandType.StoredProcedure);
            }
        }
コード例 #2
0
        public HotelTariffTaxUpdationViewModel()
        {
            HotelTariffTax = new HotelTariffTaxUpdationInfo();

            HotelTariffTaxes = new List <HotelTariffTaxUpdationInfo>();

            Vendors = new List <VendorInfo>();

            Hotels = new List <HotelInfo>();

            Meals = new List <MealInfo>();

            Pager = new PaginationInfo();

            FriendlyMessage = new List <FriendlyMessage>();

            //for date details

            HotelTariffDate = new HotelTariffDateDetailsInfo();

            HotelTariffDates = new List <HotelTariffDateDetailsInfo>();

            //for duration

            HotelTariffDuration = new HotelTariffDurationDetailsInfo();

            HotelTariffDurations = new List <HotelTariffDurationDetailsInfo>();

            //for price

            HotelTariffPrice = new HotelTariffPriceDetailsInfo();

            HotelTariffPrices = new List <HotelTariffPriceDetailsInfo>();

            //for room

            HotelTariffRoom = new HotelTariffRoomDetailsInfo();

            HotelTariffRooms = new List <HotelTariffRoomDetailsInfo>();

            // Tax Formula

            LstStandardCharges = new List <ChargesInfo>();

            LstTaxFormula = new List <TaxFormulaInfo>();

            LstTaxFormula = new List <TaxFormulaInfo>();

            //Charges

            Charges = new ChargesInfo();
        }
コード例 #3
0
        public void InsertPriceChargesDetails(HotelTariffPriceDetailsInfo hoteltariffpricedetail)
        {
            foreach (var item in hoteltariffpricedetail.HotelTariffCharges)
            {
                List <SqlParameter> sqlParam = new List <SqlParameter>();

                if (item.HotelTariffChargesDetailsId != 0)
                {
                    sqlParam.Add(new SqlParameter("HotelTariffChargesDetailsId", item.HotelTariffChargesDetailsId));
                }

                sqlParam.Add(new SqlParameter("@HotelTariffPriceDetailsId", item.HotelTariffPriceDetailsId));

                sqlParam.Add(new SqlParameter("@ChargesId", item.ChargesId));

                sqlParam.Add(new SqlParameter("@Percentage", item.Percentage));

                sqlParam.Add(new SqlParameter("@CalculatedPrice", item.CalculatedPrice));

                _sqlHelper.ExecuteNonQuery(sqlParam, Storeprocedures.spInsertHotelTariffCharges.ToString(), CommandType.StoredProcedure);
            }
        }
コード例 #4
0
        public HotelTariffViewModel()
        {
            HotelTariff = new HotelTariffInfo();

            HotelTariffs = new List <HotelTariffInfo>();

            Vendors = new List <VendorInfo>();

            Hotels = new List <HotelInfo>();

            RoomTypes = new List <RoomTypeInfo>();

            Meals = new List <MealInfo>();

            Occupancies = new List <OccupancyInfo>();

            Filter = new HotelTariffFilter();

            Pager = new PaginationInfo();

            FriendlyMessage = new List <FriendlyMessage>();

            //for date details

            HotelTariffDate = new HotelTariffDateDetailsInfo();

            HotelTariffDates = new List <HotelTariffDateDetailsInfo>();

            //for duration
            HotelTariffDuration = new HotelTariffDurationDetailsInfo();

            HotelTariffDurations = new List <HotelTariffDurationDetailsInfo>();

            HotelTariffDurationFilter = new HotelTariffDurationFilter();

            //for price
            HotelTariffPrice = new HotelTariffPriceDetailsInfo();

            HotelTariffPrices = new List <HotelTariffPriceDetailsInfo>();

            HotelTariffPriceFilter = new HotelTariffPriceFilter();


            //for room
            HotelTariffRoom = new HotelTariffRoomDetailsInfo();

            HotelTariffRooms = new List <HotelTariffRoomDetailsInfo>();

            HotelTariffRoomFilter = new HotelTariffRoomFilter();

            //for room Occupancy
            HotelTariffRoomOccupancy = new HotelTariffRoomOccupancyInfo();

            HotelTariffRoomOccupancies = new List <HotelTariffRoomOccupancyInfo>();

            HotelTariffRoomOccupancyFilter = new HotelTariffRoomOccupancyFilter();

            //For tax formula

            LstStandardCharges = new List <ChargesInfo>();

            LstTaxFormula = new List <TaxFormulaInfo>();

            LstTaxFormulaCharges = new List <TaxFormulaChargesInfo>();
            //for Customer Category

            HotelTariffCustomerCategory = new HotelTariffCustomerCategoryDetailsInfo();

            HotelTariffCustomerCategories = new List <HotelTariffCustomerCategoryDetailsInfo>();

            CustomerCategory = new CustomerCategoryInfo();

            CustomerCategories = new List <CustomerCategoryInfo>();

            HotelTariffCustomerCategoryFilter = new HotelTariffCustomerCategoryFilter();
        }
コード例 #5
0
        public void UpdateHotelTariffPriceDetails(List <HotelTariffPriceDetailsInfo> hoteltariffpricedetails, HotelTariffPriceDetailsInfo hoteltariffpricedetail, HotelTariffTaxUpdationInfo hoteltax)
        {
            foreach (var item in hoteltariffpricedetails)
            {
                List <SqlParameter> sqlParams = new List <SqlParameter>();

                sqlParams.Add(new SqlParameter("@HotelTariffPriceDetailsId", item.HotelTariffPriceDetailsId));

                sqlParams.Add(new SqlParameter("@HotelTariffDurationDetailsId", item.HotelTariffDurationDetailsId));
                Logger.Debug("HotelTariff Controller HotelTariffDurationDetailsId:" + item.HotelTariffDurationDetailsId);

                sqlParams.Add(new SqlParameter("@HotelTariffRoomOccupancyId", item.HotelTariffRoomOccupancyId));
                Logger.Debug("HotelTariff Controller HotelTariffRoomOccupancyId:" + item.HotelTariffRoomOccupancyId);

                sqlParams.Add(new SqlParameter("@HotelTariffId", item.HotelTariffId));
                Logger.Debug("HotelTariff Controller HotelTariffId:" + item.HotelTariffId);

                sqlParams.Add(new SqlParameter("@PublishPrice", item.PublishPrice));
                Logger.Debug("HotelTariff Controller PublishPrice:" + item.PublishPrice);

                sqlParams.Add(new SqlParameter("@SpecialPrice", item.SpecialPrice));
                Logger.Debug("HotelTariff Controller SpecialPrice:" + item.SpecialPrice);

                sqlParams.Add(new SqlParameter("@CommissionPrice", item.CommissionPrice));
                Logger.Debug("HotelTariff Controller CommissionPrice:" + item.CommissionPrice);

                sqlParams.Add(new SqlParameter("@FormulaId", hoteltax.TaxFormulaId));
                Logger.Debug("HotelTariff Controller TaxFormulaId:" + hoteltax.TaxFormulaId);

                sqlParams.Add(new SqlParameter("@TotalTaxPrice", item.TotalTaxPrice));
                Logger.Debug("HotelTariff Controller TotalTaxPrice:" + item.TotalTaxPrice);

                sqlParams.Add(new SqlParameter("@NetRate", item.NetRate));
                Logger.Debug("HotelTariff Controller NetRate:" + item.NetRate);

                sqlParams.Add(new SqlParameter("@NetRatePerNight", item.NetRatePerNight));
                Logger.Debug("HotelTariff Controller NetRatePerNight:" + item.NetRatePerNight);

                sqlParams.Add(new SqlParameter("@UpdatedDate", item.UpdatedDate));

                sqlParams.Add(new SqlParameter("@UpdatedBy", item.UpdatedBy));

                _sqlHelper.ExecuteNonQuery(sqlParams, Storeprocedures.spUpdateHotelTariffPriceDetails.ToString(), CommandType.StoredProcedure);
            }

            //DeletHotelTariffCharges(hoteltariffpricedetail);

            //InsertPriceChargesDetails(hoteltariffpricedetail);
        }
コード例 #6
0
        public LohanaPackageTariffSearchViewModel()
        {
            FriendlyMessage = new List <FriendlyMessage>();

            LohanaPackageTariffSearch = new LohanaPackageTariffSearchInfo();

            LohanaPackageTariffSearchList = new List <LohanaPackageTariffSearchInfo>();

            LohanaPackageTariffRoot = new LohanaPackageTariffRootInfo();

            LohanaPackageTariffRootList = new List <LohanaPackageTariffRootInfo>();

            LohanaPackageTariff = new LohanaPackageTariffInfo();

            LohanaPackageTariffList = new List <LohanaPackageTariffInfo>();

            HotelTariff = new HotelTariffInfo();

            HotelTariffs = new List <HotelTariffInfo>();

            PackageType = new PackageTypeInfo();

            PackageTypes = new List <PackageTypeInfo>();

            Hotel = new HotelInfo();

            Hotels = new List <HotelInfo>();

            RoomType = new RoomTypeInfo();

            Cities = new List <CityInfo>();

            City = new CityInfo();

            Pager = new PaginationInfo();

            HotelTariffDate = new HotelTariffDateDetailsInfo();

            HotelTariffDates = new List <HotelTariffDateDetailsInfo>();

            HotelTariffDuration = new HotelTariffDurationDetailsInfo();

            HotelTariffDurations = new List <HotelTariffDurationDetailsInfo>();

            HotelTariffPrice = new HotelTariffPriceDetailsInfo();

            HotelTariffPrices = new List <HotelTariffPriceDetailsInfo>();

            HotelTariffRoom = new HotelTariffRoomDetailsInfo();

            HotelTariffRooms = new List <HotelTariffRoomDetailsInfo>();


            LohanaPackageTariffSearchRoomList = new List <LohanaPackageTariffSearchInfo>();

            LohanaPackageTariffSearchExtraChildList = new List <LohanaPackageTariffSearchInfo>();

            LohanaPackageTariffSearchExtraList = new List <LohanaPackageTariffSearchInfo>();

            LohanaPackageTariffSearchFilter = new LohanaPackageTariffSearchInfo();

            LohanaPackageTariffSearchFilterList = new List <LohanaPackageTariffSearchInfo>();


            LohanaPackageItienaryList = new List <LohanaPackageTariffSearchInfo>();


            Enquiry = new EnquiryInfo();
        }