public void AddProvince() { LocationsManager _locationManager = (LocationsManager)container["LocationsManager"]; Province province = new Province("France"); province.Id = _locationManager.AddProvince(province.Name); Assert.AreNotEqual(0, province.Id); }
public void AddDistrict() { LocationsManager _locationManager = (LocationsManager)container["LocationsManager"]; Province province = new Province("France"); province.Id = _locationManager.AddProvince(province.Name); Assert.AreNotEqual(0, province.Id); District district = new District("Ile de France",province); district.Id = _locationManager.AddDistrict(district); Assert.AreNotEqual(0, district.Id); }
private void InitializeCities(Province province, District district) { var cities = new List<City>(); if (district != null) cities = ServicesProvider.GetInstance() .GetLocationServices() .FindCityByDistrictId(district.Id); else if (province != null) { var districts = ServicesProvider.GetInstance().GetLocationServices().FindDistrict(province); foreach (District dist in districts) cities.AddRange(ServicesProvider.GetInstance().GetLocationServices().FindCityByDistrictId(dist.Id)); } else cities = ServicesProvider.GetInstance().GetLocationServices().GetCities(); listViewCity.Items.Clear(); foreach (City cityObject in cities) { ListViewItem listViewItem = new ListViewItem(cityObject.Name); listViewCity.Items.Add(listViewItem); } }
public void SelectProvincesOnly() { LocationsManager _locationManager = (LocationsManager)container["LocationsManager"]; Province provinceA = new Province("France"); Province provinceB = new Province("Tadjikistan"); Province provinceC = new Province("Russian"); provinceA.Id = _locationManager.AddProvince(provinceA.Name); provinceB.Id = _locationManager.AddProvince(provinceB.Name); provinceC.Id = _locationManager.AddProvince(provinceC.Name); List<Province> provinceList = _locationManager.GetProvinces(); Assert.AreEqual(4, provinceList.Count); //provinceA, provinceB, provinceC + BaseManagerTest _Contains(provinceA, provinceList); _Contains(provinceB, provinceList); _Contains(provinceC, provinceList); }
public void TestUpdateDistrict() { LocationsManager _locationManager = (LocationsManager)container["LocationsManager"]; Province province = new Province("France"); province.Id = _locationManager.AddProvince(province.Name); Assert.AreNotEqual(0, province.Id); List<District> districts = _locationManager.GetDistricts(); Assert.AreEqual(2, districts.Count); Assert.AreEqual("NANCY", districts[0].Name); Assert.AreEqual(2, districts[0].Id); Assert.AreEqual("PARIS", districts[1].Name); Assert.AreEqual(1, districts[1].Id); districts[0].Name = "china"; _locationManager.UpdateDistrict(districts[0]); districts = _locationManager.GetDistricts(); districts.Sort(new DistrictComparer()); Assert.AreEqual(2, districts.Count); Assert.AreEqual("china", districts[0].Name); Assert.AreEqual(2, districts[0].Id); Assert.AreEqual("PARIS", districts[1].Name); Assert.AreEqual(1, districts[1].Id); }
public void TestDeleteProvince() { LocationsManager _locationManager = (LocationsManager)container["LocationsManager"]; Province province = new Province("France"); province.Id = _locationManager.AddProvince(province.Name); Assert.AreNotEqual(0, province.Id); List<Province> provinces = _locationManager.GetProvinces(); Assert.AreEqual(2, provinces.Count); _locationManager.DeleteProvinceById(province.Id); provinces = _locationManager.GetProvinces(); Assert.AreEqual(1, provinces.Count); }
public void TestDeleteCity() { LocationsManager _locationManager = (LocationsManager)container["LocationsManager"]; Province province = new Province("France"); province.Id = _locationManager.AddProvince(province.Name); Assert.AreNotEqual(0, province.Id); District district = new District("Ile de France", province); district.Id = _locationManager.AddDistrict(district); Assert.AreNotEqual(0, district.Id); City city = new City { Name = "Paris", DistrictId = district.Id }; city.Id=_locationManager.AddCity(city); Assert.IsTrue(city.Id > 0); List<City> cities = _locationManager.GetCities(); Assert.AreEqual(1, cities.Count); _locationManager.DeleteCityById(city.Id); cities = _locationManager.GetCities(); Assert.AreEqual(0, cities.Count); }
public List<District> FindDistrict(Province province) { return province.Id == 0 ? _locationsManager.GetDistricts() : _locationsManager.SelectDistrictsByProvinceId(province.Id); }
public void TestUpdateProvince() { Province provinceOne = new Province(2, "Pekin"); List<Province> provinces = new List<Province> {provinceOne}; DynamicMock mockLocationsManager = new DynamicMock(typeof(LocationsManager)); mockLocationsManager.SetReturnValue("GetProvinces", provinces); mockLocationsManager.ExpectAndReturn("UpdateProvince", true, provinceOne); LocationsManager mocklocationManager = (LocationsManager)mockLocationsManager.MockInstance; LocationServices locationService = new LocationServices(mocklocationManager); Assert.AreEqual("Pekin", locationService.GetProvinces()[0].Name); Assert.AreEqual(true, locationService.UpdateProvince(provinceOne)); }
public void TestUpdateDistrict() { Province provinceOne = new Province(2, "Pekin"); District district = new District("Pekin", provinceOne); List<District> districts = new List<District> {district}; DynamicMock mockLocationsManager = new DynamicMock(typeof (LocationsManager)); mockLocationsManager.SetReturnValue("GetDistricts", districts); mockLocationsManager.ExpectAndReturn("UpdateDistrict", true, district); LocationsManager mocklocationManager = (LocationsManager) mockLocationsManager.MockInstance; LocationServices locationService = new LocationServices(mocklocationManager); Assert.AreEqual("Pekin", locationService.GetDistricts()[0].Name); Assert.AreEqual(true, locationService.UpdateDistrict(district)); }
public void TestDeleteProvinceWithoutDistrictIn() { Province provinceOne = new Province(2, "Pekin"); Province provinceTwo = new Province(8, "Qhinghua"); List<District> districts = new List<District> { new District("Paris",provinceOne), new District("Pekin",provinceOne), new District("Pau",provinceOne) }; DynamicMock dynamicMock = new DynamicMock(typeof(LocationsManager)); dynamicMock.SetReturnValue("GetDistricts", districts); dynamicMock.Expect("DeleteProvinceById", 8); LocationsManager mocklocationManager = (LocationsManager)dynamicMock.MockInstance; LocationServices locationService = new LocationServices(mocklocationManager); Assert.AreEqual(true, locationService.DeleteProvince(provinceTwo)); }
public bool UpdateProvince(Province pProvince) { bool updateOk = false; try { const string q = "UPDATE [Provinces] SET [name]=@name WHERE id=@id"; using (SqlConnection conn = GetConnection()) using (OpenCbsCommand c = new OpenCbsCommand(q, conn)) { c.AddParam("@id", pProvince.Id); c.AddParam("@name", pProvince.Name); c.ExecuteNonQuery(); updateOk = true; } } catch (System.Exception ex) { throw ex; } return updateOk; }
public Province SelectProvinceByName(string name) { const string q = "SELECT id,name FROM Provinces WHERE name = @name"; using (SqlConnection conn = GetConnection()) using (OpenCbsCommand c = new OpenCbsCommand(q, conn)) { c.AddParam("@name", name); using (OpenCbsReader r = c.ExecuteReader()) { if (null == r || r.Empty) return null; r.Read(); Province retval = new Province { Id = r.GetInt("id"), Name = r.GetString("name") }; return retval; } } }
public List<Province> SelectAllProvinces() { List<Province> provinces = new List<Province>(); const string q = "SELECT id,name FROM Provinces ORDER BY name"; using (SqlConnection conn = GetConnection()) using (OpenCbsCommand c = new OpenCbsCommand(q, conn)) using (OpenCbsReader r = c.ExecuteReader()) { if (r != null) { while (r.Read()) { Province province = new Province { Id = r.GetInt("id"), Name = r.GetString("name") }; provinces.Add(province); } } } return provinces; }
public List<Province> GetProvinces() { List<Province> provinces = new List<Province>(); const string q = "SELECT [id],[name] FROM [Provinces] WHERE [deleted] = 0 ORDER BY name"; using (SqlConnection conn = GetConnection()) using (OpenCbsCommand c = new OpenCbsCommand(q, conn)) { using (OpenCbsReader r = c.ExecuteReader()) { if (r != null) { while (r.Read()) { Province province = new Province(); province.Id = r.GetInt("id"); province.Name = r.GetString("name"); provinces.Add(province); } } } } return provinces; }
private void buttonUpdate_Click(object sender, EventArgs e) { try { if (buttonUpdate.Text.Equals(GetString("buttonEdit"))) { try { node = treeViewLocations.SelectedNode; if (node == null) return; if ((node.Tag is Province)) { province = (Province) node.Tag; tbName.Text = province.Name; } else if ((node.Tag is District)) { district = (District) node.Tag; tbName.Text = district.Name; } else if ((node.Tag is City)) { city = (City) node.Tag; tbName.Text = city.Name; } } catch (Exception exception) { var exceptionStatus = CustomExceptionHandler.ShowExceptionText(exception); new frmShowError(exceptionStatus).ShowDialog(); return; } treeViewLocations.Enabled = false; buttonAdd.Enabled = false; buttonDelete.Enabled = false; buttonExit.Enabled = false; buttonUpdate.Text = GetString("buttonSave"); } else { try { if ((node.Tag is Province)) { province.Name = tbName.Text; ServicesProvider.GetInstance().GetLocationServices().UpdateProvince(province); } else if ((node.Tag is District)) { district.Name = tbName.Text; ServicesProvider.GetInstance().GetLocationServices().UpdateDistrict(district); } else if ((node.Tag is City)) { city.Name = tbName.Text; ServicesProvider.GetInstance().GetLocationServices().UpdateCity(city); } } catch (Exception exception) { var exceptionStatus = CustomExceptionHandler.ShowExceptionText(exception); new frmShowError(exceptionStatus).ShowDialog(); return; } node.Text = tbName.Text; buttonExit.Enabled = true; buttonAdd.Enabled = true; buttonDelete.Enabled = true; treeViewLocations.Enabled = true; buttonUpdate.Text = GetString("buttonEdit"); } } catch (Exception exception) { var exceptionStatus = CustomExceptionHandler.ShowExceptionText(exception); new frmShowError(exceptionStatus).ShowDialog(); return; } treeViewLocations.Sort(); }
public bool DeleteProvince(Province pProvince) { bool deleteProvincePossible = true; List<District> districts = new List<District>(); districts = _locationsManager.GetDistricts(); for (int i = 0; i < districts.Count; i++) { if (districts[i].Province.Id != pProvince.Id) continue; deleteProvincePossible = false; break; } if (deleteProvincePossible) _locationsManager.DeleteProvinceById(pProvince.Id); return deleteProvincePossible; }
public District(int id, string name, Province province) { _id = id; _name = name; _province = province; }
public bool UpdateProvince(Province province) { CheckLocation(province.Name); return _locationsManager.UpdateProvince(province); }
public District(string name, Province province) { _name = name; _province = province; }
public void TestDeleteDistrict() { LocationsManager _locationManager = (LocationsManager)container["LocationsManager"]; Province province = new Province("France"); province.Id = _locationManager.AddProvince(province.Name); Assert.AreNotEqual(0, province.Id); District district = new District("Ile de France", province); district.Id = _locationManager.AddDistrict(district); Assert.AreNotEqual(0, district.Id); List<District> districts = _locationManager.GetDistricts(); Assert.AreEqual(3, districts.Count); _locationManager.DeleteDistrictById(district.Id); districts = _locationManager.GetDistricts(); Assert.AreEqual(2, districts.Count); }
private void comboBoxProvince_SelectionChangeCommitted(object sender, System.EventArgs e) { _province = (Province)comboBoxProvince.SelectedItem; _InitializeDistricts(); textBoxCity.Text = String.Empty; }
public void TestUpdateCity() { LocationsManager _locationManager = (LocationsManager)container["LocationsManager"]; Province province = new Province("France"); province.Id = _locationManager.AddProvince(province.Name); Assert.AreNotEqual(0, province.Id); District district = new District("Ile de France", province); district.Id = _locationManager.AddDistrict(district); Assert.AreNotEqual(0, district.Id); City city = new City {Name = "Paris", DistrictId = district.Id}; city.Id=_locationManager.AddCity(city); city.Name = "qsd"; _locationManager.UpdateCity(city); List<City> cities = _locationManager.GetCities(); Assert.AreEqual("qsd", cities[0].Name); }
private void _Initialization() { InitializeComponent(); _province = new Province(); _district = null; _city = null; _comments = null; _homePhone = string.Empty; _personalPhone = string.Empty; _email = string.Empty; _zipCode = string.Empty; _homeType = string.Empty; _InitializeProvince(); _InitializeDistricts(); _InitializeCity(); _InitializeHomeType(); }
private static void _Contains(Province pProvince, IEnumerable<Province> pProvincesList) { Province selectedProvince = null; foreach (Province province in pProvincesList) { if (province.Name != pProvince.Name) { continue; } selectedProvince = province; break; } if (selectedProvince == null) Assert.Fail(); else Assert.AreEqual(selectedProvince.Name, pProvince.Name); }
private void _InitializeProvince() { comboBoxProvince.Items.Clear(); var selectProvince = new Province { Name = MultiLanguageStrings.GetString(Ressource.AddressUserControl, "all.Text") }; comboBoxProvince.Items.Add(selectProvince); var provinceList = ServicesProvider.GetInstance().GetLocationServices().GetProvinces(); foreach (var pro in provinceList) { comboBoxProvince.Items.Add(pro); } comboBoxProvince.SelectedItem = selectProvince; }
private void _SelectProvince() { if (_district.Id == 0) { return; } foreach (Province selectedProvince in comboBoxProvince.Items) { if (selectedProvince.Name != _district.Province.Name) { continue; } comboBoxProvince.SelectedItem = selectedProvince; _province = selectedProvince; break; } }
public District(int id,string name,Province province) { _id = id; _name = name; _province = province; }
public CityForm(Province province, District district) { InitializeComponent(); InitializeCities(province, district); }
public District(string name,Province province) { _name = name; _province = province; }
public Province AddProvinceIntoDatabase() { SqlCommand command = new SqlCommand("INSERT INTO Provinces (name,deleted) VALUES ('Sugh',0) SELECT SCOPE_IDENTITY()", _connection); Province province = new Province(); province.Name = "Sugh"; province.Id = int.Parse(command.ExecuteScalar().ToString()); return province; }
private void buttonAdd_Click(object sender, EventArgs e) { TreeNode node = treeViewLocations.SelectedNode; try { if (node == null) { buttonAdd.Enabled = false; buttonDelete.Enabled = false; buttonUpdate.Enabled = false; return; } if (!string.IsNullOrEmpty(tbName.Text)) { var locationServices = ServicesProvider.GetInstance().GetLocationServices(); if (node.Tag == null) { // Add province int newId = locationServices.AddProvince(tbName.Text); Province p = new Province(newId, tbName.Text); TreeNode pnode = new TreeNode(tbName.Text) {Tag = p}; node.Nodes.Add(pnode); } else if ((node.Tag is Province)) { // Add district Province province = (Province) node.Tag; int newId = locationServices.AddDistrict(tbName.Text, province.Id); District d = new District(newId, tbName.Text, province); TreeNode dnode = new TreeNode(tbName.Text) {Tag = d}; node.Nodes.Add(dnode); } else if ((node.Tag is District)) { // Add city District district = (District) node.Tag; City city = new City {Name = tbName.Text, DistrictId = district.Id}; city.Id = locationServices.AddCity(city); TreeNode cnode = new TreeNode(tbName.Text) {Tag = city}; node.Nodes.Add(cnode); buttonAdd.Enabled = false; } tbName.Clear(); } } catch(Exception exception) { var exceptionStatus = CustomExceptionHandler.ShowExceptionText(exception); new frmShowError(exceptionStatus).ShowDialog(); return; } node.Expand(); treeViewLocations.Sort(); }