public List <CLayer.City> GetCityByname(string name) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("PName", DataPlug.DataType._Varchar, name)); DataTable dt = Connection.GetTable("city_GetOnStateByName", param); List <CLayer.City> result = new List <CLayer.City>(); foreach (DataRow dr in dt.Rows) { result.Add(new CLayer.City() { CityId = Connection.ToInteger(dr["CityId"]), Name = Connection.ToString(dr["Name"]), StateId = Connection.ToInteger(dr["StateId"]), Keywords = Connection.ToString(dr["Keywords"]), }); } return(result); }
public List <CLayer.Accommodation> GetBypropertyid(long id) { List <CLayer.Accommodation> typelist = new List <CLayer.Accommodation>(); List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pid", DataPlug.DataType._Int, id)); DataTable dt = Connection.GetTable("accommodationtype_GetAllbypropertyid", param); foreach (DataRow dr in dt.Rows) { typelist.Add(new CLayer.Accommodation() { AccommodationTypeId = Connection.ToInteger(dr["AccommodationTypeId"]), AccommodationType = Connection.ToString(dr["AccommodationType"]), AccommodationId = Connection.ToInteger(dr["AccommodationId"]) }); } return(typelist); }
// // TODO Delete Country // public CLayer.Country Get(int CountryId) { CLayer.Country country = null; List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pCountryId", DataPlug.DataType._BigInt, CountryId)); DataTable dt = Connection.GetTable("country_Get", param); if (dt.Rows.Count > 0) { country = new CLayer.Country(); country.CountryId = Connection.ToLong(dt.Rows[0]["CountryId"]); country.Name = Connection.ToString(dt.Rows[0]["Name"]); country.IsDefault = Connection.ToBoolean(dt.Rows[0]["IsDefault"]); country.Status = Connection.ToInteger(dt.Rows[0]["Status"]); country.ForProperty = Connection.ToBoolean(dt.Rows[0]["ForProperty"]); country.Code = Connection.ToString(dt.Rows[0]["Code"]); } return(country); }
public List <CLayer.AccommodationFeature> GetAll() { List <CLayer.AccommodationFeature> AccomodationFeaturelist = new List <CLayer.AccommodationFeature>(); DataTable dt = Connection.GetTable("accommodationfeature_GetAll"); foreach (DataRow dr in dt.Rows) { AccomodationFeaturelist.Add(new CLayer.AccommodationFeature() { AccommodationFeatureId = Connection.ToLong(dr["AccommodationFeatureId"]), Title = Connection.ToString(dr["Title"]), Style = Connection.ToString(dr["Style"]), CanDelete = !Connection.ToBoolean(dr["CanDelete"]), Showfeatures = Connection.ToBoolean(dr["IsShow"]), }); } return(AccomodationFeaturelist); }
public List <CLayer.PropertyFeature> GetAllSearch() { DataTable dt = Connection.GetSQLTable("SELECT *,(select count(*) from property_propertyfeature ppf where" + " ppf.PropertyFeatureId=propertyfeature.PropertyFeatureId) As candelete" + " FROM propertyfeature where IsShow=1 order by Title "); List <CLayer.PropertyFeature> result = new List <CLayer.PropertyFeature>(); foreach (DataRow dr in dt.Rows) { result.Add(new CLayer.PropertyFeature() { PropertyFeatureId = Connection.ToLong(dr["PropertyFeatureId"]), Title = Connection.ToString(dr["Title"]), Style = Connection.ToString(dr["Style"]), Showfeatures = Connection.ToBoolean(dr["IsShow"]), CanDelete = (Connection.ToInteger(dr["candelete"]) < 1) }); } return(result); }
public string GetCountryWithKeyWords(string CountryName) { DataTable dt = Connection.GetSQLTable("SELECT g.CountryID,g.Country,ck.keywords FROM gdscountries g INNER JOIN countrykeywords ck" + " ON g.countryid = ck.countryid WHERE keywords LIKE '" + CountryName + "%' LIMIT 1"); //List<CLayer.GDSCountry> result = new List<CLayer.GDSCountry>(); string result = string.Empty; foreach (DataRow dr in dt.Rows) { CLayer.GDSCountry obj = new CLayer.GDSCountry(); obj.CountryID = Connection.ToInteger(dr["CountryID"]); obj.Country = Connection.ToString(dr["Country"]); //obj.IATACode = Connection.ToString(dr["IATACode"]); //obj.UPSCode = Connection.ToString(dr["UPSCode"]); //obj.CurrencyCode = Connection.ToString(dr["CurrencyCode"]); //obj.CurrencyName = Connection.ToString(dr["CurrencyName"]); result = obj.Country; } return(result); }
//OfferList Display Expired Date and Active Date with Tab value public List <CLayer.Offers> GetAllExpiredandActive(int Status, string SearchString, int Tab, int Start, int Limit) { //`Offer_GetExpiredAndActive`(IN pStatus INT ,IN pType INT, pStart INT, pLimit INT) List <CLayer.Offers> offer = new List <CLayer.Offers>(); List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pStatus", DataPlug.DataType._BigInt, Status)); param.Add(Connection.GetParameter("pSearchString", DataPlug.DataType._Varchar, SearchString)); param.Add(Connection.GetParameter("pType", DataPlug.DataType._BigInt, Tab)); param.Add(Connection.GetParameter("pStart", DataPlug.DataType._Int, Start)); param.Add(Connection.GetParameter("pLimit", DataPlug.DataType._Int, Limit)); DataSet ds = Connection.GetDataSet("Offer_GetExpiredAndActive", param); foreach (DataRow dr in ds.Tables[1].Rows) { offer.Add(new CLayer.Offers() { OfferId = Connection.ToLong(dr["OfferId"]), NoOfDays = Connection.ToInteger(dr["NoOfDays"]), StartDate = Connection.ToDate(dr["StartDate"]), EndDate = Connection.ToDate(dr["EndDate"]), Status = Connection.ToInteger(dr["Status"]), //AccommodationId = Connection.ToLong(dr["AccommodationId"]), Amount = Connection.ToDecimal(dr["Amount"]), OfferFor = Connection.ToInteger(dr["OfferFor"]), RateType = Connection.ToInteger(dr["RateType"]), SBCommission = Connection.ToDecimal(dr["SBCommission"]), OfferTitle = Connection.ToString(dr["OfferTitle"]), FreeDays = Connection.ToInteger(dr["FreeDays"]), // PropertyId = Connection.ToLong(dr["PropertyId"]), OfferType = Connection.ToInteger(dr["OfferType"]), StayCategoryId = Connection.ToInteger(dr["StayCategoryId"]), //Display //Title = Connection.ToString(dr["Title"]), //Location = Connection.ToString(dr["Location"]), // Address = Connection.ToString(dr["Address"]), TotalRows = Connection.ToLong(ds.Tables[0].Rows[0]["NumberOfRows"]) }); } return(offer); }
public List <CLayer.SupplierInvoice> getSupplierInvoiceList(string searchText, int searchType, int Start, int Limit, int TaxType, int Status) { List <CLayer.SupplierInvoice> result = new List <CLayer.SupplierInvoice>(); List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pSearchText", DataPlug.DataType._Text, searchText)); param.Add(Connection.GetParameter("pSearchType", DataPlug.DataType._Int, searchType)); param.Add(Connection.GetParameter("pStart", DataPlug.DataType._Int, Start)); param.Add(Connection.GetParameter("pLimit", DataPlug.DataType._Int, Limit)); param.Add(Connection.GetParameter("pTaxType", DataPlug.DataType._Int, TaxType)); param.Add(Connection.GetParameter("pStatus", DataPlug.DataType._Int, Status)); DataSet ds = Connection.GetDataSet("getGetSupplierInvoiceList_Pager", param); CLayer.SupplierInvoice res = null; if (ds.Tables[1].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[1].Rows) { res = new CLayer.SupplierInvoice(); res.SupplierInvoiceID = Connection.ToLong(dr["SupplierInvoiceID"]); res.PropertyId = Connection.ToLong(dr["PropertyID"]); res.Property_Name = Connection.ToString(dr["Title"]); res.SupplierId = Connection.ToLong(dr["SupplierID"]); res.SupplierName = Connection.ToString(dr["SupplierName"]); res.City = Connection.ToString(dr["City"]); res.InvoiceNumber = Connection.ToString(dr["InvoiceNumber"]); res.InvoiceDate = Connection.ToDate(dr["InvoiceDate"]); res.ServiceTaxRegNumber = Connection.ToString(dr["ServiceTaxRegNumber"]); res.PAN_Number = Connection.ToString(dr["PAN"]); res.BaseAmount = Connection.ToDecimal(dr["BaseAmount"]); res.LuxuryTax = Connection.ToDecimal(dr["LuxuryTax"]); res.ServiceTax = Connection.ToDecimal(dr["ServiceTax"]); res.TotalInvoiceValue = Connection.ToDecimal(dr["TotalInvoiceValue"]); res.EntryDate = Connection.ToDate(dr["EntryDate"]); res.TaxType = Connection.ToInteger(dr["TaxType"]); res.TotalRows = Connection.ToLong(ds.Tables[0].Rows[0]["NumberOfRows"]); result.Add(res); } } return(result); }
public CLayer.B2B GetbookingcreditforCorporateUser(long b2bId) { CLayer.B2B b2b = null; List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pB2BId", DataPlug.DataType._BigInt, b2bId)); DataTable dt = Connection.GetTable("b2bcorporateuser_Getbookingcredits", param); if (dt.Rows.Count > 0) { b2b = new CLayer.B2B(); b2b.B2BId = Connection.ToLong(dt.Rows[0]["B2BId"]); b2b.Name = Connection.ToString(dt.Rows[0]["Name"]); b2b.UserCode = Connection.ToString(dt.Rows[0]["UserCode"]); b2b.MarkupPercent = Connection.ToDecimal(dt.Rows[0]["MarkupPercent"]); b2b.CommissionPercent = Connection.ToDecimal(dt.Rows[0]["CommissionPercent"]); b2b.ServiceTaxRegNo = Connection.ToString(dt.Rows[0]["ServiceTaxRegNo"]); b2b.VATRegNo = Connection.ToString(dt.Rows[0]["VATRegNo"]); b2b.MaximumStaff = Connection.ToInteger(dt.Rows[0]["MaximumStaff"]); b2b.RequestStatus = Connection.ToInteger(dt.Rows[0]["RequestStatus"]); b2b.Email = Connection.ToString(dt.Rows[0]["Email"]); b2b.UserId = Connection.ToLong(dt.Rows[0]["UserId"]); b2b.CompanyRegNo = Connection.ToString(dt.Rows[0]["CompanyRegNo"]); b2b.UserType = Connection.ToInteger(dt.Rows[0]["UserType"]); b2b.PropertyDescription = Connection.ToString(dt.Rows[0]["PropertyDescription"]); b2b.AvailableProperties = Connection.ToInteger(dt.Rows[0]["AvailableProperties"]); b2b.PANNo = Connection.ToString(dt.Rows[0]["PANNo"]); b2b.ContactDesignation = Connection.ToString(dt.Rows[0]["ContactDesignation"]); b2b.IsCreditBooking = Connection.ToInteger(dt.Rows[0]["IsCreditBooking"]); b2b.CreditDays = Connection.ToInteger(dt.Rows[0]["CreditDays"]); b2b.CreditAmount = Connection.ToDecimal(dt.Rows[0]["CreditAmount"]); b2b.TotalCreditAmount = Connection.ToDecimal(dt.Rows[0]["TotalCreditAmount"]); b2b.ApproverID = Connection.ToInteger(dt.Rows[0]["ApproverID"]); b2b.ApproverEmail = Connection.ToString(dt.Rows[0]["ApproverEmail"]); b2b.ApproverName = Connection.ToString(dt.Rows[0]["ApproverName"]); b2b.BookingMobile = Connection.ToString(dt.Rows[0]["BookingMobile"]); b2b.BookingPhone = Connection.ToString(dt.Rows[0]["BookingPhone"]); } return(b2b); }
public List <CLayer.B2B> GetSearchAllSupplier(string name, int start, int limit, int userType, out int totalRows) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); //param.Add(Connection.GetParameter("pEmail", DataPlug.DataType._Varchar, email)); param.Add(Connection.GetParameter("pStart", DataPlug.DataType._Int, start)); param.Add(Connection.GetParameter("pLimit", DataPlug.DataType._Int, limit)); param.Add(Connection.GetParameter("pCriteria", DataPlug.DataType._Varchar, name)); param.Add(Connection.GetParameter("pUserType", DataPlug.DataType._BigInt, userType)); DataTable dt = Connection.GetTable("affiliate_SearchSupplier", param); List <CLayer.B2B> result = new List <CLayer.B2B>(); if (dt.Rows.Count > 0) { totalRows = Connection.ToInteger(dt.Rows[0]["TotalRows"]); } else { totalRows = 0; } foreach (DataRow dr in dt.Rows) { result.Add(new CLayer.B2B() { B2BId = Connection.ToLong(dr["B2BId"]), Name = Connection.ToString(dr["Name"]), //MarkupPercent = Connection.ToDecimal(dr["MarkupPercent"]), //CommissionPercent = Connection.ToDecimal(dr["CommissionPercent"]), UserCode = Connection.ToString(dr["UserCode"]), //ServiceTaxRegNo = Connection.ToString(dr["ServiceTaxRegNo"]), // VATRegNo = Connection.ToString(dr["VATRegNo"]), UserId = Connection.ToLong(dr["UserId"]), Email = Connection.ToString(dr["Email"]), // UserType = Connection.ToInteger(dr["UserType"]), //RequestStatus = Connection.ToInteger(dr["RequestStatus"]), // PropertyDescription = Connection.ToString(dr["PropertyDescription"]), //AvailableProperties = Connection.ToInteger(dr["AvailableProperties"]) }); } return(result); }
public List <CLayer.Property> Searchpropertylist(string name) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pName", DataPlug.DataType._Varchar, name)); DataTable dt = Connection.GetTable("b2b_Searchpropertylist", param); List <CLayer.Property> result = new List <CLayer.Property>(); CLayer.Property temp; foreach (DataRow dr in dt.Rows) { temp = new CLayer.Property(); temp.Title = Connection.ToString(dr["Title"]); temp.PropertyId = Connection.ToLong(dr["PropertyId"]); temp.BusinessName = Connection.ToString(dr["name"]); temp.Email = Connection.ToString(dr["Email"]); temp.Address = Connection.ToString(dr["address"]); temp.SupplierName = Connection.ToString(dr["FirstName"]); temp.Mobile = Connection.ToString(dr["Mobile"]); temp.Country = Connection.ToInteger(dr["Country"]); temp.State = Connection.ToInteger(dr["State"]); temp.CityId = Connection.ToInteger(dr["CityId"]); temp.OwnerId = Connection.ToInteger(dr["OwnerId"]); temp.City = Connection.ToString(dr["City"]); temp.ZipCode = Connection.ToString(dr["PropertyZipcode"]); temp.SupplierAddress = Connection.ToString(dr["supaddress"]); temp.SupplierCountry = Connection.ToInteger(dr["supcountry"]); temp.SupplierState = Connection.ToInteger(dr["supstate"]); temp.SupplierCity = Connection.ToString(dr["supcityname"]); temp.SupplierCityId = Connection.ToInteger(dr["supcityid"]); temp.SupplierZipCode = Connection.ToString(dr["SupplierZipeCode"]); temp.SuppierMobile = Connection.ToString(dr["supmobile"]); temp.GSTRegistrationNo = Connection.ToString(dr["GSTRegistrationNo"]); temp.PanNo = Connection.ToString(dr["PANNo"]); //temp.EntityName = Connection.ToString(dr["entityname"]); result.Add(temp); } return(result); }
public List <CLayer.SupplierPayment> GetAllSupllierPaymentSearch(int status, string searchString, int searchItem, int userType, int start, int limit) { List <CLayer.SupplierPayment> users = new List <CLayer.SupplierPayment>(); List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pStatus", DataPlug.DataType._Int, status)); param.Add(Connection.GetParameter("pSearchString", DataPlug.DataType._Varchar, searchString)); param.Add(Connection.GetParameter("pSearchItem", DataPlug.DataType._Int, searchItem)); // param.Add(Connection.GetParameter("pUserType", DataPlug.DataType._Int, userType)); param.Add(Connection.GetParameter("pStart", DataPlug.DataType._Int, start)); param.Add(Connection.GetParameter("pLimit", DataPlug.DataType._Int, limit)); DataSet ds = Connection.GetDataSet("OfflineBookingSupplierpayment_GetSearch", param); foreach (DataRow dr in ds.Tables[1].Rows) { users.Add(new CLayer.SupplierPayment() { // Salutation = Connection.ToString(dr["Salutation"]), propertyname = Connection.ToString(dr["PropertyName"]), // FirstName = Connection.ToString(dr["FirstName"]), // LastName = Connection.ToString(dr["LastName"]), SupplierEmail = Connection.ToString(dr["SupplierEmail"]), SupplierName = Connection.ToString(dr["SupplierName"]), Buyprice = Connection.ToDouble(dr["TotalBuyPrice"]), supplierPayment = Connection.ToBoolean(dr["supplierPayment"]), AmountPaid = Connection.ToDouble(dr["amount"]), SupplierMobile = Connection.ToString(dr["SupplierMobile"]), OrderId = Connection.ToString(dr["Orderno"]), CheckIn_date = Connection.ToDate(dr["CheckIn_date"]), // DeletedDate = Connection.ToDate(dr["DeletedDate"]), CheckOut_date = Connection.ToDate(dr["CheckOut_date"]), BookingDate = Connection.ToDate(dr["BookingDate"]), // Status = Connection.ToInteger(dr["Status"]), // PANNo = Connection.ToString(dr["PANNo"]), // UserCode = Connection.ToString(dr["UserCode"]), TotalRows = Connection.ToLong(ds.Tables[0].Rows[0]["NumberOfRows"]) }); } return(users); }
public List <CLayer.SupplierPaymetList> getPaymentList(string pSearchString, int start, int limit, int pSearchType = 0) { List <CLayer.SupplierPaymetList> result = new List <CLayer.SupplierPaymetList>(); CLayer.SupplierPaymetList res = null; List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pSearchString", DataPlug.DataType._Text, pSearchString)); param.Add(Connection.GetParameter("pSearchType", DataPlug.DataType._Int, pSearchType)); param.Add(Connection.GetParameter("pstart", DataPlug.DataType._Int, start)); param.Add(Connection.GetParameter("pLimit", DataPlug.DataType._Int, limit)); DataSet ds = Connection.GetDataSet("SupplierPaymentList_Get", param); foreach (DataRow dr in ds.Tables[1].Rows) { res = new CLayer.SupplierPaymetList() { SupplierPaymentId = Connection.ToLong(dr["SupplierPaymentId"]), SupplierId = Connection.ToLong(dr["SupplierId"]), OfflineSupplierEmail = Connection.ToString(dr["OfflineSupplierEmail"]), SupplierPayment = Connection.ToDecimal(dr["SupplierPayment"]), dtPayment = Connection.ToDate(dr["dtPayment"]), grossAmount = Connection.ToDecimal(dr["grossAmount"]), tdsAmount = Connection.ToDecimal(dr["tdsAmount"]), AmountPaid = Connection.ToDouble(dr["Amount"]), netAmtPaid = Connection.ToDecimal(dr["netAmtPaid"]), modeofPayment = Connection.ToString(dr["modeofPayment"]), CheckIn_date = Connection.ToDate(dr["CheckIn_date"]), CheckOut_date = Connection.ToDate(dr["CheckOut_date"]), bank = Connection.ToString(dr["bank"]), SupplierName = Connection.ToString(dr["Supplier_Name"]), Prop_Name = Connection.ToString(dr["Prop_Name"]), Prop_ID = Connection.ToLong(dr["Prop_ID"]), OrderNo = Connection.ToString(dr["OrderNo"]), TotalRows = Connection.ToLong(ds.Tables[0].Rows[0]["NumberOfRows"]) }; result.Add(res); } return(result); }
public List <CLayer.PropertyRoomType> GetAllPropertyType(int roomTypeId) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pRoomTypeId", DataPlug.DataType._Int, roomTypeId)); DataTable dt = Connection.GetTable("roomtype_GetPropertyTypes", param); List <CLayer.PropertyRoomType> result = new List <CLayer.PropertyRoomType>(); CLayer.PropertyRoomType tmp; foreach (DataRow dr in dt.Rows) { tmp = new CLayer.PropertyRoomType(); tmp.IsUsed = Connection.ToInteger(dr["isused"]) > 0; tmp.Selected = Connection.ToInteger(dr["isselected"]) > 0; tmp.Title = Connection.ToString(dr["Title"]); tmp.PropertyTypeId = Connection.ToInteger(dr["PropertyTypeId"]); //tmp.RoomTypeId = Connection.ToInteger(dr["PropertyTypeId"]); result.Add(tmp); } return(result); }
public List <CLayer.Accommodation> GetAllAccByPropertyid(long propertyId) { List <CLayer.Accommodation> result = new List <CLayer.Accommodation>(); List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pPropertyId", DataPlug.DataType._BigInt, propertyId)); DataTable dt = Connection.GetTable("accommodation_GetAllByPropertyId", param); foreach (DataRow dr in dt.Rows) { result.Add(new CLayer.Accommodation() { AccommodationId = Connection.ToLong(dr["AccommodationId"]), RoomType = Connection.ToString(dr["RoomType"]), RoomTypeCode = Connection.ToString(dr["RoomTypeCode"]), BookingCode = Connection.ToString(dr["BookingCode"]) // Availability=Connection.ToBoolean(dr["availability"]) }); } return(result); }
public List <CLayer.State> GetCustGstStateList(int Customerid, int Type) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pCustomerid", DataPlug.DataType._Int, Customerid)); param.Add(Connection.GetParameter("pType", DataPlug.DataType._Int, Type)); //param.Add(Connection.GetParameter("pOfflineBookingId", DataPlug.DataType._BigInt, OfflineBookingId)); DataTable dt = Connection.GetTable("GetCustGstStateList", param); List <CLayer.State> result = new List <CLayer.State>(); foreach (DataRow dr in dt.Rows) { result.Add(new CLayer.State() { StateId = Connection.ToInteger(dr["StateId"]), Name = Connection.ToString(dr["Name"]) }); } return(result); }
// // TODO Delete Currency // public CLayer.Currency Get(string code) { CLayer.Currency currency = null; DataTable dt = Connection.GetSQLTable("Select * From currency Where Title like '" + code + "'"); if (dt.Rows.Count > 0) { currency = new CLayer.Currency(); currency.CurrencyId = Connection.ToLong(dt.Rows[0]["CurrencyId"]); currency.Title = Connection.ToString(dt.Rows[0]["Title"]); currency.Symbol = Connection.ToString(dt.Rows[0]["Symbol"]); currency.ConversionRate = Connection.ToDecimal(dt.Rows[0]["ConversionRate"]); currency.ConversionPercentage = Connection.ToDecimal(dt.Rows[0]["ConversionPercentage"]); currency.LastUpdate = Connection.ToDate(dt.Rows[0]["LastUpdate"]); currency.IsDefault = Connection.ToBoolean(dt.Rows[0]["IsDefault"]); currency.Status = Connection.ToInteger(dt.Rows[0]["Status"]); currency.Exchangecode = Connection.ToString(dt.Rows[0]["ExchgCode"]); } return(currency); }
public List <object> GetAutoListforaccommn(string term) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); if (term.Length > 50) { term = term.Substring(0, 50); } param.Add(Connection.GetParameter("pTerm", DataPlug.DataType._Varchar, term)); DataTable dt = Connection.GetTable("Accommodation_autocompelete", param); List <object> result = new List <object>(); string a, b; int i; foreach (DataRow dr in dt.Rows) { a = Connection.ToString(dr["a"]); result.Add(new { value = a }); } return(result); }
public CLayer.Landmarks Get(long landmarkId) { CLayer.Landmarks landmark = null; List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pLandmarkId", DataPlug.DataType._BigInt, landmarkId)); DataTable dt = Connection.GetTable("landmarks_Get", param); if (dt.Rows.Count > 0) { landmark = new CLayer.Landmarks() { LandmarkId = Connection.ToLong(dt.Rows[0]["LandmarkId"]), PropertyId = Connection.ToLong(dt.Rows[0]["PropertyId"]), LandmarkTitleId = Connection.ToInteger(dt.Rows[0]["LandmarkTitleId"]), Landmark = Connection.ToString(dt.Rows[0]["Landmark"]), Range = Connection.ToDecimal(dt.Rows[0]["Range"]) }; } return(landmark); }
public List <CLayer.Tax> GetAllTypeTaxRate(long BookingId) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); List <CLayer.Tax> result = new List <CLayer.Tax>(); param.Add(Connection.GetParameter("pBookingId", DataPlug.DataType._BigInt, BookingId)); DataTable dt = Connection.GetTable("ratesbooking_GetAllTypeTaxRate", param); CLayer.Tax rt1; foreach (DataRow dr in dt.Rows) { rt1 = new CLayer.Tax(); rt1.TaxTitleId = Connection.ToInteger(dr["TaxTitleId"]); rt1.Title = Connection.ToString(dr["TaxTitleName"]); rt1.BookingId = BookingId; rt1.Rate = Connection.ToDecimal(dr["Rate"]); rt1.TotalTaxAmount = Connection.ToDecimal(dr["Amount"]); result.Add(rt1); } return(result); }
public List <CLayer.Rates> GetAll(long accommodationId) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pAccommodationId", DataPlug.DataType._BigInt, accommodationId)); DataTable dt = Connection.GetTable("rates_GetAll", param); List <CLayer.Rates> result = new List <CLayer.Rates>(); CLayer.Rates temp; foreach (DataRow dr in dt.Rows) { temp = new CLayer.Rates(); temp.StartDate = Connection.ToDate(dr["StartDate"]); temp.EndDate = Connection.ToDate(dr["EndDate"]); temp.AccommodationId = Connection.ToLong(dr["AccommodationId"]); temp.UpdatedByUser = Connection.ToString(dr["Name"]); temp.UpdatedDate = Connection.ToDate(dr["UpdatedDate"]); result.Add(temp); } return(result); }
public List <CLayer.AccommodationFeature> GetAllWithSelectedForAccommodation(long accommodationId) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pAccommodationId", DataPlug.DataType._BigInt, accommodationId)); DataTable dt = Connection.GetTable("accommodationfeature_GetAllForAccommodation", param); List <CLayer.AccommodationFeature> result = new List <CLayer.AccommodationFeature>(); foreach (DataRow dr in dt.Rows) { result.Add(new CLayer.AccommodationFeature() { AccommodationFeatureId = Connection.ToLong(dr["AccommodationFeatureId"]), Title = Connection.ToString(dr["Title"]), Style = Connection.ToString(dr["Style"]), IsUsed = Connection.ToBoolean(dr["Used"]) }); } return(result); }
public List <CLayer.Discount> GetAll(long propertyId) { string sql = "Select b.B2BId,b.Name,d.ShortTerm,d.LongTerm From discount d INNER JOIN b2b b ON d.B2Bid = b.B2BId Where d.PropertyId=" + propertyId.ToString(); DataTable dt = Connection.GetSQLTable(sql); List <CLayer.Discount> result = new List <CLayer.Discount>(); CLayer.Discount temp; foreach (DataRow dr in dt.Rows) { temp = new CLayer.Discount(); temp.B2BId = Connection.ToLong(dr["B2BId"]); temp.B2BName = Connection.ToString(dr["Name"]); temp.ShortTermRate = Connection.ToDouble(dr["ShortTerm"]); temp.LongTermRate = Connection.ToDouble(dr["LongTerm"]); temp.PropertyId = propertyId; result.Add(temp); } return(result); }
public List <CLayer.Landmarks> GetOnProperty(long propertyId) { List <CLayer.Landmarks> landmarks = new List <CLayer.Landmarks>(); List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pPropertyId", DataPlug.DataType._BigInt, propertyId)); DataTable dt = Connection.GetTable("landmarks_GetOnProperty", param); foreach (DataRow dr in dt.Rows) { landmarks.Add(new CLayer.Landmarks() { LandmarkId = Connection.ToLong(dr["LandmarkId"]), PropertyId = Connection.ToLong(dr["PropertyId"]), LandmarkTitleId = Connection.ToInteger(dr["LandmarkTitleId"]), Landmark = Connection.ToString(dr["Landmark"]), Range = Connection.ToDecimal(dr["Range"]) }); } return(landmarks); }
public List <CLayer.PropertyFeature> GetFeaturesForProperty(long propertyId) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pPropertyId", DataPlug.DataType._BigInt, propertyId)); DataTable dt = Connection.GetTable("propertyfeature_GetPropertyFeatures", param); List <CLayer.PropertyFeature> result = new List <CLayer.PropertyFeature>(); foreach (DataRow dr in dt.Rows) { result.Add(new CLayer.PropertyFeature() { PropertyFeatureId = Connection.ToLong(dr["PropertyFeatureId"]), Title = Connection.ToString(dr["Title"]), Style = Connection.ToString(dr["Style"]) //IsUsed = Connection.ToBoolean(dr["Used"]) }); } return(result); }
public CLayer.City Get(int?cityId) { CLayer.City city = null; List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pCityId", DataPlug.DataType._Int, cityId)); DataTable dt = Connection.GetTable("city_Get", param); if (dt.Rows.Count > 0) { city = new CLayer.City() { CityId = Connection.ToInteger(dt.Rows[0]["CityId"]), Name = Connection.ToString(dt.Rows[0]["Name"]), StateId = Connection.ToInteger(dt.Rows[0]["StateId"]), ForListing = Connection.ToBoolean(dt.Rows[0]["ForListing"]), Keywords = Connection.ToString(dt.Rows[0]["Keywords"]) }; } return(city); }
public List <CLayer.Testimonial> GetForWidget() { List <CLayer.Testimonial> testimonial = new List <CLayer.Testimonial>(); DataTable dt = Connection.GetTable("testimonial_GetForWidget", null); foreach (DataRow dr in dt.Rows) { testimonial.Add(new CLayer.Testimonial() { TestimonialId = Connection.ToLong(dr["TestimonialId"]), Description = Connection.ToString(dr["Description"]), Picture = Connection.ToString(dr["Picture"]), Status = Connection.ToInteger(dr["Status"]), Title = Connection.ToString(dr["Title"]), Name = Connection.ToString(dr["Name"]), Company = Connection.ToString(dr["Company"]) }); } return(testimonial); }
public CLayer.SBEntity Get(long id) { CLayer.SBEntity result = null; DataTable dt = Connection.GetSQLTable("Select * from SBEntity Where EntityId=" + id.ToString()); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; result = new CLayer.SBEntity(); result.EntityId = Connection.ToLong(dr["EntityId"]); result.Name = Connection.ToString(dr["Name"]); result.Address = Connection.ToString(dr["Address"]); result.CountryId = Connection.ToInteger(dr["CountryId"]); result.GSTNo = Connection.ToString(dr["GSTNo"]); result.StateId = Connection.ToInteger(dr["StateId"]); result.GSTStateId = Connection.ToInteger(dr["GSTStateId"]); result.Phone = Connection.ToString(dr["Phone"]); } return(result); }
public List <CLayer.CityClass> GetAll() { List <CLayer.CityClass> CityClasslist = new List <CLayer.CityClass>(); DataTable dt = Connection.GetSQLTable("SELECT * FROM cityclass"); foreach (DataRow dr in dt.Rows) { CityClasslist.Add(new CLayer.CityClass() { CityClassID = Connection.ToLong(dr["CityClassID"]), CityClassCode = Connection.ToString(dr["CityName"]), CityClassDescription = Connection.ToString(dr["CityDescription"]), //CountryID= Connection.ToLong(dr["CountryID"]), //StateID = Connection.ToLong(dr["StateID"]), //CityID= Connection.ToLong(dr["CityID"]), B2B_ID = Connection.ToLong(dr["B2b_ID"]) }); } return(CityClasslist); }
public List <CLayer.RoomFeature> GetAll() { List <CLayer.RoomFeature> roomfeaturelist = new List <CLayer.RoomFeature>(); DataTable dt = Connection.GetSQLTable("SELECT rf.*,1 AS CanDelete, " + " rt.Title as RoomType FROM roomfeature rf inner join RoomType rt on rf.RoomTypeId=rt.RoomTypeId ORDER BY Title ASC"); foreach (DataRow dr in dt.Rows) { roomfeaturelist.Add(new CLayer.RoomFeature() { RoomFeatureId = Connection.ToLong(dr["RoomFeatureId"]), Title = Connection.ToString(dr["Title"]), RoomTypeId = Connection.ToInteger(dr["RoomTypeId"]), RoomType = Connection.ToString(dr["RoomType"]), CanDelete = Connection.ToBoolean(dr["CanDelete"]) }); } return(roomfeaturelist); }