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