public void DeleteBy(ref Byy bb)
{
string deleteString = @"DELETE FROM Person WHERE (ByID = @BYID)";
using (SqlCommand cmd = new SqlCommand(deleteString, openConnection))
{
cmd.Parameters.AddWithValue("@ByID", bb.ByID);
var id = (long)cmd.ExecuteNonQuery();
bb = null;
}
}
//CRD for Byer - Føler ikke at det giver mening at opdatere by
public void AddBy(ref Byy bb)
{
string insertStringParam =
@"INSERT INTO [Byy] (Bynavn, Postnummer, Land)
OUTPUT INSERTED.ByID
VALUES (@Bynavn, @Postnummer, @Land)";
using (SqlCommand cmd = new SqlCommand(insertStringParam, openConnection))
{
cmd.Parameters.AddWithValue("@Bynavn", bb.Bynavn);
cmd.Parameters.AddWithValue("@Postnummer", bb.Postnummer);
cmd.Parameters.AddWithValue("@Land", bb.Land);
bb.ByID = (long)cmd.ExecuteScalar();
}
}
public void GetByByByID(ref Byy bb)
{
string sqlcmd = @"SELECT [Bynavn], [Postnummer], [Land] FROM Byy WHERE ([ByID] = @ByID)";
using (var cmd = new SqlCommand(sqlcmd, openConnection))
{
cmd.Parameters.AddWithValue("@ByID", bb.ByID);
SqlDataReader rdr = null;
rdr = cmd.ExecuteReader();
if (rdr.Read())
{
bb.ByID = (long)rdr["ByID"];
}
}
}
public void TheAPP()
{
DBUtil utilities = new DBUtil();
Byy _by = new Byy("Vladivostock", "90099", "Russkiy");
utilities.GetByByByID(ref _by);
utilities.AddBy(ref _by);
Adresse _adresse = new Adresse("Okeanskiy Prospekt", "333B", _by);
utilities.GetAdresseByID(ref _adresse);
utilities.AddAdresse(ref _adresse);
Person _person = new Person("Cyka Blyat", "Idi", "Nahui", "Gopnik", _adresse);
utilities.GetPersonByID(ref _person);
utilities.AddPerson(ref _person);
}
