//***Save Amount for offlinebookings bookingdetails //**Added by rahul on 29/02/20 public void SaveBookingDetailsAmounts(CLayer.BookingItem data) { //BookingItem_Update List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pBookingItemId", DataPlug.DataType._BigInt, data.OfflineBookingItemId)); param.Add(Connection.GetParameter("pAmount", DataPlug.DataType._Decimal, data.Amount)); param.Add(Connection.GetParameter("pTotalAmount", DataPlug.DataType._Decimal, data.TotalAmount)); param.Add(Connection.GetParameter("pTotalTax", DataPlug.DataType._Decimal, data.TotalTax)); param.Add(Connection.GetParameter("pSBMarkup", DataPlug.DataType._Decimal, data.CommissionSB)); param.Add(Connection.GetParameter("pB2BDiscount", DataPlug.DataType._Decimal, data.CorporateDiscountAmount)); param.Add(Connection.GetParameter("pGuestAmount", DataPlug.DataType._Decimal, data.GuestAmount)); param.Add(Connection.GetParameter("pFirstDayCharge", DataPlug.DataType._Decimal, data.FirstDayCharge)); param.Add(Connection.GetParameter("pRatesApplied", DataPlug.DataType._Varchar, data.RatesApplied)); param.Add(Connection.GetParameter("pTotalRateTax", DataPlug.DataType._Decimal, data.TotalRateTax)); param.Add(Connection.GetParameter("pTotalGuestTax", DataPlug.DataType._Decimal, data.TotalGuestTax)); param.Add(Connection.GetParameter("pPurchaseRateAfterTax", DataPlug.DataType._Decimal, data.PurchaseRateAfterTax)); param.Add(Connection.GetParameter("pPurchaseRateBeforeTax", DataPlug.DataType._Decimal, data.PurchaseRateBeforeTax)); param.Add(Connection.GetParameter("pSellRateAfterTax", DataPlug.DataType._Decimal, data.SellRateAfterTax)); param.Add(Connection.GetParameter("pSellRateBeforeTax", DataPlug.DataType._Decimal, data.SellRateBeforeTax)); object id = Connection.ExecuteQueryScalar("booking_offlinebookingdetails_Update", param); }
//***** public void SaveGDSCountry(CLayer.BookingItem data) { string sql = "Update bookingitems set GDSCountry=" + data.GDSCountry.ToString() + " Where BookingItemId=" + data.BookingItemId.ToString() + " and bookingid=" + data.BookingId + ""; Connection.ExecuteSqlQuery(sql); }
//*Added by rahul for Saving BookingItems table data to Booking details table on 28/02/20 public static long SaveIntialBookingDetailsData(CLayer.BookingItem data) { DataLayer.BookingItem bi = new DataLayer.BookingItem(); if (data.NoOfDays < 1 && data.CheckOut > data.CheckIn) { data.NoOfDays = (data.CheckOut - data.CheckIn).Days; } return(bi.SaveIntialBookingDetailsData(data)); }
//*This is for getting details of offlinebooking //*Done by rahul on 06-02-2020 public List <CLayer.BookingItem> GetAllOfflineDetails(long bookingId, bool IsAmedus = false) { List <CLayer.BookingItem> result = new List <CLayer.BookingItem>(); List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); try { param.Add(Connection.GetParameter("pBookingId", DataPlug.DataType._BigInt, bookingId)); DataTable dt; dt = Connection.GetTable("offlinebooking_GetAllItems", param); CLayer.BookingItem bi; foreach (DataRow dr in dt.Rows) { bi = new CLayer.BookingItem(); bi.BookingItemId = Connection.ToLong(dr["BookingId"]); bi.AccommodationId = Connection.ToLong(dr["AccommodatoinTypeId"]); bi.BookingId = Connection.ToLong(dr["Offline_BookingId"]); bi.AccommodationTitle = Connection.ToString(dr["AccommodationType"]); bi.CheckIn = Connection.ToDate(dr["CheckIn_date"]); bi.CheckOut = Connection.ToDate(dr["CheckOut_date"]); bi.NoOfAccommodations = Connection.ToInteger(dr["NoOfRooms"]); bi.NoOfAdults = Connection.ToInteger(dr["NoOfPaxAdult"]); bi.NoOfChildren = Connection.ToInteger(dr["NoOfPaxChild"]); bi.NoOfDays = Connection.ToInteger(dr["Noofnight"]); bi.Amount = Connection.ToDecimal(dr["TotalBuyPrice"]); bi.PropertyTitle = Connection.ToString(dr["PropertyTitle"]); bi.PropertyAddress = Connection.ToString(dr["PropertyAddress"]); bi.PropertyId = Connection.ToLong(dr["PropertyId"]); bi.TotalAmount = Connection.ToDecimal(dr["TotalAmtForBuyPrice"]); bi.TotalTax = Connection.ToDecimal(dr["StaxForBuyPrice"]); bi.AccommodationTypeT = Connection.ToString(dr["AccommodationType"]); bi.StayCategoryT = Connection.ToString(dr["StayCategory"]); bi.DailyRate = Connection.ToDecimal(dr["DailyRate"]); bi.HotelConfirmNumber = Connection.ToString(dr["HotelConfirmNumber"]); bi.CountryName = Connection.ToString(dr["CountryName"]); result.Add(bi); } } catch (Exception ex) { result = null; } return(result); }
public void UpdateGDSCurrencyDetails(CLayer.BookingItem pBookingItem) { try { string sql = "UPDATE BookingItems SET GDSCountry=" + pBookingItem.GDSCountry + ",GDSConversionRate=" + pBookingItem.GDSConversionRate + "," + "GDSAmount=" + pBookingItem.GDSAmount + ",GDSConvertedAmount=" + pBookingItem.GDSConvertedAmount + " WHERE bookingID=" + pBookingItem.BookingId + " AND AccommodationID=" + pBookingItem.AccommodationId + ""; object obj = Connection.ExecuteSQLQueryScalar(sql); } catch (Exception ex) { throw ex; } // return Connection.ToLong(obj); }
public List <CLayer.BookingItem> GetIncompleteGDSBookings() { DataTable dt = Connection.GetTable("GetIncompleteGDSBookings"); List <CLayer.BookingItem> result = new List <CLayer.BookingItem>(); CLayer.BookingItem rt; foreach (DataRow dr in dt.Rows) { rt = new CLayer.BookingItem(); rt.BookingId = Connection.ToLong(dr["BookingID"]); rt.Status = Connection.ToInteger(dr["BookingStatus"]); rt.HotelConfirmNumber = Connection.ToString(dr["HotelConfirmNumber"]); result.Add(rt); } return(result); }
public CLayer.BookingItem GetTotalTaxDetails(long bookingItemId) { CLayer.BookingItem result = null; List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pbookingItemId", DataPlug.DataType._BigInt, bookingItemId)); DataTable dt = Connection.GetTable("bookingitems_GetTotalRateTax", param); CLayer.BookingItem bi; foreach (DataRow dr in dt.Rows) { bi = new CLayer.BookingItem(); bi.TotalRateTax = Connection.ToDecimal(dr["TotalRateTax"]); bi.TotalGuestTax = Connection.ToDecimal(dr["TotalGuestTax"]); result = bi; } return(result); }
//*Added by rahul for Saving BookingItems table data to Booking details table on 28/02/20 public long SaveIntialBookingDetailsData(CLayer.BookingItem data) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pStatus", DataPlug.DataType._Int, data.Status)); param.Add(Connection.GetParameter("pForUserId", DataPlug.DataType._BigInt, data.ForUser)); param.Add(Connection.GetParameter("pBookingId", DataPlug.DataType._BigInt, data.BookingId)); param.Add(Connection.GetParameter("pAccommodationId", DataPlug.DataType._BigInt, data.AccommodationId)); param.Add(Connection.GetParameter("pNoOfAccommodations", DataPlug.DataType._Int, data.NoOfAccommodations)); param.Add(Connection.GetParameter("pNoOfAdults", DataPlug.DataType._Int, data.NoOfAdults)); param.Add(Connection.GetParameter("pNoOfDays", DataPlug.DataType._Int, data.NoOfDays)); param.Add(Connection.GetParameter("pNoOfChildren", DataPlug.DataType._Int, data.NoOfChildren)); param.Add(Connection.GetParameter("pCheckIn", DataPlug.DataType._Date, data.CheckIn)); param.Add(Connection.GetParameter("pCheckOut", DataPlug.DataType._Date, data.CheckOut)); param.Add(Connection.GetParameter("pLockInTime", DataPlug.DataType._DateTime, data.LockInTime)); object id = Connection.ExecuteQueryScalar("bookingdetails_SaveInitialData", param); return(Connection.ToLong(id)); }
public List <CLayer.BookingItem> GetAccomodationFromBookingCode(string BookingCode) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pBookingCode", DataPlug.DataType._Varchar, BookingCode)); DataTable dt = Connection.GetTable("GetAccommodationFromBookingCode", param); List <CLayer.BookingItem> result = new List <CLayer.BookingItem>(); CLayer.BookingItem rt; foreach (DataRow dr in dt.Rows) { rt = new CLayer.BookingItem(); rt.AccommodationId = Connection.ToLong(dr["AccommodationId"]); rt.BookingId = Connection.ToLong(dr["bookingID"]); result.Add(rt); } return(result); }
public List <CLayer.BookingItem> GetAllDetailsforoffline(long bookingId) { List <CLayer.BookingItem> result = new List <CLayer.BookingItem>(); List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pBookingId", DataPlug.DataType._BigInt, bookingId)); DataTable dt = Connection.GetTable("booking_GetAllItems", param); CLayer.BookingItem bi; foreach (DataRow dr in dt.Rows) { bi = new CLayer.BookingItem(); bi.BookingItemId = Connection.ToLong(dr["BookingItemId"]); bi.AccommodationId = Connection.ToLong(dr["AccommodationId"]); bi.BookingId = Connection.ToLong(dr["BookingId"]); bi.AccommodationTitle = Connection.ToString(dr["AccommodationType"]); bi.CheckIn = Connection.ToDate(dr["CheckIn"]); bi.AccommodationTypeId = Connection.ToLong(dr["AccommodationTypeId"]); bi.CheckOut = Connection.ToDate(dr["CheckOut"]); bi.NoOfAccommodations = Connection.ToInteger(dr["NoOfAccommodations"]); bi.NoOfAdults = Connection.ToInteger(dr["NoOfAdults"]); bi.NoOfChildren = Connection.ToInteger(dr["NoOfChildren"]); bi.NoOfGuests = Connection.ToInteger(dr["NoOfGuests"]); bi.NoOfDays = Connection.ToInteger(dr["NoOfDays"]); bi.Amount = Connection.ToDecimal(dr["Amount"]); bi.PropertyTitle = Connection.ToString(dr["PropertyTitle"]); bi.PropertyAddress = Connection.ToString(dr["PropertyAddress"]); bi.PropertyId = Connection.ToLong(dr["PropertyId"]); bi.TotalAmount = Connection.ToDecimal(dr["TotalAmount"]); bi.TotalTax = Connection.ToDecimal(dr["TotalTax"]); bi.AccommodationTypeT = Connection.ToString(dr["AccommodationType"]); bi.StayCategoryT = Connection.ToString(dr["StayCategory"]); bi.DailyRate = Connection.ToDecimal(dr["DailyRate"]); bi.FirstDayCharge = Connection.ToDecimal(dr["FirstDayCharge"]); bi.CommissionSB = Connection.ToDecimal(dr["MarkupForSB"]); bi.TotalCommissionforother = Connection.ToDecimal(dr["TotalComForOther"]); bi.CorporateDiscountAmount = Connection.ToDecimal(dr["B2BDiscount"]); result.Add(bi); } return(result); }
public List <CLayer.BookingItem> GetAllDetailsForPartialPay(long bookingId, bool IsAmadeus = false) { List <CLayer.BookingItem> result = new List <CLayer.BookingItem>(); List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pBookingId", DataPlug.DataType._BigInt, bookingId)); string Sql = (IsAmadeus) ? "booking_GetGDSAllItemsForPartialPay" : "booking_GetAllItemsForPartialPay"; DataTable dt = Connection.GetTable(Sql, param); CLayer.BookingItem bi; foreach (DataRow dr in dt.Rows) { bi = new CLayer.BookingItem(); bi.BookingItemId = Connection.ToLong(dr["BookingItemId"]); bi.AccommodationId = Connection.ToLong(dr["AccommodationId"]); bi.BookingId = Connection.ToLong(dr["BookingId"]); bi.AccommodationTitle = Connection.ToString(dr["AccommodationType"]); bi.CheckIn = Connection.ToDate(dr["CheckIn"]); bi.quantity = Connection.ToInteger(dr["quantity"]); bi.CheckOut = Connection.ToDate(dr["CheckOut"]); bi.NoOfAccommodations = Connection.ToInteger(dr["NoOfAccommodations"]); bi.NoOfAdults = Connection.ToInteger(dr["NoOfAdults"]); bi.NoOfChildren = Connection.ToInteger(dr["NoOfChildren"]); bi.NoOfGuests = Connection.ToInteger(dr["NoOfGuests"]); bi.NoOfDays = Connection.ToInteger(dr["NoOfDays"]); bi.Amount = Connection.ToDecimal(dr["Amount"]); bi.PropertyTitle = Connection.ToString(dr["PropertyTitle"]); bi.PropertyAddress = Connection.ToString(dr["PropertyAddress"]); bi.PropertyId = Connection.ToLong(dr["PropertyId"]); bi.TotalAmount = Connection.ToDecimal(dr["TotalAmount"]); bi.TotalTax = Connection.ToDecimal(dr["TotalTax"]); bi.AccommodationTypeT = Connection.ToString(dr["AccommodationType"]); bi.StayCategoryT = Connection.ToString(dr["StayCategory"]); bi.DailyRate = Connection.ToDecimal(dr["DailyRate"]); bi.FirstDayCharge = Connection.ToDecimal(dr["FirstDayCharge"]); bi.CommissionSB = Connection.ToDecimal(dr["TotalComForSB"]); result.Add(bi); } return(result); }
public List <CLayer.BookingItem> GetAllUnderCart(int status, long userId) { List <CLayer.BookingItem> result = new List <CLayer.BookingItem>(); List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pStatus", DataPlug.DataType._Int, status)); param.Add(Connection.GetParameter("pUserId", DataPlug.DataType._BigInt, userId)); DataTable dt = Connection.GetTable("Booking_GetCartItems", param); CLayer.BookingItem bi; foreach (DataRow dr in dt.Rows) { bi = new CLayer.BookingItem(); bi.BookingItemId = Connection.ToLong(dr["BookingItemId"]); bi.BookingId = Connection.ToLong(dr["BookingId"]); bi.AccommodationTitle = Connection.ToString(dr["AccommodationType"]); bi.CheckIn = Connection.ToDate(dr["CheckIn"]); bi.CheckOut = Connection.ToDate(dr["CheckOut"]); bi.NoOfAccommodations = Connection.ToInteger(dr["NoOfAccommodations"]); bi.NoOfAdults = Connection.ToInteger(dr["NoOfAdults"]); bi.NoOfChildren = Connection.ToInteger(dr["NoOfChildren"]); bi.NoOfGuests = Connection.ToInteger(dr["NoOfGuests"]); bi.NoOfDays = Connection.ToInteger(dr["NoOfDays"]); bi.Amount = Connection.ToDecimal(dr["Amount"]); bi.PropertyTitle = Connection.ToString(dr["PropertyTitle"]); bi.PropertyAddress = Connection.ToString(dr["PropertyAddress"]); bi.ForUserFirstName = Connection.ToString(dr["ForUserFirstName"]); bi.ForUserLastName = Connection.ToString(dr["ForUserLastName"]); bi.ForUserEmail = Connection.ToString(dr["ForUserEmail"]); bi.ForUserMobile = Connection.ToString(dr["ForUserMobile"]); bi.TotalAmount = Connection.ToDecimal(dr["TotalAmount"]); bi.TotalTax = Connection.ToDecimal(dr["TotalTax"]); result.Add(bi); } return(result); }
public CLayer.BookingItem GetDetails(long bookingItemId) { CLayer.BookingItem result = null; List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pBookingItemId", DataPlug.DataType._BigInt, bookingItemId)); DataTable dt = Connection.GetTable("bookingitems_GetDetails", param); CLayer.BookingItem bi; foreach (DataRow dr in dt.Rows) { bi = new CLayer.BookingItem(); bi.BookingItemId = Connection.ToLong(dr["BookingItemId"]); bi.BookingId = Connection.ToLong(dr["BookingId"]); bi.AccommodationTitle = Connection.ToString(dr["AccommodationType"]); bi.CheckIn = Connection.ToDate(dr["CheckIn"]); bi.CheckOut = Connection.ToDate(dr["CheckOut"]); bi.NoOfAccommodations = Connection.ToInteger(dr["NoOfAccommodations"]); bi.NoOfAdults = Connection.ToInteger(dr["NoOfAdults"]); bi.NoOfChildren = Connection.ToInteger(dr["NoOfChildren"]); bi.NoOfGuests = Connection.ToInteger(dr["NoOfGuests"]); bi.NoOfDays = Connection.ToInteger(dr["NoOfDays"]); bi.Amount = Connection.ToDecimal(dr["Amount"]); bi.PropertyTitle = Connection.ToString(dr["PropertyTitle"]); bi.PropertyAddress = Connection.ToString(dr["PropertyAddress"]); bi.ForUserFirstName = Connection.ToString(dr["ForUserFirstName"]); bi.ForUserLastName = Connection.ToString(dr["ForUserLastName"]); bi.ForUserEmail = Connection.ToString(dr["ForUserEmail"]); bi.ForUserMobile = Connection.ToString(dr["ForUserMobile"]); bi.TotalAmount = Connection.ToDecimal(dr["TotalAmount"]); bi.TotalTax = Connection.ToDecimal(dr["TotalTax"]); result = bi; } return(result); }
// 1 = success, 0 = failed public static int BookAccommodations(List <CLayer.BookingAccDetails> bookingInfo, DateTime checkIn, DateTime checkOut, long userId, long bookingId, long offlinebookingId, string orderNo = "", List <CLayer.RoomStaysResult> objRoomStayResult = null, List <CLayer.Rates> pAmedusRates = null, int CountryID = 0) { long PropId = BLayer.Accommodation.GetPropertyId(bookingInfo[0].AccommodationId); decimal tax = BLayer.PropertyTax.GetTotalTax(PropId); long InventoryAPIID = BLayer.Accommodation.GetInventoryAPIType(PropId); int result = 0; List <long> accIds = new List <long>(); //long PId = BLayer.Bookings.GetPropertyId(bookingId); foreach (CLayer.BookingAccDetails t in bookingInfo) { accIds.Add(t.AccommodationId); } //List<CLayer.Tax> taxes = BLayer.Tax.GetAll() List <CLayer.Rates> accrates; CLayer.Role.Roles rle = BLayer.User.GetRole(userId); if (rle == CLayer.Role.Roles.CorporateUser || rle == CLayer.Role.Roles.Corporate) { accrates = BLayer.Rate.GetTotalRates(accIds, checkIn, checkOut, CLayer.Role.Roles.Corporate, userId, InventoryAPIID); } else { accrates = BLayer.Rate.GetTotalRates(accIds, checkIn, checkOut, CLayer.Role.Roles.Customer, userId, InventoryAPIID); } int cnt, i; //Amadeus Rates int InventoryAPIType = BLayer.Property.GetInventoryAPITypeId(PropId); List <CLayer.Rates> AmedusRatesList = new List <CLayer.Rates>(); if (InventoryAPIType == (int)CLayer.ObjectStatus.InventoryAPIType.Amadeus) { accrates = pAmedusRates; } //Amadeus Rates end cnt = bookingInfo.Count; CLayer.Booking bk = new CLayer.Booking(); CLayer.Booking bk1 = new CLayer.Booking(); bk.BookingDate = DateTime.Today; bk.CheckIn = checkIn; bk.CheckOut = checkOut; bk.NoOfDays = (checkOut - checkIn).Days; bk.Status = (int)CLayer.ObjectStatus.BookingStatus.Cart; bk.BookingId = bookingId; bk.ByUserId = userId; bk.InventoryAPIType = BLayer.Property.GetInventoryAPITypeId(PropId); bk.BookingId = BLayer.Bookings.SaveInitialData(bk); // CLayer.Role.Roles rle = (CLayer.Role.Roles) BLayer.User.GetRole(userId); BLayer.Bookings.SetPaymentRefNo(bk.BookingId, rle, orderNo); //*Added by rahul for saving initial data to offline bookings on 28/02/20 bk1.BookingDate = DateTime.Today; bk1.CheckIn = checkIn; bk1.CheckOut = checkOut; bk1.NoOfDays = (checkOut - checkIn).Days; bk1.Status = (int)CLayer.ObjectStatus.BookingStatus.Cart; bk1.BookingId = offlinebookingId; bk1.ByUserId = userId; bk1.InventoryAPIType = BLayer.Property.GetInventoryAPITypeId(PropId); bk1.BookingId = BLayer.Bookings.SaveOfflineBookingInitialData(bk1); //*Added by rahul on 28/02/2020 for storing order number in offlinebookings BLayer.Bookings.SetOfflinePaymentRefNo(bk1.BookingId, rle, orderNo); //**** bookingId = bk.BookingId; List <CLayer.BookingItem> items = new List <CLayer.BookingItem>(); List <CLayer.BookingItem> ofitems = new List <CLayer.BookingItem>(); CLayer.BookingItem bitem; CLayer.BookingItem ofbitem; DateTime lockIn = DateTime.Now; int minutes = 0; int.TryParse(BLayer.Settings.GetValue(CLayer.Settings.LOCKIN_TIME), out minutes); lockIn = lockIn.AddMinutes(minutes); //// change no of accommodation for external inventory //int InventoryAPIType = BLayer.Property.GetInventoryAPITypeId(PropId); //List<CLayer.Rates> newaccrates = new List<CLayer.Rates>(); //if (InventoryAPIType != 0) //{ // if (accrates.Count > 0) // { // string HotelId = BLayer.Property.GetHotelId(PropId); // if (HotelId != null && HotelId != "") // { // foreach (CLayer.Rates item in accrates) // { // string RoomId = BLayer.Accommodation.GetRoomId(item.AccommodationId); // if (RoomId != null && RoomId != "") // { // if (item.NoofAcc < 1) // { // item.NoofAcc = 10; // } // } // newaccrates.Add(item); // } // } // } //} //if (newaccrates.Count == 0) //{ // newaccrates = accrates; //} CLayer.BookingItem bGDSCountryItem = new CLayer.BookingItem(); for (i = 0; i < cnt; i++) { foreach (CLayer.Rates rt in accrates) { if (bookingInfo[i].AccommodationId == rt.AccommodationId) { if (bookingInfo[i].AccCount <= rt.NoofAcc && bookingInfo[i].AccCount != 0) { bitem = new CLayer.BookingItem(); bitem.CheckIn = checkIn; bitem.CheckOut = checkOut; bitem.BookingId = bookingId; bitem.AccommodationId = rt.AccommodationId; bitem.ForUser = userId; bitem.NoOfAccommodations = bookingInfo[i].AccCount; bitem.NoOfAdults = bookingInfo[i].Adults; bitem.NoOfChildren = bookingInfo[i].Children; bitem.NoOfGuests = bookingInfo[i].Guest; bitem.LockInTime = lockIn; bitem.Status = (int)CLayer.ObjectStatus.StatusType.Active; bitem.GDSCountry = CountryID; items.Add(bitem); bitem.BookingItemId = BLayer.BookingItem.SaveIntialData(bitem); bGDSCountryItem = bitem; //*Added by rahul for Saving BookingDetails data on 28/02/20 ofbitem = new CLayer.BookingItem(); ofbitem.CheckIn = checkIn; ofbitem.CheckOut = checkOut; ofbitem.BookingId = bk1.BookingId; ofbitem.AccommodationId = rt.AccommodationId; ofbitem.ForUser = userId; ofbitem.NoOfAccommodations = bookingInfo[i].AccCount; ofbitem.NoOfAdults = bookingInfo[i].Adults; ofbitem.NoOfChildren = bookingInfo[i].Children; ofbitem.NoOfGuests = bookingInfo[i].Guest; ofbitem.LockInTime = lockIn; ofbitem.Status = (int)CLayer.ObjectStatus.StatusType.Active; ofbitem.GDSCountry = CountryID; ofitems.Add(ofbitem); ofbitem.OfflineBookingItemId = BLayer.BookingItem.SaveIntialBookingDetailsData(ofbitem); } } } } //update gdscountry in booking items BLayer.BookingItem.SaveGDSCountry(bGDSCountryItem); //calculate tax and amount for each accommodation //considering booking is for accommodations in a single property long propertyId = BLayer.Accommodation.GetPropertyId(accrates[0].AccommodationId); List <CLayer.Tax> taxes = BLayer.Tax.GetAllForProperty(propertyId, checkIn, bk.BookingDate); List <CLayer.Tax> onTotalAmountTaxes = taxes.Where(m => m.OnTotalAmount == true).OrderBy(m => m.PriceUpto).ToList(); List <CLayer.Tax> ordinaryTaxes = taxes.Where(m => m.OnTotalAmount == false).OrderBy(m => m.PriceUpto).ToList(); decimal totalTax = 0; decimal guestRate = 0; decimal tt = 0; StringBuilder ratApplied = new StringBuilder(); foreach (CLayer.BookingItem item in items) { foreach (CLayer.Rates rat in accrates) { if (item.AccommodationId == rat.AccommodationId) { totalTax = 0; ratApplied.Clear(); guestRate = ((rat.GuestRate + rat.TotalGuestTax) * item.NoOfGuests); if (InventoryAPIType == (int)CLayer.ObjectStatus.InventoryAPIType.Amadeus) { item.TotalAmount = (rat.Amount + rat.TotalRateTax); } else { item.TotalAmount = ((rat.Amount + rat.TotalRateTax) * item.NoOfAccommodations) + guestRate; } totalTax = BLayer.Tax.GetTaxOnAmount(ordinaryTaxes, item.TotalAmount, item.BookingItemId); totalTax = totalTax + BLayer.Tax.GetTaxOnAmount(onTotalAmountTaxes, item.TotalAmount + totalTax, item.BookingItemId); item.Amount = Math.Round((rat.SupplierRate * item.NoOfAccommodations) + (rat.SupplierGuestRate * item.NoOfGuests)); if (rat.RateChanges != null && rat.RateChanges.Count > 0) { for (int ri = 0; ri < rat.RateChanges.Count; ri++) { if (ratApplied.Length > 0) { ratApplied.Append(","); } ratApplied.Append(rat.RateChanges[ri].StartDate); ratApplied.Append("#"); tt = (decimal)Math.Round(rat.RateChanges[ri].DayTotalCharge + (rat.RateChanges[ri].DayTotalGuestCharge * item.NoOfGuests)); ratApplied.Append(tt); } tt = (decimal)Math.Round(rat.RateChanges[0].DayTotalCharge + (rat.RateChanges[0].DayTotalGuestCharge * item.NoOfGuests)); } else { tt = 0; } item.FirstDayCharge = tt; item.TotalTax = totalTax; if (InventoryAPIType == (int)CLayer.ObjectStatus.InventoryAPIType.Amadeus) { item.TotalRateTax = Math.Round(rat.TotalRateTax); item.TotalGuestTax = Math.Round(rat.TotalGuestTax); } else { item.TotalRateTax = Math.Round(rat.TotalRateTax * item.NoOfAccommodations); item.TotalGuestTax = Math.Round(rat.TotalGuestTax * item.NoOfGuests); } // include tax with amount item.TotalAmount = Math.Round(item.TotalAmount); item.GuestAmount = Math.Round(guestRate); item.RatesApplied = ratApplied.ToString(); item.CorporateDiscountAmount = rat.CorpDiscount; item.CommissionSB = rat.SBMarkup; if (item.NoOfGuests > 0) { item.CommissionSB += rat.SBGuestMarkup; item.CorporateDiscountAmount += rat.CorpGuestDiscount; } BLayer.BookingItem.SaveAmounts(item); // save tax rate for each bookingitemid long BItId = item.BookingItemId; long BookId = item.BookingId; long Pid = BLayer.Accommodation.GetPropertyId(rat.AccommodationId); List <CLayer.Tax> tax1 = BLayer.Tax.GetPropertyTaxById(Pid); foreach (CLayer.Tax tx in tax1) { decimal TaxAmountBItem = Math.Round(((tx.Rate / tax) * ((rat.TotalRateTax * item.NoOfAccommodations) + (rat.TotalGuestTax * item.NoOfGuests)))); BLayer.BookingItem.SaveBookingtaxdata(BookId, BItId, tx.TaxTitleId, tx.Rate, TaxAmountBItem); } if (rat.AppliedOffers != null && rat.AppliedOffers.Count > 0) { foreach (CLayer.BookingItemOffer bo in rat.AppliedOffers) { BLayer.BookingItem.AddOffer(item.BookingItemId, bo.OfferId, bo.OfferTitle); } } } } } BLayer.Bookings.UpdateAmounts(bookingId); //***This is for saving rates for offline bookings - booking details foreach (CLayer.BookingItem item in ofitems) { foreach (CLayer.Rates rat in accrates) { if (item.AccommodationId == rat.AccommodationId) { totalTax = 0; ratApplied.Clear(); guestRate = ((rat.GuestRate + rat.TotalGuestTax) * item.NoOfGuests); if (InventoryAPIType == (int)CLayer.ObjectStatus.InventoryAPIType.Amadeus) { item.TotalAmount = (rat.Amount + rat.TotalRateTax); } else { item.TotalAmount = ((rat.Amount + rat.TotalRateTax) * item.NoOfAccommodations) + guestRate; } totalTax = BLayer.Tax.GetTaxOnAmount(ordinaryTaxes, item.TotalAmount, item.OfflineBookingItemId); totalTax = totalTax + BLayer.Tax.GetTaxOnAmount(onTotalAmountTaxes, item.TotalAmount + totalTax, item.OfflineBookingItemId); item.Amount = Math.Round((rat.SupplierRate * item.NoOfAccommodations) + (rat.SupplierGuestRate * item.NoOfGuests)); if (rat.RateChanges != null && rat.RateChanges.Count > 0) { for (int ri = 0; ri < rat.RateChanges.Count; ri++) { if (ratApplied.Length > 0) { ratApplied.Append(","); } ratApplied.Append(rat.RateChanges[ri].StartDate); ratApplied.Append("#"); tt = (decimal)Math.Round(rat.RateChanges[ri].DayTotalCharge + (rat.RateChanges[ri].DayTotalGuestCharge * item.NoOfGuests)); ratApplied.Append(tt); } tt = (decimal)Math.Round(rat.RateChanges[0].DayTotalCharge + (rat.RateChanges[0].DayTotalGuestCharge * item.NoOfGuests)); } else { tt = 0; } item.FirstDayCharge = tt; item.TotalTax = totalTax; if (InventoryAPIType == (int)CLayer.ObjectStatus.InventoryAPIType.Amadeus) { item.TotalRateTax = Math.Round(rat.TotalRateTax); item.TotalGuestTax = Math.Round(rat.TotalGuestTax); } else { item.TotalRateTax = Math.Round(rat.TotalRateTax * item.NoOfAccommodations); item.TotalGuestTax = Math.Round(rat.TotalGuestTax * item.NoOfGuests); } // include tax with amount item.TotalAmount = Math.Round(item.TotalAmount); item.GuestAmount = Math.Round(guestRate); item.RatesApplied = ratApplied.ToString(); item.CorporateDiscountAmount = rat.CorpDiscount; item.CommissionSB = rat.SBMarkup; item.SellRateAfterTax = rat.SellRateAfterTax; item.SellRateBeforeTax = rat.SellRateBeforeTax; item.PurchaseRateAfterTax = rat.PurchaseRateAfterTax; item.PurchaseRateBeforeTax = rat.PurchaseRateBeforeTax; if (item.NoOfGuests > 0) { item.CommissionSB += rat.SBGuestMarkup; item.CorporateDiscountAmount += rat.CorpGuestDiscount; } BLayer.BookingItem.SaveBookingDetailsAmounts(item); // save tax rate for each bookingitemid long BItId = item.BookingItemId; long BookId = item.BookingId; long Pid = BLayer.Accommodation.GetPropertyId(rat.AccommodationId); List <CLayer.Tax> tax1 = BLayer.Tax.GetPropertyTaxById(Pid); foreach (CLayer.Tax tx in tax1) { decimal TaxAmountBItem = Math.Round(((tx.Rate / tax) * ((rat.TotalRateTax * item.NoOfAccommodations) + (rat.TotalGuestTax * item.NoOfGuests)))); BLayer.BookingItem.SaveOfflineBookingtaxdata(BookId, BItId, tx.TaxTitleId, tx.Rate, TaxAmountBItem); } if (rat.AppliedOffers != null && rat.AppliedOffers.Count > 0) { foreach (CLayer.BookingItemOffer bo in rat.AppliedOffers) { BLayer.BookingItem.AddOffer(item.BookingItemId, bo.OfferId, bo.OfferTitle); } } } } } BLayer.Bookings.UpdateOfflinebookingAmounts(bk1.BookingId); //add paypal commision outside india users long UserId = BLayer.Bookings.GetBookedByUserId(bookingId); CLayer.User dat = BLayer.User.GetCountrUser(UserId); string ct = dat.Country; if (ct != "India") { decimal paypalcomm = Convert.ToDecimal(BLayer.Settings.GetValue(CLayer.Settings.PAYPAL_COMMISSION)); decimal GrandTotalAmt = Math.Round(BLayer.Bookings.GetTotal(bookingId)); decimal TotalAmtIncPayComm = Math.Round(GrandTotalAmt + (paypalcomm * GrandTotalAmt / 100)); BLayer.Bookings.SavePaypalComm((GrandTotalAmt * paypalcomm / 100), bookingId); BLayer.Bookings.UpdateTotalAmtIncPayComm(TotalAmtIncPayComm, bookingId); BLayer.Bookings.UpdateOfflineBookingTotalAmtIncPayComm(TotalAmtIncPayComm, bk1.BookingId); } //PartialPaymentbooking CLayer.Role.Roles UsertypeId = BLayer.User.GetRole(userId); decimal Partialamountperc = 0; if (UsertypeId == CLayer.Role.Roles.Customer) { Partialamountperc = Math.Round(BLayer.Property.GetPropertyB2CpartialamountPerc(propertyId)); } if (UsertypeId == CLayer.Role.Roles.Administrator || UsertypeId == CLayer.Role.Roles.Corporate || UsertypeId == CLayer.Role.Roles.Affiliate || UsertypeId == CLayer.Role.Roles.Supplier || UsertypeId == CLayer.Role.Roles.CorporateUser) { Partialamountperc = Math.Round(BLayer.Property.GetPropertyB2BpartialamountPerc(propertyId)); } decimal Partialamount = Math.Round((Partialamountperc * Math.Round(BLayer.Bookings.GetTotal(bookingId))) / 100); decimal remainingamount = Math.Round(Math.Round(BLayer.Bookings.GetTotal(bookingId)) - Partialamount); BLayer.BookingItem.SavePartialAmount(bookingId, Partialamountperc, Partialamount, remainingamount); result = 1; return(result); }
//********Ends Here********* public List <CLayer.BookingItem> GetAllBookingDetailsForApproval(long bookingId, bool IsAmedus = false) { List <CLayer.BookingItem> result = new List <CLayer.BookingItem>(); List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); try { param.Add(Connection.GetParameter("pBookingId", DataPlug.DataType._BigInt, bookingId)); DataTable dt; if (IsAmedus) { dt = Connection.GetTable("booking_GetAllItemsamedusForApproval", param); } else { dt = Connection.GetTable("booking_GetAllItems", param); } CLayer.BookingItem bi; foreach (DataRow dr in dt.Rows) { bi = new CLayer.BookingItem(); bi.BookingItemId = Connection.ToLong(dr["BookingItemId"]); bi.AccommodationId = Connection.ToLong(dr["AccommodationId"]); bi.BookingId = Connection.ToLong(dr["BookingId"]); bi.AccommodationTitle = Connection.ToString(dr["AccommodationType"]); bi.CheckIn = Connection.ToDate(dr["CheckIn"]); bi.CheckOut = Connection.ToDate(dr["CheckOut"]); bi.NoOfAccommodations = Connection.ToInteger(dr["NoOfAccommodations"]); bi.NoOfAdults = Connection.ToInteger(dr["NoOfAdults"]); bi.NoOfChildren = Connection.ToInteger(dr["NoOfChildren"]); bi.NoOfGuests = Connection.ToInteger(dr["NoOfGuests"]); bi.NoOfDays = Connection.ToInteger(dr["NoOfDays"]); bi.Amount = Connection.ToDecimal(dr["Amount"]); bi.PropertyTitle = Connection.ToString(dr["PropertyTitle"]); bi.PropertyAddress = Connection.ToString(dr["PropertyAddress"]); bi.PropertyId = Connection.ToLong(dr["PropertyId"]); //bi.ForUserFirstName = Connection.ToString(dr["ForUserFirstName"]); //bi.ForUserLastName = Connection.ToString(dr["ForUserLastName"]); // bi.ForUserEmail = Connection.ToString(dr["ForUserEmail"]); // bi.ForUserMobile = Connection.ToString(dr["ForUserMobile"]); bi.TotalAmount = Connection.ToDecimal(dr["TotalAmount"]); bi.TotalTax = Connection.ToDecimal(dr["TotalTax"]); bi.AccommodationTypeT = Connection.ToString(dr["AccommodationType"]); bi.StayCategoryT = Connection.ToString(dr["StayCategory"]); bi.DailyRate = Connection.ToDecimal(dr["DailyRate"]); bi.FirstDayCharge = Connection.ToDecimal(dr["FirstDayCharge"]); // bi.CommissionSB = Connection.ToDecimal(dr["TotalComForSB"]); bi.CommissionSB = Connection.ToDecimal(dr["MarkupForSB"]); bi.TotalCommissionforother = Connection.ToDecimal(dr["TotalComForOther"]); bi.CorporateDiscountAmount = Connection.ToDecimal(dr["B2BDiscount"]); bi.HotelConfirmNumber = Connection.ToString(dr["HotelConfirmNumber"]); bi.TotalRateTax = Connection.ToDecimal(dr["TotalRateTax"]); bi.CountryName = Connection.ToString(dr["CountryName"]); bi.cityName = Connection.ToString(dr["City"]); if (IsAmedus) { bi.ApproverName = Connection.ToString(dr["ApproverName"]); bi.RejectionNote = Connection.ToString(dr["RejectionNote"]); } result.Add(bi); } } catch (Exception ex) { result = null; } return(result); }
//***Save Amount for offlinebookings bookingdetails //**Added by rahul on 29/02/20 public static void SaveBookingDetailsAmounts(CLayer.BookingItem data) { DataLayer.BookingItem bi = new DataLayer.BookingItem(); bi.SaveBookingDetailsAmounts(data); }
public static int BookAccommodations(List <CLayer.BookingAccDetails> bookingInfo, DateTime checkIn, DateTime checkOut, long userId, long bookingId, string orderNo = "") { long PropId = BLayer.Accommodation.GetPropertyId(bookingInfo[0].AccommodationId); decimal tax = BLayer.PropertyTax.GetTotalTax(PropId); long InventoryAPIType = BLayer.Accommodation.GetInventoryAPIType(PropId); int result = 0; List <long> accIds = new List <long>(); foreach (CLayer.BookingAccDetails t in bookingInfo) { accIds.Add(t.AccommodationId); } List <CLayer.Rates> accrates; CLayer.Role.Roles rle = BLayer.User.GetRole(userId); if (rle == CLayer.Role.Roles.CorporateUser || rle == CLayer.Role.Roles.Corporate) { accrates = BLayer.Rate.GetTotalRates(accIds, checkIn, checkOut, CLayer.Role.Roles.Corporate, userId, InventoryAPIType); } else { accrates = BLayer.Rate.GetTotalRates(accIds, checkIn, checkOut, CLayer.Role.Roles.Customer, userId, InventoryAPIType); } int cnt, i; cnt = bookingInfo.Count; CLayer.Booking bk = new CLayer.Booking(); bk.BookingDate = DateTime.Today; bk.CheckIn = checkIn; bk.CheckOut = checkOut; bk.NoOfDays = (checkOut - checkIn).Days; bk.Status = (int)CLayer.ObjectStatus.BookingStatus.Offline; bk.BookingId = bookingId; bk.ByUserId = userId; bk.BookingId = BLayer.Bookings.SaveInitialDataForOfflinBeforConfirm(bk); BLayer.Bookings.SetPaymentRefNo(bk.BookingId, rle, orderNo); bookingId = bk.BookingId; List <CLayer.BookingItem> items = new List <CLayer.BookingItem>(); CLayer.BookingItem bitem; DateTime lockIn = DateTime.Now; int minutes = 0; int.TryParse(BLayer.Settings.GetValue(CLayer.Settings.LOCKIN_TIME), out minutes); lockIn = lockIn.AddMinutes(minutes); //Delete All Booking Items Befor Modify to New Booking by booking id BLayer.BookingItem.DeleteAllItemsByBookingId(bookingId); BLayer.BookingItem.DeleteAllTaxItemsByBookingId(bookingId); for (i = 0; i < cnt; i++) { foreach (CLayer.Rates rt in accrates) { if (bookingInfo[i].AccommodationId == rt.AccommodationId) { if (bookingInfo[i].AccCount <= rt.NoofAcc && bookingInfo[i].AccCount != 0) { bitem = new CLayer.BookingItem(); bitem.CheckIn = checkIn; bitem.CheckOut = checkOut; bitem.BookingId = bookingId; bitem.AccommodationId = rt.AccommodationId; bitem.ForUser = userId; bitem.NoOfAccommodations = bookingInfo[i].AccCount; bitem.NoOfAdults = bookingInfo[i].Adults; bitem.NoOfChildren = bookingInfo[i].Children; bitem.NoOfGuests = bookingInfo[i].Guest; bitem.Cus_SupplierAmount = bookingInfo[i].Cus_SupplierAmount; bitem.Cus_TotalAmount = bookingInfo[i].Cus_TotalAmount; bitem.Cus_TaxAmount = bookingInfo[i].Cus_TaxAmount; bitem.Cus_GrandTotalAmount = bookingInfo[i].Cus_GrandTotalAmount; bitem.LockInTime = lockIn; bitem.Status = (int)CLayer.ObjectStatus.StatusType.Active; items.Add(bitem); bitem.BookingItemId = BLayer.BookingItem.SaveIntialData(bitem); } } } } long propertyId = BLayer.Accommodation.GetPropertyId(accrates[0].AccommodationId); List <CLayer.Tax> taxes = BLayer.Tax.GetAllForProperty(propertyId, checkIn, bk.BookingDate); List <CLayer.Tax> onTotalAmountTaxes = taxes.Where(m => m.OnTotalAmount == true).OrderBy(m => m.PriceUpto).ToList(); List <CLayer.Tax> ordinaryTaxes = taxes.Where(m => m.OnTotalAmount == false).OrderBy(m => m.PriceUpto).ToList(); decimal totalTax = 0; decimal guestRate = 0; decimal tt = 0; StringBuilder ratApplied = new StringBuilder(); foreach (CLayer.BookingItem item in items) { foreach (CLayer.Rates rat in accrates) { if (item.AccommodationId == rat.AccommodationId) { totalTax = 0; ratApplied.Clear(); guestRate = ((rat.GuestRate + rat.TotalGuestTax) * item.NoOfGuests); item.TotalAmount = ((rat.Amount + rat.TotalRateTax) * item.NoOfAccommodations) + guestRate; totalTax = BLayer.Tax.GetTaxOnAmount(ordinaryTaxes, item.TotalAmount, item.BookingItemId); totalTax = totalTax + BLayer.Tax.GetTaxOnAmount(onTotalAmountTaxes, item.TotalAmount + totalTax, item.BookingItemId); item.Amount = Math.Round((rat.SupplierRate * item.NoOfAccommodations) + (rat.SupplierGuestRate * item.NoOfGuests)); if (rat.RateChanges != null && rat.RateChanges.Count > 0) { for (int ri = 0; ri < rat.RateChanges.Count; ri++) { if (ratApplied.Length > 0) { ratApplied.Append(","); } ratApplied.Append(rat.RateChanges[ri].StartDate); ratApplied.Append("#"); tt = (decimal)Math.Round(rat.RateChanges[ri].DayTotalCharge + (rat.RateChanges[ri].DayTotalGuestCharge * item.NoOfGuests)); ratApplied.Append(tt); } tt = (decimal)Math.Round(rat.RateChanges[0].DayTotalCharge + (rat.RateChanges[0].DayTotalGuestCharge * item.NoOfGuests)); } else { tt = 0; } item.FirstDayCharge = tt; item.TotalTax = totalTax; item.TotalRateTax = Math.Round(rat.TotalRateTax * item.NoOfAccommodations); item.TotalGuestTax = Math.Round(rat.TotalGuestTax * item.NoOfGuests); // include tax with amount item.TotalAmount = Math.Round(item.TotalAmount); item.GuestAmount = Math.Round(guestRate); item.RatesApplied = ratApplied.ToString(); item.CorporateDiscountAmount = rat.CorpDiscount; item.CommissionSB = rat.SBMarkup; if (item.NoOfGuests > 0) { item.CommissionSB += rat.SBGuestMarkup; item.CorporateDiscountAmount += rat.CorpGuestDiscount; } BLayer.BookingItem.SaveAmounts(item); BLayer.BookingItem.UpdateCustomBook(item.BookingItemId, 0); //update custom amount if (item.Cus_GrandTotalAmount > 0) { item.Amount = item.Cus_GrandTotalAmount; item.TotalAmount = item.Cus_GrandTotalAmount; item.TotalTax = item.Cus_TaxAmount; item.TotalRateTax = item.Cus_TaxAmount; item.CommissionSB = item.Cus_TotalAmount - item.Cus_SupplierAmount; item.GuestAmount = 0; item.TotalGuestTax = 0; item.CorporateDiscountAmount = 0; BLayer.BookingItem.SaveAmounts(item); BLayer.BookingItem.UpdateCustomBook(item.BookingItemId, 1); } // save tax rate for each bookingitemid long BItId = item.BookingItemId; long BookId = item.BookingId; long Pid = BLayer.Accommodation.GetPropertyId(rat.AccommodationId); List <CLayer.Tax> tax1 = BLayer.Tax.GetPropertyTaxById(Pid); if (item.Cus_GrandTotalAmount > 0) { } else { foreach (CLayer.Tax tx in tax1) { decimal TaxAmountBItem = Math.Round(((tx.Rate / tax) * ((rat.TotalRateTax * item.NoOfAccommodations) + (rat.TotalGuestTax * item.NoOfGuests)))); BLayer.BookingItem.SaveBookingtaxdata(BookId, BItId, tx.TaxTitleId, tx.Rate, TaxAmountBItem); } if (rat.AppliedOffers != null && rat.AppliedOffers.Count > 0) { foreach (CLayer.BookingItemOffer bo in rat.AppliedOffers) { BLayer.BookingItem.AddOffer(item.BookingItemId, bo.OfferId, bo.OfferTitle); } } } } } } BLayer.Bookings.UpdateAmounts(bookingId); //add paypal commision outside india users long UserId = BLayer.Bookings.GetBookedByUserId(bookingId); CLayer.User dat = BLayer.User.GetCountrUser(UserId); string ct = dat.Country; if (ct != "India") { decimal paypalcomm = Convert.ToDecimal(BLayer.Settings.GetValue(CLayer.Settings.PAYPAL_COMMISSION)); decimal GrandTotalAmt = Math.Round(BLayer.Bookings.GetTotal(bookingId)); decimal TotalAmtIncPayComm = Math.Round(GrandTotalAmt + (paypalcomm * GrandTotalAmt / 100)); BLayer.Bookings.SavePaypalComm((GrandTotalAmt * paypalcomm / 100), bookingId); BLayer.Bookings.UpdateTotalAmtIncPayComm(TotalAmtIncPayComm, bookingId); } //PartialPaymentbooking CLayer.Role.Roles UsertypeId = BLayer.User.GetRole(userId); decimal Partialamountperc = 0; if (UsertypeId == CLayer.Role.Roles.Customer) { Partialamountperc = Math.Round(BLayer.Property.GetPropertyB2CpartialamountPerc(propertyId)); } if (UsertypeId == CLayer.Role.Roles.Administrator || UsertypeId == CLayer.Role.Roles.Corporate || UsertypeId == CLayer.Role.Roles.Affiliate || UsertypeId == CLayer.Role.Roles.Supplier || UsertypeId == CLayer.Role.Roles.CorporateUser) { Partialamountperc = Math.Round(BLayer.Property.GetPropertyB2BpartialamountPerc(propertyId)); } decimal Partialamount = Math.Round((Partialamountperc * Math.Round(BLayer.Bookings.GetTotal(bookingId))) / 100); decimal remainingamount = Math.Round(Math.Round(BLayer.Bookings.GetTotal(bookingId)) - Partialamount); BLayer.BookingItem.SavePartialAmount(bookingId, Partialamountperc, Partialamount, remainingamount); result = 1; return(result); }
public static void SaveGDSCountry(CLayer.BookingItem data) { DataLayer.BookingItem bi = new DataLayer.BookingItem(); bi.SaveGDSCountry(data); }
public static void UpdateGDSCurrencyDetails(CLayer.BookingItem pBookingItem) { DataLayer.BookingItem bi = new DataLayer.BookingItem(); bi.UpdateGDSCurrencyDetails(pBookingItem); }