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);
}
}
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();
}
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);
}
}
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();
}
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);
}
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();
}