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