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