public List <PersonAddressRelations> GetAddressByPersonIDPersonAddressRelation(ref Person person)
{
string GetAddressByName = @"SELECT * FROM PersonAddressRelations WHERE (PersonID=@PersonID)";
using (SqlCommand cmd = new SqlCommand(GetAddressByName, OpenConnection))
{
cmd.Parameters.AddWithValue("@PersonID", person.PersonID);
SqlDataReader rdr = null;
rdr = cmd.ExecuteReader();
var list = new List <PersonAddressRelations>();
while (rdr.Read())
{
PersonAddressRelations personAddressRelations = new PersonAddressRelations();
personAddressRelations.PersonID = (int)rdr["PersonID"];
personAddressRelations.AddressID = (int)rdr["AddressID"];
personAddressRelations.Address = GetAddressByID(personAddressRelations.AddressID);
personAddressRelations.Person = person;
list.Add(personAddressRelations);
}
return(list);
}
}
public void DeletePersonAddressRelation(ref PersonAddressRelations personAddressRelations)
{
string DeleteString = @"DELETE FROM PersonAddressRelations WHERE (PersonID=@PersonID)";
using (SqlCommand cmd = new SqlCommand(DeleteString, OpenConnection))
{
cmd.Parameters.AddWithValue("@PersonID", personAddressRelations.PersonID);
var count = cmd.ExecuteNonQuery();
personAddressRelations = null;
}
}
public void AddPersonAddressRelation(ref PersonAddressRelations personAddressRelations)
{
string insertStringParam = @"INSERT INTO PersonAddressRelations (PersonID, AddressID)
VALUES(@PersonID, @AddressID)";
using (SqlCommand cmd = new SqlCommand(insertStringParam, OpenConnection))
{
cmd.Parameters.AddWithValue("@PersonID", personAddressRelations.PersonID);
cmd.Parameters.AddWithValue("@AddressID", personAddressRelations.AddressID);
var count = cmd.ExecuteNonQuery();
}
}
static void Main(string[] args)
{
Console.WriteLine("Hello ... " +
"\n ... " +
"\n .. " +
"\n . " +
"\n" +
"Starting Database\n");
DBUtilities entry = new DBUtilities();
AddressCity _newcity = new AddressCity()
{
City = "Viby J",
PostalCode = "8260"
};
entry.AddCity(ref _newcity);
Address _newaddress = new Address()
{
RoadName = "østergade",
HouseNumber = "44",
Story = "3",
IsRegisteredAddress = "Primær",
AddressType = "Home",
CityID = _newcity.CityID
};
_newcity.Addresses = new List <Address>();
_newcity.Addresses.Add(_newaddress);
entry.AddAddressToDB(ref _newaddress);
Person _newPerson = new Person()
{
FirstName = "Test",
MiddleName = "Tester",
LastName = "Testersen",
ContactType = "Privat",
//Note = "Hader DAB",
};
_newPerson.AddressRelations.Add(new PersonAddressRelations()
{
Address = _newaddress
});
_newaddress.Persons = new List <Person>();
_newaddress.Persons.Add(_newPerson);
entry.AddPerson(ref _newPerson);
var newRelations = new PersonAddressRelations()
{
PersonID = _newPerson.PersonID, AddressID = _newaddress.AddressID
};
entry.AddPersonAddressRelation(ref newRelations);
//var _person = entry.GetPersonByName(ref _newPerson);
var kartotek = new DBUtilities();
var PersonsInDB = kartotek.GetAllThePersonS();
foreach (Person Persons in PersonsInDB)
{
Console.WriteLine(" ");
Console.WriteLine("Personens ID: \t" + Persons.PersonID);
Console.WriteLine("Personens Fornavn er: \t" + Persons.FirstName);
Console.WriteLine("Personens Mellemnavn er: \t" + Persons.MiddleName);
Console.WriteLine("Personens Efternavn er: \t" + Persons.LastName);
Console.WriteLine("Kontakt typen for personen er \t" + Persons.ContactType);
foreach (var addressRelation in Persons.AddressRelations)
{
Console.WriteLine("Adressen er: ");
Console.WriteLine($"{addressRelation.Address.RoadName}, {addressRelation.Address.HouseNumber}");
Console.WriteLine($"{addressRelation.Address.AddressCity.PostalCode} {addressRelation.Address.AddressCity.City}");
}
//for (int i = 0; i < Persons.AddressRelations.Count; i++)
//{
// var addressRelation = Persons.AddressRelations.ElementAt(i);
// Console.WriteLine($"Adresse #{i+1} er:");
// Console.WriteLine($"{addressRelation.Address.RoadName}, {addressRelation.Address.HouseNumber}");
// Console.WriteLine($"{addressRelation.Address.AddressCity.PostalCode} {addressRelation.Address.AddressCity.City}");
//}
//Console.WriteLine("Note om Personen \t" + Persons.Note);
}
Console.WriteLine();
//DBCalls test = new DBCalls();
//test.CreateEntryInDB();
//var FN = "test";
//var LN = "tester";
//var MN = "testesen";
//var CT = "noob";
//var Note = "træt af dab";
//DBUtilities newperson = new DBUtilities(0,FN,MN,LN,CT,Note);
//var temp = newperson.ListPersons();
//foreach (Person person in temp)
//{
// Console.WriteLine("ID \t" + person.PersonID);
// Console.WriteLine("Fornavn \t" + person.FirstName);
// Console.WriteLine("Mellemnavn \t" + person.MiddleName);
// Console.WriteLine("Efternavn \t" + person.LastName);
//}
//Console.WriteLine("Creating new entry... ");
//var NewEntry = new Person();
//Console.WriteLine("Please enter First Name: ");
//NewEntry.FirstName = (Console.ReadLine());
//Console.WriteLine("Please enter Middle Name (Optional): ");
//NewEntry.MiddleName = (Console.ReadLine());
//Console.WriteLine("Please enter Last Name: ");
//NewEntry.LastName = (Console.ReadLine());
//Console.WriteLine("Please enter contact type (Business, Private etc.: ");
//NewEntry.ContactType = (Console.ReadLine());
//Console.WriteLine("Please enter any notes");
//NewEntry.Note = (Console.ReadLine());
Console.ReadLine();
}
