private List <SqlParameter> SetValuesInLohanaPackageTariff(LohanaPackageTariffInfo lohanapackagetariff) { List <SqlParameter> sqlParams = new List <SqlParameter>(); if (lohanapackagetariff.LohanaPackageTariffId != 0) { sqlParams.Add(new SqlParameter("@LohanaPackageTariffId", lohanapackagetariff.LohanaPackageTariffId)); } else { sqlParams.Add(new SqlParameter("@CreatedDate", lohanapackagetariff.CreatedDate)); sqlParams.Add(new SqlParameter("@CreatedBy", lohanapackagetariff.CreatedBy)); } sqlParams.Add(new SqlParameter("@PackageTypeId", lohanapackagetariff.PackageTypeId)); sqlParams.Add(new SqlParameter("@PackageName", lohanapackagetariff.PackageName)); sqlParams.Add(new SqlParameter("@DayDuration", lohanapackagetariff.DayDuration)); sqlParams.Add(new SqlParameter("@NightDuration", lohanapackagetariff.NightDuration)); sqlParams.Add(new SqlParameter("@IsActive", lohanapackagetariff.IsActive)); sqlParams.Add(new SqlParameter("@UpdatedDate", lohanapackagetariff.UpdatedDate)); sqlParams.Add(new SqlParameter("@UpdatedBy", lohanapackagetariff.UpdatedBy)); return(sqlParams); }
public LohanaPackageTariffViewModel() { LohanaPackageTariff = new LohanaPackageTariffInfo(); LohanaPackageTariffs = new List <LohanaPackageTariffInfo>(); LohanaPackageTariffHotel = new LohanaPackageTariffHotelInfo(); LohanaPackageTariffHotels = new List <LohanaPackageTariffHotelInfo>(); LohanaPackageTariffVehicle = new LohanaPackageTariffVehicleInfo(); LohanaPackageTariffVehicles = new List <LohanaPackageTariffVehicleInfo>(); LohanaPackageTariffRoot = new LohanaPackageTariffRootInfo(); LohanaPackageTariffRoots = new List <LohanaPackageTariffRootInfo>(); LohanaPackageTariffSightSeeing = new LohanaPackageTariffSightSeeingInfo(); Cities = new List <CityInfo>(); RoomTypes = new List <RoomTypeInfo>(); Meals = new List <MealInfo>(); Hotels = new List <HotelInfo>(); Vendors = new List <VendorInfo>(); Vehicles = new List <VehicleInfo>(); PackageTypes = new List <PackageTypeInfo>(); Pager = new PaginationInfo(); FriendlyMessage = new List <FriendlyMessage>(); }
public void UpdateLohanaPackageTariff(LohanaPackageTariffInfo lohanapackagetariff) { _sqlHelper.ExecuteNonQuery(SetValuesInLohanaPackageTariff(lohanapackagetariff), Storeprocedures.spUpdateLohanaPackageTariffBasic.ToString(), CommandType.StoredProcedure); }
public int InsertLohanaPackageTariff(LohanaPackageTariffInfo lohanapackagetariff) { return(Convert.ToInt32(_sqlHelper.ExecuteScalerObj(SetValuesInLohanaPackageTariff(lohanapackagetariff), Storeprocedures.spInsertLohanaPackageTariffBasic.ToString(), CommandType.StoredProcedure))); }
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(); }