public void User_UserTrip_Update(UserTourInformation userTourInformation)
{
try
{
var result = SqlHelper.QuerySP("User_UserTrip_Update",
new
{
UserTripId = userTourInformation.UserTripId
, CountryId = userTourInformation.CountryId
, StartDate = userTourInformation.StartDate
, EndDate = userTourInformation.EndDate
, TravelModeId = userTourInformation.TravelModeId
, SourceAttractionId = userTourInformation.SourceAttractionId
, DestinationAttractionId = userTourInformation.DestinationAttractionId
, NoOfPersons = userTourInformation.NoOfPersons
, NoOfCars = userTourInformation.NoOfCars
, CarMileage = userTourInformation.CarMileage
, FuelPrice = userTourInformation.FuelPrice
, DrivingBreak = userTourInformation.DrivingBreak
});
}
catch (Exception ex)
{
throw ex;
}
}
public JsonResult GetTourInformationOnTripId()
{
UserTourInformation result = new UserTourInformation();
result = _IUserInfo.User_GetTourInformationOnTripId(userEntity.UserTripId, userEntity.UserId);
return(jsonReturn.JsonResult <UserTourInformation>(result));
}
public void User_UserTrip_Update(UserTourInformation userTourInformation)
{
try
{
_userService.User_UserTrip_Update(userTourInformation);
}
catch (Exception e)
{
throw e;
}
}
public JsonResult User_UserTrip_Update(int noOfPersons, int noOfCars, decimal carMileage, decimal fuelPrice, int drivingBreak)
{
UserTourInformation result = new UserTourInformation();
result.UserTripId = userEntity.UserTripId;
result.NoOfPersons = noOfPersons;
result.NoOfCars = noOfCars;
result.CarMileage = carMileage;
result.FuelPrice = fuelPrice;
result.DrivingBreak = drivingBreak;
_IUserInfo.User_UserTrip_Update(result);
return(jsonReturn.JsonResult <UserTourInformation>(result));
}
public UserTourInformation User_GetTourInformationOnTripId(int userTripId, int userId)
{
try
{
SqlHelper.countryId = User_GetTourInformation(userId).Where(x => x.UserTripId == userTripId).Select(y => y.CountryId).FirstOrDefault();
UserTourInformation _returnResult = SqlHelper.QuerySP <UserTourInformation>("User_GetTourInformationOnTripId",
new
{
UserTripId = userTripId
}).ToList().FirstOrDefault();
return(_returnResult);
}
catch (Exception ex)
{
throw ex;
}
}
public JsonResult User_AddUpdateTourName(string tourName, int userTripId, int countryId)
{
UserTourInformation result = _IUserInfo.User_AddUpdateTourName(tourName, userTripId, userEntity.UserId, countryId);
return(jsonReturn.JsonResult <UserTourInformation>(result));
}
public void User_UserTrip_Update(UserTourInformation userTourInformation)
{
_dataAccessUsers.User_UserTrip_Update(userTourInformation);
}
public void RecalcuateTourInfo(UserTourInformation tourdata)
{
try
{
List <GetOrderOfAttractionVisit> storedAttractinInfo =
userDal.User_GetUserStoredAttractinInfo(tourdata.UserTripId, tourdata.UserId);
List <UserTable_UpdatedBreaksTemp> breakInformation = userDal.User_RequestedBreaks(tourdata.UserTripId);
List <userTable_OnlyId> userattraction = new List <userTable_OnlyId>();
List <UserTable_UpdatedBreaks> breakInfo = breakInformation
.Where(y => !string.IsNullOrEmpty(y.UpdateDayEndTime) &&
!string.IsNullOrEmpty(y.UpdateDayStartTime) &&
!string.IsNullOrEmpty(y.UpdatedBreakTime) &&
!string.IsNullOrEmpty(y.UpdatedDinnerTime) &&
!string.IsNullOrEmpty(y.UpdatedLunchTime)
).Select(x => new UserTable_UpdatedBreaks
{
IsUserInterestedBreak = x.IsUserInterestedBreak,
IsUserInterestedDayBreak = x.IsUserInterestedDayBreak,
UpdateDayStartTime = TimeSpan.Parse(x.UpdateDayStartTime),
UpdatedDinnerTime = TimeSpan.Parse(x.UpdatedDinnerTime),
UpdatedLunchTime = TimeSpan.Parse(x.UpdatedLunchTime),
IsUserInterestedLunchBreak = x.IsUserInterestedLunchBreak,
UpdatedBreakTime = TimeSpan.Parse(x.UpdatedBreakTime),
UpdateDayEndTime = TimeSpan.Parse(x.UpdateDayEndTime),
IsUserInterestedDinnerBreak = x.IsUserInterestedDinnerBreak,
RequestDate = Convert.ToDateTime(x.RequestDate),
IsBreakAdded = x.IsBreakAdded,
BreakAttractionId = x.BreakAttractionId,
IsLunchAdded = x.IsLunchAdded,
LunchAttractionId = x.LunchAttractionId,
IsDinnerAdded = x.IsDinnerAdded,
DinnerAttractionId = x.DinnerAttractionId,
IsUserInterestedBreakFast = x.IsUserInterestedBreakFast,
UpdatedBreakFastTime = TimeSpan.Parse(x.UpdatedBreakFastTime),
IsBreakFastAdded = x.IsBreakFastAdded,
BreakFastAttractionId = x.BreakFastAttractionId,
IsDayBreakAdded = x.IsDayBreakAdded,
DayBreakAttractionId = x.DayBreakAttractionId,
NoOfCars = x.NoOfCars,
AverageMileage = x.AverageMileage,
BreakExpense = x.BreakExpense,
BreakFastExpense = x.BreakFastExpense,
CarRentalExpense = x.CarRentalExpense,
DayBreakExpense = x.DayBreakExpense,
LunchExpense = x.LunchExpense,
NoOfRooms = x.NoOfRooms,
DinnerExpense = x.DinnerExpense,
IsNoOfCarsUserUpdated = x.IsNoOfCarsUserUpdated,
IsAverageMileageUserUpdated = x.IsAverageMileageUserUpdated,
IsCarRentalExpenseUserUpdated = x.IsCarRentalExpenseUserUpdated,
IsBreakFastExpenseUserUpdated = x.IsBreakFastExpenseUserUpdated,
IsLunchExpenseUserUpdated = x.IsLunchExpenseUserUpdated,
IsBreakExpenseUserUpdated = x.IsBreakExpenseUserUpdated,
IsDinnerExpenseUserUpdated = x.IsDinnerExpenseUserUpdated,
IsDayBreakExpenseUserUpdated = x.IsDayBreakExpenseUserUpdated,
IsNoOfRoomsUserUpdated = x.IsNoOfRoomsUserUpdated
}).ToList();
using (AttractionInformationBinding attractionInformation = new AttractionInformationBinding())
{
attractionInformation.UserRequestedAttractionInformation(tourdata.TravelModeId,
storedAttractinInfo, tourdata.CountryId,
breakInfo,
tourdata.UserTripId);
}
}
catch (Exception ex)
{
throw ex;
}
}
public void User_UserTrip_Update(UserTourInformation userTourInformation)
{
_businessUserBAL.User_UserTrip_Update(userTourInformation);
}