private List <SqlParameter> SetValuesInLohanaPackageTariffVehicle(LohanaPackageTariffVehicleInfo lohanapackagetariffvehicle)
{
List <SqlParameter> sqlParams = new List <SqlParameter>();
if (lohanapackagetariffvehicle.LohanaPackageTariffVehicleId != 0)
{
sqlParams.Add(new SqlParameter("@LohanaPackageTariffVehicleId", lohanapackagetariffvehicle.LohanaPackageTariffVehicleId));
}
else
{
sqlParams.Add(new SqlParameter("@CreatedDate", lohanapackagetariffvehicle.CreatedDate));
sqlParams.Add(new SqlParameter("@CreatedBy", lohanapackagetariffvehicle.CreatedBy));
}
sqlParams.Add(new SqlParameter("@LohanaPackageTariffId", lohanapackagetariffvehicle.LohanaPackageTariffId));
sqlParams.Add(new SqlParameter("@VehicleTariffId", lohanapackagetariffvehicle.VehicleTariffId));
sqlParams.Add(new SqlParameter("@VehicleId", lohanapackagetariffvehicle.VehicleId));
sqlParams.Add(new SqlParameter("@NoOfNight", lohanapackagetariffvehicle.NoOfNight));
sqlParams.Add(new SqlParameter("@UpdatedDate", lohanapackagetariffvehicle.UpdatedDate));
sqlParams.Add(new SqlParameter("@UpdatedBy", lohanapackagetariffvehicle.UpdatedBy));
return(sqlParams);
}
public void DeleteLohanaPackageTariffVehicle(int lohanapackagetariffid, int lohanapackagetariffvehicleid)
{
List <SqlParameter> sqlParam = new List <SqlParameter>();
LohanaPackageTariffVehicleInfo lohanapackagetariffvehicle = new LohanaPackageTariffVehicleInfo();
sqlParam.Add(new SqlParameter("@LohanaPackageTariffId", lohanapackagetariffid));
Logger.Debug("LohanaPackageTariff Controller LohanaPackageTariffId:" + lohanapackagetariffid);
sqlParam.Add(new SqlParameter("@LohanaPackageTariffVehicleId", lohanapackagetariffvehicleid));
Logger.Debug("LohanaPackageTariff Controller LohanaPackageTariffVehicleId:" + lohanapackagetariffvehicleid);
_sqlHelper.ExecuteNonQuery(sqlParam, Storeprocedures.spDeleteLohanaPackageTariffVehicle.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 UpdateLohanaPackageTariffVehicle(LohanaPackageTariffVehicleInfo lohanapackagetariffvehicle)
{
_sqlHelper.ExecuteNonQuery(SetValuesInLohanaPackageTariffVehicle(lohanapackagetariffvehicle), Storeprocedures.spUpdateLohanaPackageTariffVehicle.ToString(), CommandType.StoredProcedure);
}
public int InsertLohanaPackageTariffVehicle(LohanaPackageTariffVehicleInfo lohanapackagetariffvehicle)
{
return(Convert.ToInt32(_sqlHelper.ExecuteScalerObj(SetValuesInLohanaPackageTariffVehicle(lohanapackagetariffvehicle), Storeprocedures.spInsertLohanaPackageTariffVehicle.ToString(), CommandType.StoredProcedure)));
}
