public void DeleteAA_Adresse(ref AA_Adresse aaa)
{
string deleteString = @"DELETE FROM AA_Adresse WHERE (AA_AdresseID = @AA_AdresseID)";
using (SqlCommand cmd = new SqlCommand(deleteString, openConnection))
{
cmd.Parameters.AddWithValue("@AA_AdresseID", aaa.AA_AdresseID);
var id = cmd.ExecuteNonQuery();
aaa = null;
}
}
public void UpdateAA_Adresse(ref AA_Adresse aaa)
{
string insertStringParam =
@"UPDATE AA_Adresse SET Type = @Type, AdresseID = @AdresseID, PersonID = @PersonID WHERE AA_AdresseID = @AA_AdresseID";
using (SqlCommand cmd = new SqlCommand(insertStringParam, openConnection))
{
cmd.Parameters.AddWithValue("@Type", aaa.Type);
cmd.Parameters.AddWithValue("@AdresseID", aaa.AdresseID);
cmd.Parameters.AddWithValue("@PersonID", aaa.PersonID);
cmd.ExecuteNonQuery();
}
}
//CRUD for Alternative adresser
public void AddAA_Adresse(ref AA_Adresse aaa)
{
string insertStringParam =
@"INSERT INTO [AA_Adresse] (PersonID, AdresseID, Type)
OUTPUT INSERTED.PersonID
VALUES (@PersonID, @AdresseID, @Type)";
using (SqlCommand cmd = new SqlCommand(insertStringParam, openConnection))
{
cmd.Parameters.AddWithValue("@PersonID", aaa.PersonID);
cmd.Parameters.AddWithValue("@AdresseID", aaa.AdresseID);
cmd.Parameters.AddWithValue("@Type", aaa.Type);
aaa.AA_AdresseID = (long)cmd.ExecuteScalar();
}
}
public void GetAA_AdresseByID(ref AA_Adresse aaa)
{
string sqlcmd = @"SELECT [Type], [AdresseID], [PersonID] FROM AA_Adresse WHERE ([AA_AdresseID] = @AA_AdresseID)";
using (var cmd = new SqlCommand(sqlcmd, openConnection))
{
cmd.Parameters.AddWithValue("@AA_AdresseID", aaa.AA_AdresseID);
SqlDataReader rdr = null;
rdr = cmd.ExecuteReader();
if (rdr.Read())
{
aaa.AA_AdresseID = (long)rdr["AA_AdresseID"];
}
}
}
