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