public override bool UpdateInsertObject <T>(T obj)
{
PatientenKarte pk = obj as PatientenKarte;
int success = 0;
using (SqlConnection connection = base.GetSqlConnection())
{
connection.Open();
var cmd = new SqlCommand
{
Connection = connection,
CommandText = "IF NOT EXISTS (SELECT 1 FROM patient_card WITH(NOLOCK) WHERE id = @val"
+ "BEGIN INSERT INTO patient_card (patient_id) VALUES (@patID) END"
+ "ELSE BEGIN UPDATE patient_card SET patient_id = @patID WHERE id = @val END"
};
cmd.Parameters.Add(new SqlParameter("@val", pk.GetId()));
cmd.Parameters.Add(new SqlParameter("@patID", pk.GetPatient().id));
cmd.Prepare();
success = cmd.ExecuteNonQuery();
}
return(success == 1);
}
private void InsertBehandlungenToCard(PatientenKarte card)
{
BehandlungDO bDO = new BehandlungDO(base.connectionString);
List <Behandlung> bList = new List <Behandlung>();
foreach (Behandlung b in bDO.GetBehandlungenFromCard(card.GetId()))
{
card.AddBehandlung(b);
}
}
