public CLayer.CityClassResult Save(CLayer.CityClass cityclass) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); CLayer.CityClassResult r = new CLayer.CityClassResult(); param.Add(Connection.GetParameter("pCityClassId", DataPlug.DataType._BigInt, cityclass.CityClassID)); param.Add(Connection.GetParameter("pCityClassCode", DataPlug.DataType._Varchar, cityclass.CityClassCode)); param.Add(Connection.GetParameter("pCityClassDesription", DataPlug.DataType._Varchar, cityclass.CityClassDescription)); param.Add(Connection.GetParameter("pB2B_ID", DataPlug.DataType._BigInt, cityclass.B2B_ID)); Int64 id = Convert.ToInt64(Connection.ExecuteQueryScalar("cityclass_Save", param)); string[] CountryIds = cityclass.CountryIDs.Split(','); string[] StateIds = cityclass.StateIDs.Split(','); string[] CityIds = cityclass.CityIDs.Split(','); for (int i = 0; i <= CityIds.Length - 1; i++) { List <DataPlug.Parameter> param1 = new List <DataPlug.Parameter>(); param1.Add(Connection.GetParameter("pCityClassId", DataPlug.DataType._BigInt, id)); param1.Add(Connection.GetParameter("pCountryId", DataPlug.DataType._BigInt, Convert.ToInt64(CountryIds[i]))); param1.Add(Connection.GetParameter("pStateId", DataPlug.DataType._BigInt, Convert.ToInt64(StateIds[i]))); param1.Add(Connection.GetParameter("pCityId", DataPlug.DataType._BigInt, Convert.ToInt64(CityIds[i]))); Int64 CityId = Convert.ToInt64(Connection.ExecuteQueryScalar("cityclassBasedCities_Save", param1)); } r.Result = "Success"; return(r); }
public long SaveUser(CLayer.User data) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pUserId", DataPlug.DataType._BigInt, data.UserId)); if (data.SalutationId == 0) { param.Add(Connection.GetParameter("pSalutationId", DataPlug.DataType._Int, DBNull.Value)); } else { param.Add(Connection.GetParameter("pSalutationId", DataPlug.DataType._Int, data.SalutationId)); } // param.Add(Connection.GetParameter("pBusinessName", DataPlug.DataType._Varchar, data.Businessname)); param.Add(Connection.GetParameter("pFirstName", DataPlug.DataType._Varchar, data.FirstName)); param.Add(Connection.GetParameter("pLastName", DataPlug.DataType._Varchar, data.LastName)); param.Add(Connection.GetParameter("pDateOfBirth", DataPlug.DataType._Date, data.DateOfBirth)); param.Add(Connection.GetParameter("pSex", DataPlug.DataType._Int, data.Sex)); param.Add(Connection.GetParameter("pUserType", DataPlug.DataType._Int, data.UserTypeId)); param.Add(Connection.GetParameter("pStatus", DataPlug.DataType._Int, data.Status)); param.Add(Connection.GetParameter("pEmail", DataPlug.DataType._Varchar, data.Email)); object result = Connection.ExecuteQueryScalar("userexternal_Save", param); return(Connection.ToLong(result)); }
public long GetInvoiceNumber(long stateId) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pStateId", DataPlug.DataType._BigInt, stateId)); return(Connection.ToLong(Connection.ExecuteQueryScalar("State_InvoiceNumber", param))); }
public long Save(CLayer.SupplierInvoice data) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pSupplierInvoiceID", DataPlug.DataType._BigInt, data.SupplierInvoiceID)); param.Add(Connection.GetParameter("pPropertyID", DataPlug.DataType._Int, data.PropertyId)); param.Add(Connection.GetParameter("pSupplierID", DataPlug.DataType._Int, data.SupplierId)); param.Add(Connection.GetParameter("pInvoiceNumber", DataPlug.DataType._Text, data.InvoiceNumber)); param.Add(Connection.GetParameter("pInvoiceDate", DataPlug.DataType._DateTime, data.InvoiceDate)); param.Add(Connection.GetParameter("pServiceTaxRegNumber", DataPlug.DataType._Text, data.ServiceTaxRegNumber)); param.Add(Connection.GetParameter("pPAN", DataPlug.DataType._Text, data.PAN_Number)); param.Add(Connection.GetParameter("pBaseAmount", DataPlug.DataType._Decimal, data.BaseAmount)); param.Add(Connection.GetParameter("pLuxuryTax", DataPlug.DataType._Decimal, data.LuxuryTax)); param.Add(Connection.GetParameter("pServiceTax", DataPlug.DataType._Decimal, data.ServiceTax)); param.Add(Connection.GetParameter("pTotalInvoiceValue", DataPlug.DataType._Decimal, data.TotalInvoiceValue)); param.Add(Connection.GetParameter("pEntryDate", DataPlug.DataType._DateTime, data.EntryDate)); param.Add(Connection.GetParameter("ptxtTotalAdjustmentResult", DataPlug.DataType._Decimal, data.txtTotalAdjustmentResult)); param.Add(Connection.GetParameter("pPropertyEmailAddresss", DataPlug.DataType._Text, data.PropertyEmailAddresss)); param.Add(Connection.GetParameter("pPropertyType", DataPlug.DataType._Text, data.PropertyType)); param.Add(Connection.GetParameter("pTaxType", DataPlug.DataType._Text, data.TaxType)); param.Add(Connection.GetParameter("pIsSupInvoicedone", DataPlug.DataType._Bool, data.IsSupInvoicedone)); object result = Connection.ExecuteQueryScalar("SupplierInvoice_save", param); return(Connection.ToInteger(result)); }
public long Save_Amadeus(CLayer.Accommodation data) { try { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pAccommodationId", DataPlug.DataType._BigInt, data.AccommodationId)); param.Add(Connection.GetParameter("pAccommodationTypeId", DataPlug.DataType._Int, data.AccommodationTypeId)); param.Add(Connection.GetParameter("pStayCategoryId", DataPlug.DataType._Int, data.StayCategoryId)); param.Add(Connection.GetParameter("pAccommodationCount", DataPlug.DataType._Int, data.AccommodationCount)); param.Add(Connection.GetParameter("pPropertyId", DataPlug.DataType._BigInt, data.PropertyId)); param.Add(Connection.GetParameter("pDescription", DataPlug.DataType._Text, data.Description)); //param.Add(Connection.GetParameter("pLocation", DataPlug.DataType._Varchar, data.Location)); param.Add(Connection.GetParameter("pMaxNoOfPeople", DataPlug.DataType._Int, data.MaxNoOfPeople)); param.Add(Connection.GetParameter("pMaxNoOfChildren", DataPlug.DataType._Int, data.MaxNoOfChildren)); param.Add(Connection.GetParameter("pMinNoOfPeople", DataPlug.DataType._Int, data.MinNoOfPeople)); param.Add(Connection.GetParameter("pBedRooms", DataPlug.DataType._Int, data.BedRooms)); param.Add(Connection.GetParameter("pArea", DataPlug.DataType._Decimal, data.Area)); param.Add(Connection.GetParameter("pStatus", DataPlug.DataType._Int, data.Status)); param.Add(Connection.GetParameter("pUpdatedBy", DataPlug.DataType._BigInt, data.UpdatedById)); param.Add(Connection.GetParameter("pTotalAccommodations", DataPlug.DataType._Int, data.TotalAccommodations)); param.Add(Connection.GetParameter("pRoomType", DataPlug.DataType._Varchar, data.RoomType)); param.Add(Connection.GetParameter("pRoomTypeCode", DataPlug.DataType._Varchar, data.RoomTypeCode)); param.Add(Connection.GetParameter("pSourceofBusiness", DataPlug.DataType._Varchar, data.SourceofBusiness)); param.Add(Connection.GetParameter("pBookingCode", DataPlug.DataType._Varchar, data.BookingCode)); param.Add(Connection.GetParameter("pRatePlanCode", DataPlug.DataType._Varchar, data.RatePlanCode)); param.Add(Connection.GetParameter("pRoomStayRPH", DataPlug.DataType._Varchar, data.RoomStayRPH)); object result = Connection.ExecuteQueryScalar("accommodation_amadeus_save", param); return(Connection.ToInteger(result)); } catch (Exception ex22) { return(0); } }
public int GDSSave(CLayer.Country country) { string pKeyWords = country.KeyWords; string sql = "select keywords from country where countryid=" + country.CountryId + ""; string result = Convert.ToString(Connection.ExecuteSQLQueryScalar(sql)); if (!string.IsNullOrEmpty(result)) { string[] resultList = result.Split(','); for (int i = 0; i < resultList.Length; i++) { if (resultList[i] != pKeyWords) { country.KeyWords = result + "," + pKeyWords; } } } List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pCountryId", DataPlug.DataType._BigInt, country.CountryId)); param.Add(Connection.GetParameter("pName", DataPlug.DataType._Varchar, country.Name)); param.Add(Connection.GetParameter("pCode", DataPlug.DataType._Varchar, country.Code)); param.Add(Connection.GetParameter("pIsDefault", DataPlug.DataType._Bool, country.IsDefault)); param.Add(Connection.GetParameter("pStatus", DataPlug.DataType._Int, country.Status)); param.Add(Connection.GetParameter("pForProperty", DataPlug.DataType._Bool, country.ForProperty)); param.Add(Connection.GetParameter("pKeyWords", DataPlug.DataType._Varchar, country.KeyWords)); object objresult = Connection.ExecuteQueryScalar("GDScountry_Save", param); return(Connection.ToInteger(objresult)); }
public long GDSSave(CLayer.Invoice data) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pInvoiceId", DataPlug.DataType._BigInt, data.InvoiceId)); param.Add(Connection.GetParameter("pBookingId", DataPlug.DataType._BigInt, data.BookingId)); param.Add(Connection.GetParameter("pToAddress", DataPlug.DataType._Varchar, data.ToAddress)); param.Add(Connection.GetParameter("pInvoiceDate", DataPlug.DataType._Date, data.InvoiceDate)); param.Add(Connection.GetParameter("pDueDate", DataPlug.DataType._Date, data.DueDate)); param.Add(Connection.GetParameter("pMailDate", DataPlug.DataType._Date, data.MailedDate)); param.Add(Connection.GetParameter("pReimbursements", DataPlug.DataType._Decimal, data.Reimbursements)); param.Add(Connection.GetParameter("pDiscounts", DataPlug.DataType._Decimal, data.Discounts)); param.Add(Connection.GetParameter("pOthers", DataPlug.DataType._Decimal, data.Others)); param.Add(Connection.GetParameter("pInvoiceType", DataPlug.DataType._Int, data.InvoiceType)); param.Add(Connection.GetParameter("pInvoiceNumber", DataPlug.DataType._Varchar, data.InvoiceNumber)); param.Add(Connection.GetParameter("pStatus", DataPlug.DataType._Int, data.Status)); param.Add(Connection.GetParameter("pHtmlSection1", DataPlug.DataType._Text, data.HtmlSection1)); param.Add(Connection.GetParameter("pHtmlSection2", DataPlug.DataType._Text, data.HtmlSection2)); param.Add(Connection.GetParameter("pHtmlSection3", DataPlug.DataType._Text, data.HtmlSection3)); param.Add(Connection.GetParameter("pHtmlSection4", DataPlug.DataType._Text, data.HtmlSection4)); object obj = Connection.ExecuteQueryScalar("GDSInvoice_Save", param); return(Connection.ToLong(obj)); }
public void UpdateCountry(string Name) { List <DataPlug.Parameter> parameter = new List <DataPlug.Parameter>(); parameter.Add(Connection.GetParameter("pName", DataPlug.DataType._Varchar, Name)); Connection.ExecuteQueryScalar("Sp_Tamarind_Country_Upd", parameter); }
//***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 int Save(CLayer.Tax data) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pTaxId", DataPlug.DataType._Int, data.TaxId)); param.Add(Connection.GetParameter("pTaxTitleId", DataPlug.DataType._Int, data.TaxTitleId)); param.Add(Connection.GetParameter("pRate", DataPlug.DataType._Decimal, data.Rate)); param.Add(Connection.GetParameter("pCountryId", DataPlug.DataType._Int, data.CountryId)); param.Add(Connection.GetParameter("pStateId", DataPlug.DataType._Int, data.StateId)); param.Add(Connection.GetParameter("pCityId", DataPlug.DataType._Int, data.CityId)); param.Add(Connection.GetParameter("pNotes", DataPlug.DataType._Varchar, data.Notes)); param.Add(Connection.GetParameter("pStatus", DataPlug.DataType._Int, data.Status)); param.Add(Connection.GetParameter("pStartDate", DataPlug.DataType._DateTime, data.StartDate)); param.Add(Connection.GetParameter("pEndDate", DataPlug.DataType._DateTime, data.EndDate)); param.Add(Connection.GetParameter("pOnDate", DataPlug.DataType._Int, data.OnDate)); param.Add(Connection.GetParameter("pOnTotalAmount", DataPlug.DataType._Bool, data.OnTotalAmount)); param.Add(Connection.GetParameter("pPriceUpto", DataPlug.DataType._Decimal, data.PriceUpto)); param.Add(Connection.GetParameter("pUpdatedBy", DataPlug.DataType._BigInt, data.UpdatedBy)); param.Add(Connection.GetParameter("pUpdatedDate", DataPlug.DataType._DateTime, data.UpdatedDate)); param.Add(Connection.GetParameter("pUnlimitedPrice", DataPlug.DataType._Bool, data.Unlimited)); object result = Connection.ExecuteQueryScalar("tax_Save", param); return(Connection.ToInteger(result)); }
public long SaveInitialCustomerPaymentData(CLayer.OfflinePayment data) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pUserId", DataPlug.DataType._Int, data.UserId)); param.Add(Connection.GetParameter("pName", DataPlug.DataType._Varchar, data.Name)); param.Add(Connection.GetParameter("pRefNumber", DataPlug.DataType._Varchar, data.ReferenceNumber)); param.Add(Connection.GetParameter("pAmount", DataPlug.DataType._Decimal, data.Amount)); param.Add(Connection.GetParameter("pMessage", DataPlug.DataType._Varchar, data.Message)); param.Add(Connection.GetParameter("pAddress", DataPlug.DataType._Varchar, data.Address)); param.Add(Connection.GetParameter("pEmail", DataPlug.DataType._Varchar, data.Email)); param.Add(Connection.GetParameter("pMobile", DataPlug.DataType._Varchar, data.Mobile)); param.Add(Connection.GetParameter("pCountryId", DataPlug.DataType._Int, data.CountryId)); param.Add(Connection.GetParameter("pStateId", DataPlug.DataType._Int, data.StateId)); param.Add(Connection.GetParameter("pCityId", DataPlug.DataType._Int, data.CityId)); param.Add(Connection.GetParameter("pCityName", DataPlug.DataType._Varchar, data.City)); param.Add(Connection.GetParameter("pZipCode", DataPlug.DataType._Varchar, data.ZipCode)); param.Add(Connection.GetParameter("pGatewaytype", DataPlug.DataType._Int, data.Gatewaytype)); param.Add(Connection.GetParameter("pStatus", DataPlug.DataType._Int, (int)CLayer.ObjectStatus.OfflinePyamentStatus.Processing)); param.Add(Connection.GetParameter("pPaymentlinkid", DataPlug.DataType._Char, data.CustomerGuid)); object result = Connection.ExecuteQueryScalar("SP_offlineCustomerPayment_Save", param); return(Connection.ToLong(result)); }
public long VerifiedUpdate(CLayer.Review feedback) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pPropertyId", DataPlug.DataType._BigInt, feedback.PropertyId)); param.Add(Connection.GetParameter("pUserId", DataPlug.DataType._BigInt, feedback.UserId)); param.Add(Connection.GetParameter("pBookingId", DataPlug.DataType._BigInt, feedback.BookingId)); param.Add(Connection.GetParameter("pDescription", DataPlug.DataType._Varchar, feedback.Description)); param.Add(Connection.GetParameter("pUpdatedUserId", DataPlug.DataType._BigInt, feedback.UpdatedBy)); param.Add(Connection.GetParameter("pUpdatedDate", DataPlug.DataType._DateTime, feedback.UpdatedDate)); param.Add(Connection.GetParameter("pStatus", DataPlug.DataType._Int, feedback.Status)); param.Add(Connection.GetParameter("pIsRecommended", DataPlug.DataType._Bool, feedback.Recommended)); param.Add(Connection.GetParameter("pAccommodationCity", DataPlug.DataType._Varchar, feedback.AccommodationCity)); param.Add(Connection.GetParameter("pAccessibility", DataPlug.DataType._Int, feedback.Accessibility)); param.Add(Connection.GetParameter("pEasiness", DataPlug.DataType._Int, feedback.Easiness)); param.Add(Connection.GetParameter("pCleanlinessBed", DataPlug.DataType._Int, feedback.CleanlinessBed)); param.Add(Connection.GetParameter("pCleanlinessBath", DataPlug.DataType._Int, feedback.CleanlinessBath)); param.Add(Connection.GetParameter("pSleepQuality", DataPlug.DataType._Int, feedback.SleepQuality)); param.Add(Connection.GetParameter("pStaffbehave", DataPlug.DataType._Int, feedback.Staffbehave)); param.Add(Connection.GetParameter("pOverallExp", DataPlug.DataType._Int, feedback.OverallExp)); param.Add(Connection.GetParameter("pConsiderfornext", DataPlug.DataType._Int, feedback.Considerfornext)); //param.Add(Connection.GetParameter("pRating", DataPlug.DataType._Int, feedback.Rating)); object result = Connection.ExecuteQueryScalar("review_Update", param); return(Connection.ToLong(result)); }
public void SetStatus(long B2BId, int Status) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pB2BId", DataPlug.DataType._BigInt, B2BId)); param.Add(Connection.GetParameter("pStatus", DataPlug.DataType._Int, Status)); object result = Connection.ExecuteQueryScalar("b2b_SetStatus", param); }
public void Delete(int taxId) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pTaxId", DataPlug.DataType._Int, taxId)); Connection.ExecuteQueryScalar("tax_Delete", param); return; }
public void Accommodation_Amadeus_Delete(long PropertyId) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pPropertyId", DataPlug.DataType._BigInt, PropertyId)); object result = Connection.ExecuteQueryScalar("accommodation_amadeus_Delete", param); }
//offerList Delete public void DeleteOffer(long offerId) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pOfferId", DataPlug.DataType._BigInt, offerId)); Connection.ExecuteQueryScalar("offers_Delete", param); return; }
public void UpdateHotelList(int HotelID, string HotelName) { List <DataPlug.Parameter> parameters = new List <DataPlug.Parameter>(); parameters.Add(Connection.GetParameter("pHotelId", DataPlug.DataType._BigInt, HotelID)); parameters.Add(Connection.GetParameter("pHotelName", DataPlug.DataType._Varchar, HotelName)); Connection.ExecuteQueryScalar("sp_tamarind_hotellist", parameters); }
public int GetSupplierCountForMail(DateTime forDate) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pBookingDate", DataPlug.DataType._Date, forDate)); object obj = Connection.ExecuteQueryScalar("b2b_GetSupplierCountForMail", param); return(Connection.ToInteger(obj)); }
public bool IsExist(string paymentId) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pPaymentId", DataPlug.DataType._Varchar, paymentId)); object result = Connection.ExecuteQueryScalar("Offlinetransaction_IsExist", param); return(Connection.ToInteger(result) > 0); }
public long GetCorporateIdOfUser(long userId) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pUserId", DataPlug.DataType._BigInt, userId)); object result = Connection.ExecuteQueryScalar("b2b_GetCorporateId", param); return(Connection.ToLong(result)); }
public long UnSubscribed(CLayer.Mail data) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pEmailId", DataPlug.DataType._Varchar, data.Mailaddress)); object result = Connection.ExecuteQueryScalar("subscriptions_Unsubscribed", param); return(Connection.ToLong(result)); }
public long DeleteProperty(long PropertyId) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pPropertyId", DataPlug.DataType._BigInt, PropertyId)); object result = Connection.ExecuteQueryScalar("offers_DeleteProperty", param); return(Connection.ToLong(result)); }
public void SetStatus(int taxId, CLayer.ObjectStatus.StatusType status) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pTaxId", DataPlug.DataType._Int, taxId)); param.Add(Connection.GetParameter("pStatus", DataPlug.DataType._Int, (int)status)); Connection.ExecuteQueryScalar("tax_SetStatus", param); return; }
public DateTime GetbookingsmedayforCorp(long b2bId) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pB2BId", DataPlug.DataType._BigInt, b2bId)); object result = Connection.ExecuteQueryScalar("b2bcorporate_GetbookingsmedayforCorp", param); return(Connection.ToDate(result)); }
public void DeletePropertyTax(long Id, long Tid) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pPropertyId", DataPlug.DataType._Int, Id)); param.Add(Connection.GetParameter("pTaxTitleId", DataPlug.DataType._Int, Tid)); Connection.ExecuteQueryScalar("propertytax_Delete", param); return; }
public string GetRoomId(long AccommodationId) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pAccommodationId", DataPlug.DataType._BigInt, AccommodationId)); object obj = Connection.ExecuteQueryScalar("property_GetRoomId", param); return(Connection.ToString(obj)); }
public void SaveApprovalOrder(CLayer.ApprovalOrder data) { List<DataPlug.Parameter> parameter = new List<DataPlug.Parameter>(); parameter.Add(Connection.GetParameter("Puser_id", DataPlug.DataType._BigInt, data.user_id)); parameter.Add(Connection.GetParameter("Papprover_id", DataPlug.DataType._BigInt, data.approver_id)); parameter.Add(Connection.GetParameter("Papprover_order", DataPlug.DataType._Int, data.approver_order)); parameter.Add(Connection.GetParameter("Pcreated_by", DataPlug.DataType._Int, data.created_by)); Connection.ExecuteQueryScalar("corporate_ApprovalOrder_Save", parameter); }
public int GetCorpCreditPaymentStatus(long bookingId) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pBookingId", DataPlug.DataType._BigInt, bookingId)); object obj = Connection.ExecuteQueryScalar("booking_GetCorpCreditPaymentStatus", param); return(Connection.ToInteger(obj)); }
public void Delete(long PropertyId, long UserId, long BookingId) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pPropertyId", DataPlug.DataType._BigInt, PropertyId)); param.Add(Connection.GetParameter("pUserId", DataPlug.DataType._BigInt, UserId)); param.Add(Connection.GetParameter("pBookingId", DataPlug.DataType._BigInt, BookingId)); Connection.ExecuteQueryScalar("review_Delete", param); }
public string GetTamarindCityID(string CityName) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pCity", DataPlug.DataType._Varchar, CityName)); object result = Connection.ExecuteQueryScalar("sp_tamarind_Getcityid", param); return(Connection.ToString(result)); }