public static CityCollection GetCollection()
{
CityCollection tempList = null;
using (SqlConnection myConnection = new SqlConnection(AppConfiguration.ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("usp_GetCity", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.AddWithValue("@QueryId", SelectTypeEnum.GetCollection);
myConnection.Open();
using (SqlDataReader myReader = myCommand.ExecuteReader())
{
if (myReader.HasRows)
{
tempList = new CityCollection();
while (myReader.Read())
{
tempList.Add(FillDataRecord(myReader));
}
}
myReader.Close();
}
}
}
return(tempList);
}
public CityCollection GetCities()
{
CityCollection cities = new CityCollection();
cities.GetMulti(null);
return cities;
}
public CityCollection GetCities()
{
CityCollection cities = new CityCollection();
cities.GetMulti(null);
return(cities);
}
private void BindCityList()
{
CityCollection cityList = new CityCollection();
cityList = CityDAL.GetCollection();
rptCityList.DataSource = cityList;
rptCityList.DataBind();
}
private void loadButton_Click(object sender, EventArgs e)
{
var builder = CityCollection.CreateBuilder();
builder.ItemsList.Add(MakeCity(1, "Paris", "FRA", true));
builder.ItemsList.Add(MakeCity(2, "Lyon", "FRA", true, 10));
builder.ItemsList.Add(MakeCity(3, "Marseille", "FRA", true));
collection = builder.Build();
logbox.AppendText(string.Format("Collection Size: {0}\r\n", collection.ItemsCount));
}
static void Main2(string[] args)
{
CityCollection myColl = new CityCollection();
// Ausgabe
foreach (string s in myColl)
{
Console.WriteLine(s);
}
// Ausgabe in umgekehrter Reihenfolge
}
private void ShowCities(CityCollection collection)
{
var sorted = collection.Items
.OrderBy(c => c.__isset.displayOrder ? c.DisplayOrder : int.MaxValue)
.ThenBy(c => c.Id);
foreach (var city in sorted)
{
logbox.AppendText(city.ToString() + "\r\n");
}
logbox.AppendText("\r\n");
}
/// <summary>
/// Loads a collection of City objects from the database.
/// </summary>
/// <returns>A collection containing all of the City objects in the database.</returns>
public static CityCollection LoadCollection(string spName, SqlParameter[] parms)
{
CityCollection result = new CityCollection();
using (SqlDataReader reader = SqlHelper.Default.ExecuteReader(spName, parms))
{
while (reader.Read())
{
City tmp = new City();
tmp.LoadFromReader(reader);
result.Add(tmp);
}
}
return(result);
}
private void LoadView()
{
SupplierUI supplier = SupplierController.GetSupplierUIForSupplierProfile(SuppliersSessionHelper.SupplierId());
txtbusiness.Text = supplier.BusinessName;
txtContactName.Text = supplier.ContactName;
txtContactPhone.Text = supplier.ContactPhone;
txtEmail.Text = supplier.Email;
txtEmail.Enabled = false;
txtNumber.Text = supplier.HouseNum;
txtStreet.Text = supplier.Street;
ddlCity.DataSource = CityCollection.FetchAll();
ddlCity.DataBind();
if (supplier.CityId != 0)
{
ddlCity.SelectedValue = supplier.CityId.ToString();
}
txtPhone.Text = supplier.Phone;
rptCity.DataSource = CityController.GetAllCityUIBy(SuppliersSessionHelper.SupplierId(), false);
rptCity.DataBind();
rptHomeCity.DataSource = CityController.GetAllCityUIBy(SuppliersSessionHelper.SupplierId(), true);
rptHomeCity.DataBind();
showHideServiceFields(supplier.IsService);
if (supplier.IsService)
{
txtDescription.Text = supplier.Description;
txtDiscount.Text = supplier.Discount;
string ImageFile = "";
ImageFile = Snoopi.core.MediaUtility.GetImagePath("Supplier", supplier.ProfileImage, 0, 225, 225);
if (ImageFile.ToLower().Contains(".jpg") || ImageFile.ToLower().Contains(".jpeg") || ImageFile.ToLower().Contains(".png"))
{
ImageFileHandler(fuImage, imgImage, btnDeleteImage, ImageFile);
}
}
if (supplier.ApprovedTermsDate == null && supplier.IsService)
{
IsApprovedTerms.Value = "false";
}
else
{
IsApprovedTerms.Value = "true";
}
}
public Player(RawNode initNode, RawNode repositoryNode)
{
this.repositoryNode = repositoryNode;
dataSources = new DataSources();
var simpleResources = new SimpleResourceCollection(initNode.GetNode("simple-resources"), new SimpleResourceCategories(), this, new SimpleResourceDataSource(repositoryNode.GetNode("simple-resources"), this));
var objects = new SomeModelCollection(initNode.GetNode("objects"), new SomeModelCategories(), this, new SomeModelDataSource(repositoryNode.GetNode("objects"), this));
var random = new RandomCollection(initNode.GetNode("random"), new RandomCategories(), this, new RandomDataSource(repositoryNode.GetNode("random"), this));
var cities = new CityCollection(initNode.GetNode("cities"), new CityCategories(), this, new CityDescriptionDataSource(repositoryNode.GetNode("cities"), this));
AddChild(random);
AddChild(simpleResources);
AddChild(objects);
AddChild(cities);
}
public static void Main()
{
CityCollection myColl = new CityCollection();
foreach (string s in myColl)
{
Console.WriteLine(s);
}
Console.WriteLine("\nReverse Output:");
//Ausgabe in umgekehrter Reihenfolge
foreach (string s in myColl.Reverse())
{
Console.WriteLine(s);
}
Console.WriteLine("\nPress Enter to Exit");
Console.ReadLine();
}
public override void Get(HttpRequest Request, HttpResponse Response, params string[] PathParams)
{
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.Cache.SetMaxAge(TimeSpan.Zero);
Response.ContentType = @"application/json";
using (StreamWriter streamWriter = new StreamWriter(Response.OutputStream))
{
using (JsonTextWriter jsonWriter = new JsonTextWriter(streamWriter))
{
CityCollection c = CityCollection.FetchAll();
jsonWriter.WriteStartObject();
jsonWriter.WritePropertyName(@"cities-title");
jsonWriter.WriteValue(Settings.GetSetting(Settings.Keys.TITLE_CITIES) ?? @"");
jsonWriter.WritePropertyName(@"cities");
jsonWriter.WriteStartArray();
foreach (City item in c)
{
jsonWriter.WriteStartObject();
jsonWriter.WritePropertyName(@"city_id");
jsonWriter.WriteValue(item.CityId);
jsonWriter.WritePropertyName(@"city_name");
jsonWriter.WriteValue(item.CityName);
jsonWriter.WriteEndObject();
}
jsonWriter.WriteEndArray();
jsonWriter.WriteEndObject();
}
}
}
/// <summary>
/// Initializes a new instance of the <see cref="ViewModel"/> class.
/// </summary>
public PersonViewModel()
{
_gridCutCommand = new DelegateCommand(Cut);
_gridCopyCommand = new DelegateCommand(Copy);
_gridPasteCommand = new DelegateCommand(Paste);
_gridDeleteCommand = new DelegateCommand(Delete);
_expandCommand = new DelegateCommand(Expand);
_collapseCommand = new DelegateCommand(Collapse);
_sortAscendingCommand = new DelegateCommand(SortAscending);
_sortDescendingCommand = new DelegateCommand(SortDescending);
_clearSortingCommand = new DelegateCommand(ClearSorting);
_bestFitCommand = new DelegateCommand(BestFit);
_addAboveCommand = new DelegateCommand(AddAbove);
_addBelowCommand = new DelegateCommand(AddBelow);
_addAsChildCommand = new DelegateCommand(AddAsChild);
persons = this.CreateGenericPersonData(5, 8);
cityCollection = new ObservableCollection <string>();
foreach (var item in city)
{
CityCollection.Add(item);
}
}
private void GetCities(Int64 AppUserId)
{
if (ddlCity.Items.Count == 0)
{
Query q = new Query(City.TableSchema).SelectAll().OrderBy(City.Columns.CityName, dg.Sql.SortDirection.ASC);
CityCollection citiesList = CityCollection.FetchByQuery(q);
Int64 selectedCityId = AppUserId == 0 ? citiesList[0].CityId : AppUser.FetchByID(AppUserId).CityId;
int index = 0;
foreach (City city in citiesList)
{
ddlCity.Items.Add(new ListItem(city.CityName, city.CityId.ToString()));
//check if to select this item
if (selectedCityId == city.CityId)
{
ddlCity.Items[index].Selected = true;
}
index++;
}
}
}
public Enumerator(CityCollection collection)
{
coll = collection;
pos = -1;
}
public override void Get(HttpRequest Request, HttpResponse Response, params string[] PathParams)
{
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.Cache.SetMaxAge(TimeSpan.Zero);
Response.ContentType = @"application/json";
using (StreamWriter streamWriter = new StreamWriter(Response.OutputStream))
{
using (JsonTextWriter jsonWriter = new JsonTextWriter(streamWriter))
{
double EndBidTime = Convert.ToDouble(Settings.GetSettingDecimal(Settings.Keys.END_BID_TIME_MIN,15));
int SuppliedWithinHour = Settings.GetSettingInt32(Settings.Keys.SUPPLIED_WITHIN_HOUR, 24);
string HomeBanner = Settings.GetSetting(Settings.Keys.BANNER_HOME);
string CategoryBanner = Settings.GetSetting(Settings.Keys.BANNER_CATEGORY);
string SubCategoryBanner = Settings.GetSetting(Settings.Keys.BANNER_SUB_CATEGORY);
string AdminEmail = Settings.GetSetting(Settings.Keys.ADMIN_EMAIL);
string AdminPhone = Settings.GetSetting(Settings.Keys.ADMIN_PHONE);
string MinPriceOfferBids = Settings.GetSetting(Settings.Keys.MIN_PRICE_FOR_OFFER_BIDS);
string PrivacyPolicyUrl = Settings.GetSetting(Settings.Keys.PRIVACY_POLICY_URL);
jsonWriter.WriteStartObject();
//general settings
jsonWriter.WritePropertyName(@"setting");
jsonWriter.WriteStartObject();
jsonWriter.WritePropertyName(@"end_bid_time_min");
jsonWriter.WriteValue(EndBidTime);
jsonWriter.WritePropertyName(@"supplied_within_hour");
jsonWriter.WriteValue(SuppliedWithinHour);
jsonWriter.WritePropertyName(@"home_banner");
jsonWriter.WriteValue(HomeBanner);
jsonWriter.WritePropertyName(@"category_banner");
jsonWriter.WriteValue(CategoryBanner);
jsonWriter.WritePropertyName(@"sub_category_banner");
jsonWriter.WriteValue(SubCategoryBanner);
jsonWriter.WritePropertyName(@"admin_email");
jsonWriter.WriteValue(AdminEmail);
jsonWriter.WritePropertyName(@"admin_phone");
jsonWriter.WriteValue(AdminPhone);
jsonWriter.WritePropertyName(@"min_price_for_bids_offer");
jsonWriter.WriteValue(MinPriceOfferBids);
//////////
jsonWriter.WritePropertyName(@"privacy_policy_url");
jsonWriter.WriteValue(PrivacyPolicyUrl);
jsonWriter.WritePropertyName(@"services");
jsonWriter.WriteStartArray();
foreach (Service item in ServiceController.GetAllService())
{
jsonWriter.WriteStartObject();
jsonWriter.WritePropertyName(@"service_id");
jsonWriter.WriteValue(item.ServiceId);
jsonWriter.WritePropertyName(@"service_name");
jsonWriter.WriteValue(item.ServiceName);
jsonWriter.WriteEndObject();
}
jsonWriter.WriteEndArray();
////////////
PriceFilterCollection priceFilterCol = PriceFilterCollection.FetchAll();
jsonWriter.WritePropertyName(@"price-title");
jsonWriter.WriteValue(Settings.GetSetting(Settings.Keys.TITLE_PRICES) ?? @"");
jsonWriter.WritePropertyName(@"list_price_filter");
jsonWriter.WriteStartArray();
foreach (PriceFilter item in priceFilterCol)
{
jsonWriter.WriteStartObject();
jsonWriter.WritePropertyName(@"price_id");
jsonWriter.WriteValue(item.PriceId);
jsonWriter.WritePropertyName(@"price_name");
jsonWriter.WriteValue(item.PriceName);
jsonWriter.WriteEndObject();
}
jsonWriter.WriteEndArray();
jsonWriter.WritePropertyName(@"category-title");
jsonWriter.WriteValue(Settings.GetSetting(Settings.Keys.TITLE_CATEGORIES) ?? @"");
jsonWriter.WritePropertyName(@"list_category");
jsonWriter.WriteStartArray();
CategoryYad2Collection categoryYad2Col = CategoryYad2Collection.FetchAll();
foreach (CategoryYad2 item in categoryYad2Col)
{
jsonWriter.WriteStartObject();
jsonWriter.WritePropertyName(@"category_id");
jsonWriter.WriteValue(item.CategoryYad2Id);
jsonWriter.WritePropertyName(@"category_name");
jsonWriter.WriteValue(item.CategoryYad2Name);
jsonWriter.WriteEndObject();
}
jsonWriter.WriteEndArray();
///////////////
List<FilterUI> lstFilterUI = ProductController.GetAllFilter();
jsonWriter.WritePropertyName(@"filters");
jsonWriter.WriteStartArray();
foreach (FilterUI item in lstFilterUI)
{
jsonWriter.WriteStartObject();
jsonWriter.WritePropertyName(@"filter_id");
jsonWriter.WriteValue(item.FilterId);
jsonWriter.WritePropertyName(@"filter_name");
jsonWriter.WriteValue(item.FilterName);
jsonWriter.WritePropertyName(@"list_sub_filter");
jsonWriter.WriteStartArray();
foreach (SubFilterUI subItem in item.LstSubFilter)
{
jsonWriter.WriteStartObject();
jsonWriter.WritePropertyName(@"filter_id");
jsonWriter.WriteValue(subItem.FilterId);
jsonWriter.WritePropertyName(@"sub_filter_id");
jsonWriter.WriteValue(subItem.SubFilterId);
jsonWriter.WritePropertyName(@"sub_filter_name");
jsonWriter.WriteValue(subItem.SubFilterName);
jsonWriter.WriteEndObject();
}
jsonWriter.WriteEndArray();
jsonWriter.WriteEndObject();
}
jsonWriter.WriteEndArray();
///////////////
jsonWriter.WritePropertyName(@"animal_list");
jsonWriter.WriteStartArray();
Query q = new Query(Animal.TableSchema);
using (DataReaderBase reader = q.ExecuteReader())
{
while (reader.Read())
{
jsonWriter.WriteStartObject();
jsonWriter.WritePropertyName(@"animal_id");
jsonWriter.WriteValue(reader[Animal.Columns.AnimalId]);
jsonWriter.WritePropertyName(@"animal_name");
jsonWriter.WriteValue(reader[Animal.Columns.AnimalName] ?? "");
jsonWriter.WriteEndObject();
}
}
jsonWriter.WriteEndArray();
///////////////////
CityCollection cities = CityCollection.FetchAll();
List<City> c = new List<City>();
c = cities;
c= c.OrderBy(x => x.CityName).ToList();
jsonWriter.WritePropertyName(@"cities-title");
jsonWriter.WriteValue(Settings.GetSetting(Settings.Keys.TITLE_CITIES) ?? @"");
jsonWriter.WritePropertyName(@"cities");
jsonWriter.WriteStartArray();
foreach (City item in c)
{
jsonWriter.WriteStartObject();
jsonWriter.WritePropertyName(@"city_id");
jsonWriter.WriteValue(item.CityId);
jsonWriter.WritePropertyName(@"city_name");
jsonWriter.WriteValue(item.CityName);
jsonWriter.WriteEndObject();
}
jsonWriter.WriteEndArray();
//////////////
jsonWriter.WriteEndObject();
}
}
}
public void Open(string guid, string kladr)
{
connection.ConnectionString = ConnectionString;
connection.Open();
CustomReloadCollection(RegionCollection, FiasSql.RegionSql, null);
var searchResult = new Dictionary <string, string>();
using (var transaction = connection.BeginTransaction())
{
using (var query = new DbQuery(connection, transaction))
{
query.SqlText = "select ID_REGION, ID_AUTO, ID_AREA, ID_CITY, ID_CTAR, ID_PLACE, ID_STREET, ID_HOUSE from PR_FIAS_EXTRACT(@ID_GUID, @ID_KLADR)";
query.Parameters.Add(query.GetNewParameter("ID_GUID", guid == string.Empty ? null : guid));
query.Parameters.Add(query.GetNewParameter("ID_KLADR", kladr == string.Empty ? null : kladr));
query.ExecuteDataReader();
if (query.DataReader.Read())
{
for (var i = 0; i < query.DataReader.FieldCount; i++)
{
searchResult.Add(query.DataReader.GetName(i), query.DataReader[i].ToString());
}
}
}
}
if (searchResult.Count == 0)
{
return;
}
if (searchResult["ID_REGION"] != string.Empty)
{
SelectedRegion = RegionCollection.FirstOrDefault(a => a.Id == searchResult["ID_REGION"]);
}
if (searchResult["ID_AUTO"] != string.Empty)
{
SelectedAuto = AutoCollection.FirstOrDefault(a => a.Id == searchResult["ID_AUTO"]);
}
if (searchResult["ID_AREA"] != string.Empty)
{
SelectedArea = AreaCollection.FirstOrDefault(a => a.Id == searchResult["ID_AREA"]);
}
if (searchResult["ID_CITY"] != string.Empty)
{
SelectedCity = CityCollection.FirstOrDefault(a => a.Id == searchResult["ID_CITY"]);
}
if (searchResult["ID_CTAR"] != string.Empty)
{
SelectedCtar = CtarCollection.FirstOrDefault(a => a.Id == searchResult["ID_CTAR"]);
}
if (searchResult["ID_PLACE"] != string.Empty)
{
SelectedPlace = PlaceCollection.FirstOrDefault(a => a.Id == searchResult["ID_PLACE"]);
}
if (searchResult["ID_STREET"] != string.Empty)
{
SelectedStreet = StreetCollection.FirstOrDefault(a => a.Id == searchResult["ID_STREET"]);
}
if (searchResult["ID_HOUSE"] != string.Empty)
{
SelectedHouse = HouseCollection.FirstOrDefault(a => a.Id == searchResult["ID_HOUSE"]);
}
}
