public void TestConstructor() { District district = new District(1,"tress",new Province(1,"Sugh")); Assert.AreEqual(1,district.Id); Assert.AreEqual("tress",district.Name); Assert.AreEqual(1,district.Province.Id); Assert.AreEqual("Sugh",district.Province.Name); }
public District AddDistrictIntoDatabase() { Province province = AddProvinceIntoDatabase(); District district = new District(); district.Province = province; district.Name = "District"; SqlCommand command = new SqlCommand("INSERT INTO Districts (name,province_id,deleted) VALUES ('" + district.Name + "',@provinceId,0) SELECT SCOPE_IDENTITY()", _connection); command.Parameters.Add(new SqlParameter("@provinceId",SqlDbType.Int)); command.Parameters["@provinceId"].Value = province.Id; district.Id = int.Parse(command.ExecuteScalar().ToString()); return district; }
public int AddDistrict(District pDistrict) { const string q = "INSERT INTO [Districts]([name], [province_id],[deleted]) VALUES(@name,@provinceId,0) SELECT SCOPE_IDENTITY()"; using (SqlConnection conn = GetConnection()) using (OpenCbsCommand c = new OpenCbsCommand(q, conn)) { c.AddParam("@name", pDistrict.Name); c.AddParam("@provinceId", pDistrict.Province.Id); c.AddParam("@deleted", false); return int.Parse(c.ExecuteScalar().ToString()); } }
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 TestIdSecondaryAddressPartiallyFilled() { Person person = new Person(); District district = new District(1,"tress",new Province(1,"Sugh")); person.SecondaryDistrict = null; person.SecondaryCity = null; Assert.IsFalse(person.SecondaryAddressPartiallyFilled); person.SecondaryDistrict = district; Assert.IsTrue(person.SecondaryAddressPartiallyFilled); person.SecondaryCity = "city"; Assert.IsFalse(person.SecondaryAddressPartiallyFilled); person.SecondaryDistrict = null; person.SecondaryCity = null; Assert.IsFalse(person.SecondaryAddressPartiallyFilled); person.SecondaryCity = "paris"; Assert.IsTrue(person.SecondaryAddressPartiallyFilled); }
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); }
public District AddDistrictIntoDatabase() { Province province = AddProvinceIntoDatabase(); District district = new District(); district.Province = province; district.Name = "District"; OpenCbsCommand command = new OpenCbsCommand("INSERT INTO Districts (name,province_id,deleted) VALUES ('" + district.Name + "',@provinceId,0) SELECT SCOPE_IDENTITY()", SqlConnection); command.AddParam("@provinceId", province.Id); district.Id = int.Parse(command.ExecuteScalar().ToString()); return district; }
public void TestIfSecondaryAddressIsEmpty() { Person person = new Person(); District district = new District(1,"tress",new Province(1,"Sugh")); person.SecondaryDistrict = null; person.SecondaryCity = null; Assert.IsTrue(person.SecondaryAddressIsEmpty); person.SecondaryDistrict = district; Assert.IsFalse(person.SecondaryAddressIsEmpty); person.SecondaryCity = "Paris"; Assert.IsFalse(person.SecondaryAddressIsEmpty); person.SecondaryDistrict = null; person.SecondaryCity = null; Assert.IsTrue(person.SecondaryAddressIsEmpty); }
private Person AddPerson(bool active, EconomicActivity dOA, int loanCycle, string city, District district, string firstName, string lastname, char sex, string identificationData) { Person person = new Person(); person.Active = active; person.Activity = dOA; person.City = city; person.District = district; person.FirstName = firstName; person.LastName = lastname; person.Sex = sex; person.LoanCycle = loanCycle; person.IdentificationData = identificationData; person.DateOfBirth = new DateTime(1980, 12, 12); return person; }
public void TestFixtureSetUp() { TechnicalSettings.UseOnlineMode = false; _DeleteDatas(); _cltManagement = new ClientManager(DataUtil.TESTDB); _locations = new LocationsManager(DataUtil.TESTDB); _agriculture = _addDataForTesting.AddDomainOfApplicationAgriculture(); _district = _addDataForTesting.AddDistrictIntoDatabase(); _projectManager = new ProjectManager(DataUtil.TESTDB); ApplicationSettings settings = ApplicationSettings.GetInstance(""); }
public bool IsGroupNameAlreadyUsedInDistrict(string pName, District pDistrict) { string q = @"SELECT COUNT(*) FROM Tiers INNER JOIN Groups ON Tiers.id = Groups.id WHERE { fn UCASE(Groups.name) } = @name AND Tiers.district_id=@disctrictId"; using (SqlConnection conn = GetConnection()) using (OpenCbsCommand c = new OpenCbsCommand(q, conn)) { c.AddParam("@name", pName.ToUpper()); c.AddParam("@disctrictId", pDistrict.Id); int count = (int)c.ExecuteScalar(); return (count > 0); } }
private void _SetValue(District pDistrict, string pCity, string pComments,string pHomePhone,string pPersonalPhone,string pZipCode, string pEmail,string pHomeType) { if (pDistrict != null) { comboBoxDistrict.Text = pDistrict.Name; comboBoxProvince.Text = pDistrict.Province.Name; } textBoxCity.Text = pCity; tbAddress.Text = pComments; textBoxHomePhone.Text = pHomePhone; textBoxPersonalPhone.Text = pPersonalPhone; textBoxEMail.Text = pEmail; tbZipCode.Text = pZipCode; comboBoxHomeType.Text = pHomeType; }
private void _InitializeDistricts() { comboBoxDistrict.Items.Clear(); District selectDistrict = new District{Name = MultiLanguageStrings.GetString(Ressource.AddressUserControl,"selectDistrict.Text")}; comboBoxDistrict.Items.Add(selectDistrict); List<District> districtList = ServicesProvider.GetInstance().GetLocationServices().FindDistrict(_province); foreach (District dis in districtList) { comboBoxDistrict.Items.Add(dis); } comboBoxDistrict.SelectedItem = selectDistrict; _district = null; }
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 void comboBoxDistrict_SelectionChangeCommitted(object sender, System.EventArgs e) { _district = (District)comboBoxDistrict.SelectedItem; _SelectProvince(); textBoxCity.Text = String.Empty; }
private void ChooseDisrictProvinceByCity() { City selectedCity = textBoxCity.GetCity(); if (selectedCity != null) { _city = selectedCity.Name; _district = ServicesProvider.GetInstance().GetLocationServices().FindDistirctById(selectedCity.DistrictId); _SelectDistrict(); _SelectProvince(); char delimeterChar = '('; string[] words = _city.Split(delimeterChar); textBoxCity.Text = _city = words[0].TrimEnd(); } }
public void SetUp() { _DeleteDatas(); _cltManagement = new ClientManager(DataUtil.TESTDB); _agriculture = _addDataForTesting.AddDomainOfApplicationAgriculture(); _district = _addDataForTesting.AddDistrictIntoDatabase(); _addDataForTesting.AddBranchIntoDatabase(); _branch = new Branch {Id = 1, Name = "Default"}; _person = new Person(); _person.Active = true; _person.BadClient = false; _person.LoanCycle = 1; _person.City = "Dushambe"; _person.District = _district; _person.FirstName = "Nicolas"; _person.LastName = "BARON"; _person.Sex = 'M'; _person.IdentificationData = "123ARK3VC"; _person.Nationality = "France"; _person.BirthPlace = "Nancy"; _person.Email = "*****@*****.**"; _person.SecondaryEmail = "*****@*****.**"; _person.HomeType = "Maison"; _person.ZipCode = "12345"; _person.SecondaryZipCode = "123458"; _person.SecondaryHomeType = "Maison"; _person.Status = OClientStatus.Inactive; _person.FollowUpComment = "Comment follow Up"; _person.Sponsor1 = "coucou"; _person.Sponsor1Comment = "coucou2"; _person.Branch = _branch; _group = new Group(); _group.Active = true; _group.BadClient = false; _group.City = "Dushambe"; _group.LoanCycle = 2; _group.District = _district; _group.Name = "SCG"; _group.ZipCode = "12345"; _group.SecondaryZipCode = "123458"; _group.Email = "*****@*****.**"; _group.SecondaryEmail = "*****@*****.**"; _group.HomeType = "Maison"; _group.SecondaryHomeType = "Maison"; _group.Status = OClientStatus.Active; _group.FollowUpComment = "Follow Up Comment Group"; _group.Sponsor2 = "coucou"; _group.Sponsor2Comment = "coucou2"; _group.Branch = _branch; }
public void SetUp() { _DeleteDatas(); _cltManagement = new ClientManager(DataUtil.TESTDB); _agriculture = _addDataForTesting.AddDomainOfApplicationAgriculture(); _district = _addDataForTesting.AddDistrictIntoDatabase(); _addDataForTesting.AddBranchIntoDatabase(); _branch = new Branch {Id = 1, Name = "Default"}; _person = new Person(); _person.Active = true; _person.BadClient = false; _person.LoanCycle = 1; _person.City = "Dushambe"; _person.District = _district; _person.FirstName = "Nicolas"; _person.LastName = "BARON"; _person.Sex = 'M'; _person.IdentificationData = "123ARK3VC"; _person.HouseHoldHead = true; _person.StudyLevel = "1"; _person.SSNumber = "3333"; _person.CAFNumber = "2424"; _person.HousingSituation = "test"; _person.UnemploymentMonths = 1; _person.Nationality = "France"; _person.BirthPlace = "Nancy"; _person.Email = "*****@*****.**"; _person.SecondaryEmail = "*****@*****.**"; _person.HomeType = "Maison"; _person.ZipCode = "12345"; _person.SecondaryZipCode = "123458"; _person.SecondaryHomeType = "Maison"; _person.Handicapped = true; _person.Status = OClientStatus.Inactive; _person.FollowUpComment = "Comment follow Up"; _person.FirstContact = new DateTime(2009, 12, 25); _person.FirstAppointment = new DateTime(2010, 04, 01); _person.Sponsor1 = "coucou"; _person.Sponsor1Comment = "coucou2"; _person.Branch = _branch; _group = new Group(); _group.Active = true; _group.BadClient = false; _group.City = "Dushambe"; _group.LoanCycle = 2; _group.District = _district; _group.Name = "SCG"; _group.ZipCode = "12345"; _group.SecondaryZipCode = "123458"; _group.Email = "*****@*****.**"; _group.SecondaryEmail = "*****@*****.**"; _group.HomeType = "Maison"; _group.SecondaryHomeType = "Maison"; _group.Status = OClientStatus.Active; _group.FollowUpComment = "Follow Up Comment Group"; _group.Sponsor2 = "coucou"; _group.Sponsor2Comment = "coucou2"; _group.Branch = _branch; }
public void TestIfSecondaryAddressIsEmpty() { Group group = new Group(); District district = new District(1,"tress",new Province(1,"Sugh")); group.SecondaryDistrict = null; group.SecondaryCity = null; Assert.IsTrue(group.SecondaryAddressIsEmpty); group.SecondaryDistrict = district; Assert.IsFalse(group.SecondaryAddressIsEmpty); group.SecondaryCity = "Paris"; Assert.IsFalse(group.SecondaryAddressIsEmpty); group.SecondaryDistrict = null; group.SecondaryCity = null; Assert.IsTrue(group.SecondaryAddressIsEmpty); }
private static Group AddGroup(bool active, string city, District district, string name, Member leader, int NbOfMembers) { Group group = new Group {Active = active, City = city, District = district, Name = name, Leader = leader}; for (int i = 0; i < NbOfMembers; i++) { group.AddMember(new Member { Tiers = new Person(), LoanShareAmount = 1000 + i, CurrentlyIn = true, IsLeader = true, JoinedDate = TimeProvider.Today }); } return group; }
public void TestIfSecondaryAddressPartiallyFilled() { Group group = new Group(); District district = new District(1,"tress",new Province(1,"Sugh")); group.SecondaryDistrict = null; group.SecondaryCity = null; Assert.IsFalse(group.SecondaryAddressPartiallyFilled); group.SecondaryDistrict = district; Assert.IsTrue(group.SecondaryAddressPartiallyFilled); group.SecondaryCity = "city"; Assert.IsFalse(group.SecondaryAddressPartiallyFilled); group.SecondaryDistrict = null; group.SecondaryCity = null; Assert.IsFalse(group.SecondaryAddressPartiallyFilled); group.SecondaryCity = "paris"; Assert.IsTrue(group.SecondaryAddressPartiallyFilled); }
public void TestIfDistrictIsCorrectlySetAndRetrieved() { District district = new District(1,"Qath",new Province(1,"Khatlon")); person.District = district; Assert.AreEqual(1,person.District.Id); Assert.AreEqual("Qath",person.District.Name); Assert.AreEqual(1,person.District.Province.Id); Assert.AreEqual("Khatlon",person.District.Province.Name); }
public bool UpdateDistrict(District district) { CheckLocation(district.Name); return _locationsManager.UpdateDistrict(district); }
public void TestIfSecondaryDistrictIsCorrectlySetAndRetrieved() { District district = new District(1,"tress",new Province(1,"Sugh")); person.SecondaryDistrict = district; Assert.AreEqual(district.Id,person.SecondaryDistrict.Id); Assert.AreEqual(district.Name,person.SecondaryDistrict.Name); Assert.AreEqual(1,person.SecondaryDistrict.Province.Id); Assert.AreEqual("Sugh",person.SecondaryDistrict.Province.Name); }
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 CityForm(Province province, District district) { InitializeComponent(); InitializeCities(province, district); }
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); }
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 TestDistrict() { district = new District(); }