Hi,
We use "in the center" to refer to the middle of a area,space or object especially exact middle.
E.g:The hotel is right in the centre of the village.
Whereas we use "at the middle" to show an involvement in a happening.
E.g:He always seems to be at the centre of things(dispute,controversy,etc).
Hope it helps,
Iman