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