Major-General William Casement (1788–1844), Military Secretary to the Government of India and Member of the Supreme Council