private LohanaPackageTariffSearchInfo GetLohanaPackageTariffItienarySearchDetailsValues(DataRow dr) { LohanaPackageTariffSearchInfo LohanaPackageTariffItienarySearch = new LohanaPackageTariffSearchInfo(); if (!dr.IsNull("HotelName")) { LohanaPackageTariffItienarySearch.HotelName = Convert.ToString(dr["HotelName"]); } if (!dr.IsNull("VehicleName")) { LohanaPackageTariffItienarySearch.VehicleName = Convert.ToString(dr["VehicleName"]); } if (!dr.IsNull("MealName")) { LohanaPackageTariffItienarySearch.MealName = Convert.ToString(dr["MealName"]); } if (!dr.IsNull("SightSeeingName")) { LohanaPackageTariffItienarySearch.SightSeeingName = Convert.ToString(dr["SightSeeingName"]); } if (!dr.IsNull("LohanaPackageTariffRootId")) { LohanaPackageTariffItienarySearch.LohanaPackageTariffRootId = Convert.ToInt32(dr["LohanaPackageTariffRootId"]); } if (!dr.IsNull("LohanaPackageTariffId")) { LohanaPackageTariffItienarySearch.LohanaPackageTariffId = Convert.ToInt32(dr["LohanaPackageTariffId"]); } if (!dr.IsNull("Title")) { LohanaPackageTariffItienarySearch.Title = Convert.ToString(dr["Title"]); } return(LohanaPackageTariffItienarySearch); }
private LohanaPackageTariffSearchInfo GetLohanaPackageTariffBasicDetailsValues(DataRow dr) { LohanaPackageTariffSearchInfo LohanaPackageTariffSearchBasicDetail = new LohanaPackageTariffSearchInfo(); if (!dr.IsNull("FinalCost")) { LohanaPackageTariffSearchBasicDetail.Cost = Convert.ToDecimal(dr["FinalCost"]); } if (!dr.IsNull("PackageName")) { LohanaPackageTariffSearchBasicDetail.PackageName = Convert.ToString(dr["PackageName"]); } if (!dr.IsNull("PackageTypeName")) { LohanaPackageTariffSearchBasicDetail.PackageTypeName = Convert.ToString(dr["PackageTypeName"]); } if (!dr.IsNull("RoomTypeName")) { LohanaPackageTariffSearchBasicDetail.RoomTypeName = Convert.ToString(dr["RoomTypeName"]); } if (!dr.IsNull("LPTDuration")) { LohanaPackageTariffSearchBasicDetail.LPTDuration = Convert.ToString(dr["LPTDuration"]); } if (!dr.IsNull("OccupancyValue")) { LohanaPackageTariffSearchBasicDetail.OccupancyValue = Convert.ToInt32(dr["OccupancyValue"]); } if (!dr.IsNull("OccupancyName")) { LohanaPackageTariffSearchBasicDetail.OccupancyName = Convert.ToString(dr["OccupancyName"]); } if (!dr.IsNull("RoomTypeId")) { LohanaPackageTariffSearchBasicDetail.RoomTypeId = Convert.ToInt32(dr["RoomTypeId"]); } if (!dr.IsNull("PackageTypeId")) { LohanaPackageTariffSearchBasicDetail.PackageTypeId = Convert.ToInt32(dr["PackageTypeId"]); } if (!dr.IsNull("OccupancyId")) { LohanaPackageTariffSearchBasicDetail.OccupancyId = Convert.ToInt32(dr["OccupancyId"]); } if (!dr.IsNull("CountryId")) { LohanaPackageTariffSearchBasicDetail.CountryId = Convert.ToInt32(dr["CountryId"]); } if (!dr.IsNull("CountryName")) { LohanaPackageTariffSearchBasicDetail.CountryName = Convert.ToString(dr["CountryName"]); } if (!dr.IsNull("StateId")) { LohanaPackageTariffSearchBasicDetail.StateId = Convert.ToInt32(dr["StateId"]); } if (!dr.IsNull("StateName")) { LohanaPackageTariffSearchBasicDetail.StateName = Convert.ToString(dr["StateName"]); } if (!dr.IsNull("CityId")) { LohanaPackageTariffSearchBasicDetail.CityId = Convert.ToInt32(dr["CityId"]); } if (!dr.IsNull("CityName")) { LohanaPackageTariffSearchBasicDetail.CityName = Convert.ToString(dr["CityName"]); } if (!dr.IsNull("LohanaPackageTariffId")) { LohanaPackageTariffSearchBasicDetail.LohanaPackageTariffId = Convert.ToInt32(dr["LohanaPackageTariffId"]); } return(LohanaPackageTariffSearchBasicDetail); }
//Get LohanaPackage Tariff Basic Detail public List <LohanaPackageTariffSearchInfo> GetLohanaPackageTariffBasicDetails(LohanaPackageTariffSearchInfo searchInfo, bool IsExtraChild, int OccupancyType) { var count = 1; List <SqlParameter> sqlParam = new List <SqlParameter>(); searchInfo.DayDuration = searchInfo.NightDuration + count; List <LohanaPackageTariffSearchInfo> LPTSearchDetails = new List <LohanaPackageTariffSearchInfo>(); sqlParam.Add(new SqlParameter("@PackageTypeId", searchInfo.PackageTypeId)); sqlParam.Add(new SqlParameter("@OccupancyId", searchInfo.OccupancyId)); sqlParam.Add(new SqlParameter("@CountryId", searchInfo.CountryId)); sqlParam.Add(new SqlParameter("@StateId", searchInfo.StateId)); sqlParam.Add(new SqlParameter("@CityId", searchInfo.CityId)); sqlParam.Add(new SqlParameter("@OccupancyType", OccupancyType)); sqlParam.Add(new SqlParameter("@IsExtraChild", IsExtraChild)); sqlParam.Add(new SqlParameter("@DayDuration", searchInfo.DayDuration)); sqlParam.Add(new SqlParameter("@NightDuration", searchInfo.NightDuration)); sqlParam.Add(new SqlParameter("@CheckInDate", searchInfo.CheckInDate)); sqlParam.Add(new SqlParameter("@CheckOutDate", searchInfo.CheckOutDate)); DataSet ds = _sqlHelper.ExecuteDataSet(sqlParam, Storeprocedures.spGetLohanaPackageTariffDetailsSearch.ToString(), CommandType.StoredProcedure); DataTable dt1 = ds.Tables[0]; if (dt1 != null && dt1.Rows.Count > 0) { foreach (DataRow dr in dt1.Rows) { LPTSearchDetails.Add(GetLohanaPackageTariffBasicDetailsValues(dr)); } } return(LPTSearchDetails); }
public PartialViewResult GetLohanaPackageTariffSearch(LohanaPackageTariffSearchViewModel lptsViewModel) { try { bool IsExtraChild = false; decimal cost = 0; decimal Extracost = 0; //int OccupancyValueCount = 0; decimal ExtraPeopleCost = 0; decimal ExtraChildCost = 0; decimal Extra = 0; //lptsViewModel.LohanaPackageTariffSearch.CheckOutDate = lptsViewModel.LohanaPackageTariffSearch.CheckInDate.AddDays(lptsViewModel.LohanaPackageTariffSearch.DayDuration); lptsViewModel.LohanaPackageTariffSearchList = _lptsRepo.GetLohanaPackageTariffBasicDetails(lptsViewModel.LohanaPackageTariffSearch, IsExtraChild, (int)OccupancyType.Room); //lptsViewModel.LohanaPackageTariffSearchList int TotalAdultCount = lptsViewModel.LohanaPackageTariffSearch.AdultCount; foreach (var item in lptsViewModel.LohanaPackageTariffSearchList.Select(a => new { a.LohanaPackageTariffId, a.RoomTypeId }).Distinct()) { if (lptsViewModel.LohanaPackageTariffSearch.ChildCount != 0) { IsExtraChild = true; lptsViewModel.LohanaPackageTariffSearchExtraChildList = _lptsRepo.GetLohanaPackageTariffBasicDetails(lptsViewModel.LohanaPackageTariffSearch, IsExtraChild, (int)OccupancyType.Extra); if (lptsViewModel.LohanaPackageTariffSearchExtraChildList.Count > 0) { ExtraChildCost = lptsViewModel.LohanaPackageTariffSearch.ChildCount * (lptsViewModel.LohanaPackageTariffSearchExtraChildList.Where(a => a.LohanaPackageTariffId == item.LohanaPackageTariffId).Select(a => a.Cost).FirstOrDefault()); } else { decimal singlePeopleCost = lptsViewModel.LohanaPackageTariffSearchList.Where(b => b.LohanaPackageTariffId == item.LohanaPackageTariffId && b.OccupancyValue == 1).Select(a => a.Cost).FirstOrDefault(); ExtraChildCost = lptsViewModel.LohanaPackageTariffSearch.ChildCount * singlePeopleCost; } } string PackageName = " "; string PackageTypeName = " "; int LohanaPackageTariffId = 0; int DayDuration = 0; int NightDuration = 0; string LPTDuration = ""; int PackageTypeId = 0; int CountryId = 0; int StateId = 0; int CityId = 0; int RoomTypeId = 0; int OccupancyId = 0; string OccupanyName = ""; string CountryName = ""; string StateName = ""; string CityName = ""; decimal Cost = 0; // OccupancyValueCount = lptsViewModel.LohanaPackageTariffSearchRoomList.Where(a => a.LohanaPackageTariffId == item.LohanaPackageTariffId).Select(b => b.OccupancyValue).Sum(); //for (int k = 0; k <= 1; k++) //{ //if (OccupancyValueCount >= lptsViewModel.LohanaPackageTariffSearch.AdultCount) //{ foreach (var i in lptsViewModel.LohanaPackageTariffSearchList.Where(a => a.LohanaPackageTariffId == item.LohanaPackageTariffId && a.RoomTypeId == item.RoomTypeId).OrderByDescending(s => s.OccupancyValue)) //foreach (var i in lptsViewModel.LohanaPackageTariffSearchList) { if (i.OccupancyValue <= lptsViewModel.LohanaPackageTariffSearch.AdultCount) { if (i.OccupancyValue == lptsViewModel.LohanaPackageTariffSearch.AdultCount) { //cost = i.Cost * lptsViewModel.LohanaPackageTariffSearch.AdultCount; cost = i.Cost; lptsViewModel.LohanaPackageTariffSearch.AdultCount = 0; } else { while (lptsViewModel.LohanaPackageTariffSearch.AdultCount >= i.OccupancyValue) { int remains = lptsViewModel.LohanaPackageTariffSearch.AdultCount - i.OccupancyValue; //Extra = i.Cost * i.OccupancyValue; Extra = i.Cost; lptsViewModel.LohanaPackageTariffSearch.AdultCount = remains; Extracost += Extra; } } } LohanaPackageTariffId = i.LohanaPackageTariffId; PackageName = i.PackageName; PackageTypeName = i.PackageTypeName; CountryId = i.CountryId; StateId = i.StateId; CityId = i.CityId; PackageTypeId = i.PackageTypeId; RoomTypeId = i.RoomTypeId; OccupancyId = i.OccupancyId; OccupanyName = i.OccupancyName; CountryName = i.CountryName; StateName = i.StateName; CityName = i.CityName; DayDuration = i.DayDuration; NightDuration = i.NightDuration; LPTDuration = i.LPTDuration; Cost = i.Cost; } //} if (lptsViewModel.LohanaPackageTariffSearch.AdultCount != 0) { //extra adult cost IsExtraChild = false; // int RemainingPeople = lptsViewModel.LohanaPackageTariffSearch.AdultCount - OccupancyValueCount; lptsViewModel.LohanaPackageTariffSearchExtraList = _lptsRepo.GetLohanaPackageTariffBasicDetails(lptsViewModel.LohanaPackageTariffSearch, IsExtraChild, (int)OccupancyType.Extra); if (lptsViewModel.LohanaPackageTariffSearchExtraList.Count > 0) { ExtraPeopleCost = lptsViewModel.LohanaPackageTariffSearch.AdultCount * (lptsViewModel.LohanaPackageTariffSearchExtraList.Where(a => a.LohanaPackageTariffId == item.LohanaPackageTariffId).Select(a => a.Cost).FirstOrDefault()); } else { decimal singlePeopleCost = lptsViewModel.LohanaPackageTariffSearchList.Where(b => b.LohanaPackageTariffId == item.LohanaPackageTariffId && b.OccupancyValue == 1).Select(a => a.Cost).FirstOrDefault(); ExtraPeopleCost = lptsViewModel.LohanaPackageTariffSearch.AdultCount * singlePeopleCost; } //lptsViewModel.LohanaPackageTariffSearch.AdultCount = OccupancyValueCount; } // } decimal PackageCost = cost + Extracost + ExtraPeopleCost + ExtraChildCost; if (PackageCost != 0) { LohanaPackageTariffSearchInfo info = new LohanaPackageTariffSearchInfo(); // info.SupplierName = Suppliername; info.PackageTypeName = PackageTypeName; info.PackageName = PackageName; info.Cost = PackageCost; info.LohanaPackageTariffId = LohanaPackageTariffId; info.CountryId = CountryId; info.StateId = StateId; info.CityId = CityId; info.PackageTypeId = PackageTypeId; info.OccupancyId = OccupancyId; info.OccupancyName = OccupanyName; info.RoomTypeId = RoomTypeId; info.CountryName = CountryName; info.StateName = StateName; info.CityName = CityName; info.DayDuration = DayDuration; info.NightDuration = NightDuration; info.LPTDuration = LPTDuration; lptsViewModel.LohanaPackageTariffSearchRoomList.Add(info); } lptsViewModel.LohanaPackageTariffSearch.AdultCount = TotalAdultCount; PackageCost = 0; cost = 0; Extracost = 0; ExtraPeopleCost = 0; ExtraChildCost = 0; } Logger.Debug("LohanaPackageTariffSearch Controller GetLohanaPackageTariffSearch"); } catch (Exception ex) { lptsViewModel.FriendlyMessage.Add(MessageStore.Get("SYS01")); Logger.Error("LohanaPackageTariffSearch Controller - GetLohanaPackageTariffSearch" + ex.ToString()); } TempData["lptsViewModel"] = lptsViewModel; return(PartialView("_LohanaPackageTariffSearchDetails", lptsViewModel)); }
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(); }