public void TestMethod1()
{
AddressBook.DataLayer data = new AddressBook.DataLayer();
data.InsertPerson("michal", "Imlauf", 12, 13);
data.InsertAddres("A", "B", 53701, 29);
// data.UpdateAddress(22,"C","E",000);
//data.UpdatePerson(28,"A","C",17,18);
BindingList <Person> persons = new BindingList <Person>();
persons = data.SelectAllPersons(persons);
persons[0] = data.SelectAdresses(persons[0]);
// data.DeleteAdress(1);
// data.DeletePerson(1);
}
/// <summary>
/// Adding adress to the database and to the person object
/// </summary>
/// <param name="street">City name</param>
/// <param name="city">Adress name</param>
/// <param name="psc">Area code</param>
/// <param name="personID">ID of Person in Database</param>
/// <returns>Error message if input is incorrect</returns>
public string AddAdress(string street, string city, string psc, string personID)
{
int tempPsc = 0;
int tempPersonID;
if (psc != "")//validity check of PSC
{
if (!Int32.TryParse(psc, out tempPsc))
{
return("PSČ musí být číslo");
}
}
Int32.TryParse(personID, out tempPersonID);
try //trying to add Adress to the database and person object
{
Person tempPerson = Persons.Single(p => p.PersonID.ToString() == tempPersonID.ToString()); //seraching for Person object in list by its id
Adress tempAdress = new Adress(street, city, tempPsc, tempPersonID); //creating new adress object
int id = data.InsertAddres(street, city, tempPsc, tempPerson.PersonID); //inserting adress info into database
if (id == 0)
{
Log("Unable to Insert Adress into database"); //if we are unable to insert into database
}
else //else we set adressId and add adress object into person's adresslist
{
tempAdress.AdressID = id;
tempPerson.Adresses.Add(tempAdress);
}
}
catch (Exception exp)
{
Log(exp.ToString());
}
return("");
}
