public int AddOrganisation(Organisation org)
 {
     using (var connection = GetOpenMapsConnection())
     {
         string query = @"INSERT INTO tblOrganisation (OrganisationName, Phone, MailEnabled) VALUES (@OrganisationName, @Phone, @MailEnabled);";
         return connection.Execute(query, org);
     }
 }
        public int AddOrganisation2(Organisation org)
        {
            using (var connection = GetOpenMapsConnection())
            {
                string query = @"INSERT INTO tblOrganisation (OrganisationName, Phone, MailEnabled) VALUES (@OrganisationName, @Phone, @MailEnabled);
                                 SELECT CAST(SCOPE_IDENTITY() as int);";
                org.OrganisationId = connection.Query<int>(query, org).Single();

                if (org.OrganisationId > 0)
                {
                    return 1;
                }

                return 0;
            }
        }