public void DeleteLohanaPackageTariffRootDetail(LohanaPackageTariffRootInfo lohanapackagetariffroot)
{
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@LohanaPackageTariffRootDetailId", lohanapackagetariffroot.LohanaPackageTariffRootDetailId));
_sqlHelper.ExecuteNonQuery(sqlParams, Storeprocedures.spDeleteLohanaPackageTariffRootDetail.ToString(), CommandType.StoredProcedure);
}
private List <SqlParameter> SetValuesInLohanaPackageTariffRootDetail(LohanaPackageTariffRootInfo lohanapackagetariffroot)
{
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@LohanaPackageTariffRootId", lohanapackagetariffroot.LohanaPackageTariffRootId));
sqlParams.Add(new SqlParameter("@LohanaPackageTariffId", lohanapackagetariffroot.LohanaPackageTariffId));
sqlParams.Add(new SqlParameter("@LohanaPackageTariffRefId", lohanapackagetariffroot.LohanaPackageTariffRefId));
sqlParams.Add(new SqlParameter("@LohanaPackageTariffTypeId", lohanapackagetariffroot.LohanaPackageTariffTypeId));
sqlParams.Add(new SqlParameter("@CreatedDate", lohanapackagetariffroot.CreatedDate));
sqlParams.Add(new SqlParameter("@CreatedBy", lohanapackagetariffroot.CreatedBy));
sqlParams.Add(new SqlParameter("@UpdatedDate", lohanapackagetariffroot.UpdatedDate));
sqlParams.Add(new SqlParameter("@UpdatedBy", lohanapackagetariffroot.UpdatedBy));
return(sqlParams);
}
private List <SqlParameter> SetValuesInLohanaPackageTariffRoot(LohanaPackageTariffRootInfo lohanapackagetariffroot)
{
List <SqlParameter> sqlParams = new List <SqlParameter>();
if (lohanapackagetariffroot.LohanaPackageTariffRootId != 0)
{
sqlParams.Add(new SqlParameter("@LohanaPackageTariffRootId", lohanapackagetariffroot.LohanaPackageTariffRootId));
sqlParams.Add(new SqlParameter("@Title", lohanapackagetariffroot.Title));
}
else
{
sqlParams.Add(new SqlParameter("@CreatedDate", lohanapackagetariffroot.CreatedDate));
sqlParams.Add(new SqlParameter("@CreatedBy", lohanapackagetariffroot.CreatedBy));
}
sqlParams.Add(new SqlParameter("@UpdatedDate", lohanapackagetariffroot.UpdatedDate));
sqlParams.Add(new SqlParameter("@UpdatedBy", lohanapackagetariffroot.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 UpdateLohanaPackageTariffRootTitle(LohanaPackageTariffRootInfo lohanapackagetariffroot)
{
_sqlHelper.ExecuteNonQuery(SetValuesInLohanaPackageTariffRoot(lohanapackagetariffroot), Storeprocedures.spUpdateLohanaPackageTariffRootTitle.ToString(), CommandType.StoredProcedure);
}
public int InsertLohanaPackageTariffRootDetail(LohanaPackageTariffRootInfo lohanapackagetariffroot)
{
return(Convert.ToInt32(_sqlHelper.ExecuteScalerObj(SetValuesInLohanaPackageTariffRootDetail(lohanapackagetariffroot), Storeprocedures.spInsertLohanaPackageTariffRootDetails.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();
}
