Esempio n. 1
0
        private SightSeeingTariffOccupancyInfo GetSightSeeingTariffOccupancyValues(DataRow dr)
        {
            SightSeeingTariffOccupancyInfo sightseeingtariffoccupancy = new SightSeeingTariffOccupancyInfo();

            sightseeingtariffoccupancy.SightSeeingTariffId = Convert.ToInt32(dr["SightSeeingTariffId"]);
            sightseeingtariffoccupancy.OccupancyId         = Convert.ToInt32(dr["OccupancyId"]);
            sightseeingtariffoccupancy.AgeFrom             = Convert.ToDecimal(dr["AgeFrom"]);
            sightseeingtariffoccupancy.AgeTo       = Convert.ToDecimal(dr["AgeFrom"]);
            sightseeingtariffoccupancy.MealId      = Convert.ToInt32(dr["MealId"]);
            sightseeingtariffoccupancy.Inclusion   = Convert.ToString(dr["Inclusion"]);
            sightseeingtariffoccupancy.Exclusion   = Convert.ToString(dr["Exclusion"]);
            sightseeingtariffoccupancy.CreatedDate = Convert.ToDateTime(dr["CreatedDate"]);
            sightseeingtariffoccupancy.CreatedBy   = Convert.ToInt32(dr["CreatedBy"]);
            sightseeingtariffoccupancy.UpdatedDate = Convert.ToDateTime(dr["UpdatedDate"]);
            sightseeingtariffoccupancy.UpdatedBy   = Convert.ToInt32(dr["UpdatedBy"]);

            return(sightseeingtariffoccupancy);
        }
Esempio n. 2
0
        private List <SqlParameter> SetValuesInSightSeeingTariffOccupancy(SightSeeingTariffOccupancyInfo sightseeingtariffoccupancy)
        {
            List <SqlParameter> sqlParams = new List <SqlParameter>();

            if (sightseeingtariffoccupancy.SightSeeingTariffOccupancyId != 0)
            {
                sqlParams.Add(new SqlParameter("@SightSeeingTariffOccuapancyId", sightseeingtariffoccupancy.SightSeeingTariffOccupancyId));
            }
            else
            {
                sqlParams.Add(new SqlParameter("@CreatedDate", sightseeingtariffoccupancy.CreatedDate));

                sqlParams.Add(new SqlParameter("@CreatedBy", sightseeingtariffoccupancy.CreatedBy));

                sqlParams.Add(new SqlParameter("@SightSeeingTariffId", sightseeingtariffoccupancy.SightSeeingTariffId));
                Logger.Debug("SightSeeingTariff Controller SightSeeingTariffId:" + sightseeingtariffoccupancy.SightSeeingTariffId);
            }

            sqlParams.Add(new SqlParameter("@OccupancyId", sightseeingtariffoccupancy.OccupancyId));
            Logger.Debug("SightSeeingTariff Controller OccupancyId:" + sightseeingtariffoccupancy.OccupancyId);

            sqlParams.Add(new SqlParameter("@AgeFrom", sightseeingtariffoccupancy.AgeFrom));
            Logger.Debug("SightSeeingTariff Controller AgeFrom:" + sightseeingtariffoccupancy.AgeFrom);

            sqlParams.Add(new SqlParameter("@AgeTo", sightseeingtariffoccupancy.AgeTo));
            Logger.Debug("SightSeeingTariff Controller AgeTo:" + sightseeingtariffoccupancy.AgeTo);

            sqlParams.Add(new SqlParameter("@MealId", sightseeingtariffoccupancy.MealId));
            Logger.Debug("SightSeeingTariff Controller MealId:" + sightseeingtariffoccupancy.MealId);

            sqlParams.Add(new SqlParameter("@Inclusion", sightseeingtariffoccupancy.Inclusion));
            Logger.Debug("SightSeeingTariff Controller Inclusion:" + sightseeingtariffoccupancy.Inclusion);

            sqlParams.Add(new SqlParameter("@Exclusion", sightseeingtariffoccupancy.Exclusion));
            Logger.Debug("SightSeeingTariff Controller Exclusion:" + sightseeingtariffoccupancy.Exclusion);

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

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

            return(sqlParams);
        }
Esempio n. 3
0
 public int InsertSightSeeingtTariffOccupancy(SightSeeingTariffOccupancyInfo sightseeingtariffoccupancy)
 {
     return(Convert.ToInt32(_sqlHelper.ExecuteScalerObj(SetValuesInSightSeeingTariffOccupancy(sightseeingtariffoccupancy), Storeprocedures.spInsertSightSeeingTariffOccupancy.ToString(), CommandType.StoredProcedure)));
 }
Esempio n. 4
0
 public void UpdateSightSeeingtTariffOccupancy(SightSeeingTariffOccupancyInfo sightseeingtariffoccupancy)
 {
     _sqlHelper.ExecuteNonQuery(SetValuesInSightSeeingTariffOccupancy(sightseeingtariffoccupancy), Storeprocedures.spUpdateSightSeeingtTariffOccupancy.ToString(), CommandType.StoredProcedure);
 }
        public SightSeeingTariffViewModel()
        {
            //For Sight Seeing Tariff

            SightSeeingTariff = new SightSeeingTariffInfo();

            SightSeeingTariffs = new List <SightSeeingTariffInfo>();

            Filter = new SightSeeingTariffFilter();


            Vendors = new List <VendorInfo>();

            SightSeeings = new List <SightSeeingInfo>();

            Meals = new List <MealInfo>();

            Occupancies = new List <OccupancyInfo>();

            Pager = new PaginationInfo();

            FriendlyMessage = new List <FriendlyMessage>();

            //for date details

            SightSeeingTariffDate = new SightSeeingTariffDateInfo();

            SightSeeingTariffDates = new List <SightSeeingTariffDateInfo>();

            //For Duration

            Durations = new List <DurationInfo>();

            Duration = new DurationInfo();

            DurationFilter = new DurationFilter();

            //for sight seeing duration

            SightSeeingTariffDuration = new SightSeeingTariffDurationInfo();

            SightSeeingTariffDurations = new List <SightSeeingTariffDurationInfo>();

            SightSeeingTariffDurationFilter = new SightSeeingTariffDurationFilter();

            //For Sight Seeing Tariff Occupancy

            SightSeeingTariffOccupancy = new SightSeeingTariffOccupancyInfo();

            SightSeeingTariffOccupancies = new List <SightSeeingTariffOccupancyInfo>();

            SightSeeingTariffOccupancyFilter = new SightSeeingTariffOccupancyFilter();

            //For tax formula

            LstStandardCharges = new List <ChargesInfo>();

            LstTaxFormula = new List <TaxFormulaInfo>();

            LstTaxFormulaCharges = new List <TaxFormulaChargesInfo>();

            //For Sight Seeing Details

            SightSeeingDetails = new List <SightSeeingDetailInfo>();

            SightSeeingDetail = new SightSeeingDetailInfo();

            SightSeeingDetailFilter = new SightSeeingDetailFilter();

            //For Sight Seeing Tariff Price

            SightSeeingTariffPrice = new SightSeeingTariffPriceInfo();

            SightSeeingTariffPrices = new List <SightSeeingTariffPriceInfo>();

            SightSeeingTariffPriceFilter = new SightSeeingTariffPriceFilter();

            //For Sight Seeing Tariff Duration

            SightSeeingTariffDuration = new SightSeeingTariffDurationInfo();

            SightSeeingTariffDurations = new List <SightSeeingTariffDurationInfo>();

            SightSeeingTariffDurationFilter = new SightSeeingTariffDurationFilter();

            //for Customer Category

            SightSeeingTariffCustomerCategory = new SightSeeingTariffCustomerCategoryInfo();

            SightSeeingTariffCustomerCategories = new List <SightSeeingTariffCustomerCategoryInfo>();

            CustomerCategory = new CustomerCategoryInfo();

            CustomerCategories = new List <CustomerCategoryInfo>();

            SightSeeingTariffCustomerCategoryFilter = new SightSeeingTariffCustomerCategoryFilter();
        }