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