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