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