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