public static AreaCollection GetAllItem() { //AreaCollection ItemCollection = new AreaCollection(); //Database db = SqlHelper.CreateConnection(SqlHelper.MyConnection); //DbCommand dbCommand = db.GetStoredProcCommand("tblArea_GetAll"); //using (IDataReader dataReader = db.ExecuteReader(dbCommand)) //{ // Area item; // while (dataReader.Read()) // { // item = GetItemFromReader(dataReader); // ItemCollection.Add(item); // } //} //return ItemCollection; AreaCollection collection = new AreaCollection(); try { using (var reader = SqlHelper.ExecuteReader("tblArea_GetList", null)) { while (reader.Read()) { Area obj = new Area(); obj = GetItemFromReader(reader); collection.Add(obj); } } } catch (Exception objEx) { collection.Add(new Area() { AreaID = 0, AreaName = objEx.Message, Description = objEx.StackTrace }); } return(collection); }
public void Add() { var addView = new AddAreaView(); if (addView.ShowDialog() == true) { _lookup.Add(addView.NewItem); _viewModel.Collection.Add(addView.NewItem); } }
public Models.Api.SchoolListClassifiedRS GetSchoolListClassified(ApiRequest apiRQ) { var schoolCollection1 = new SchoolCollection(); schoolCollection1.Add(new School { ID = 1, Name = "上海海富幼儿园龙阳校区" }); schoolCollection1.Add(new School { ID = 2, Name = "上海私立蒙特梭利幼儿园" }); schoolCollection1.Add(new School { ID = 3, Name = "上海市建青实验学校幼儿部" }); schoolCollection1.Add(new School { ID = 4, Name = "上海中国福利会幼儿园" }); schoolCollection1.Add(new School { ID = 5, Name = "上海市浦东新区冰厂田幼儿园(云山路寄宿部)" }); var area1 = new Area { ID = 1, Name = "黄浦区", Schools = schoolCollection1 }; var schoolCollection2 = new SchoolCollection(); schoolCollection2.Add(new School { ID = 6, Name = "上海市实验幼儿园(杏山园)" }); schoolCollection2.Add(new School { ID = 7, Name = "孔祥东音乐幼儿园(巨野路园区)" }); schoolCollection2.Add(new School { ID = 8, Name = "上海市徐汇区科技幼儿园" }); var area2 = new Area { ID = 2, Name = "徐汇区", Schools = schoolCollection2 }; var schoolCollection3 = new SchoolCollection(); schoolCollection3.Add(new School { ID = 9, Name = "上海乌南幼儿园" }); schoolCollection3.Add(new School { ID = 10, Name = "上海市本溪路幼儿园" }); schoolCollection3.Add(new School { ID = 11, Name = "上海市宝山区行知实验幼儿园" }); var area3 = new Area { ID = 3, Name = "长宁区", Schools = schoolCollection3 }; var areaCollection1 = new AreaCollection(); areaCollection1.Add(area1); areaCollection1.Add(area2); areaCollection1.Add(area3); var schoolCollection4 = new SchoolCollection(); schoolCollection4.Add(new School { ID = 12, Name = "宁波市第一幼儿园" }); schoolCollection4.Add(new School { ID = 13, Name = "宁波市宝韵音乐幼儿园" }); schoolCollection4.Add(new School { ID = 14, Name = "宁波市华光幼儿园" }); var schoolCollection5 = new SchoolCollection(); schoolCollection5.Add(new School { ID = 15, Name = "杭州市行知幼儿园" }); schoolCollection5.Add(new School { ID = 16, Name = "杭州市清波幼儿园" }); schoolCollection5.Add(new School { ID = 17, Name = "杭州市娃哈哈幼儿园" }); var area4 = new Area { ID = 4, Name = "杭州市", Schools = schoolCollection5 }; var area5 = new Area { ID = 5, Name = "宁波市", Schools = schoolCollection4 }; var areaCollection2 = new AreaCollection(); areaCollection2.Add(area4); areaCollection2.Add(area5); var sh = new Province { ID = 1, Areas = areaCollection1, Name = "上海市" }; var zj = new Province { ID = 2, Areas = areaCollection2, Name = "浙江省" }; return new SchoolListClassifiedRS { Ok = true, Provinces = new List<Province> { sh, zj } }; }
internal static AreaCollection CollectAll() { var dataTable = DatabaseController.ExecuteSelectQuery("SELECT * FROM " + TABLE_NAME); var collection = new AreaCollection(); foreach (DataRow dataRow in dataTable.Rows) { var item = new Area(); item.SetPropertiesFromDataRow(dataRow); collection.Add(item); } return(collection); }
public static AreaCollection GetAllItembyCountryID(int CountryID) { AreaCollection ItemCollection = new AreaCollection(); Database db = SqlHelper.CreateConnection(SqlHelper.MyConnection); DbCommand dbCommand = db.GetStoredProcCommand("tblArea_GetByCountryID"); db.AddInParameter(dbCommand, "CountryID", DbType.String, CountryID); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { Area item; while (dataReader.Read()) { item = GetItemFromReader(dataReader); ItemCollection.Add(item); } } return(ItemCollection); }
private void frmMain_Load(object sender, EventArgs e) { Cursor.Current = Cursors.WaitCursor; status.Text = string.Empty; this.Show(); System.Windows.Forms.Application.DoEvents(); string mapPointFile = string.Empty; openFileDialog1.Filter = "Mappoint Files (*.ptm)|*.ptm"; openFileDialog1.RestoreDirectory = true; if (openFileDialog1.ShowDialog() == DialogResult.OK) { mappointAreas = new AreaCollection(); MapPoint.Application mApp = new MapPoint.Application(); mApp.Visible = false; mApp.UserControl = false; MapPoint.Map map = mApp.OpenMap(openFileDialog1.FileName, false); int i = 0; foreach (MapPoint.Shape shape in map.Shapes) { //try //{ if (shape.Type == GeoShapeType.geoFreeform) { i++; status.Text = "Importing Shape " + i.ToString(); System.Windows.Forms.Application.DoEvents(); AreaCoordinateCollection coordinates = new AreaCoordinateCollection(); System.Object[] objects = (System.Object[])shape.Vertices; foreach (System.Object obj in objects) { if (obj is MapPoint.Location) { MapPoint.Location location = (MapPoint.Location)obj; AreaCoordinate coordinate = new AreaCoordinate(); coordinate.Latitude = location.Latitude; coordinate.Longitude = location.Longitude; coordinates.Add(coordinate); System.Windows.Forms.Application.DoEvents(); } } Area area = new Area(coordinates.MinLatitude(), coordinates.MinLongitude()); if (area == null || area.AreaID == -1) { area.AreaID = int.MinValue; area.OrganizationID = OrganizationId; area.Name = "Area: " + i.ToString(); area.MapHeight = 400; area.MapWidth = 600; } area.Coordinates = coordinates; for (int j = 0; j < area.Coordinates.Count; j++) { AreaCoordinate aCoordinate = area.Coordinates[j]; aCoordinate.AreaID = area.AreaID; aCoordinate.Order = j; } if (area.Blob != null) { area.Blob.DateModified = DateTime.Now; } mappointAreas.Add(area); } //} //catch (System.Exception ex) //{ // MessageBox.Show("Area " + i.ToString() + ": " + ex.Message, "Error Reading Area"); //} } LoadExistingAreas(); LoadMappointAreas(0); } else { btnLink.Enabled = false; btnCreateNew.Enabled = false; btnRemove.Enabled = false; btnImport.Enabled = false; } status.Text = string.Empty; Cursor.Current = Cursors.Default; }
public Models.Api.SchoolListClassifiedRS GetSchoolListClassified(ApiRequest apiRQ) { var schoolCollection1 = new SchoolCollection(); schoolCollection1.Add(new School { ID = 1, Name = "上海海富幼儿园龙阳校区" }); schoolCollection1.Add(new School { ID = 2, Name = "上海私立蒙特梭利幼儿园" }); schoolCollection1.Add(new School { ID = 3, Name = "上海市建青实验学校幼儿部" }); schoolCollection1.Add(new School { ID = 4, Name = "上海中国福利会幼儿园" }); schoolCollection1.Add(new School { ID = 5, Name = "上海市浦东新区冰厂田幼儿园(云山路寄宿部)" }); var area1 = new Area { ID = 1, Name = "黄浦区", Schools = schoolCollection1 }; var schoolCollection2 = new SchoolCollection(); schoolCollection2.Add(new School { ID = 6, Name = "上海市实验幼儿园(杏山园)" }); schoolCollection2.Add(new School { ID = 7, Name = "孔祥东音乐幼儿园(巨野路园区)" }); schoolCollection2.Add(new School { ID = 8, Name = "上海市徐汇区科技幼儿园" }); var area2 = new Area { ID = 2, Name = "徐汇区", Schools = schoolCollection2 }; var schoolCollection3 = new SchoolCollection(); schoolCollection3.Add(new School { ID = 9, Name = "上海乌南幼儿园" }); schoolCollection3.Add(new School { ID = 10, Name = "上海市本溪路幼儿园" }); schoolCollection3.Add(new School { ID = 11, Name = "上海市宝山区行知实验幼儿园" }); var area3 = new Area { ID = 3, Name = "长宁区", Schools = schoolCollection3 }; var areaCollection1 = new AreaCollection(); areaCollection1.Add(area1); areaCollection1.Add(area2); areaCollection1.Add(area3); var schoolCollection4 = new SchoolCollection(); schoolCollection4.Add(new School { ID = 12, Name = "宁波市第一幼儿园" }); schoolCollection4.Add(new School { ID = 13, Name = "宁波市宝韵音乐幼儿园" }); schoolCollection4.Add(new School { ID = 14, Name = "宁波市华光幼儿园" }); var schoolCollection5 = new SchoolCollection(); schoolCollection5.Add(new School { ID = 15, Name = "杭州市行知幼儿园" }); schoolCollection5.Add(new School { ID = 16, Name = "杭州市清波幼儿园" }); schoolCollection5.Add(new School { ID = 17, Name = "杭州市娃哈哈幼儿园" }); var area4 = new Area { ID = 4, Name = "杭州市", Schools = schoolCollection5 }; var area5 = new Area { ID = 5, Name = "宁波市", Schools = schoolCollection4 }; var areaCollection2 = new AreaCollection(); areaCollection2.Add(area4); areaCollection2.Add(area5); var sh = new Province { ID = 1, Areas = areaCollection1, Name = "上海市" }; var zj = new Province { ID = 2, Areas = areaCollection2, Name = "浙江省" }; return(new SchoolListClassifiedRS { Ok = true, Provinces = new List <Province> { sh, zj } }); }