private List <SqlParameter> SetValuesInLohanaPackageTariffHotel(LohanaPackageTariffHotelInfo lohanapackagetariffhotel)
{
List <SqlParameter> sqlParams = new List <SqlParameter>();
if (lohanapackagetariffhotel.LohanaPackageTariffHotelId != 0)
{
sqlParams.Add(new SqlParameter("@LohanaPackageTariffHotelId", lohanapackagetariffhotel.LohanaPackageTariffHotelId));
}
else
{
sqlParams.Add(new SqlParameter("@CreatedDate", lohanapackagetariffhotel.CreatedDate));
sqlParams.Add(new SqlParameter("@CreatedBy", lohanapackagetariffhotel.CreatedBy));
}
sqlParams.Add(new SqlParameter("@LohanaPackageTariffId", lohanapackagetariffhotel.LohanaPackageTariffId));
//sqlParams.Add(new SqlParameter("@HotelTariffRoomOccupancyId", lohanapackagetariffhotel.HotelTariffRoomOccupancyId));
if (lohanapackagetariffhotel.LohanaPackageTariffTypeId != (int)LohanaBusinessEntities.Common.EnumCollection.LohanaPackageTariffType.LohanaPackageTariffHotel)
{
sqlParams.Add(new SqlParameter("@RefId", lohanapackagetariffhotel.HotelTariffRoomDetailsId));
}
else
{
sqlParams.Add(new SqlParameter("@RefId", lohanapackagetariffhotel.SupplierHotelDetailId));
}
sqlParams.Add(new SqlParameter("@NoOfNight", lohanapackagetariffhotel.NoOfNight));
sqlParams.Add(new SqlParameter("@UpdatedDate", lohanapackagetariffhotel.UpdatedDate));
sqlParams.Add(new SqlParameter("@UpdatedBy", lohanapackagetariffhotel.UpdatedBy));
return(sqlParams);
}
public void DeleteLohanaPackageTariffHotel(int lohanapackagetariffid, int lohanapackagetariffhotelid)
{
List <SqlParameter> sqlParam = new List <SqlParameter>();
LohanaPackageTariffHotelInfo lohanapackagetariffhotel = new LohanaPackageTariffHotelInfo();
sqlParam.Add(new SqlParameter("@LohanaPackageTariffId", lohanapackagetariffid));
Logger.Debug("LohanaPackageTariff Controller LohanaPackageTariffId:" + lohanapackagetariffid);
sqlParam.Add(new SqlParameter("@LohanaPackageTariffHotelId", lohanapackagetariffhotelid));
Logger.Debug("LohanaPackageTariff Controller LohanaPackageTariffHotelId:" + lohanapackagetariffhotelid);
//sqlParam.Add(new SqlParameter("@HotelTariffRoomOccupancyId", hoteltariffroomoccupancyid));
//Logger.Debug("LohanaPackageTariff Controller HotelTariffRoomOccupancyId:" + hoteltariffroomoccupancyid);
_sqlHelper.ExecuteNonQuery(sqlParam, Storeprocedures.spDeleteLohanaPackageTariffHotel.ToString(), CommandType.StoredProcedure);
}
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 UpdateLohanaPackageTariffHotel(LohanaPackageTariffHotelInfo lohanapackagetariffhotel)
{
_sqlHelper.ExecuteNonQuery(SetValuesInLohanaPackageTariffHotel(lohanapackagetariffhotel), Storeprocedures.spUpdateLohanaPackageTariffHotel.ToString(), CommandType.StoredProcedure);
}
public int InsertLohanaPackageTariffHotel(LohanaPackageTariffHotelInfo lohanapackagetariffhotel)
{
return(Convert.ToInt32(_sqlHelper.ExecuteScalerObj(SetValuesInLohanaPackageTariffHotel(lohanapackagetariffhotel), Storeprocedures.spInsertLohanaPackageTariffHotel.ToString(), CommandType.StoredProcedure)));
}
