private static void InitCity()
{
if (StaticCalls.citylist.Count == 0)
{
DataTable query = StaticCalls.GetQuery("SELECT City_ID, City_Name, Country_ID, City_Native_Name, Latitude, Longitude FROM Cities", StaticCalls.ConnectionString, null);
List <City> list = new List <City>();
try
{
foreach (DataRow row in query.Rows)
{
list.Add(new City
{
Country_ID = (int)row[2],
City_ID = (int)row[0],
City_Name = (string)row[1],
City_Native_Name = (string)row[3],
Latitude = (string)row[4],
Longitude = (string)row[5]
});
}
}
catch
{
}
StaticCalls.citylist = list;
}
}
public static string InsertCity(City c)
{
StaticCalls.SetQuery("Insert Into Cities (City_Name,City_Native_Name,City_Latin_Name,Country_ID,Latitude,Longitude) values ('" + c.City_Name + "','" + c.City_Native_Name + "','" + c.City_Latin_Name + "'," + c.Country_ID + ",'" + c.Latitude + "','" + c.Longitude + "');");
DataTable query = StaticCalls.GetQuery("select IDENT_CURRENT('Cities') as 'id'", StaticCalls.ConnectionString, null);
if (query == null)
{
return("1");
}
return(query.Rows[0][0].ToString());
}
private static void InitPropertyIDList()
{
if (StaticCalls.propertyidlist.Count == 0)
{
DataTable query = StaticCalls.GetQuery("SELECT Properties.Property_Id_ext from Properties;", StaticCalls.ConnectionString, null);
List <string> list = new List <string>();
try
{
foreach (DataRow row in query.Rows)
{
list.Add(string.Concat(row["Property_Id_ext"]));
}
}
catch
{
}
StaticCalls.propertyidlist = list;
}
}
private static List <string> Get_Property_List()
{
if (StaticCalls.propertyidlist.Count == 0)
{
DataTable query = StaticCalls.GetQuery("SELECT Properties.Property_Photo from Properties;", StaticCalls.ConnectionString, null);
List <string> list = new List <string>();
try
{
foreach (DataRow row in query.Rows)
{
list.Add(string.Concat(row["Property_Photo"]));
}
return(list);
}
catch
{
return(new List <string>());
}
}
return(new List <string>());
}
public static List <Setting_Nestoria> Get_Parameters()
{
DataTable query = StaticCalls.GetQuery("SELECT Nestoria.place, Nestoria.listing, Nestoria.count, Country.country_code, Nestoria.keywords\r\n FROM Country INNER JOIN\r\n Nestoria ON Country.country_id = Nestoria.country_id", "SettingsConnectionString", null);
List <Setting_Nestoria> list = new List <Setting_Nestoria>();
if (query.Rows != null)
{
foreach (DataRow row in query.Rows)
{
list.Add(new Setting_Nestoria
{
Place_Name = row["place"].ToString(),
Country = row["country_code"].ToString(),
Keywords = row["keywords"].ToString(),
Listing_Type = row["listing"].ToString(),
Count = row["count"].ToString()
});
}
}
return(list);
}
