public void deleteCurrentPerson()
{
try
{
_conn.Open();
string query = @"DELETE FROM Person WHERE PersonId = @Data1";
using (var cmd = new SqlCommand(query, _conn))
{
cmd.Parameters.AddWithValue("@Data1", _currentPerson.PId);
int rowsAffected = cmd.ExecuteNonQuery();
_currentPerson = null;
Console.WriteLine("affected rows: {0}", rowsAffected);
}
}
finally
{
if (_conn != null)
{
_conn.Close();
}
}
}
private void btnValider_Click( object sender, EventArgs e )
{
this._personneSaisie = new Person(
this.tbxLastName.Text,
this.tbxFirstName.Text,
this.tbxAddress.Text,
this.tbxPhone.Text );
this.Close();
}
static void Main(string[] args)
{
PersonDataUtil pUtil = new PersonDataUtil();
var Pers = new Person
{
Fornavn = "Martin",
MellemNavn = "Boje",
EfterNavn = "Carpentier",
PersonType = "Mig Selv",
FRAdresse = new Adresse
{
Bynavn = "Aarhus",
Husnummer = "2b",
Postnummer = 8240,
Vejnavn = "Børglumvej"
}
};
pUtil.insertPerson(Pers);
//pUtil.PrintPersonContent();
pUtil.setCurrentPerson(28);
pUtil.getCurrentPersonTelephone();
pUtil.getCurrentFRAddress();
pUtil.setCurrentPerson(39);
pUtil.getCurrentFRAddress();
pUtil.CurrentPerson.tlf = new Telefon
{
Ejes_Af = pUtil.CurrentPerson,
TlfNummer = 60185500,
TlfType = "Mobil"
};
pUtil.InsertTelephoneToPerson();
Console.WriteLine("Før ændringer:");
Console.WriteLine("{0} {1} {2} {3}", pUtil.CurrentPerson.Fornavn, pUtil.CurrentPerson.MellemNavn, pUtil.CurrentPerson.EfterNavn, pUtil.CurrentPerson.FRAdresse.Bynavn);
pUtil.CurrentPerson.Fornavn = "Anton";
pUtil.CurrentPerson.EfterNavn = "Boderling";
pUtil.updateCurrentPerson();
Console.WriteLine("Efter Ændringer");
Console.WriteLine("{0} {1} {2} {3}", pUtil.CurrentPerson.Fornavn, pUtil.CurrentPerson.MellemNavn, pUtil.CurrentPerson.EfterNavn, pUtil.CurrentPerson.FRAdresse.Bynavn);
pUtil.deleteCurrentPerson();
Console.Read();
}
/// <summary>
/// Persist a person into the database
/// </summary>
/// <param name="person">The person that will be persisted in DB</param>
public void savePerson( Person person )
{
try
{
// Open session
NHibernate.ISession session = this.sessionFactory.OpenSession();
// Start Transaction
NHibernate.ITransaction transaction = session.BeginTransaction();
// Tell NHibernate that this object should be saved
session.Save( person );
// Commit transaction
transaction.Commit();
// Close session
session.Close();
}
catch( Exception ex )
{
throw ex;
}
}
public void setCurrentPerson(long id)
{
SqlDataReader rdr = null;
try
{
// Open the connection
_conn.Open();
// 1. Instantiate a new command with a query and connection
SqlCommand cmd = new SqlCommand(@"SELECT * FROM Person WHERE (PersonId='" + id + "')", _conn);
// 2. Call Execute reader to get query results
rdr = cmd.ExecuteReader();
// transfer data from result set to local model
while (rdr.Read())
{
Console.WriteLine(rdr[0]);
_currentPerson = new Person
{
PId = (long)rdr["PersonId"],
Fornavn = (string)rdr["Fornavn"],
MellemNavn = (string)rdr["Mellemnavn"],
EfterNavn = (string)rdr["Efternavn"],
PersonType = (string)rdr["Persontype"]
};
break; //Only the first comming Håndværker with name specified but here superflous
}
}
finally
{
// close the reader
if (rdr != null)
{
rdr.Close();
}
// Close the connection
if (_conn != null)
{
_conn.Close();
}
}
}
public void insertPerson(Person person)
{
try
{
_conn.Open();
if (person.FRAdresse != null)
{
string insertAdress = @"INSERT INTO Adresse (Vejnavn, Husnummer, Postnummer, Bynavn)
OUTPUT INSERTED.AdresseId
VALUES (@Data1, @Data2, @Data3, @Data4)";
using (var cmd = new SqlCommand(insertAdress, _conn))
{
cmd.Parameters.AddWithValue("@Data1", person.FRAdresse.Vejnavn);
cmd.Parameters.AddWithValue("@Data2", person.FRAdresse.Husnummer);
cmd.Parameters.AddWithValue("@Data3", person.FRAdresse.Postnummer);
cmd.Parameters.AddWithValue("@Data4", person.FRAdresse.Bynavn);
person.FRAdresse.AdresseId = (long)cmd.ExecuteScalar();
_currentPerson = person;
}
string sqlQuery = @"INSERT INTO Person (Fornavn, Mellemnavn, Efternavn, Persontype, AdresseId)
OUTPUT INSERTED.PersonId
VALUES (@Data1, @Data2, @Data3, @Data4, @Data5)";
using (var cmd = new SqlCommand(sqlQuery, _conn))
{
person.MellemNavn = person.MellemNavn ?? "";
cmd.Parameters.AddWithValue("@Data1", person.Fornavn);
cmd.Parameters.AddWithValue("@Data2", person.MellemNavn);
cmd.Parameters.AddWithValue("@Data3", person.EfterNavn);
cmd.Parameters.AddWithValue("@Data4", person.PersonType);
cmd.Parameters.AddWithValue("@Data5", person.FRAdresse.AdresseId);
person.PId = (long)cmd.ExecuteScalar();
_currentPerson = person;
}
}
else
{
Console.WriteLine("Person missing adress");
}
}
finally
{
if (_conn != null)
{
_conn.Close();
}
}
}
private void btnAnnuler_Click( object sender, EventArgs e )
{
this._personneSaisie = null;
this.Close();
}
