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