public void AddAmadeusTaxRates(CLayer.Tax data)
{
try
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pTaxId", DataPlug.DataType._BigInt, data.TaxId));
param.Add(Connection.GetParameter("pPropertyId", DataPlug.DataType._BigInt, data.PropertyId));
param.Add(Connection.GetParameter("pAccommodationId", DataPlug.DataType._BigInt, data.AccommodationId));
param.Add(Connection.GetParameter("pBookingID", DataPlug.DataType._BigInt, data.BookingId));
param.Add(Connection.GetParameter("pTaxRate", DataPlug.DataType._Double, data.TaxRate));
param.Add(Connection.GetParameter("pTaxAmount", DataPlug.DataType._BigInt, data.PropertyId));
param.Add(Connection.GetParameter("pTotalCGSTTaxAmount", DataPlug.DataType._Decimal, data.TotalCGSTTaxAmount));
param.Add(Connection.GetParameter("pTotalSGSTTaxAmount", DataPlug.DataType._Decimal, data.TotalSGSTTaxAmount));
param.Add(Connection.GetParameter("pTotalIGSTTaxAmount", DataPlug.DataType._Decimal, data.TotalIGSTTaxAmount));
param.Add(Connection.GetParameter("pCGSTTitle", DataPlug.DataType._Varchar, data.CGSTTitle));
param.Add(Connection.GetParameter("pSGSTTitle", DataPlug.DataType._Varchar, data.SGSTTitle));
param.Add(Connection.GetParameter("pIGSTTitle", DataPlug.DataType._Varchar, data.IGSTTitle));
param.Add(Connection.GetParameter("pBookingCode", DataPlug.DataType._Varchar, data.BookingCode));
param.Add(Connection.GetParameter("pCGSTTaxRate", DataPlug.DataType._Double, data.CGSTTaxRate));
param.Add(Connection.GetParameter("pSGSTTaxRate", DataPlug.DataType._Double, data.SGSTTaxRate));
param.Add(Connection.GetParameter("pIGSTTaxRate", DataPlug.DataType._Double, data.IGSTTaxRate));
param.Add(Connection.GetParameter("pBookingType", DataPlug.DataType._Double, data.BookingType));
Connection.ExecuteQuery("amadeustaxrates_save", param);
}
catch (Exception ex)
{
throw ex;
}
}
public void SetDeleteStatus(long supplierPaymentId)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pSupplierPaymentID", DataPlug.DataType._BigInt, supplierPaymentId));
Connection.ExecuteQuery("supplierpayment_delete", param);
}
public void Delete(long fileId)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pFileId", DataPlug.DataType._BigInt, fileId));
Connection.ExecuteQuery("userfiles_Delete", param);
}
public void DeleteOnUser(long userId)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pUserId", DataPlug.DataType._BigInt, userId));
Connection.ExecuteQuery("userfiles_DeleteOnProperty", param);
}
public void SetUpdateDate(long pageId)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pPageId", DataPlug.DataType._BigInt, pageId));
Connection.ExecuteQuery("staticpage_SetUpdateDate", param);
}
public void Delete(long AddressId)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pAddressId", DataPlug.DataType._BigInt, AddressId));
Connection.ExecuteQuery("address_Delete", param);
}
public void DeleteOnProperty(long propertyid)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pPropertyId", DataPlug.DataType._BigInt, propertyid));
Connection.ExecuteQuery("propertyfiles_DeleteOnProperty", param);
}
public void RateRefresh(long propertyId)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pPropertyId", DataPlug.DataType._BigInt, propertyId));
Connection.ExecuteQuery("rate_Refresh", param);
}
public void Delete(long b2bId)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pB2BId", DataPlug.DataType._BigInt, b2bId));
Connection.ExecuteQuery("b2b_Delete", param);
}
public void DeleteOnUser(long UserId)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pUserId", DataPlug.DataType._BigInt, UserId));
Connection.ExecuteQuery("Address_DeleteOnUser", param);
}
public void DeleteOnAccommodation(long accommodationId)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pAccommodationId", DataPlug.DataType._BigInt, accommodationId));
Connection.ExecuteQuery("accommodationfiles_DeleteOnAccommodation", param);
}
public void Delete(int TestimonialId)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pTestimonialId", DataPlug.DataType._BigInt, TestimonialId));
Connection.ExecuteQuery("testimonial_Delete", param);
return;
}
public void SaveAffiliate(CLayer.B2B data)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pB2BId", DataPlug.DataType._BigInt, data.B2BId));
param.Add(Connection.GetParameter("pCompanyRegNo", DataPlug.DataType._Varchar, data.CompanyRegNo));
Connection.ExecuteQuery("b2b_SaveAffiliate", param);
}
public void SetApprovalDate(long b2bId, DateTime approvalDate)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pUserId", DataPlug.DataType._BigInt, b2bId));
param.Add(Connection.GetParameter("pApprovalDate", DataPlug.DataType._DateTime, approvalDate));
Connection.ExecuteQuery("b2b_SetApprovalDate", param);
}
public void Delete(int AccomodationFeatureID)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pId", DataPlug.DataType._Int, AccomodationFeatureID));
Connection.ExecuteQuery("accommodationfeature_Delete", param);
return;
}
public void Delete(int accTypeId)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pTypeId", DataPlug.DataType._BigInt, accTypeId));
Connection.ExecuteQuery("accommodationtype_Delete", param);
return;
}
public void Delete(long roomid)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pRoomId", DataPlug.DataType._BigInt, roomid));
Connection.ExecuteQuery("room_Delete", param);
return;
}
public void Delete(int SalutationId)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pSalutationId", DataPlug.DataType._Int, SalutationId));
Connection.ExecuteQuery("salutation_Delete", param);
return;
}
public void Delete(long landmarkId)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pLandmarkId", DataPlug.DataType._BigInt, landmarkId));
Connection.ExecuteQuery("landmarks_Delete", param);
return;
}
public void Delete(int CategoryID)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pCategoryId", DataPlug.DataType._BigInt, CategoryID));
Connection.ExecuteQuery("staycategory_Delete", param);
return;
}
public void SetStatus(int status, long OfflinePayId)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pOfflinePayId", DataPlug.DataType._BigInt, OfflinePayId));
param.Add(Connection.GetParameter("pStatus", DataPlug.DataType._Int, status));
Connection.ExecuteQuery("OfflinePayment_SetStatus", param);
}
public void SetCreditBookingstatus(int status, long bookingId)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pBookingId", DataPlug.DataType._BigInt, bookingId));
param.Add(Connection.GetParameter("pStatus", DataPlug.DataType._Int, status));
Connection.ExecuteQuery("booking_SetCreditBookingstatus", param);
}
public void Delete(int PropertyTypeId)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pPropertyTypeId", DataPlug.DataType._BigInt, PropertyTypeId));
Connection.ExecuteQuery("propertytype_Delete", param);
return;
}
public void SetCategoryType(int typeID, string categoriesCSV)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pTypeId", DataPlug.DataType._Int, typeID));
param.Add(Connection.GetParameter("pCategories", DataPlug.DataType._Varchar, categoriesCSV));
Connection.ExecuteQuery("accommodationtype_SetStayType", param);
}
public void Delete(int EmployeeGradesId)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pGradeId", DataPlug.DataType._BigInt, EmployeeGradesId));
Connection.ExecuteQuery("EmployeeGrades_Delete", param);
return;
}
public void Delete(long AccommodationId)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pAccId", DataPlug.DataType._BigInt, AccommodationId));
Connection.ExecuteQuery("Accommodation_Delete", param);
return;
}
public void SetCreditBookingPaid(bool Paid, long bookingId)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pBookingId", DataPlug.DataType._BigInt, bookingId));
param.Add(Connection.GetParameter("pPaid", DataPlug.DataType._Bool, Paid));
Connection.ExecuteQuery("booking_SetCreditBookingPaid", param);
}
public void SetPropertyType(int roomTypeId, string propertyTypesCSV)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pRoomTypeId", DataPlug.DataType._Int, roomTypeId));
param.Add(Connection.GetParameter("pPropertyTypes", DataPlug.DataType._Varchar, propertyTypesCSV));
Connection.ExecuteQuery("roomtype_SetPropertyType", param);
}
public void Delete(int CityClassId)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pCityClassId", DataPlug.DataType._BigInt, CityClassId));
Connection.ExecuteQuery("CityClass_Delete", param);
return;
}
public void Delete(int RoomTypeID)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pRoomTypeId", DataPlug.DataType._BigInt, RoomTypeID));
Connection.ExecuteQuery("roomtype_Delete", param);
return;
}
